dbTalk Databases Forums  

lock status 6 problem

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


Discuss lock status 6 problem in the comp.databases.berkeley-db forum.



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

Default lock status 6 problem - 03-28-2006 , 04:00 AM






when i written code to test performance when multi-threaded, i have one
thread for writing ,and two for reading. and i set the
env_flag=DB_CREATE|DB_INIT_MPOOL|DB_INIT_LOCK|DB_P RIVATE
when each thread reads writes 500,000 records
the console gives me messages like this:
performance: unexpected lock status: 6
Panic:Invalid argument region error detect
and if i set the records number to 10,000 , it works well
if i set the flag DB_PRIVATE off ,it works well
the writing thread causes no problem.
i show my gratitude for any help


Reply With Quote
  #2  
Old   
ubell@sleepycat.com
 
Posts: n/a

Default Re: lock status 6 problem - 03-28-2006 , 10:40 AM






If you are using multiple threads then you must specify DB_THREAD when
you open the environment. Also using DB_INIT_LOCK without DB_INIT_TXN
is not recommended since if you have locking on you can deadlock and
without a transaction log partial updates cannot be undone leading to
corruption of your data.

Michael Ubell
Sleepycat Software.


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

Default Re: lock status 6 problem - 03-28-2006 , 07:49 PM



thanks!
Actually i hava tried to use the flags you mentioned , but some other
problems have mislead me. you have my gratitude!


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.