[firebird-support] Single Row Table Becomes Unresponsive

2013-12-10 Thread 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

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

2013-12-10 Thread Alexey Kovyazin
Hi Greg, Run gstat -r or IBAnalyst and check number of record versions in this table. I suppose there could be millions of versions. Regards, Alexey Kovyazin IBSurgeon Hi, We're using Firebird 2.1.2.1818 on Centos 5.9. We have a third party replication product SymmetricDS, that accesses a

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

2013-12-10 Thread Thomas Steinmaurer
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