Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

php & dbxml deadlock detection

529962Jul 7 2010 — edited Aug 10 2010
Hello,

i'm developing a webframework based on dbxml and php using the php modules out of the dbxml-2.5.16 source tree.
I experienced really good performance with transaction enabled read and update queries.

I got stuck on two problems...
1. when concurrent update queries are executed, my db environment is getting corrupt and has to be recovered.
(it seems that it is not possible to enable deadlock detection for db environments with php)
i also tried using the command line db_deadlock util which never detected deadlocks in my db environment -
however i guess for that to work i also have to enable deadlock detection in php
2. after a while when i for example try to do db_hotbackup i get following error message:
db_hotbackup: Logging region out of memory; you may need to increase its size
db_hotbackup: Recovery function for LSN 1 9540789 failed
db_hotbackup: PANIC: Cannot allocate memory
db_hotbackup: process-private: unable to find environment
db_hotbackup: DB_ENV->open: backup/2010070603: DB_RUNRECOVERY: Fatal error, run database recovery
db_hotbackup: HOT BACKUP FAILED!
after some research it also seems to be impossible to set set_lg_regionmax with php so i tried to specify a larger logging region
in DB_CONFIG file...even no success with different values...only solution was to periodically run db_recovery

Any suggestions for my issues?

Best regards.
Felix
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2010
Added on Jul 7 2010
6 comments
1,677 views