Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Berkely DB > DB environment ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 1707 of 1804
Post > Topic >>

DB environment complete lockout: is there a way to investigate?

by "oleksandr kalinin" <alexka79@[EMAIL PROTECTED] > Jan 30, 2007 at 03:35 AM

Hello All,

I've run into a lockout scenario (that is when even db_stat and 
db_deadlock utilities hang). DB recovery works fine. However, since 
the setup is quite simple and it has been running fine for years now, 
I am very surprised about the sudden lockout and would like to find 
the root cause of it. I have the copy of 'broken' DB environment 
files.

Is there any way to find out what exactly is causing the lockout, if 
there is a lock that has not been released, what process has obtained 
it, etc? Is that possible to do some 'basic' manual analysis of 
BerkeleyDB environment files on my own in case db_stat is unusable, 
using BerkeleyDB API?

In my setup, there is one multithreaded program with two threads of 
control using BerkeleyDB (exclusive 'get' calls, i.e. read-only) and a 
command line utility for updating the table at specific time once a 
day. Lockout did happen two times already, at random time, in the 
middle of normal functioning of the whole system, and I could not find 
any common pattern or correlation on what could have caused these 
errors.

Environment is opened with DB_INIT_CDB | DB_INIT_MPOOL | DB_CREATE 
flags;
Daemon 'reading only' program opens tables with following flag : 
DB_RDONLY
Tables update program table open flags : DB_CREATE

Many thanks in advance for your hints,

Regards,
Oleksandr
 




 7 Posts in Topic:
DB environment complete lockout: is there a way to investigate?
"oleksandr kalinin&q  2007-01-30 03:35:45 
Re: DB environment complete lockout: is there a way to investiga
Florian Weimer <fw@[EM  2007-01-30 14:48:22 
Re: DB environment complete lockout: is there a way to investiga
"oleksandr kalinin&q  2007-01-31 03:36:55 
Re: DB environment complete lockout: is there a way to investiga
Florian Weimer <fw@[EM  2007-01-31 13:03:39 
Re: DB environment complete lockout: is there a way to investiga
"Kevin Duraj" &  2007-01-31 11:52:21 
Re: DB environment complete lockout: is there a way to investiga
michael.cahill@[EMAIL PRO  2007-01-31 16:10:30 
Re: DB environment complete lockout: is there a way to investiga
"oleksandr kalinin&q  2007-02-01 04:50:09 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 0:43:57 CDT 2008.