------------------------
LATEST DETECTED DEADLOCK
------------------------
120227 13:50:21
*** (1) TRANSACTION:
TRANSACTION 0 169973206, ACTIVE 0 sec, process no 23481, OS thread id
1230383424 fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 13 lock struct(s), heap size 3024, undo log entries 1
MySQL thread id 639889, query id 123087728 localhost 127.0.0.1 idcs
Searching rows for update
update IngRekeningInformatie set batchId=5238 where batchId=-1
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 12967928 n bits 328 index `batchIndex` of
table `idcsdb/IngRekeningInformatie` trx id 0 169973206 lock_mode X waiting
Record lock, heap no 204 PHYSICAL RECORD: n_fields 2; compact format; info
bits 0
0: len 8; hex 7fffffffffffffff; asc ;; 1: len 30; hex
303030303035353535362020202020202020202020202020202020202020; asc 0000055556
;...(truncated);
*** (2) TRANSACTION:
TRANSACTION 0 169973161, ACTIVE 0 sec, process no 23481, OS thread id
1206421824 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1216, undo log entries 70
MySQL thread id 639253, query id 123088066 localhost 127.0.0.1 idcs update
insert into IngRekeningInformatie (aanmaakTijd, adresEnWoonplaats, batchId,
brns, dataGevonden, extraInfo, inAanvraag, inhoud, postcode,
uitgebreideNaam, verkorteNaam, rekeningNummer) values ('2012-02-27
12:00:00', null, -1, '0007020583000891721', null, null, 1, null, null, null,
null, '0000051216')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 12967928 n bits 328 index `batchIndex` of
table `idcsdb/IngRekeningInformatie` trx id 0 169973161 lock_mode X locks
rec but not gap
Record lock, heap no 204 PHYSICAL RECORD: n_fields 2; compact format; info
bits 0
0: len 8; hex 7fffffffffffffff; asc ;; 1: len 30; hex
303030303035353535362020202020202020202020202020202020202020; asc 0000055556
;...(truncated);
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 12967928 n bits 328 index `batchIndex` of
table `idcsdb/IngRekeningInformatie` trx id 0 169973161 lock_mode X locks
gap before rec insert intention waiting
Record lock, heap no 218 PHYSICAL RECORD: n_fields 2; compact format; info
bits 0
0: len 8; hex 7fffffffffffffff; asc ;; 1: len 30; hex
303030303035333838302020202020202020202020202020202020202020; asc 0000053880
;...(truncated);
*** WE ROLL BACK TRANSACTION (1)
CREATE TABLE `IngRekeningInformatie` (
`rekeningNummer` char(50) NOT NULL,
`aanmaakTijd` datetime default NULL,
`adresEnWoonplaats` varchar(255) default NULL,
`batchId` bigint(20) NOT NULL,
`brns` longtext,
`dataGevonden` varchar(255) default NULL,
`extraInfo` varchar(255) default NULL,
`inAanvraag` bit(1) NOT NULL,
`inhoud` varchar(255) default NULL,
`postcode` varchar(255) default NULL,
`uitgebreideNaam` varchar(255) default NULL,
`verkorteNaam` varchar(255) default NULL,
PRIMARY KEY (`rekeningNummer`),
KEY `batchIndex` (`batchId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;