Subject | lock wait |
---|---|
Author | flashjobs |
Post date | 2007-01-23T04:34:29Z |
Hello,
I am developing a Delphi5/Firebird app using only TIBO components.
I started with FB1.0 and successfully deployed a lite version of my
app to my client's pc, using FB1.0. I have faced little problems in
my app. I then upgraded to Firebird 1.5. After this upgradation most
of the problems are solved. Now my app attached 75 more nodes in
windows platform and a dedicated server in Linux. Having 300 more
tables in my database.
In rare case my app shows busy mode when trying to access data. when
i faced this problem, i have identified that, when i disconnecting
a particular node the lock will be releasing.
i think there are uncommitted transactions locking some records.
how can i solve this problem ?
is there any utility to locate these transactions ?
Manoj
Developer
Software Associates
Kerala, India
I am developing a Delphi5/Firebird app using only TIBO components.
I started with FB1.0 and successfully deployed a lite version of my
app to my client's pc, using FB1.0. I have faced little problems in
my app. I then upgraded to Firebird 1.5. After this upgradation most
of the problems are solved. Now my app attached 75 more nodes in
windows platform and a dedicated server in Linux. Having 300 more
tables in my database.
In rare case my app shows busy mode when trying to access data. when
i faced this problem, i have identified that, when i disconnecting
a particular node the lock will be releasing.
i think there are uncommitted transactions locking some records.
how can i solve this problem ?
is there any utility to locate these transactions ?
Manoj
Developer
Software Associates
Kerala, India