SHOW ENGINE INNODB STATUS/G

gistfile1.txt

mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
Status:
=====================================
120516  1:11:59 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 41 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 232, signal count 232
Mutex spin waits 0, rounds 1915, OS waits 39
RW-shared spins 362, OS waits 176; RW-excl spins 32, OS waits 2
------------------------
LATEST FOREIGN KEY ERROR
------------------------
120516  0:56:48 Transaction:
TRANSACTION 0 2955, ACTIVE 0 sec, OS thread id 679484944 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
4 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 11356, query id 18443 c2.phxv.nearlyfreespeech.net 172.17.0.202 impinform update
INSERT INTO stocks (stock_ticker, stock_name, stock_desc, country_id, sector_id, prioritycode_id) VALUES ('', '', '', '1', -
'1', '1')
Foreign key constraint fails for table `impindata/stocks`:
,
  CONSTRAINT `stocks_ibfk_1` FOREIGN KEY (`sector_id`) REFERENCES `sectors` (`sector_id`) ON UPDATE CASCADE
Trying to add in child table, in index `sector_id` tuple:
DATA TUPLE: 2 fields;
 0: len 4; hex 7fffffff; asc     ;; 1: len 4; hex 80000002; asc     ;;

But in parent table `impindata/sectors`, in index `PRIMARY`,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 6; compact format; info bits 0
 0: len 4; hex 80000001; asc     ;; 1: len 6; hex 000000000b12; asc       ;; 2: len 7; hex 800000002d0110; asc     -  ;; 3: len 5; hex 536f6c6172; asc Solar;; 4: len 30; hex 52617069646c792067726f77696e672072656e657761626c6520656e6572; asc Rapidly growing renewable ener;...(truncated); 5: len 4; hex 4f8f5de2; asc O ] ;;

------------
TRANSACTIONS
------------
Trx id counter 0 2966
Purge done for trx's n:o < 0 2765 undo n:o < 0 0
History list length 12
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, OS thread id 679485488
MySQL thread id 11360, query id 18544 ssh-out.nearlyfreespeech.net 208.94.116.220 impinform
SHOW ENGINE INNODB STATUS
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (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
0 OS file reads, 1758 OS file writes, 1139 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 34679, used cells 0, node heap has 1 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 0 460310
Log flushed up to   0 460310
Last checkpoint at  0 460310
0 pending log writes, 0 pending chkp writes
658 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 23514970; in additional pool allocated 1494144
Buffer pool size   512
Free buffers       315
Database pages     196
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 0, created 196, written 1984
0.00 reads/s, 0.00 creates/s, 0.00 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 679483312, state: waiting for server activity
Number of rows inserted 180, updated 25, deleted 26, read 6137
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.05 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================