===================================== 090707 3:42:14 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 8232, signal count 8213 --Thread 47299114490192 has waited at ./../include/trx0undo.ic line 127 for 930.00 seconds the semaphore: X-lock on RW-latch at 0x2b04aa55da78 created in file buf0buf.c line 497 a writer (thread id 47299114490192) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file buf0flu.c line 585 Last time write locked in file ./../include/trx0undo.ic line 127 Mutex spin waits 0, rounds 21322, OS waits 884 RW-shared spins 13562, OS waits 6777; RW-excl spins 560, OS waits 542 ------------ TRANSACTIONS ------------ Trx id counter 0 6584091 Purge done for trx's n:o < 0 6584039 undo n:o < 0 0 History list length 35 Total number of lock structs in row lock hash table 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 6584089, ACTIVE (PREPARED) 1143 sec, process no 27785, OS thread id 47299114490192 committing 2 lock struct(s), heap size 368, undo log entries 1 MySQL thread id 32538, query id 4298627 localhost gamed COMMIT -------- 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: 1 1090 OS file reads, 320095 OS file writes, 279462 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 30731, node heap has 112 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 158857117 Log flushed up to 0 158857117 Last checkpoint at 0 158854549 0 pending log writes, 0 pending chkp writes 235039 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 38219728; in additional pool allocated 2096896 Buffer pool size 1024 Free buffers 1 Database pages 911 Modified db pages 4 Pending reads 0 Pending writes: LRU 0, flush list 4, single page 0 Pages read 1131, created 129, written 91701 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 27785, id 47299112360272, state: flushing buffer pool pages Number of rows inserted 42391, updated 53399, deleted 28883, read 167839787 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Error: semaphore wait has lasted > 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 090707 3:42:25InnoDB: Assertion failure in thread 47299103967568 in file srv0srv.c line 2097 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: about forcing recovery. 090707 3:42:25 - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=8 max_connections=100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 93184 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.