My Firebird server deadlocks often. I am using 2.5.8 on Linux in a mix of superserver, superclassic, 32-bit and 64-bit. All are affected.
When this happens I cannot make any new connections or run any queries on existing connections.
This looks just like
which was meant to be fixed in 2.5.5.
I created a Python program which connects to the server, registers an event listener then disconnects. It runs 5 threads at once. The server deadlocked after about 300 connects (64 connections on each thread). When I killed the Python program the server resumes. The test database is any empty database.
I have attached a back trace from the server while it's in this state.