percona-discussion team mailing list archive

Thread
Date
[Bug 366839] [NEW] crash in 5.1.34-4 release

To: percona-discussion@xxxxxxxxxxxxxxxxxxx
From: Percona <launchpad@xxxxxxxxxxx>
Date: Sat, 25 Apr 2009 16:54:37 -0000
Reply-to: Bug 366839 <366839@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

=====================================
090424  3:58:02 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 422217, signal count 256743
--Thread 1265445184 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1264380224 has waited at ../../storage/innobase/include/btr0btr.ic line 47 for 888.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaad9c3ab48 created in file buf/buf0buf.c line 683
a writer (thread id 1264380224) has reserved it in mode  wait exclusive
number of readers 0, s_waiters flag 0, x_waiters flag 1, lock_word: 100000
Last time read locked in file buf/buf0flu.c line 809
Last time write locked in file btr/btr0sea.c line 863
--Thread 1273964864 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1264912704 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1272367424 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1265977664 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1266510144 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1267042624 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1274231104 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276361024 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1275562304 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1275828544 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276627264 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1271834944 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1270769984 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1271302464 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1269172544 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1273432384 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1268107584 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1267575104 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276094784 has waited at btr/btr0cur.c line 442 for 886.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276893504 has waited at btr/btr0cur.c line 442 for 884.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1273698624 has waited at btr/btr0cur.c line 442 for 880.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
Mutex spin waits 1528397, rounds 11725460, OS waits 264859
RW-shared spins 141357, OS waits 87261; RW-excl spins 150598, OS waits 44784
Spin rounds per wait: 7.67 mutex, 15.20 RW-shared, 7.61 RW-excl
--------
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 (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (read thread)
I/O thread 7 state: waiting for i/o request (read thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
I/O thread 10 state: waiting for i/o request (write thread)
I/O thread 11 state: waiting for i/o request (write thread)
I/O thread 12 state: waiting for i/o request (write thread)
I/O thread 13 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
614697 OS file reads, 265668 OS file writes, 33202 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 2617, free list len 408569, seg size 411187,
1334919 inserts, 951822 merged recs, 191917 merges
Hash table size 73015699, node heap has 12211 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 5606564217437
Log flushed up to   5606563993456
Last checkpoint at  5605498976984
Max checkpoint age  2122655294
Modified age        1061827701
Checkpoint age      1065240453
0 pending log writes, 0 pending chkp writes
10432 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 36367761408; in additional pool allocated 0
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 784194824 	(584125592 + 200069232)
    Page hash           36508664
    Dictionary cache    146254456 	(146032976 + 221480)
    File system         127984 	(82672 + 45312)
    Lock system         87676360 	(87656392 + 19968)
    Recovery system     0 	(0 + 0)
    Threads             411736 	(406936 + 4800)
Dictionary memory allocated 221480
Buffer pool size        2162688
Buffer pool size, bytes 35433480192
Free buffers            1380429
Database pages          712952
Modified db pages       165904
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 644672, created 68281, written 398940
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
LRU len: 712952, unzip_LRU len: 228718
I/O sum[18446744073709551615]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 31469, id 1264380224, state: purging
Number of rows inserted 1218834, updated 2892268, deleted 678747, read 179949871
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

** Affects: percona-xtradb
     Importance: Undecided
         Status: New

-- 
crash in 5.1.34-4 release
https://bugs.launchpad.net/bugs/366839
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraDB.

Status in Percona XtraDB Storage Engine for MySQL: New

Bug description:
=====================================
090424  3:58:02 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 422217, signal count 256743
--Thread 1265445184 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1264380224 has waited at ../../storage/innobase/include/btr0btr.ic line 47 for 888.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaad9c3ab48 created in file buf/buf0buf.c line 683
a writer (thread id 1264380224) has reserved it in mode  wait exclusive
number of readers 0, s_waiters flag 0, x_waiters flag 1, lock_word: 100000
Last time read locked in file buf/buf0flu.c line 809
Last time write locked in file btr/btr0sea.c line 863
--Thread 1273964864 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1264912704 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1272367424 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1265977664 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1266510144 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1267042624 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1274231104 has waited at btr/btr0cur.c line 442 for 888.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276361024 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1275562304 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1275828544 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276627264 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1271834944 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1270769984 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1271302464 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1269172544 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1273432384 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1268107584 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1267575104 has waited at btr/btr0cur.c line 442 for 887.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276094784 has waited at btr/btr0cur.c line 442 for 886.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1276893504 has waited at btr/btr0cur.c line 442 for 884.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
--Thread 1273698624 has waited at btr/btr0cur.c line 442 for 880.00 seconds the semaphore:
S-lock on RW-latch at 0x2ab367e7bc50 created in file dict/dict0dict.c line 1573
a writer (thread id 1264380224) has reserved it in mode  exclusive
number of readers 0, s_waiters flag 1, x_waiters flag 0, lock_word: 0
Last time read locked in file btr/btr0cur.c line 442
Last time write locked in file btr/btr0cur.c line 435
Mutex spin waits 1528397, rounds 11725460, OS waits 264859
RW-shared spins 141357, OS waits 87261; RW-excl spins 150598, OS waits 44784
Spin rounds per wait: 7.67 mutex, 15.20 RW-shared, 7.61 RW-excl
--------
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 (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (read thread)
I/O thread 7 state: waiting for i/o request (read thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
I/O thread 10 state: waiting for i/o request (write thread)
I/O thread 11 state: waiting for i/o request (write thread)
I/O thread 12 state: waiting for i/o request (write thread)
I/O thread 13 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
614697 OS file reads, 265668 OS file writes, 33202 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 2617, free list len 408569, seg size 411187,
1334919 inserts, 951822 merged recs, 191917 merges
Hash table size 73015699, node heap has 12211 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 5606564217437
Log flushed up to   5606563993456
Last checkpoint at  5605498976984
Max checkpoint age  2122655294
Modified age        1061827701
Checkpoint age      1065240453
0 pending log writes, 0 pending chkp writes
10432 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 36367761408; in additional pool allocated 0
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 784194824 	(584125592 + 200069232)
    Page hash           36508664
    Dictionary cache    146254456 	(146032976 + 221480)
    File system         127984 	(82672 + 45312)
    Lock system         87676360 	(87656392 + 19968)
    Recovery system     0 	(0 + 0)
    Threads             411736 	(406936 + 4800)
Dictionary memory allocated 221480
Buffer pool size        2162688
Buffer pool size, bytes 35433480192
Free buffers            1380429
Database pages          712952
Modified db pages       165904
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 644672, created 68281, written 398940
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
LRU len: 712952, unzip_LRU len: 228718
I/O sum[18446744073709551615]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 31469, id 1264380224, state: purging
Number of rows inserted 1218834, updated 2892268, deleted 678747, read 179949871
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Follow ups

[Bug 366839] Re: crash in 5.1.34-4 release
From: Percona, 2009-04-26
[Bug 366839] [NEW] crash in 5.1.34-4 release
From: Percona, 2009-04-25
References

[Bug 366839] [NEW] crash in 5.1.34-4 release
From: Percona, 2009-04-25