[firebird-support] Re: Single Row Table Becomes Unresponsive

[Greg Kay]

I agree I should keep an eye on the versions for this table. Being third 
party code I'm not exactly sure about the usage of the table but it's 
roughly something like two updates every 5 seconds, in separate 
transactions.

I forgot to mention we're using Firebird classic. When we've had the 
unresponsive table problem, we've shutdown our system and are left with 
only one connection to the problem database. The pid for this connection 
cannot be killed, even with kill -9. This I don't understand.  Does 
anyone know why a kill -9 would not work and what sort of state 
Firebird has gotten into?

Thanks,
Greg

[firebird-support] Single Row Table Becomes Unresponsive

[Greg Kay]

Hi,

We're using Firebird 2.1.2.1818 on Centos 5.9. We have a third party 
replication product SymmetricDS, that accesses a single row table very 
often to do reads and writes. (It seems to be using the table to manage 
some sort of locking between SymmetricDS processes.) Very occasionally, 
this table becomes unresponsive. The SymmetricDS process hangs and 
IBExpert cannot access the table. Looking at the Firebird server box we 
can see a connection that we cannot kill, even with kill -9.  The only 
way we can resolve the problem is to reboot the Firebird machine.

Does anyone have any ideas on this?

Thanks,
Greg