Failed to connect database: Connection Lost to database - Firebird and Delphi application

Question

I have a server with more than sixty client databases that currently operate with Firebird 3.0.3.32900 and an application in Delphi that is responsible for synchronizing logs from end to end. For example, the application is responsible for forwarding data that is generated in the POS (sales, registrations...) to the Rear.

It turns out, some bases are not having connection, and in case I try to force a synchronization, the message "Failed to connect database - Connection Lost to database" is displayed. However, I can access the database via Ibexpert and via Rear executable, and even save data. Even stranger, is that for the application to work, it is necessary to establish connection with the bank, which is possible without problems.

This message only happens in this synchronization feature. Anything else you do, there is no connection error with the bank.

I’ve been dealing with this problem for a week. I reinstalled Firebird (including migrating from 2.1.7 to 3.0.3) and even replacing the server for a new one. I also did gfix that solved the day, the next the problem came back.

I searched the internet and saw something like Firebird does not handle many instances or that the port may be being used by another application.

Firebird has been installed in Classic mode and currently manages over 180 simultaneous connections. The application of synchronism only uses a port that I define.

Does anyone have any idea what might be going on? I hope I’ve been clear, in case you need more details, ask me.

I will continue to research and test here.

From now on. No waiting.

Answer 1

Classic server creates a separate process for each client connection, while "Super Server" creates only one process and uses threads and a shared cache.

Momentarily, you can change Firebird to work on "Super Server" as it is more efficient to work with large amounts of connections, and change the Firebird "conf" to work better with your hardware.

If you don’t have as much knowledge in conf, use one of the Ibsurgeon

Ideally you would stop connecting remotely and create a 3-tiered application (client, middleware, database).