php & dbxml deadlock detection
529962Jul 7 2010 — edited Aug 10 2010Hello,
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