Subject | Re: Single Row Table Becomes Unresponsive |
---|---|
Author | Greg Kay |
Post date | 2013-12-13T05:58:08Z |
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
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