===================================== 101020 1:41:44 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1963 1_second, 1944 sleeps, 196 10_second, 16 background, 16 flush srv_master_thread log flush and writes: 2400 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 924314, signal count 731075 --Thread 140736347502352 has waited at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 4599 for 953.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7fffd0bab700 created in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c line 898 a writer (thread id 140736347502352) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 4779 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 4207 --Thread 140737288865552 has waited at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 504 for 953.00 seconds the semaphore: X-lock on RW-latch at 0x7fff9000c880 created in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736347502352) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c line 567 --Thread 140737288599312 has waited at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 838 for 953.00 seconds the semaphore: S-lock on RW-latch at 0x7fff9000c880 created in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736347502352) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c line 567 --Thread 140737288333072 has waited at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 838 for 902.00 seconds the semaphore: S-lock on RW-latch at 0x7fff9000c880 created in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736347502352) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c line 567 Mutex spin waits 2700251, rounds 28459834, OS waits 506375 RW-shared spins 292053, rounds 9865463, OS waits 305319 RW-excl spins 92133, rounds 3595461, OS waits 101767 Spin rounds per wait: 10.54 mutex, 33.78 RW-shared, 39.02 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 101020 0:45:22 *** (1) TRANSACTION: TRANSACTION 86A8B, ACTIVE 0 sec, process no 24512, OS thread id 140737288599312 starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 376, 5 row lock(s) MySQL thread id 4, query id 1091 127.0.0.1 root Updating update ignore `blobtest` set `data`='azevolvcjdmoglgmyfrrbkgmjaedtlwhxpzmtoorufxnonngoftrvxoihrmyfjvjsfrgmdljtbdzilhaegntruaqoprghjvufcumycbmcafvpdtxeelmuopyisreaebagoxktonkdahsxvglzesvpkxctnasoxiwlwoojdewsewigifkqkrwhwaohbbeqfhraityrjeaomegvybxifaskkqurnuklzrdrishctcomrkzmetezlqhvannduvegszfaxjmkpoluicqrxdlceumgnyuwtuieubwwtqjiyesuyppmqnpjnmqjvtrbsdrdnniweljzcwklimvxeziyipknpfizhgnwecqabsayytsohmcvuuzaduqjiqqgkeauutoiklrezoayusunbxovvojeggabeoscfyqkicctrcengvpqlqrfokicwnrqvhwzzejerijchgkjolwfznwxjseydqtddjllztpucmcbftjqkdmkbjpxbiciwwoyhsbmjpghaxeqjuhomjwxnrjqaigxhqijwmuywmzheefpomdsksxdgpkpxqqoyftnisehcseizxcayvwbyaszccusqxxqszgxcaftfvlapvpxrcbbcpijxtchqboumsxhsqwjwgivbwruqduvxwalwuqqvcupkfwnzdtagyvupapgcqkttbvqbburwdbyqfsffsapddfrvhnjkgaoirflxbrmxtwbfucljcykmyedwprlwhxbxgruaznkzrwfdmbcczcorhyijxzivlgkrpslmjobbgzadnuvlpwblopgfrwpmyheylrdbmjhqqmfduiafgixoolxjnihygrzvanhdauvzamowrsoirlqwipxlkibvfduvpdyqhadjxxlkyzftaduwpbhukmkperavzbckhicbzedjvawsebkasqw *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 6 page no 3 n bits 80 index `PRIMARY` of table `test`.`blobtest` trx id 86A8B lock_mode X waiting Record lock, heap no 7 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 8; hex 0000000000000007; asc ;; 1: len 6; hex 000000086a8a; asc j ;; 2: len 7; hex 10000002320038; asc 2 8;; 3: len 30; hex 68697a6f63616e647469696b666a7972636d6c666b6e6675747272727174; asc hizocandtiikfjyrcmlfknfutrrrqt; (total 788 bytes); *** (2) TRANSACTION: TRANSACTION 86A8A, ACTIVE 0 sec, process no 24512, OS thread id 140737288865552 fetching rows mysql tables in use 1, locked 1 3 lock struct(s), heap size 376, 2 row lock(s), undo log entries 1 MySQL thread id 2, query id 1090 127.0.0.1 root Updating update ignore `blobtest` set `data`='hizocandtiikfjyrcmlfknfutrrrqttymmfvtlssejcvljlmextlihfemnuzwbvpmyzvethtvwxqswhnwlnerdtxmxbuvklgmxkxsthsviufiotyqdmxjxymqnhviivfcjkfjlqcnsttvvkyryddaalxjaahfbqkmfvaxibycuvqmgdivujnilvtbcrvdqxqczvjvaguotwxpmkoqnuktxamdagyzqhxvivxfmrjwltnfjootlbagpdrjxeoavwdrlvznykvhtublszgojurqpargiwbmztwzcueejzogdndqyimdrongxjkkjkbagnvubpgrzqqueuvslmgwedwjngbgrvmtyjqkvddvtvtwcdusrbpnvudyabtnikmkxwzszlhdayjeggsjxaeevznjikwrfklctibqecgqtmgvkmcsizxkqhzblolsaycvvgbhyijktzmxdlwadfbqzuoqkcogswoujccdprhnvxplnuibnvjzuianvewwnjyikfswvhbazjnitqaafpifdrifwuwzhgzktkuatfyqvkbhvcbbbayfkljpaalxfxuemsdumlwchomfwnfjoslwdquimlbsgeuqvekjrcpwsbsvperoxirjbhlomosiussihovtdrhfwjfrmgegpvnvbutcrdtybjprtnldloqgftyxxcjuwdrpacufdbtalfhvzgvkotougtmuajllpqehpytguwbpheahugebroycjcujyxmxoyebyjdjvrmgxrjxsgeywzmihmbezwfvyntpaaazmbwyoxohvxugvqhmykqthcevaixegowskulnoehvthfvigjmahqqaqylqegnqibrrrbqhxfrfjpibqphqcmxvuhvaptwmklkiocqnckrwhxzwvehyvrfuwdhtpruztgnimctlbamhkmz *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 6 page no 3 n bits 80 index `PRIMARY` of table `test`.`blobtest` trx id 86A8A lock_mode X locks rec but not gap Record lock, heap no 7 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 8; hex 0000000000000007; asc ;; 1: len 6; hex 000000086a8a; asc j ;; 2: len 7; hex 10000002320038; asc 2 8;; 3: len 30; hex 68697a6f63616e647469696b666a7972636d6c666b6e6675747272727174; asc hizocandtiikfjyrcmlfknfutrrrqt; (total 788 bytes); *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 6 page no 3 n bits 80 index `PRIMARY` of table `test`.`blobtest` trx id 86A8A lock_mode X locks rec but not gap waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 8; hex 0000000000000008; asc ;; 1: len 6; hex 000000086a89; asc j ;; 2: len 7; hex 8f0000013a0110; asc : ;; 3: len 30; hex 76697a71656b786c79797673646965707464616164616273726f6a796976; asc vizqekxlyyvsdieptdaadabsrojyiv; (total 788 bytes); *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter E969F Purge done for trx's n:o < E91A2 undo n:o < 0 History list length 368 Total number of lock structs in row lock hash table 27 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION E969E, ACTIVE 953 sec, process no 24512, OS thread id 140737288333072 estimating records in index range mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 6, query id 637503 127.0.0.1 root init delete from `blobtest` where `id`<=34140 limit 5 ---TRANSACTION E969B, ACTIVE 953 sec, process no 24512, OS thread id 140737288865552 updating or deleting mysql tables in use 1, locked 1 ROLLING BACK 28 lock struct(s), heap size 3112, 229 row lock(s), undo log entries 2 MySQL thread id 2, query id 637500 127.0.0.1 root Updating update ignore `blobtest` set `data`='bhzacfqdznntbqsecbkjyjpmmdlesmahivzvdfrhgtazbkmlgtqnrhvpplvrmgjrlfaujkttdihoacujeaxyniicxacnrinuhrcxtydpvrasmgmkipeznwzajbgbbpplesqobqgioamgdmjajlkcwtqyqdzdejazckompapgnreqhrwqphmdkdavlcxhydbykoftafmpxdcwgivelqxpyxtqyeqrpsjwzkltexjbtawchmvlqmliqocbaqoqfohzvcwinohmygaxkzosbvzcwkjrxgduzlrvyrmjruwxbblneyfhaqnduurlfgbrasdwkseccopvcqaxackurgzydrduwmannswacxzkabmmpcinburocsodfjnefnlpixgnvhpynpmnyunbfnetrdaqwaekvnuxadrgaifquherujyjdyqyhiwufcpnfnhdzvosewowtrpvwqrnbgwjujjujbrfrlvcdhbmoeptmoriumwwafkgdloqbtdtejljawquetioywpprvmzbbzysdtlhsaywighyjysvvprpuxoianwrhptetj ---TRANSACTION E9671, ACTIVE 953 sec, process no 24512, OS thread id 140737288599312 estimating records in index range mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1 MySQL thread id 4, query id 637502 127.0.0.1 root init update ignore `blobtest` set `data`='xbtqfdveabqysrzlusnylqupfckexavnjjtqpsyujnhijczcpjstydoqhbhxlvkyqvsyewjkaiogpcmcadsrergzppkztrryyztyjhmrzdilzusnpseicswaepbixbvibirozsnpcppznxdbvdhtjbopzillbpwttcbxavvmpepueswmfqtmndfycwhpftdglrzznvjofwmzfewfvbjphmklrxzwmcjrixvmiwgkldpupdyekylrqvalhsvfaqrxcrjjdjxcpjgwdihweijdhzxofmytnbptcdpisehzsjmkpmkvbldcjvqpdglcwjkatyjlwkzkeoqoprniofkgxzrzpnlbokusdhcmhxdmuksribhfonzexvllgorxginodhvzutxbmergxdmmrekcymteivqzdfmpfnsyugmalzwumkpasnfjjmpenfanxxhwhrglpcwnolqznoyeweafgyzkybtkyftzuizcftqgihdiibhcjaicvkbqatswhqzndizqznxgamkhgvomxbjwsijgdcglsatqdlvqhfwcughaorxzfhp Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68420 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 68421 Validating 6 47360 Validating 6 47360 Validating 6 47360 Validating 6 47360 Validating 6 47360 Validating 6 47360 Validating 6 47360 Validating 6 47360 Validating 6 30750 Validating 6 30750 Validating 6 30750 Validating 6 30750 Validating 6 30750 Validating 6 30750 Validating 6 30750 Validating 6 29619 Validating 6 29619 Validating 6 29619 Validating 6 29619 Validating 6 29619 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 47456 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 25105 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 47424 Validating 6 29626 Validating 6 29626 Validating 6 29626 Validating 6 29626 Validating 6 29626 Validating 6 29626 Validating 6 21449 Validating 6 21449 Validating 6 21449 Validating 6 21449 Validating 6 21449 Validating 6 21449 Validating 6 21458 Validating 6 21458 Validating 6 21458 Validating 6 21458 Validating 6 21458 Validating 6 21458 Validating 6 21458 Validating 6 21458 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 42804 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 30742 Validating 6 39435 Validating 6 39435 Validating 6 39435 Validating 6 39435 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 38374 Validating 6 28614 Validating 6 28614 Validating 6 28614 Validating 6 28614 Validating 6 28614 Validating 6 28614 Validating 6 28614 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 45158 Validating 6 44177 Validating 6 44177 Validating 6 44177 Validating 6 44177 Validating 6 44177 Validating 6 44177 Validating 6 44177 Validating 6 44177 Validating 6 44179 Validating 6 44179 Validating 6 44179 Validating 6 44179 Validating 6 44179 Validating 6 44179 Validating 6 44179 Validating 6 44179 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45122 Validating 6 45121 Validating 6 45121 Validating 6 45121 Validating 6 45121 Validating 6 45121 Validating 6 45121 Validating 6 45121 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 10264 Validating 6 9582 Validating 6 9582 Validating 6 9582 Validating 6 9582 Validating 6 9582 Validating 6 9582 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 68910 Validating 6 15803 Validating 6 15803 Validating 6 15803 Validating 6 15803 Validating 6 15803 Validating 6 68419 Validating 6 68419 Validating 6 68419 Validating 6 68419 Validating 6 68419 Validating 6 68419 -------- 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 (write thread) I/O thread 7 state: waiting for i/o request (write 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) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 57502 OS file reads, 129013 OS file writes, 20927 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, 1 merges merged operations: insert 1, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1155127, used cells 70055, node heap has 143 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 32703080804 Log flushed up to 32703080279 Last checkpoint at 32544320452 0 pending log writes, 0 pending chkp writes 11049 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 541442048; in additional pool allocated 0 Dictionary memory allocated 38608 Buffer pool size 32000 Free buffers 2 Database pages 31855 Old database pages 11738 Modified db pages 5121 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 68120, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 58923, created 71338, written 504680 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 31855, unzip_LRU len: 0 I/O sum[0]: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. 24512, id 140736347502352, state: master purging Number of rows inserted 104945, updated 69428, deleted 70093, read 752320 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. 101020 1:41:45 InnoDB: Assertion failure in thread 140736578770704 in file /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c line 2387 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.1/en/forcing-recovery.html InnoDB: about forcing recovery. Program received signal SIGABRT, Aborted. [Switching to Thread 0x7fffc9c8d710 (LWP 24552)] 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig); (gdb) bt #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x00000000009342ac in srv_error_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2387 #3 0x00000030e1807761 in start_thread (arg=0x7fffc9c8d710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) set pagination off (gdb) thread apply all bt Thread 26 (Thread 0x7ffff4201710 (LWP 24593)): #0 0x00000030e180e48d in read () at ../sysdeps/unix/syscall-template.S:82 #1 0x0000000000a90eb9 in vio_read (vio=0x2a72ed0, buf=0x2a9c530 "\001", size=4) at /home/sbester/build/bzr/mysql-5.5-security/vio/viosocket.c:44 #2 0x000000000054e5d6 in my_real_read (net=0x2a8b328, complen=0x7ffff4200d58) at /home/sbester/build/bzr/mysql-5.5-security/sql/net_serv.cc:841 #3 0x000000000054ec19 in my_net_read (net=0x2a8b328) at /home/sbester/build/bzr/mysql-5.5-security/sql/net_serv.cc:1038 #4 0x00000000005d7526 in do_command (thd=0x2a8b0c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:716 #5 0x00000000006b108c in do_handle_one_connection (thd_arg=0x2a8b0c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:745 #6 0x00000000006b0ee9 in handle_one_connection (arg=0x2a8b0c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #7 0x00000030e1807761 in start_thread (arg=0x7ffff4201710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 25 (Thread 0x7ffff413e710 (LWP 24578)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x7fff9000b018, mp=0x7fff9000afa0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x7fff9000b018, mutex=0x7fff9000afa0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x7fff9000afa0, reset_sig_count=251981) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009387aa in sync_array_wait_event (arr=0x125a5c0, index=3) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0arr.c:457 #5 0x000000000093a5cd in rw_lock_s_lock_spin (lock=0x7fff9000c880, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=838) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:450 #6 0x0000000000939442 in rw_lock_s_lock_func (lock=0x7fff9000c880, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=838) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/sync0rw.ic:418 #7 0x00000000009dec9c in mtr_s_lock_func (lock=0x7fff9000c880, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=838, mtr=0x7ffff4134ef0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/mtr0mtr.ic:252 #8 0x000000000095f0fb in btr_cur_open_at_index_side_func (from_left=1, index=0x7fff9000c808, latch_mode=1, cursor=0x7ffff41353c0, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=3368, mtr=0x7ffff4134ef0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:838 #9 0x0000000000964087 in btr_estimate_n_rows_in_range (index=0x7fff9000c808, tuple1=0x7fff90009a38, mode1=2, tuple2=0x7fff90009a88, mode2=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:3366 #10 0x0000000000904819 in ha_innobase::records_in_range (this=0x7fffb401a920, keynr=0, min_key=0x0, max_key=0x7ffff4139440) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:7502 #11 0x0000000000812ea1 in check_quick_keys (param=0x7ffff4139680, idx=0, key_tree=0x7fff90005d20, min_key=0x7ffff41397d8 "\340\t", min_key_flag=0, min_keypart=-1, max_key=0x7ffff413a6d6 "\\\205", max_key_flag=0, max_keypart=-1) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:7788 #12 0x00000000008123f9 in check_quick_select (param=0x7ffff4139680, idx=0, tree=0x7fff90005d20, update_tbl_stats=true) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:7559 #13 0x000000000080b8cb in get_key_scans_params (param=0x7ffff4139680, tree=0x7fff90005ab0, index_read_must_be_used=false, update_tbl_stats=true, read_time=245720) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:4959 #14 0x0000000000806276 in SQL_SELECT::test_quick_select (this=0x7fff90004900, thd=0x2a993c0, keys_to_use=..., prev_tables=0, limit=5, force_quick_range=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:2321 #15 0x000000000067524a in SQL_SELECT::check_quick (this=0x7fff90004900, thd=0x2a993c0, force_quick_range=false, limit=5) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.h:826 #16 0x0000000000842db7 in mysql_delete (thd=0x2a993c0, table_list=0x7fff9005d350, conds=0x7fff9000c600, order_list=0x2a9b878, limit=5, options=0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_delete.cc:193 #17 0x00000000005dc855 in mysql_execute_command (thd=0x2a993c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:2917 #18 0x00000000005e383f in mysql_parse (thd=0x2a993c0, rawbuf=0x7fff9000dc30 "delete from `blobtest` where `id`<=34140 limit 5", length=48, parser_state=0x7ffff413d730) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5500 #19 0x00000000005d8072 in dispatch_command (command=COM_QUERY, thd=0x2a993c0, packet=0x2aad551 "delete from `blobtest` where `id`<=34140 limit 5", packet_length=48) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1030 #20 0x00000000005d76d2 in do_command (thd=0x2a993c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:770 #21 0x00000000006b108c in do_handle_one_connection (thd_arg=0x2a993c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:745 #22 0x00000000006b0ee9 in handle_one_connection (arg=0x2a993c0) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #23 0x00000030e1807761 in start_thread (arg=0x7ffff413e710) at pthread_create.c:301 #24 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 23 (Thread 0x7ffff417f710 (LWP 24575)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x7fff9000b018, mp=0x7fff9000afa0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x7fff9000b018, mutex=0x7fff9000afa0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x7fff9000afa0, reset_sig_count=251981) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009387aa in sync_array_wait_event (arr=0x125a5c0, index=2) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0arr.c:457 #5 0x000000000093a5cd in rw_lock_s_lock_spin (lock=0x7fff9000c880, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=838) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:450 #6 0x0000000000939442 in rw_lock_s_lock_func (lock=0x7fff9000c880, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=838) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/sync0rw.ic:418 #7 0x00000000009dec9c in mtr_s_lock_func (lock=0x7fff9000c880, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=838, mtr=0x7ffff4176230) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/mtr0mtr.ic:252 #8 0x000000000095f0fb in btr_cur_open_at_index_side_func (from_left=1, index=0x7fff9000c808, latch_mode=1, cursor=0x7ffff4176700, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=3368, mtr=0x7ffff4176230) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:838 #9 0x0000000000964087 in btr_estimate_n_rows_in_range (index=0x7fff9000c808, tuple1=0x7fff9c00b848, mode1=2, tuple2=0x7fff9c00b898, mode2=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:3366 #10 0x0000000000904819 in ha_innobase::records_in_range (this=0x7fff9c00bf10, keynr=0, min_key=0x0, max_key=0x7ffff417a780) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:7502 #11 0x0000000000812ea1 in check_quick_keys (param=0x7ffff417a9c0, idx=0, key_tree=0x7fff9c0046a0, min_key=0x7ffff417ab18 "\340\t", min_key_flag=0, min_keypart=-1, max_key=0x7ffff417ba16 "\032R\001", max_key_flag=0, max_keypart=-1) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:7788 #12 0x00000000008123f9 in check_quick_select (param=0x7ffff417a9c0, idx=0, tree=0x7fff9c0046a0, update_tbl_stats=true) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:7559 #13 0x000000000080b8cb in get_key_scans_params (param=0x7ffff417a9c0, tree=0x7fff9c004400, index_read_must_be_used=false, update_tbl_stats=true, read_time=245720) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:4959 #14 0x0000000000806276 in SQL_SELECT::test_quick_select (this=0x7fff9c018540, thd=0x2a92240, keys_to_use=..., prev_tables=0, limit=5, force_quick_range=false) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.cc:2321 #15 0x000000000067524a in SQL_SELECT::check_quick (this=0x7fff9c018540, thd=0x2a92240, force_quick_range=false, limit=5) at /home/sbester/build/bzr/mysql-5.5-security/sql/opt_range.h:826 #16 0x000000000066ffba in mysql_update (thd=0x2a92240, table_list=0x7fff9c001e40, fields=..., values=..., conds=0x7fff9c002750, order_num=0, order=0x0, limit=5, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ffff417de70, updated_return=0x7ffff417de68) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_update.cc:343 #17 0x00000000005dbf1d in mysql_execute_command (thd=0x2a92240) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:2703 #18 0x00000000005e383f in mysql_parse (thd=0x2a92240, rawbuf=0x7fff9c0252d0 "update ignore `blobtest` set `data`='xbtqfdveabqysrzlusnylqupfckexavnjjtqpsyujnhijczcpjstydoqhbhxlvkyqvsyewjkaiogpcmcadsrergzppkztrryyztyjhmrzdilzusnpseicswaepbixbvibirozsnpcppznxdbvdhtjbopzillbpwttcb"..., length=13031, parser_state=0x7ffff417e730) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5500 #19 0x00000000005d8072 in dispatch_command (command=COM_QUERY, thd=0x2a92240, packet=0x2abf571 "update ignore `blobtest` set `data`='xbtqfdveabqysrzlusnylqupfckexavnjjtqpsyujnhijczcpjstydoqhbhxlvkyqvsyewjkaiogpcmcadsrergzppkztrryyztyjhmrzdilzusnpseicswaepbixbvibirozsnpcppznxdbvdhtjbopzillbpwttcb"..., packet_length=13031) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1030 #20 0x00000000005d76d2 in do_command (thd=0x2a92240) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:770 #21 0x00000000006b108c in do_handle_one_connection (thd_arg=0x2a92240) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:745 #22 0x00000000006b0ee9 in handle_one_connection (arg=0x2a92240) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #23 0x00000030e1807761 in start_thread (arg=0x7ffff417f710) at pthread_create.c:301 #24 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 21 (Thread 0x7ffff41c0710 (LWP 24572)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x7fff9000b018, mp=0x7fff9000afa0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x7fff9000b018, mutex=0x7fff9000afa0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x7fff9000afa0, reset_sig_count=251981) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009387aa in sync_array_wait_event (arr=0x125a5c0, index=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0arr.c:457 #5 0x000000000093ab52 in rw_lock_x_lock_func (lock=0x7fff9000c880, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=504) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:694 #6 0x00000000009ded39 in mtr_x_lock_func (lock=0x7fff9000c880, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=504, mtr=0x7ffff41bd5f0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/mtr0mtr.ic:271 #7 0x000000000095e520 in btr_cur_search_to_nth_level (index=0x7fff9000c808, level=0, tuple=0x7fffb4012088, mode=4, latch_mode=33, cursor=0x7fffb40071f0, has_search_latch=0, file=0xc6a300 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0umod.c", line=127, mtr=0x7ffff41bd5f0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:504 #8 0x000000000096860c in btr_pcur_open_with_no_init_func (index=0x7fff9000c808, tuple=0x7fffb4012088, mode=4, latch_mode=33, cursor=0x7fffb40071f0, has_search_latch=0, file=0xc6a300 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0umod.c", line=127, mtr=0x7ffff41bd5f0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/include/btr0pcur.ic:542 #9 0x000000000096932b in btr_pcur_restore_position_func (latch_mode=33, cursor=0x7fffb40071f0, file=0xc6a300 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0umod.c", line=127, mtr=0x7ffff41bd5f0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0pcur.c:321 #10 0x0000000000a0f0a9 in row_undo_mod_clust_low (node=0x7fffb4007178, thr=0x7fffb4011ed0, mtr=0x7ffff41bd5f0, mode=33) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0umod.c:127 #11 0x0000000000a0f478 in row_undo_mod_clust (node=0x7fffb4007178, thr=0x7fffb4011ed0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0umod.c:273 #12 0x0000000000a106ef in row_undo_mod (node=0x7fffb4007178, thr=0x7fffb4011ed0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0umod.c:893 #13 0x0000000000a06aa7 in row_undo (node=0x7fffb4007178, thr=0x7fffb4011ed0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0undo.c:325 #14 0x0000000000a06ba7 in row_undo_step (thr=0x7fffb4011ed0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0undo.c:367 #15 0x00000000009fe056 in que_thr_step (thr=0x7fffb4011ed0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1245 #16 0x00000000009fe272 in que_run_threads_low (thr=0x7fffb4011ed0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1305 #17 0x00000000009fe386 in que_run_threads (thr=0x7fffb400df50) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1342 #18 0x0000000000943ded in trx_general_rollback_for_mysql (trx=0x7fffb40065e8, savept=0x7ffff41bdd00) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/trx/trx0roll.c:97 #19 0x000000000091bde5 in row_mysql_handle_errors (new_err=0x7ffff41bdcf8, trx=0x7fffb40065e8, thr=0x7fff9c0244d8, savept=0x7ffff41bdd00) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0mysql.c:589 #20 0x000000000091d5ef in row_update_for_mysql (mysql_rec=0x7fff9c008788 "\376\v\023\001", prebuilt=0x7fff9c00a128) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0mysql.c:1470 #21 0x0000000000900e4a in ha_innobase::update_row (this=0x7fff9c008050, old_row=0x7fff9c008788 "\376\v\023\001", new_row=0x7fff9c008770 "\376\v\023\001") at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/handler/ha_innodb.cc:5252 #22 0x000000000073b482 in handler::ha_update_row (this=0x7fff9c008050, old_data=0x7fff9c008788 "\376\v\023\001", new_data=0x7fff9c008770 "\376\v\023\001") at /home/sbester/build/bzr/mysql-5.5-security/sql/handler.cc:4743 #23 0x0000000000670d4a in mysql_update (thd=0x2a4e660, table_list=0x7fffb4013e00, fields=..., values=..., conds=0x7fffb4033d60, order_num=0, order=0x0, limit=3, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ffff41bee70, updated_return=0x7ffff41bee68) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_update.cc:660 #24 0x00000000005dbf1d in mysql_execute_command (thd=0x2a4e660) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:2703 #25 0x00000000005e383f in mysql_parse (thd=0x2a4e660, rawbuf=0x7fffb401b5b0 "update ignore `blobtest` set `data`='bhzacfqdznntbqsecbkjyjpmmdlesmahivzvdfrhgtazbkmlgtqnrhvpplvrmgjrlfaujkttdihoacujeaxyniicxacnrinuhrcxtydpvrasmgmkipeznwzajbgbbpplesqobqgioamgdmjajlkcwtqyqdzdejazcko"..., length=37970, parser_state=0x7ffff41bf730) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:5500 #26 0x00000000005d8072 in dispatch_command (command=COM_QUERY, thd=0x2a4e660, packet=0x2aa0541 "update ignore `blobtest` set `data`='bhzacfqdznntbqsecbkjyjpmmdlesmahivzvdfrhgtazbkmlgtqnrhvpplvrmgjrlfaujkttdihoacujeaxyniicxacnrinuhrcxtydpvrasmgmkipeznwzajbgbbpplesqobqgioamgdmjajlkcwtqyqdzdejazcko"..., packet_length=37970) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:1030 #27 0x00000000005d76d2 in do_command (thd=0x2a4e660) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_parse.cc:770 #28 0x00000000006b108c in do_handle_one_connection (thd_arg=0x2a4e660) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:745 #29 0x00000000006b0ee9 in handle_one_connection (arg=0x2a4e660) at /home/sbester/build/bzr/mysql-5.5-security/sql/sql_connect.cc:684 #30 0x00000030e1807761 in start_thread (arg=0x7ffff41c0710) at pthread_create.c:301 #31 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 19 (Thread 0x7ffff4242710 (LWP 24555)): #0 do_sigwait (set=, sig=0x7ffff4241ea8) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 __sigwait (set=, sig=0x7ffff4241ea8) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x0000000000545459 in signal_hand (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/sql/mysqld.cc:2702 #3 0x00000030e1807761 in start_thread (arg=0x7ffff4242710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 18 (Thread 0x7fffbbfff710 (LWP 24554)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x29a3458, mp=0x29a33e0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x29a3458, mutex=0x29a33e0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x29a33e0, reset_sig_count=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009387aa in sync_array_wait_event (arr=0x125a5c0, index=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0arr.c:457 #5 0x000000000093a75a in rw_lock_x_lock_wait (lock=0x7fffd0bab700, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:529 #6 0x000000000093a835 in rw_lock_x_lock_low (lock=0x7fffd0bab700, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:572 #7 0x000000000093a93b in rw_lock_x_lock_func (lock=0x7fffd0bab700, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:628 #8 0x00000000009757c2 in buf_page_get_gen (space=6, zip_size=0, offset=17263, rw_latch=2, guess=0x0, mode=10, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599, mtr=0x7fffbbffe1b0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c:3067 #9 0x000000000096686f in btr_free_externally_stored_field (index=0x7fff9000c808, field_ref=0x7fffe0c2da38 "", rec=0x0, offsets=0x0, page_zip=0x0, i=0, rb_ctx=RB_NONE, local_mtr=0x7fffbbffe710) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:4598 #10 0x0000000000a05ef0 in row_purge_upd_exist_or_extern (node=0x2a4dfe8) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c:591 #11 0x0000000000a0635e in row_purge (node=0x2a4dfe8, thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c:759 #12 0x0000000000a0644e in row_purge_step (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c:802 #13 0x00000000009fe072 in que_thr_step (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1247 #14 0x00000000009fe272 in que_run_threads_low (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1305 #15 0x00000000009fe386 in que_run_threads (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1342 #16 0x0000000000940cb1 in trx_purge (limit=20) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/trx/trx0purge.c:1184 #17 0x0000000000934629 in srv_master_do_purge () at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2562 #18 0x0000000000934e21 in srv_master_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2793 #19 0x00000030e1807761 in start_thread (arg=0x7fffbbfff710) at pthread_create.c:301 #20 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 17 (Thread 0x7fffc928c710 (LWP 24553)): #0 0x00000030e14da043 in select () at ../sysdeps/unix/syscall-template.S:82 #1 0x00000000009e5d62 in os_thread_sleep (tm=5000000) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0thread.c:274 #2 0x0000000000933bf1 in srv_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2082 #3 0x00000030e1807761 in start_thread (arg=0x7fffc928c710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 16 (Thread 0x7fffc9c8d710 (LWP 24552)): #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x00000000009342ac in srv_error_monitor_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2387 #3 0x00000030e1807761 in start_thread (arg=0x7fffc9c8d710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 15 (Thread 0x7fffca68e710 (LWP 24551)): #0 0x00000030e14da043 in select () at ../sysdeps/unix/syscall-template.S:82 #1 0x00000000009e5d62 in os_thread_sleep (tm=1000000) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0thread.c:274 #2 0x0000000000933f9d in srv_lock_timeout_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2228 #3 0x00000030e1807761 in start_thread (arg=0x7fffca68e710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 13 (Thread 0x7fffcbf9d710 (LWP 24526)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x18549b8, mp=0x1854940, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x18549b8, mutex=0x1854940) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854940, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=9, message1=0x7fffcbf9ce50, message2=0x7fffcbf9ce48, type=0x7fffcbf9ce40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=9) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218348) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffcbf9d710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 12 (Thread 0x7fffcc99e710 (LWP 24525)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x18548f8, mp=0x1854880, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x18548f8, mutex=0x1854880) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854880, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=8, message1=0x7fffcc99de50, message2=0x7fffcc99de48, type=0x7fffcc99de40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=8) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218340) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffcc99e710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 11 (Thread 0x7fffcd39f710 (LWP 24524)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x1854838, mp=0x18547c0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x1854838, mutex=0x18547c0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x18547c0, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=7, message1=0x7fffcd39ee50, message2=0x7fffcd39ee48, type=0x7fffcd39ee40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=7) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218338) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffcd39f710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 10 (Thread 0x7fffcdda0710 (LWP 24523)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x1854778, mp=0x1854700, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x1854778, mutex=0x1854700) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854700, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=6, message1=0x7fffcdd9fe50, message2=0x7fffcdd9fe48, type=0x7fffcdd9fe40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=6) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218330) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffcdda0710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 9 (Thread 0x7fffce7a1710 (LWP 24522)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x18546b8, mp=0x1854640, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x18546b8, mutex=0x1854640) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854640, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=5, message1=0x7fffce7a0e50, message2=0x7fffce7a0e48, type=0x7fffce7a0e40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=5) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218328) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffce7a1710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 8 (Thread 0x7fffcf1a2710 (LWP 24521)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x18545f8, mp=0x1854580, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x18545f8, mutex=0x1854580) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854580, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=4, message1=0x7fffcf1a1e50, message2=0x7fffcf1a1e48, type=0x7fffcf1a1e40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=4) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218320) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffcf1a2710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 7 (Thread 0x7fffcfba3710 (LWP 24520)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x1854538, mp=0x18544c0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x1854538, mutex=0x18544c0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x18544c0, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=3, message1=0x7fffcfba2e50, message2=0x7fffcfba2e48, type=0x7fffcfba2e40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=3) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218318) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7fffcfba3710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 6 (Thread 0x7ffff4e6f710 (LWP 24519)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x1854478, mp=0x1854400, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x1854478, mutex=0x1854400) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854400, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=2, message1=0x7ffff4e6ee50, message2=0x7ffff4e6ee48, type=0x7ffff4e6ee40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=2) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218310) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7ffff4e6f710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 5 (Thread 0x7ffff5870710 (LWP 24518)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x18543b8, mp=0x1854340, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x18543b8, mutex=0x1854340) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854340, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=1, message1=0x7ffff586fe50, message2=0x7ffff586fe48, type=0x7ffff586fe40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218308) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7ffff5870710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 0x7ffff7fd8710 (LWP 24517)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x18542f8, mp=0x1854280, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x18542f8, mutex=0x1854280) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 #3 0x00000000009e553f in os_event_wait_low (event=0x1854280, reset_sig_count=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 #4 0x00000000009e3c62 in os_aio_simulated_handle (global_segment=0, message1=0x7ffff7fd7e50, message2=0x7ffff7fd7e48, type=0x7ffff7fd7e40) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0file.c:4881 #5 0x00000000009a77de in fil_aio_wait (segment=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/fil/fil0fil.c:4464 #6 0x0000000000935e9e in io_handler_thread (arg=0x1218300) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0start.c:494 #7 0x00000030e1807761 in start_thread (arg=0x7ffff7fd8710) at pthread_create.c:301 #8 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1 (Thread 0x7ffff7fda700 (LWP 24512)): #0 0x00000030e14d7de3 in __poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x0000000000548716 in handle_connections_sockets () at /home/sbester/build/bzr/mysql-5.5-security/sql/mysqld.cc:5096 #2 0x0000000000547d16 in mysqld_main (argc=11, argv=0x1227e28) at /home/sbester/build/bzr/mysql-5.5-security/sql/mysqld.cc:4566 #3 0x0000000000541204 in main (argc=10, argv=0x7fffffffe3f8) at /home/sbester/build/bzr/mysql-5.5-security/sql/main.cc:24 (gdb) (gdb) bt full #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 No locals. #1 0x0000000000a5c3d1 in safe_cond_wait (cond=0x29a3458, mp=0x29a33e0, file=0xc62fe8 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c", line=140) at /home/sbester/build/bzr/mysql-5.5-security/mysys/thr_mutex.c:240 error = 0 #2 0x00000000009e4ce5 in os_cond_wait (cond=0x29a3458, mutex=0x29a33e0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:140 No locals. #3 0x00000000009e553f in os_event_wait_low (event=0x29a33e0, reset_sig_count=1) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/os/os0sync.c:567 old_signal_count = 1 #4 0x00000000009387aa in sync_array_wait_event (arr=0x125a5c0, index=0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0arr.c:457 cell = 0x7ffff6ceb010 event = 0x29a33e0 #5 0x000000000093a75a in rw_lock_x_lock_wait (lock=0x7fffd0bab700, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:529 index = 0 i = 0 #6 0x000000000093a835 in rw_lock_x_lock_low (lock=0x7fffd0bab700, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:572 curr_thread = 140736347502352 #7 0x000000000093a93b in rw_lock_x_lock_func (lock=0x7fffd0bab700, pass=0, file_name=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/sync/sync0rw.c:628 index = 140736695285176 i = 0 spinning = 0 #8 0x00000000009757c2 in buf_page_get_gen (space=6, zip_size=0, offset=17263, rw_latch=2, guess=0x0, mode=10, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599, mtr=0x7fffbbffe1b0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c:3067 block = 0x7fffd0bab5b8 fold = 6308725 access_time = 3335398670 fix_type = 2 must_read = 0 retries = 0 buf_pool = 0x1869158 #9 0x000000000096686f in btr_free_externally_stored_field (index=0x7fff9000c808, field_ref=0x7fffe0c2da38 "", rec=0x0, offsets=0x0, page_zip=0x0, i=0, rb_ctx=RB_NONE, local_mtr=0x7fffbbffe710) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:4598 ext_block = 0x96e0cf page = 0x2
space_id = 6 rec_zip_size = 0 ext_zip_size = 0 page_no = 17263 next_page_no = 140736687265544 mtr = { state = 12231, memo = { heap = 0x0, used = 16, data = "\002\000\000\000\000\000\000\000\bW@\320\377\177\000\000\003", '\000' , "\002", '\000' , "6", '\000' , "\002", '\000' , "\002", '\000' , "\002", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "\002", '\000' , "\002\000\000\000\000\000\000\000\250\340\377\273\377\177\000\000\b$\000\260\377\177\000\000\000\000\000\000\000\000\000\000\b$\000\260\377\177", '\000' ..., base = warning: can't find linker symbol for virtual table for `(null)' value { count = 9678611, start = 0x0, end = 0x39d }, list = { prev = 0xc51ef0, next = 0x1854a78 }, buf_end = 0, magic_n = 375767 }, log = { heap = 0x0, used = 0, data = "\000@\000\000\000\000\000\000\230[\236\000\000\000\000\000`\344\377\273\377\177\000\000\065\000\000\000\000\000\000\000\030Q\304\000\000\000\000\000\020\016>\320\377\177\000\000\000\000\020", '\000' , "\020\a\034\364\377\177\000\000\000\000\000\000\000\000\000\000\240\344\377\273\377\177\000\000\065\250\223\000\000\000\000\000\065\000\000\000\000\000\000\000\030Q\304", '\000' , "\020\016>\320\377\177\000\000\000\000\000\000\000\000\000\000\020\367\377\273\377\177\000\000 \345\377\273\377\177\000\000;\251\223\000\000\000\000\000\360\344\377\273\377\177\000\000\227Õ\000\000\000\000\000\020\000\000\000\000\000\000\000\030\347\377\273\377\177\000\000\030\347\377\273\377\177\000\000\020\000\000\000\000\000\000\000 \345\377\273\377\177\000\000\202\346\235", '\000' , "`\214!\001\000\000\000\000 \345\377\273\377\177\000\000n\267\223\000\000\000\000\000\030\347\377\273\377\177\000\000\230[\236\000\000\000\000\000`\345\377\273\377\177\000\000"..., base = { count = 140736347498264, start = 0x7fffbbffe748, end = 0x7fffbbffe6d0 }, list = warning: can't find linker symbol for virtual table for `(null)' value { prev = 0x9757e1, next = 0xa }, buf_end = 0, magic_n = 375767 }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 140736347498256, end_lsn = 140736687265544, magic_n = 54551 } #10 0x0000000000a05ef0 in row_purge_upd_exist_or_extern (node=0x2a4dfe8) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c:591 block = 0x7fffd0405708 internal_offset = 35 data_field = 0x7fffe0c2d738 "oftwmhjnswssiphoskmzobshsricqeqmauvzsgnuhbyvttbldsupzgpwafsutnwvvgniimmmkecrjkkmiuujvbpyikdfwngfccayhyrkjejubbcorujtalbhlidkcllczfkhczttutrqelhsogulqpcdalimesghenpaqnbmpfmrcefrdwijkdqkgxkhvuqqzlifzfor"... ufield = 0x7fffb0001130 heap = 0x7fffb0001e80 entry = 0x7fffb0002030 index = 0x7fff9000c808 is_insert = 0 rseg_id = 47 page_no = 458 offset = 5909 i = 0 mtr = { state = 12231, memo = { heap = 0x0, used = 48, data = "8\000\000\000\000\000\000\000\200\310\000\220\377\177\000\000\002\000\000\000\000\000\000\000\310\f>\320\377\177\000\000\002\000\000\000\000\000\000\000\bW@\320\377\177\000\000\340O\203\001\000\000\000\000\200\347\377\273\377\177\000\000%Z\236\000\000\000\000\000\372(\276L\000\000\000\000\060P\203\001\000\000\000\000\240\347\377\273\377\177\000\000\250W\236\000\000\000\000\000 \350\377\273\377\177\000\000\240P\203\001\000\000\000\000 \350\377\273\377\177\000\000\313,\236\000\000\000\000\000\320\347\377\273\377\177\000\000\004\000\000\000\000\000\000\000\070\266\000\220\377\177\000\000\340\023\205\001\016\000\000\000\240\272\354\317\377\177\000\000\070\265\000\220\377\177\000\000\340O\203\001\000\000\000\000\v\000\000\000\000\000\000\000\000Z\034\004\000\000\000\000\360h\203\001\000\000\000\000\062\000\000\000\000\000\000\000\002", '\000' "\311, \300\245", '\000' , "cÂ¥\000\000\000\000\000\000\000\000\000\312\002\000\000\350/\306\000\331"..., base = { count = 0, start = 0x0, end = 0x68000000e3 }, list = { prev = 0x7c00000062, next = 0x6e00000077 }, buf_end = 0, magic_n = 375767 }, log = { heap = 0x0, used = 0, data = "\320\371\377\273\377\177\000\000\000\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000=\232G\341\060\000\000\000\a\000\000\000\000\000\000\000\a\000\000\000\000\000\000\000\360\351\377\273\377\177\000\000 7\225\000\000\000\000\000\200\251%\001\000\000\000\000\b\000\000\000\000\000\000\000\350\344\244\002\000\000\000\000P\020\000\260\377\177\000\000\360\351\377\273\377\177\000\000>\223\235\000\000\000\000\000x\000\000\000\000\000\000\000P\020\000\260\377\177\000\000P\352\377\273\377\177\000\000\263\253\235\000\000\000\000\000 \352\377\273\377\177\000\000L\000\000\000\000\000\000\000\350\344\244\002", '\000' "\260, \r\000\000\000\000\000\000\340\344\244\002\000\000\000\000\300\352\377\273\377\177\000\000(\016", '\000' , "P\020\000\260\377\177\000\000p\352\377\273\377\177\000\000>\223\235\000\000\000\000\000\030\002\000\000\000\000\000\000P\020\000\260\377\177\000\000\300\352\377\273\377\177\000\000\251\225\235\000\000\000\000\000\260\000\000\000\000\000\000\000\377"..., base = { count = 5, start = 0x7fffb0001208, end = 0x7fff90009f90 }, list = { prev = 0x1, next = 0x7fff90009d18 }, buf_end = 0, magic_n = 375767 }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 44360016, end_lsn = 44353856, magic_n = 54551 } #11 0x0000000000a0635e in row_purge (node=0x2a4dfe8, thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c:759 roll_ptr = 13229323935422229 purge_needed = 1 updated_extern = 1 trx = 0x2a4d398 #12 0x0000000000a0644e in row_purge_step (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/row/row0purge.c:802 node = 0x2a4dfe8 err = 44359656 #13 0x00000000009fe072 in que_thr_step (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1247 node = 0x2a4dfe8 old_thr = 0x2a4de30 trx = 0x2a4d398 type = 13 #14 0x00000000009fe272 in que_run_threads_low (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1305 next_thr = 0x2a4de30 loop_count = 33 #15 0x00000000009fe386 in que_run_threads (thr=0x2a4de30) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/que/que0que.c:1342 No locals. #16 0x0000000000940cb1 in trx_purge (limit=20) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/trx/trx0purge.c:1184 thr = 0x2a4de30 old_pages_handled = 79798 #17 0x0000000000934629 in srv_master_do_purge () at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2562 n_pages_purged = 1287530751 #18 0x0000000000934e21 in srv_master_thread (arg=0x0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/srv/srv0srv.c:2793 buf_stat = { n_page_gets = 55900089, n_pages_read = 58923, n_pages_written = 504516, n_pages_created = 71338, n_ra_pages_read = 0, n_ra_pages_evicted = 22, n_pages_made_young = 68120, n_pages_not_made_young = 0 } event = 0x126f8f0 old_activity_count = 1694154 n_pages_purged = 0 n_bytes_merged = 0 n_pages_flushed = 0 n_bytes_archived = 0 n_tables_to_drop = 0 n_ios = 574487 n_ios_old = 574269 n_ios_very_old = 571969 n_pend_ios = 128 next_itr_time = 1287530752544 i = 10 #19 0x00000030e1807761 in start_thread (arg=0x7fffbbfff710) at pthread_create.c:301 __res = pd = 0x7fffbbfff710 now = unwind_buf = { cancel_jmp_buf = {{ jmp_buf = {140736347502352, -3213608340963384661, 140737488344752, 140736347503056, 0, 3, 3213757873970815659, -3240556271879511381}, mask_was_saved = 0 }}, priv = { pad = {0x0, 0x0, 0x0, 0x0}, data = { prev = 0x0, cleanup = 0x0, canceltype = 0 } } } not_first_call = sp = freesize = #20 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 No locals. (gdb) (gdb) frame 9 #9 0x000000000096686f in btr_free_externally_stored_field (index=0x7fff9000c808, field_ref=0x7fffe0c2da38 "", rec=0x0, offsets=0x0, page_zip=0x0, i=0, rb_ctx=RB_NONE, local_mtr=0x7fffbbffe710) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c:4598 4598 ext_block = buf_page_get(space_id, ext_zip_size, page_no, (gdb) list 4593 mtr_commit(&mtr); 4594 4595 return; 4596 } 4597 4598 ext_block = buf_page_get(space_id, ext_zip_size, page_no, 4599 RW_X_LATCH, &mtr); 4600 buf_block_dbg_add_level(ext_block, SYNC_EXTERN_STORAGE); 4601 page = buf_block_get_frame(ext_block); 4602 (gdb) info locals ext_block = 0x96e0cf page = 0x2
space_id = 6 rec_zip_size = 0 ext_zip_size = 0 page_no = 17263 next_page_no = 140736687265544 mtr = { state = 12231, memo = { heap = 0x0, used = 16, data = "\002\000\000\000\000\000\000\000\bW@\320\377\177\000\000\003", '\000' , "\002", '\000' , "6", '\000' , "\002", '\000' , "\002", '\000' , "\002", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "6", '\000' , "\002", '\000' , "\002\000\000\000\000\000\000\000\250\340\377\273\377\177\000\000\b$\000\260\377\177\000\000\000\000\000\000\000\000\000\000\b$\000\260\377\177", '\000' ..., base = warning: can't find linker symbol for virtual table for `(null)' value { count = 9678611, start = 0x0, end = 0x39d }, list = { prev = 0xc51ef0, next = 0x1854a78 }, buf_end = 0, magic_n = 375767 }, log = { heap = 0x0, used = 0, data = "\000@\000\000\000\000\000\000\230[\236\000\000\000\000\000`\344\377\273\377\177\000\000\065\000\000\000\000\000\000\000\030Q\304\000\000\000\000\000\020\016>\320\377\177\000\000\000\000\020", '\000' , "\020\a\034\364\377\177\000\000\000\000\000\000\000\000\000\000\240\344\377\273\377\177\000\000\065\250\223\000\000\000\000\000\065\000\000\000\000\000\000\000\030Q\304", '\000' , "\020\016>\320\377\177\000\000\000\000\000\000\000\000\000\000\020\367\377\273\377\177\000\000 \345\377\273\377\177\000\000;\251\223\000\000\000\000\000\360\344\377\273\377\177\000\000\227Õ\000\000\000\000\000\020\000\000\000\000\000\000\000\030\347\377\273\377\177\000\000\030\347\377\273\377\177\000\000\020\000\000\000\000\000\000\000 \345\377\273\377\177\000\000\202\346\235", '\000' , "`\214!\001\000\000\000\000 \345\377\273\377\177\000\000n\267\223\000\000\000\000\000\030\347\377\273\377\177\000\000\230[\236\000\000\000\000\000`\345\377\273\377\177\000\000"..., base = { count = 140736347498264, start = 0x7fffbbffe748, end = 0x7fffbbffe6d0 }, list = warning: can't find linker symbol for virtual table for `(null)' value { prev = 0x9757e1, next = 0xa }, buf_end = 0, magic_n = 375767 }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 140736347498256, end_lsn = 140736687265544, magic_n = 54551 } (gdb) (gdb) frame 8 #8 0x00000000009757c2 in buf_page_get_gen (space=6, zip_size=0, offset=17263, rw_latch=2, guess=0x0, mode=10, file=0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", line=4599, mtr=0x7fffbbffe1b0) at /home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c:3067 3067 rw_lock_x_lock_func(&(block->lock), 0, file, line); (gdb) list 3062 fix_type = MTR_MEMO_PAGE_S_FIX; 3063 break; 3064 3065 default: 3066 ut_ad(rw_latch == RW_X_LATCH); 3067 rw_lock_x_lock_func(&(block->lock), 0, file, line); 3068 3069 fix_type = MTR_MEMO_PAGE_X_FIX; 3070 break; 3071 } (gdb) print block $1 = (buf_block_t *) 0x7fffd0bab5b8 (gdb) print *block $2 = { page = { space = 6, offset = 17263, state = 5, flush_type = 2, io_fix = 0, buf_fix_count = 2, zip = { data = 0x0, m_start = 0, m_end = 0, m_nonempty = 0, n_blobs = 0, ssize = 0 }, hash = 0x0, in_page_hash = 1, in_zip_hash = 0, list = { prev = 0x7fffd09f0660, next = 0x7fffcfc5a068 }, in_flush_list = 1, in_free_list = 0, newest_modification = 32657776095, oldest_modification = 32635621304, LRU = { prev = 0x7fffd0a8c408, next = 0x7fffcfc5a068 }, in_LRU_list = 1, old = 0, freed_page_clock = 97377, access_time = 3335398670, buf_pool = 0x1869158 }, frame = 0x7fffef5f4000 "", unzip_LRU = { prev = 0x0, next = 0x0 }, in_unzip_LRU_list = 0, mutex = { event = 0x29a3260, lock_word = 0 '\000', waiters = 0, list = { prev = 0x7fffd0bab880, next = 0x7fffd0bab450 }, cfile_name = 0xc49120 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c", cline = 897, thread_id = 18446744073709551615, magic_n = 979585, count_os_wait = 0, count_using = 12523, count_spin_loop = 0, count_spin_rounds = 0, count_os_yield = 0, lspent_time = 0, lmax_spent_time = 0, cmutex_name = 0xc4989c "&block->mutex", mutex_type = 0, pfs_psi = 0x0 }, lock = { lock_word = -1, waiters = 0, recursive = 1, writer_thread = 140736347502352, event = 0x29a3320, wait_ex_event = 0x29a33e0, list = { prev = 0x7fffd0bab918, next = 0x7fffd0bab4e8 }, pfs_psi = 0x0, count_os_wait = 1, cfile_name = 0xc49120 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c", last_s_file_name = 0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", last_x_file_name = 0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", writer_is_wait_ex = 0, cline = 898, last_s_line = 4779, last_x_line = 4207, magic_n = 22643 }, lock_hash_val = 56126, check_index_page_at_flush = 0, modify_clock = 26, n_hash_helps = 1, n_fields = 0, n_bytes = 1, left_side = 1, n_pointers = 0, is_hashed = 0, curr_n_fields = 0, curr_n_bytes = 0, curr_left_side = 0, index = 0x0 } (gdb) (gdb) print block->lock $3 = { lock_word = -1, waiters = 0, recursive = 1, writer_thread = 140736347502352, event = 0x29a3320, wait_ex_event = 0x29a33e0, list = { prev = 0x7fffd0bab918, next = 0x7fffd0bab4e8 }, pfs_psi = 0x0, count_os_wait = 1, cfile_name = 0xc49120 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/buf/buf0buf.c", last_s_file_name = 0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", last_x_file_name = 0xc46ca0 "/home/sbester/build/bzr/mysql-5.5-security/storage/innobase/btr/btr0cur.c", writer_is_wait_ex = 0, cline = 898, last_s_line = 4779, last_x_line = 4207, magic_n = 22643 } (gdb)