stuck transactions? - openldap-technical

15 Dec 2009


      Hi,
I notice that when I run db4.8tat -t the Active Transaction list does 
not change very often. I would have expected it to not be the same 
twice. So I guess I have a lot of stuck transactions?
I use back_hdb and slapd is under some load.
Could this be related to the messages in the log:
Dec 15 15:09:19 server1 slapd[32060]: => bdb_idl_delete_key: c_del id 
failed: DB_LOCK_DEADLOCK: Locker killed to resolve a deadlock (-30994)
Dec 15 15:09:19 server1 slapd[32060]: conn=40803 op=18: attribute 
"entryCSN" index delete failure
/Peter
Active transactions:
         80000003: running; pid/thread 32060/47089260848688; begin LSN: 
file/offset 0/0
         80000004: running; pid/thread 32060/47089260848688; begin LSN: 
file/offset 0/0
         80000006: running; pid/thread 32060/1127287120; begin LSN: 
file/offset 0/0
         80000007: running; pid/thread 32060/1110501712; begin LSN: 
file/offset 0/0
         80000008: running; pid/thread 32060/1118894416; begin LSN: 
file/offset 0/0
         8000006b: running; pid/thread 32060/1135679824; begin LSN: 
file/offset 0/0
         8000006d: running; pid/thread 32060/1088940368; begin LSN: 
file/offset 0/0
         80000076: running; pid/thread 32060/1144072528; begin LSN: 
file/offset 0/0
         80000077: running; pid/thread 32060/1152465232; begin LSN: 
file/offset 0/0
         8000007c: running; pid/thread 32060/1160857936; begin LSN: 
file/offset 0/0
         80000081: running; pid/thread 32060/1169250640; begin LSN: 
file/offset 0/0
         80000082: running; pid/thread 32060/1177643344; begin LSN: 
file/offset 0/0
         800000b7: running; pid/thread 32060/1186036048; begin LSN: 
file/offset 0/0
....