firebird3.0.service failed because the control process exited with error code. How to start firebird?
● firebird3.0.service — Firebird Database Server ( SuperServer ) Loaded: loaded (/lib/systemd/system/firebird3.0.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Thu 2019-05-16 19:01:13 IST; 29s ago Process: 9628 ExecStart=/usr/sbin/fbguard -pidfile /run/firebird3.0/default.pid -daemon -forever (code=exited, status=252) May 16 19:00:58 ADMIN-I-61 systemd1: Starting Firebird Database Server ( SuperServer ). May 16 19:01:13 ADMIN-I-61 systemd1: firebird3.0.service: Control process exited, code=exited status=252 May 16 19:01:13 ADMIN-I-61 systemd1: Failed to start Firebird Database Server ( SuperServer ). May 16 19:01:13 ADMIN-I-61 systemd1: firebird3.0.service: Unit entered failed state. May 16 19:01:13 ADMIN-I-61 systemd1: firebird3.0.service: Failed with result ‘exit-code’.
/etc/init.d/firebird3.0 start /etc/init.d/firebird3.0 restart [. ] Starting firebird3.0 (via systemctl): firebird3.0.serviceJob for firebird3.0.service failed because the control process exited with error code. See "systemctl status firebird3.0.service" and "journalctl -xe" for details. failed! ADMIN-I-61 Thu May 16 11:06:37 2019 /opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird ADMIN-I-61 Thu May 16 11:07:26 2019 INET/inet_error: bind errno = 98 ADMIN-I-61 Thu May 16 11:07:27 2019 startup:INET_connect: Unable to complete network request to host "ADMIN-I-61". Error while listening for an incoming connection. Address already in use ADMIN-I-61 Thu May 16 11:07:27 2019 /opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated due to startup error (2) ADMIN-I-61 Thu May 16 11:07:27 2019 /opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated due to startup error (2) ADMIN-I-61 Thu May 16 12:22:35 2019 /opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird 
I have check ports please help.
Can’t restart or stop Firebird 1.5 on linux
I have an ubuntu server running firebird 1.5. It was working fine, but recently it started hanging (firebird does not respond anymore). Even when trying to restart or stop the server, it shows an error:
>sudo service firebird1.5-super stop * Stopping Firebird 1.5 server manager. Unable to complete network request to host "localhost". -Failed to establish a connection. -Connection reset by peer can not attach to server This could possibly be a ipv4/ipv6 mismatch. If localhost resolves to ipv6 ::1 and firebird only binds to ipv4 127.0.0.1 . I regularly reconfigure /etc/hosts to default to 127.0.0.1.but you might also be able to use the ip or localhost4 somewhere in the firebird config.
1 Answer 1
I think I found the solution, but I believe it is more related to software then database (So if someone knows how to move this to stack overflow please do this).
The problem was that when hibernate (the persistence layer) works with Firebird 1.5, it doesn’t create the temporary tables used by hibernate like in other new databases, instead it creates actual tables with the prefix HT_ (HT_SOMETABLE). I tried to deactivate this with a «hack», until now it’s working fine, no more hanging and nothing unusual has happened because of this hack.
I created a custom Firebird dialect to stop hibernate from creating these tables:
import org.hibernate.dialect.FirebirdDialect; public class FirebirdHackedDialect extends FirebirdDialect < @Override public String getCreateTableString() < String sql = "HackParaNaoCriarTabelasNoFirebird: "; return sql; >> And set this dialect to the persistence.xml:
firebird3.0.service failed because the control process exited with error code. How to start firebird?
● firebird3.0.service — Firebird Database Server ( SuperServer ) Loaded: loaded (/lib/systemd/system/firebird3.0.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Thu 2019-05-16 19:01:13 IST; 29s ago Process: 9628 ExecStart=/usr/sbin/fbguard -pidfile /run/firebird3.0/default.pid -daemon -forever (code=exited, status=252) May 16 19:00:58 ADMIN-I-61 systemd1: Starting Firebird Database Server ( SuperServer ). May 16 19:01:13 ADMIN-I-61 systemd1: firebird3.0.service: Control process exited, code=exited status=252 May 16 19:01:13 ADMIN-I-61 systemd1: Failed to start Firebird Database Server ( SuperServer ). May 16 19:01:13 ADMIN-I-61 systemd1: firebird3.0.service: Unit entered failed state. May 16 19:01:13 ADMIN-I-61 systemd1: firebird3.0.service: Failed with result ‘exit-code’.
/etc/init.d/firebird3.0 start /etc/init.d/firebird3.0 restart [. ] Starting firebird3.0 (via systemctl): firebird3.0.serviceJob for firebird3.0.service failed because the control process exited with error code. See "systemctl status firebird3.0.service" and "journalctl -xe" for details. failed! ADMIN-I-61 Thu May 16 11:06:37 2019 /opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird ADMIN-I-61 Thu May 16 11:07:26 2019 INET/inet_error: bind errno = 98 ADMIN-I-61 Thu May 16 11:07:27 2019 startup:INET_connect: Unable to complete network request to host "ADMIN-I-61". Error while listening for an incoming connection. Address already in use ADMIN-I-61 Thu May 16 11:07:27 2019 /opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated due to startup error (2) ADMIN-I-61 Thu May 16 11:07:27 2019 /opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated due to startup error (2) ADMIN-I-61 Thu May 16 12:22:35 2019 /opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird
I have check ports please help.