===================================== 071117 16:21:40 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 4 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 16, signal count 16 Mutex spin waits 0, rounds 107, OS waits 2 RW-shared spins 28, OS waits 14; RW-excl spins 0, OS waits 0 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 071117 16:21:28 Transaction: TRANSACTION 0 8774, ACTIVE 0 sec, OS thread id 4152 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 320 MySQL thread id 623, query id 2087 localhost 127.0.0.1 autoforms update insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values (?,?,?,?,?,?,?,?) Foreign key constraint fails for table `autoforms30/field`: , CONSTRAINT `field_ibfk_1` FOREIGN KEY (`docid`) REFERENCES `document` (`docid`) ON DELETE CASCADE Trying to add in child table, in index `PRIMARY` tuple: DATA TUPLE: 10 fields; 0: len 4; hex 000005a3; asc ú;; 1: len 16; hex 73656374696f6e412e7265616441434c; asc sectionA.readACL;; 2: len 4; hex 00000000; asc ;; 3: len 6; hex 000000002246; asc " F;; 4: len 7; hex 800000002d018d; asc - ;; 5: len 4; hex 00000001; asc ;; 6: len 3; hex 616c6c; asc all;; 7: len 8; hex 0000000000000000; asc ;; 8: len 8; hex 8000 000000000000; asc ;; 9: SQL NULL; But in parent table `autoforms30/document`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 16; compact format; info bits 0 0: len 4; hex 000005a2; asc ó;; 1: len 6; hex 000000002244; asc "D;; 2: len 7; hex 800000002d0110; asc - ;; 3: len 30; hex 36384339323446354237464439323238413434433231 3344444535454238; asc 68C924F5B7FD9228A44C213DDE5EB8;...(truncated); 4: len 30; hex 363843393234463542374644393232384134344332313344444535454238; asc 68C924F5B7FD9228A44C213DDE5EB8 ;...(truncated); 5: SQL NULL; 6: SQL NULL; 7: len 17; hex 61727469636c6543617465676f72696573; asc articleCategories;; 8: len 5; hex 61646d696e; asc admin;; 9: len 8; hex 800001164d fc4b97; asc MⁿKù;; 10: len 11; hex 6c69737455706461746564; asc listUpdated;; 11: len 5; hex 61646d696e; asc admin;; 12: len 8; hex 800001164dfc4b97; asc MⁿKù;; 13: len 8; h ex 8000000000000000; asc ;; 14: len 8; hex 8000000000000000; asc ;; 15: len 0; hex ; asc ;; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 071117 16:21:28 *** (1) TRANSACTION: TRANSACTION 0 8773, ACTIVE 0 sec, OS thread id 4152 inserting mysql tables in use 1, locked 1 LOCK WAIT 5 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 623, query id 2080 localhost 127.0.0.1 autoforms update insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values (?,?,?,?,?,?,?,?) *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1180 n bits 80 index `PRIMARY` of table `autoforms30/field` trx id 0 8773 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) TRANSACTION: TRANSACTION 0 8772, ACTIVE 0 sec, OS thread id 4260 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 6 lock struct(s), heap size 1024, undo log entries 3 MySQL thread id 622, query id 2081 localhost 127.0.0.1 autoforms update insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values (?,?,?,?,?,?,?,?) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 1180 n bits 72 index `PRIMARY` of table `autoforms30/field` trx id 0 8772 lock_mode X Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 1180 n bits 80 index `PRIMARY` of table `autoforms30/field` trx id 0 8772 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 0 8775 Purge done for trx's n:o < 0 8749 undo n:o < 0 0 History list length 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 8774, not started, OS thread id 4152 MySQL thread id 623, query id 2093 localhost 127.0.0.1 autoforms ---TRANSACTION 0 8772, not started, OS thread id 4260 MySQL thread id 622, query id 2098 localhost 127.0.0.1 autoforms ---TRANSACTION 0 0, not started, OS thread id 2648 MySQL thread id 621, query id 2099 localhost 127.0.0.1 root SHOW INNODB STATUS ---TRANSACTION 0 8768, not started, OS thread id 6048 MySQL thread id 617, query id 2058 localhost 127.0.0.1 autoforms ---TRANSACTION 0 8767, not started, OS thread id 5832 MySQL thread id 616, query id 2048 localhost 127.0.0.1 autoforms ---TRANSACTION 0 8771, not started, OS thread id 4664 MySQL thread id 619, query id 2060 localhost 127.0.0.1 autoforms ---TRANSACTION 0 8769, not started, OS thread id 3128 MySQL thread id 618, query id 2061 localhost 127.0.0.1 autoforms ---TRANSACTION 0 8766, not started, OS thread id 4548 MySQL thread id 615, query id 2049 localhost 127.0.0.1 autoforms -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 961 OS file reads, 132 OS file writes, 33 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 9.25 writes/s, 0.75 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 4 inserts, 4 merged recs, 4 merges Hash table size 178567, used cells 1538, node heap has 3 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 22773191 Log flushed up to 0 22773191 Last checkpoint at 0 22773191 0 pending log writes, 0 pending chkp writes 28 log i/o's done, 0.25 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 54224256; in additional pool allocated 1663104 Buffer pool size 2752 Free buffers 1798 Database pages 951 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 951, created 0, written 104 0.00 reads/s, 0.00 creates/s, 8.75 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 948, state: waiting for server activity Number of rows inserted 46, updated 3, deleted 14, read 26852 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================