=====================================
110615 9:47:03 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 90047 1_second, 90047 sleeps, 8270 10_second, 7374 background, 7374 flush
srv_master_thread log flush and writes: 90638
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 17316, signal count 16266
--Thread 1396 has waited at row0ins.c line 2002 for 944.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0000000017D765C0 created in file buf0buf.c line 898
a writer (thread id 1396) has reserved it in mode wait exclusive
number of readers 1, waiters flag 0, lock_word: ffffffff
Last time read locked in file buf0flu.c line 1292
Last time write locked in file ..\..\..\mysql-5.5.12\storage\innobase\btr\btr0sea.c line 903
Mutex spin waits 8966, rounds 176166, OS waits 5072
RW-shared spins 11697, rounds 350395, OS waits 10145
RW-excl spins 551, rounds 18216, OS waits 525
Spin rounds per wait: 19.65 mutex, 29.96 RW-shared, 33.06 RW-excl
------------
TRANSACTIONS
------------
Trx id counter C8EA56
Purge done for trx's n:o < C55BA3 undo n:o < 0
History list length 274
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION C8EA55, ACTIVE 945 sec, OS thread id 1396 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s)
MySQL thread id 27361, query id 922505 localhost 127.0.0.1 mirth update
INSERT INTO eav_data (StudyID, AttributeID, value_timestamp, value_int) VALUES ('699', '5', 20110615093254, '100')
--------
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 (read thread)
I/O thread 4 state: wait Windows aio (read thread)
I/O thread 5 state: wait Windows aio (read thread)
I/O thread 6 state: wait Windows aio (write thread)
I/O thread 7 state: wait Windows aio (write thread)
I/O thread 8 state: wait Windows aio (write thread)
I/O thread 9 state: wait Windows aio (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 1 [0, 0, 1, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
182275 OS file reads, 583574 OS file writes, 224180 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 57, seg size 59, 136 merges
merged operations:
insert 1660, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 1423691, node heap has 3 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 19276479126
Log flushed up to 19276479126
Last checkpoint at 19276475464
0 pending log writes, 0 pending chkp writes
198268 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 736182272; in additional pool allocated 0
Dictionary memory allocated 68562
Buffer pool size 43904
Free buffers 0
Database pages 43901
Old database pages 16185
Modified db pages 28
Pending reads 0
Pending writes: LRU 0, flush list 29, single page 0
Pages made young 132506, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 182259, created 820, written 375259
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s
LRU len: 43901, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
1 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread id 2272, state: flushing buffer pool pages
Number of rows inserted 189797, updated 4, deleted 0, read 195965806
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.
110615 9:47:12 InnoDB: Assertion failure in thread 2260 in file srv0srv.c line 2441
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.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread 2256 stopped in file os0sync.c line 474
110615 9:47:12 - mysqld got exception 0xc0000005 ;
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=371195904
read_buffer_size=65536
max_used_connections=2
max_threads=100
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 395520 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
InnoDB: Thread 2272 stopped in file ut0ut.c line 76
000000014024E382 my_osmaperr()
0000000077D6B71A BaseThreadStart()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
InnoDB: Thread 2264 stopped in file os0sync.c line 474
InnoDB: Thread 1396 stopped in file sync0arr.c line 359