Database hangs, ever increasing Lock Held
lsgroupJan 6 2009 — edited Jan 27 2009Hi,
We have Berkeley Dbxml instance running with concurrent access. Our dbxml instance will hang within 2 days. As long was we stop the program, db_recover the database files and restart the program every day, we avoid it hanging. We tink this is because the number of locks seem to grow. running db_deadlock every second does not help and it never reports removing any deadlocks. It hangs just the same eventually.
How do I manage locks? Is there a way I can detect and cancel these locks? I'm including 2 db_stat outputs, one from the morning and another at the end of the day when the database hung (stalled and became unresponsive to requests). I'm going to post the 2 db_stat outputs in 2 replies to this post because it causes this post to exceed the max length...
In the seond db_stat at the time the database stalled, I see that the "Number of current Lockers" equals "Maximum number of lockers at any one time", which was 214. However, the beginning of the output states that the "Maximum number of locks possible" = 295000 which is way more than 214.
Thank you in advance!