dbTalk Databases Forums  

DB hang problem (Perl application)

comp.databases.berkeley-db comp.databases.berkeley-db


Discuss DB hang problem (Perl application) in the comp.databases.berkeley-db forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dae
 
Posts: n/a

Default DB hang problem (Perl application) - 04-24-2006 , 01:24 PM






I've a problem that my application hangs on reading/writing db file...
but first - brief description.
1. application works with a lot of small db files (about 100 000 files
of 16-20 KB size), which are working on the same BDB environment.
2. it's perl fast cgi web application.
3. current Env config is:
-Flags = DB_INIT_MPOOL | DB_INIT_CDB | DB_CREATE
-Cache size: 32 MB (64 MB tried)
-Lock detect: DB_LOCK_DEFAULT
4. OS is Gentoo Linux
5. Hardware: AMD Opteron 64 (2 processors), 300 GB HDD, 4 GB RAM
6. Application has high locking activity.

Only db_recover helps.

I've found similar problem here
http://groups.google.ru/group/comp.d...348b8 2ae11a3
but I didn't found how they solved it in code.

Several additions:
1. If I open another db file(s) with the same Env while other file(s)
are hanged up - it works, I can read, write, lock and unlock db.
2. Each utility works fine and doesn't complain that "db env is
corrupt, run recover".

The problem is still unsolved.


Reply With Quote
  #2  
Old   
Dae
 
Posts: n/a

Default Re: DB hang problem (Perl application) - 04-24-2006 , 01:29 PM






Forgot to add, that db_stat and db_deadlock show no lost lockers or
deadlocks.


Reply With Quote
  #3  
Old   
Dae
 
Posts: n/a

Default Re: DB hang problem (Perl application) - 04-26-2006 , 12:33 PM



I believ I've found a sollution, it's DB_DIRTY_READ (for db opening).
but is it safe enough to use it?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.