Three threads running zlibdml.php caused hangup after some hours. [sbester@levovo mysql-5.5-innodb]$ bzr log| head -n 10 ------------------------------------------------------------ revno: 3192 committer: Marko Mäkelä branch nick: 5.5-innodb timestamp: Wed 2010-10-20 15:58:47 +0300 (gdb) set arg --no-defaults --innodb-file-per-table --skip-gr --skip-na --innodb-flush-log-at-trx-commit=0 --innodb-doublewrite=0 --innodb-support-xa=0 --innodb-log-file-size=500M --innodb-buffer-pool-size=512M --innodb-log-buffer-size=32M --basedir=. --datadir=./data --innodb-file-format=barracuda --innodb-flush-method=O_DIRECT (gdb) run Starting program: /home/sbester/mysql/5.5/mysql-5.5.8-ga-linux-x86_64/bin/mysqld --no-defaults --innodb-file-per-table --skip-gr --skip-na --innodb-flush-log-at-trx-commit=0 --innodb-doublewrite=0 --innodb-support-xa=0 --innodb-log-file-size=500M --innodb-buffer-pool-size=512M --innodb-log-buffer-size=32M --basedir=. --datadir=./data --innodb-file-format=barracuda --innodb-flush-method=O_DIRECT [Thread debugging using libthread_db enabled] [New Thread 0x7ffff7fd8710 (LWP 28669)] [Thread 0x7ffff7fd8710 (LWP 28669) exited] [New Thread 0x7ffff7fd8710 (LWP 28670)] [Thread 0x7ffff7fd8710 (LWP 28670) exited] 101020 17:20:19 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Compressed tables use zlib 1.2.3 101020 17:20:19 InnoDB: Initializing buffer pool, size = 512.0M 101020 17:20:19 InnoDB: Completed initialization of buffer pool [New Thread 0x7ffff7fd8710 (LWP 28671)] [New Thread 0x7fffcf3bf710 (LWP 28672)] [New Thread 0x7fffce9be710 (LWP 28673)] [New Thread 0x7fffcdfbd710 (LWP 28674)] [New Thread 0x7fffcd5bc710 (LWP 28675)] [New Thread 0x7fffccbbb710 (LWP 28676)] [New Thread 0x7fffcc1ba710 (LWP 28677)] [New Thread 0x7fffcb7b9710 (LWP 28678)] [New Thread 0x7fffcadb8710 (LWP 28679)] [New Thread 0x7fffca3b7710 (LWP 28680)] 101020 17:20:19 InnoDB: highest supported file format is Barracuda. [New Thread 0x7fffc99b6710 (LWP 28681)] [New Thread 0x7fffc8b20710 (LWP 28682)] [New Thread 0x7fffc811f710 (LWP 28683)] [Thread 0x7fffc99b6710 (LWP 28681) exited] [New Thread 0x7fffc771e710 (LWP 28684)] [New Thread 0x7fffc99b6710 (LWP 28685)] 101020 17:20:20 InnoDB: 1.1.3 started; log sequence number 22855679074 [New Thread 0x7ffff40d4710 (LWP 28686)] 101020 17:20:21 [Note] /home/sbester/mysql/5.5/mysql-5.5.8-ga-linux-x86_64/bin/mysqld: ready for connections. Version: '5.5.8-ga' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 0x7ffff4093710 (LWP 28688)] [Thread 0x7ffff4093710 (LWP 28688) exited] [New Thread 0x7ffff4052710 (LWP 28689)] [New Thread 0x7ffff4093710 (LWP 28705)] [New Thread 0x7fffc8fb5710 (LWP 18064)] [New Thread 0x7fffc6b10710 (LWP 18065)] [Thread 0x7fffc8fb5710 (LWP 18064) exited] [Thread 0x7ffff4093710 (LWP 28705) exited] [New Thread 0x7ffff4093710 (LWP 26446)] [Thread 0x7ffff4093710 (LWP 26446) exited] [New Thread 0x7fffc8fb5710 (LWP 26448)] InnoDB: Warning: a long semaphore wait: --Thread 140736565303056 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 511 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 InnoDB: Warning: a long semaphore wait: --Thread 140736526878480 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c line 2782 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7fffcf9c6b00 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/buf/buf0buf.c line 898 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 3265 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 4599 InnoDB: Warning: a long semaphore wait: --Thread 140737287366416 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 838 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 101020 23:02:16 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 50 seconds InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 140736565303056 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 511 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 InnoDB: Warning: a long semaphore wait: --Thread 140736526878480 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c line 2782 for 923.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7fffcf9c6b00 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/buf/buf0buf.c line 898 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 3265 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 4599 InnoDB: Warning: a long semaphore wait: --Thread 140737287366416 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 838 for 923.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 InnoDB: Warning: a long semaphore wait: --Thread 140736575792912 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 511 for 913.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 101020 23:13:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 40 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 16989 1_second, 16723 sleeps, 1697 10_second, 19 background, 18 flush srv_master_thread log flush and writes: 19389 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 493772, signal count 568124 --Thread 140736565303056 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 511 for 943.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 --Thread 140736526878480 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c line 2782 for 943.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x7fffcf9c6b00 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/buf/buf0buf.c line 898 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 3265 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 4599 --Thread 140737287366416 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 838 for 943.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 --Thread 140736575792912 has waited at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 511 for 933.00 seconds the semaphore: S-lock on RW-latch at 0x7fffbc00d1e0 created in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/dict/dict0dict.c line 1650 a writer (thread id 140736526878480) 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-innodb/storage/innobase/btr/btr0cur.c line 511 Last time write locked in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c line 504 Mutex spin waits 5585734, rounds 14704592, OS waits 100212 RW-shared spins 542987, rounds 11129705, OS waits 226855 RW-excl spins 201095, rounds 6431209, OS waits 152936 Spin rounds per wait: 2.63 mutex, 20.50 RW-shared, 31.98 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 101020 22:55:35 *** (1) TRANSACTION: TRANSACTION 4F9FFE, ACTIVE 0 sec, process no 28668, OS thread id 140736565303056 starting index read mysql tables in use 1, locked 1 LOCK WAIT 4 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1 MySQL thread id 7, query id 7106230 127.0.0.1 root Updating update ignore `blobtest` set `data`='qsrkvudmpnjnmpucoaigbpcqqaqbxejosfwuifgvsbmrqnzrudcuggpxdlczodcejgnrogjnvycjoxbdnbsvfrvnubfxvcgpajiyzraiaktsydftkvwsefupokegkeqiaqysdsyldnyzvqgrvbgyrwpzlrqlygluiamwsmfekpechabsmpqjtiisrrvgssuicwahufiwmgnjdlsodhpjabihlifzrktokojolkglvwdcyxwszdoxrownstrghftekyouxjuxiplbwfcxnczdtfeccuinyehmjmymoixsnbcbfqakytrpoabwoaaonbydxbszwhbnbrcmwvihpsbstdtxhgsspqsjygfkfzehaqxmobrlgmowrnwiynoawblsgaxofcbsnpnuqxaaesnbbshuhbcdxztafozyadytgyelfzcyfinklothmryrgmfdwseywrikxtxjbjeyqtgdenhclxakscaekhprtqmnihponakppgsfuumlfrfzvhaatuwhsgvvuvxtfsjbiewjtvmqrnnuanjtvhesilyussytavuhxctedhdowkekjzdscxbqimrsovsltumryrobwpdyhgzfwfckpsdeduqfrjgvjjnqqajkfwflmcyhxxzdmwovyhofqxfsugoufxujylfwixscrdbcqjgpmdrpckwfkpnjvsjphlwizuyvnmpyqdxbvpffpyjwbmhuctfgosizatfpghuxgswhvuutmjhoujwwrjikgxytihdpbegjxycxwmdbgdzkbrgrewvueaggibvggjdyvzpylixzineoywdcbzrvojozebgzueimijdhyshbfwjyluklmcndbncwdqilaqfzryugevtxlkrorbpodlqaowwqcufkddxcptdwuqunulumrzlrvsopdfrjrkgjpt *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 4 page no 9 n bits 72 index `PRIMARY` of table `test`.`blobtest` trx id 4F9FFE lock_mode X waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 8; hex 0000000000000003; asc ;; 1: len 6; hex 0000004f9ffd; asc O ;; 2: len 7; hex 16000003c00d9c; asc ;; 3: len 30; hex 6e7278647075656d74766d6f786668656966746b676d64657571746b6b7a; asc nrxdpuemtvmoxfheiftkgmdeuqtkkz; (total 788 bytes); *** (2) TRANSACTION: TRANSACTION 4F9FFD, ACTIVE 0 sec, process no 28668, OS thread id 140737287366416 fetching rows mysql tables in use 1, locked 1 6 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 3 MySQL thread id 2, query id 7106234 127.0.0.1 root Updating update ignore `blobtest` set `data`='nrxdpuemtvmoxfheiftkgmdeuqtkkzryufldygjhgmdzgstxxyedeujrjespckfimmxsbufptkazgmujoycpesfqcsememzasdgmtypetdjwdrlvhakgfdjjbwzvoxlmdulzcmzlqgfuvjqptgyzfwxyygioqtlkbwqqklkwniozjtpqnprhxjvurpgbmpvizewonlswntzzzkczhgtctgbgcnprqfqlnpmuzpkethgjgotmbpiavlrqpqhjppqnnjqvsiybfvxkakuesjsxqpkaqitwjoqzmbheyfjbzeghwvzysmwankxjnwwitakzfqgzphaponvrlvejiuimtogjzbmcvnqgwsgzlokhsbpiatutbptegnaxgbkgwjssvmobdlvyeurwgsmtbgiojbqkrqfwyswpuqbnlicmnzogefnfikjxmryyagwaxwfcgooauyaeahrkfabfjmhkbisybfqxmrxqbtutivmcipyruronwvuvunfzvczntsqtyczgmygnhafzppmseewfnthzstykxjqmnybuqreafawxfozmgudyzblelpumhjxasemfgwcaebbqwnpodyfhojztbeoesozyesyozdgtzhkhyllisiksncihckjakdsorycpwhapjugltpoisgponsbijrfszkcgevrgodmswghmccinkzmrhivqtuwtltxpyqhgrmwgghpfwgxieujorqkrzxdvjwkkqdyzamgodpsyykawzyhhgrufsobkwyqjcbymzcygczfftkyhbmdmqaaxjofurstaxrokyyohpnbuzagsmnhyqlqroteakizhczjdrusdrunokbbquygzavtbcjzdnsgdstajqrxefvhjilfbikviaxwqdpizgeccokhfkxuwcsqdjdksbjcqfapfzrrfux *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 4 page no 9 n bits 72 index `PRIMARY` of table `test`.`blobtest` trx id 4F9FFD lock_mode X locks rec but not gap Record lock, heap no 4 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 8; hex 0000000000000003; asc ;; 1: len 6; hex 0000004f9ffd; asc O ;; 2: len 7; hex 16000003c00d9c; asc ;; 3: len 30; hex 6e7278647075656d74766d6f786668656966746b676d64657571746b6b7a; asc nrxdpuemtvmoxfheiftkgmdeuqtkkz; (total 788 bytes); *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 4 page no 9 n bits 72 index `PRIMARY` of table `test`.`blobtest` trx id 4F9FFD lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 8; hex 0000000000000004; asc ;; 1: len 6; hex 0000004f9ffe; asc O ;; 2: len 7; hex 97000001890084; asc ;; 3: len 30; hex 6f6869677867637a746d777a78746f686e72687a776b6876626f656a746a; asc ohigxgcztmwzxtohnrhzwkhvboejtj; (total 3162 bytes); *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 518413 Purge done for trx's n:o < 5181E0 undo n:o < 0 History list length 205 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 518410, not started, process no 28668, OS thread id 140737287366416 estimating records in index range mysql tables in use 1, locked 1 MySQL thread id 2, query id 7302646 127.0.0.1 root init update ignore `blobtest` set `data`='nrkwacgbuahmbiufezvvmoluqbvjulfnjgjmbhlaegqwzwptkxfktvjrkaekmotiucmmksxidbindcsnnkjbuvchlgjswqcrfxdpugbqiyunafepinbhydpmrskkodjtfvpuywsdtkxihngucgxjglvfvlpvuyzdsvqzotehbhwrgxhbisfdghlcrvjmnoyvfmtcdgmahqwiderocmorkgqltbzuqkocnhhcwkjgvmbnagpokthmpbwolrabioemqqzildeekihanxzsdrdjvnllbqxconkpxzkqhisaxzmimvtkhzofxmdfmzftaohfmguvumerqmvbhmyesjgenbpkhsirnyuzhkporhrildwjfbakkkmofyqiwvwlsxecpkedohqgwuptlujzvrldwwnicuwgkbebokdpophystkogsnwcimzgesqeccvfldiailjoqoisxispxvimxkhnadfioljekaxtcawakjlwzsgjnzabovqfywkzcgsodysowmyxgscmeqpudwgsiuuafngduhiufpshnkkbmqldjiaxramvio ---TRANSACTION 518412, ACTIVE 943 sec, process no 28668, OS thread id 140736565303056 inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 376, 0 row lock(s) MySQL thread id 7, query id 7302645 127.0.0.1 root update replace into `blobtest` set `data`='xwasdhjkbpgxtxkxdxhdibhoedtbnomrzmwnruclujceqkrngaoiydqbrfnzljyvbdcdsfmlhintzuerceflpchnmctpgtxvmzlxxxhlfsmfucvgphmudauftbsmxthhxebzltadrukuggxkarzvqcrxaktiuqmbcgvvejcepwokwbidacgyqebyhlzugddovnbesbwagpazdltfgjqvnxcvzupoeropxkvxwcdmrynoczhfydmpiivougxkebsfutlsdfdfedjrocqmgfjvpyehxyxtirkozqcpivntybvdndpgjtqvilhidzqfpncpdyluxnsmsaqwgezgiegcvvzlhkibvtsbjoyennebjoxvxpyxbbpnfjhskldnohxdpbdutdwirgcjxtrmxckhsuicoextwktyxryjhezbrlpyrqvfcdnjvtljbzmyvttdqepyhhvaazpymayqxbqqsclljnxebmggvkckjusmhshccgadjtffuzvlenjghimxkhfirbegzyexhyqxxalmcsqlzedsvtimydqkwchmqawjrbtvqwtw ---TRANSACTION 518411, ACTIVE 943 sec, process no 28668, OS thread id 140736526878480 updating or deleting mysql tables in use 1, locked 1 14 lock struct(s), heap size 3112, 81 row lock(s), undo log entries 2 MySQL thread id 5, query id 7302643 127.0.0.1 root Updating update ignore `blobtest` set `data`='lastqnjymksllxmrpzxjpriefffmlucelqxzgbcdhuxrljnlijrnirbbdsncypooitbvyxkqwdqxqgvkpxnqxlggwvvfqjqfqdolflwosjwlwggptvwnsvqzizzobacvgnkdyvedrakgpezkiauzzjbzbqwaphtrpsmtpmgbnqifnjbutyhgxfawnbjsnkrdfttdhjwfmqbxyxpwmrrwacjfflyxpfzgzsocwmwknozuqysdvxxuertyxrsuagiswmemwskdrmxawqgwciaufpjjyqffimyzbdbrqtoccyubbvhobronpyvzyxylavnrifvhrfgwmjpcfbxutmbejfrnvozajjwmvrvnsknixfkqmduycuobkhlptahhsrdoehlcwhuvcnqqsrntknbotgxglnwpslntssaonckdepvjtunorzkqiidlfthagwlxwsslsmsjifenbwdhytvbwejbxijlmivytkkspljqutxjmlzfhermbsigeismsvodmzsxmwvrsgxcgleemqcumdbzhjzzbqdzwykqhdlamilkcmeqezj -------- 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 1836803 OS file reads, 1851534 OS file writes, 53293 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 18, seg size 20, 34039 merges merged operations: insert 36981, delete mark 5848, delete 757 discarded operations: insert 245, delete mark 10, delete 7 Hash table size 1106407, node heap has 41 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 179897939898 Log flushed up to 179897939898 Last checkpoint at 179209379991 0 pending log writes, 0 pending chkp writes 31420 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 549715968; in additional pool allocated 0 Dictionary memory allocated 38416 Buffer pool size 32768 Free buffers 4845 Database pages 27882 Old database pages 10272 Modified db pages 11287 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2718130, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1837000, created 2301748, written 5362307 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 27882, 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. 28668, id 140736575792912, state: master purging Number of rows inserted 1120889, updated 805322, deleted 773764, read 8534514 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 23:14:06 InnoDB: Assertion failure in thread 140736550008592 in file /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c line 2407 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 0x7fffc811f710 (LWP 28683)] 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 0x0000000000815e95 in srv_error_monitor_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2407 #3 0x00000030e1807761 in start_thread (arg=0x7fffc811f710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) set pagination off (gdb) set print pretty on (gdb) set print object on (gdb) thread apply all bt Thread 26 (Thread 0x7fffc8fb5710 (LWP 26448)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 #4 0x000000000081d99e in rw_lock_s_lock_spin (lock=0x7fffbc00d1e0, pass=, file_name=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", line=511) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:450 #5 0x000000000084e922 in rw_lock_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7fff900514b8, mode=4, latch_mode=2, cursor=0x7fffc8fb2460, has_search_latch=0, file=0xa8fcc8 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c", line=2002, mtr=0x7fffc8fb1bb0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/sync0rw.ic:418 #6 mtr_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7fff900514b8, mode=4, latch_mode=2, cursor=0x7fffc8fb2460, has_search_latch=0, file=0xa8fcc8 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c", line=2002, mtr=0x7fffc8fb1bb0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/mtr0mtr.ic:252 #7 btr_cur_search_to_nth_level (index=0x7fffbc00d168, level=0, tuple=0x7fff900514b8, mode=4, latch_mode=2, cursor=0x7fffc8fb2460, has_search_latch=0, file=0xa8fcc8 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c", line=2002, mtr=0x7fffc8fb1bb0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:511 #8 0x00000000008e36cb in row_ins_index_entry_low (mode=2, index=0x7fffbc00d168, entry=0x7fff900514b8, n_ext=0, thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2000 #9 0x00000000008e58d1 in row_ins_index_entry (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2171 #10 row_ins_index_entry_step (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2256 #11 row_ins (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2388 #12 row_ins_step (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2498 #13 0x00000000007ff766 in row_insert_for_mysql (mysql_rec=, prebuilt=0x7fffb8010848) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0mysql.c:1199 #14 0x00000000007f16b6 in ha_innobase::write_row (this=0x7fffb8025860, record=0x7fffb8025a60 "\376p~") at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/handler/ha_innodb.cc:4942 #15 0x0000000000678f7a in handler::ha_write_row (this=0x7fffb8025860, buf=0x7fffb8025a60 "\376p~") at /home/sbester/build/bzr/mysql-5.5-innodb/sql/handler.cc:4733 #16 0x000000000055ffd4 in write_record (thd=0x20b7440, table=0x7fffb8008c90, info=0x7fffc8fb2920) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_insert.cc:1516 #17 0x0000000000565efa in mysql_insert (thd=0x20b7440, table_list=0x7fffbc004b08, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_insert.cc:935 #18 0x0000000000577271 in mysql_execute_command (thd=0x20b7440) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:2823 #19 0x00000000005792f4 in mysql_parse (thd=0x20b7440, rawbuf=, length=40538, parser_state=0x7fffc8fb49f0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:5499 #20 0x000000000057a9b3 in dispatch_command (command=COM_QUERY, thd=0x20b7440, packet=, packet_length=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:1029 #21 0x00000000006144bb in do_handle_one_connection (thd_arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:745 #22 0x00000000006145bc in handle_one_connection (arg=0x20b7440) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:684 #23 0x00000030e1807761 in start_thread (arg=0x7fffc8fb5710) at pthread_create.c:301 #24 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 24 (Thread 0x7fffc6b10710 (LWP 18065)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1a5e3d0, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1a5e3d0, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 #4 0x000000000081e133 in rw_lock_x_lock_wait (lock=0x7fffcf9c6b00, pass=, file_name=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:529 #5 rw_lock_x_lock_low (lock=0x7fffcf9c6b00, pass=, file_name=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:572 #6 rw_lock_x_lock_func (lock=0x7fffcf9c6b00, pass=, file_name=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:628 #7 0x000000000085d0da in buf_page_get_gen (space=4, zip_size=0, offset=20608, rw_latch=2, guess=, mode=, file=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782, mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/buf/buf0buf.c:3107 #8 0x00000000008961c9 in fseg_alloc_free_page_low (space=4, zip_size=0, seg_inode=0x7fffd99300f2 "", hint=20627, direction=113 'q', mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c:2780 #9 0x0000000000896b62 in fseg_alloc_free_page_general (seg_header=, hint=20627, direction=113 'q', has_done_reservation=1, mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c:2868 #10 0x000000000083d194 in btr_page_alloc (index=, hint_page_no=20627, file_direction=113 'q', level=0, mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0btr.c:388 #11 0x000000000084d743 in btr_store_big_rec_extern_fields (index=0x7fffbc00d168, rec_block=, rec=0x7fffec24b6c1 "", offsets=0x7fffc6b0c5b0, big_rec_vec=0x7fff9008e7a8, local_mtr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:4184 #12 0x000000000080e3ac in row_upd_clust_rec (node=, index=0x7fffbc00d168, thr=, mtr=0x7fffc6b0c970) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:1808 #13 0x0000000000811847 in row_upd_clust_step (node=, thr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:2032 #14 0x0000000000812326 in row_upd (thr=0x7fffbc009968) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:2082 #15 row_upd_step (thr=0x7fffbc009968) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:2215 #16 0x00000000007fdaee in row_update_for_mysql (mysql_rec=, prebuilt=0x7fffbc009078) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0mysql.c:1444 #17 0x00000000007eeadf in ha_innobase::update_row (this=0x7fffbc007c50, old_row=0x7fffbc007e68 "\376\360S", new_row=0x7fffbc007e50 "\376\360S") at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/handler/ha_innodb.cc:5238 #18 0x0000000000678ec1 in handler::ha_update_row (this=0x7fffbc007c50, old_data=0x7fffbc007e68 "\376\360S", new_data=0x7fffbc007e50 "\376\360S") at /home/sbester/build/bzr/mysql-5.5-innodb/sql/handler.cc:4758 #19 0x00000000005e5474 in mysql_update (thd=0x211c600, table_list=0x7fff90004b08, fields=, values=..., conds=0x7fff90005468, order_num=, order=0x7fffc6b0d930, limit=2, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7fffc6b0edd8, updated_return=0x7fffc6b0edd0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_update.cc:707 #20 0x00000000005771e8 in mysql_execute_command (thd=0x211c600) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:2702 #21 0x00000000005792f4 in mysql_parse (thd=0x211c600, rawbuf=, length=39599, parser_state=0x7fffc6b0f9f0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:5499 #22 0x000000000057a9b3 in dispatch_command (command=COM_QUERY, thd=0x211c600, packet=, packet_length=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:1029 #23 0x00000000006144bb in do_handle_one_connection (thd_arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:745 #24 0x00000000006145bc in handle_one_connection (arg=0x211c600) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:684 #25 0x00000030e1807761 in start_thread (arg=0x7fffc6b10710) at pthread_create.c:301 #26 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 21 (Thread 0x7ffff4052710 (LWP 28689)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=2) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 #4 0x000000000081d99e in rw_lock_s_lock_spin (lock=0x7fffbc00d1e0, pass=, file_name=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", line=838) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:450 #5 0x000000000084b558 in rw_lock_s_lock_func (from_left=1, index=0x7fffbc00d168, cursor=0x7ffff404b5b0, line=3368, mtr=0x7ffff404b110, file=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", latch_mode=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/sync0rw.ic:418 #6 mtr_s_lock_func (from_left=1, index=0x7fffbc00d168, cursor=0x7ffff404b5b0, line=3368, mtr=0x7ffff404b110, file=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", latch_mode=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/mtr0mtr.ic:252 #7 btr_cur_open_at_index_side_func (from_left=1, index=0x7fffbc00d168, cursor=0x7ffff404b5b0, line=3368, mtr=0x7ffff404b110, file=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", latch_mode=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:838 #8 0x000000000084bca6 in btr_estimate_n_rows_in_range (index=0x7fffbc00d168, tuple1=, mode1=, tuple2=0x7fffb8022f20, mode2=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:3366 #9 0x00000000007eaf2e in ha_innobase::records_in_range (this=0x7fff90013750, keynr=, min_key=0x0, max_key=0x7ffff404b780) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/handler/ha_innodb.cc:7477 #10 0x0000000000730239 in check_quick_keys (param=0x7ffff404baa0, idx=0, key_tree=0x7fffb800eb70, min_key=, min_key_flag=0, min_keypart=-1, max_key=, max_key_flag=0, max_keypart=-1) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:7788 #11 0x0000000000730867 in check_quick_select (param=0x7ffff404baa0, idx=, tree=, update_tbl_stats=true) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:7559 #12 0x0000000000730ae2 in get_key_scans_params (param=0x7ffff404baa0, tree=0x7fffb800e918, index_read_must_be_used=false, update_tbl_stats=true, read_time=65811.199999999997) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:4959 #13 0x000000000073d2d8 in SQL_SELECT::test_quick_select (this=, thd=, keys_to_use=, prev_tables=, limit=, force_quick_range=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:2321 #14 0x00000000005e4991 in check_quick (thd=0x2104850, table_list=0x7fffb8004b08, fields=..., values=..., conds=0x7fffb8005468, order_num=, order=0x0, limit=5, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ffff4050dd8, updated_return=0x7ffff4050dd0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.h:826 #15 mysql_update (thd=0x2104850, table_list=0x7fffb8004b08, fields=..., values=..., conds=0x7fffb8005468, order_num=, order=0x0, limit=5, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ffff4050dd8, updated_return=0x7ffff4050dd0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_update.cc:399 #16 0x00000000005771e8 in mysql_execute_command (thd=0x2104850) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:2702 #17 0x00000000005792f4 in mysql_parse (thd=0x2104850, rawbuf=, length=31836, parser_state=0x7ffff40519f0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:5499 #18 0x000000000057a9b3 in dispatch_command (command=COM_QUERY, thd=0x2104850, packet=, packet_length=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:1029 #19 0x00000000006144bb in do_handle_one_connection (thd_arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:745 #20 0x00000000006145bc in handle_one_connection (arg=0x2104850) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:684 #21 0x00000030e1807761 in start_thread (arg=0x7ffff4052710) at pthread_create.c:301 #22 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 19 (Thread 0x7ffff40d4710 (LWP 28686)): #0 do_sigwait (set=, sig=0x7ffff40d3e78) at ../sysdeps/unix/sysv/linux/sigwait.c:65 #1 __sigwait (set=, sig=0x7ffff40d3e78) at ../sysdeps/unix/sysv/linux/sigwait.c:100 #2 0x00000000004ffc9b in signal_hand (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/mysqld.cc:2704 #3 0x00000030e1807761 in start_thread (arg=0x7ffff40d4710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 18 (Thread 0x7fffc99b6710 (LWP 28685)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=3) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 #4 0x000000000081d99e in rw_lock_s_lock_spin (lock=0x7fffbc00d1e0, pass=, file_name=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", line=511) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:450 #5 0x000000000084e922 in rw_lock_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7ffff0001728, mode=4, latch_mode=1, cursor=0x20b1e28, has_search_latch=0, file=0xa74d50 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c", line=674, mtr=0x7fffc99b4b40) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/sync0rw.ic:418 #6 mtr_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7ffff0001728, mode=4, latch_mode=1, cursor=0x20b1e28, has_search_latch=0, file=0xa74d50 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c", line=674, mtr=0x7fffc99b4b40) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/mtr0mtr.ic:252 #7 btr_cur_search_to_nth_level (index=0x7fffbc00d168, level=0, tuple=0x7ffff0001728, mode=4, latch_mode=1, cursor=0x20b1e28, has_search_latch=0, file=0xa74d50 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c", line=674, mtr=0x7fffc99b4b40) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:511 #8 0x0000000000804c7f in btr_pcur_open_func (pcur=0x20b1e28, mode=, table=, ref=0x7ffff0001728, mtr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/btr0pcur.ic:498 #9 row_search_on_row_ref (pcur=0x20b1e28, mode=, table=, ref=0x7ffff0001728, mtr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c:674 #10 0x00000000008e5c13 in row_purge_reposition_pcur (node=0x20b1dc8, index=0x7fffbc00d988, entry=0x7ffff0002558) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:101 #11 row_purge_poss_sec (node=0x20b1dc8, index=0x7fffbc00d988, entry=0x7ffff0002558) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:256 #12 0x00000000008e5dbb in row_purge_remove_sec_if_poss_leaf (node=0x20b1dc8, index=0x7fffbc00d988, entry=0x7ffff0002558) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:383 #13 0x00000000008e6214 in row_purge_remove_sec_if_poss (node=0x20b1dc8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:433 #14 row_purge_upd_exist_or_extern (node=0x20b1dc8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:524 #15 0x00000000008e6c18 in row_purge (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:759 #16 row_purge_step (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:802 #17 0x00000000008dbe25 in que_thr_step (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/que/que0que.c:1247 #18 que_run_threads_low (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/que/que0que.c:1305 #19 que_run_threads (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/que/que0que.c:1342 #20 0x0000000000822a1c in trx_purge (limit=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/trx/trx0purge.c:1184 #21 0x0000000000817374 in srv_master_do_purge (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2584 #22 srv_master_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2816 #23 0x00000030e1807761 in start_thread (arg=0x7fffc99b6710) at pthread_create.c:301 #24 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 17 (Thread 0x7fffc771e710 (LWP 28684)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x00000000008c6efd in os_cond_wait_timed (event=0x12c40c0, time_in_usec=, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:161 #2 os_event_wait_time_low (event=0x12c40c0, time_in_usec=, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:730 #3 0x0000000000819213 in srv_monitor_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2097 #4 0x00000030e1807761 in start_thread (arg=0x7fffc771e710) at pthread_create.c:301 #5 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 16 (Thread 0x7fffc811f710 (LWP 28683)): #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x0000000000815e95 in srv_error_monitor_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2407 #3 0x00000030e1807761 in start_thread (arg=0x7fffc811f710) at pthread_create.c:301 #4 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 15 (Thread 0x7fffc8b20710 (LWP 28682)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:212 #1 0x00000000008c6efd in os_cond_wait_timed (event=0x12c4040, time_in_usec=, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:161 #2 os_event_wait_time_low (event=0x12c4040, time_in_usec=, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:730 #3 0x00000000008157f0 in srv_lock_timeout_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2247 #4 0x00000030e1807761 in start_thread (arg=0x7fffc8b20710) at pthread_create.c:301 #5 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 13 (Thread 0x7fffca3b7710 (LWP 28680)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462310, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462310, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=9, message1=0x7fffca3b6e08, message2=0x7fffca3b6e00, type=0x7fffca3b6df8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=9) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffca3b7710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 12 (Thread 0x7fffcadb8710 (LWP 28679)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462290, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462290, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=8, message1=0x7fffcadb7e08, message2=0x7fffcadb7e00, type=0x7fffcadb7df8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffcadb8710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 11 (Thread 0x7fffcb7b9710 (LWP 28678)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462210, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462210, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=7, message1=0x7fffcb7b8e08, message2=0x7fffcb7b8e00, type=0x7fffcb7b8df8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=7) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffcb7b9710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 10 (Thread 0x7fffcc1ba710 (LWP 28677)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462190, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462190, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=6, message1=0x7fffcc1b9e08, message2=0x7fffcc1b9e00, type=0x7fffcc1b9df8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=6) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffcc1ba710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 9 (Thread 0x7fffccbbb710 (LWP 28676)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462110, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462110, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=5, message1=0x7fffccbbae08, message2=0x7fffccbbae00, type=0x7fffccbbadf8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=5) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffccbbb710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 8 (Thread 0x7fffcd5bc710 (LWP 28675)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462090, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462090, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=4, message1=0x7fffcd5bbe08, message2=0x7fffcd5bbe00, type=0x7fffcd5bbdf8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=4) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffcd5bc710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 7 (Thread 0x7fffcdfbd710 (LWP 28674)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1462010, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1462010, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=3, message1=0x7fffcdfbce08, message2=0x7fffcdfbce00, type=0x7fffcdfbcdf8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=3) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffcdfbd710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 6 (Thread 0x7fffce9be710 (LWP 28673)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1461f90, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1461f90, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=2, message1=0x7fffce9bde08, message2=0x7fffce9bde00, type=0x7fffce9bddf8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=2) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffce9be710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 5 (Thread 0x7fffcf3bf710 (LWP 28672)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1461f10, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1461f10, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=1, message1=0x7fffcf3bee08, message2=0x7fffcf3bee00, type=0x7fffcf3bedf8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7fffcf3bf710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 4 (Thread 0x7ffff7fd8710 (LWP 28671)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x00000000008c7061 in os_cond_wait (event=0x1461e90, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 #2 os_event_wait_low (event=0x1461e90, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 #3 0x00000000008c3ffb in os_aio_simulated_handle (global_segment=0, message1=0x7ffff7fd7e08, message2=0x7ffff7fd7e00, type=0x7ffff7fd7df8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0file.c:4881 #4 0x0000000000884e07 in fil_aio_wait (segment=0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fil/fil0fil.c:4464 #5 0x000000000081a74d in io_handler_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0start.c:493 #6 0x00000030e1807761 in start_thread (arg=0x7ffff7fd8710) at pthread_create.c:301 #7 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1 (Thread 0x7ffff7fda700 (LWP 28668)): #0 0x00000030e14d7de3 in __poll (fds=, nfds=, timeout=) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x000000000050191c in handle_connections_sockets () at /home/sbester/build/bzr/mysql-5.5-innodb/sql/mysqld.cc:5102 #2 0x0000000000502db1 in mysqld_main (argc=15, argv=0x1010c80) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/mysqld.cc:4572 #3 0x00000030e141ec5d in __libc_start_main (main=0x4f9390 , argc=15, ubp_av=0x7fffffffdfe8, init=, fini=, rtld_fini=, stack_end=0x7fffffffdfd8) at libc-start.c:226 #4 0x00000000004f92c9 in _start () (gdb) (gdb) thread 18 [Switching to thread 18 (Thread 0x7fffc99b6710 (LWP 28685))]#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 162 62: movl (%rsp), %edi (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 0x00000000008c7061 in os_cond_wait (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 No locals. #2 os_event_wait_low (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 old_signal_count = 9603 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=3) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 cell = 0x7ffff6ceb100 event = 0x7fffbc00b960 #4 0x000000000081d99e in rw_lock_s_lock_spin (lock=0x7fffbc00d1e0, pass=, file_name=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", line=511) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:450 index = 3 i = #5 0x000000000084e922 in rw_lock_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7ffff0001728, mode=4, latch_mode=1, cursor=0x20b1e28, has_search_latch=0, file=0xa74d50 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c", line=674, mtr=0x7fffc99b4b40) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/sync0rw.ic:418 file_name = 0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c" pass = 0 #6 mtr_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7ffff0001728, mode=4, latch_mode=1, cursor=0x20b1e28, has_search_latch=0, file=0xa74d50 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c", line=674, mtr=0x7fffc99b4b40) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/mtr0mtr.ic:252 file = 0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c" #7 btr_cur_search_to_nth_level (index=0x7fffbc00d168, level=0, tuple=0x7ffff0001728, mode=4, latch_mode=1, cursor=0x20b1e28, has_search_latch=0, file=0xa74d50 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c", line=674, mtr=0x7fffc99b4b40) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:511 page = block = space = guess = 0x7fffcf40fe98 height = page_no = up_match = up_bytes = low_match = low_bytes = savepoint = 0 rw_latch = page_mode = buf_mode = estimate = 0 zip_size = 140737219943104 page_cursor = btr_op = BTR_NO_OP root_height = 0 info = 0x7fffbc00d3a8 heap = 0x0 offsets_ = {100, 2, 2147483654, 8, 12, 21458496, 21457536, 5, 4194336, 140736678134976, 100, 2, 100, 2, 2147483655, 40, 48, 140736575787808, 140736575786080, 8710262, 10991544, 53, 140736575787808, 568, 100, 140737219926944, 140737219926944, 9, 1, 608, 0, 0, 0, 244813135908, 532575944796, 140736347563544, 140736575785152, 8511394, 2, 5, 34042928, 0, 532575944804, 476741369975, 140737219930616, 140737201258624, 34042920, 34043704, 18003588929826995678, 0, 140736575786112, 8737198, 1535, 140737219940160, 100, 2, 2147483656, 255, 263, 8410217, 140737219937744, 140737219941104, 140736347558248, 72, 140737219942085, 9306559, 140736347558248, 140737219942064, 140737219942058, 140737219941104, 18446744073709551615, 4, 0, 1831, 21457464, 0, 140736575785408, 8775673, 0, 1831, 0, 1831, 140736575786672, 8734524, 140736575785616, 140736673804816, 140736575785600, 9180772, 4, 3060, 140736575785584, 8511394, 140736575785536, 8775673, 140736674768560, 0, 0, 140736696729674, 140736575786800, 2} offsets = 0x7fffc99b4730 #8 0x0000000000804c7f in btr_pcur_open_func (pcur=0x20b1e28, mode=, table=, ref=0x7ffff0001728, mtr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/btr0pcur.ic:498 btr_cursor = 0x20b1e28 #9 row_search_on_row_ref (pcur=0x20b1e28, mode=, table=, ref=0x7ffff0001728, mtr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0row.c:674 low_match = rec = index = #10 0x00000000008e5c13 in row_purge_reposition_pcur (node=0x20b1dc8, index=0x7fffbc00d988, entry=0x7ffff0002558) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:101 found = #11 row_purge_poss_sec (node=0x20b1dc8, index=0x7fffbc00d988, entry=0x7ffff0002558) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:256 can_delete = mtr = { memo = { heap = 0x0, used = 0, data = "\001", '\000' , "7\000\000\000\000\000\000\000\330\332\000\274\377\177\000\000\341\377\377\377\377\377\377\377\001\000\000\000\000\000\000\000\002", '\000' , "\003", '\000' "\330, T\233\311\377\177", '\000' , "\004\000\000\000\000\000\000\000X%\000\360\377\177\000\000\004\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000\000\332\000\274\377\177\000\000\320T\233\311\377\177", '\000' , "\037\v\000\000\000\000\000\000\002\000\000\000\000\000\000\000d\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\a\000\000\200\000\000\000\000(\000\000\000\000\000\000\000\060\000\000\000\000\000\000\000\064\000\000\000\000\000\000\000\030\346\000\274\377\177\000\000\002\000\000\000\000\000\000\000\a\000\000\000\000\000\000\000\000@\343\356\377\177\000\000\200"..., base = { count = 33, start = 0x3f00000000000010, end = 0x7fffc99b4dd0 }, list = warning: can't find linker symbol for virtual table for `(null)' value { prev = 0x81dfa2, next = 0x0 } }, log = { heap = 0x0, used = 0, data = "\000\000\000\000\000\000\000\000\000N\233\311\377\177\000\000\341\341\201\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000 N\233\311\377\177\000\000\341\341\201\000\000\000\000\000\247\353l\313\000\000\000\000\004\000\000\000\000\000\000\000@N\233\311\377\177\000\000\341\341\201\000\000\000\000\000\240O<\317\377\177\000\000\070jG\001\000\000\000\000pP<\317\377\177\000\000\000\000\000\000\000\000\000\000\240O<\317\377\177\000\000\070jG\001\000\000\000\000\306\037\034\313\000\000\000\000\002\000\000\000\000\000\000\000\240O<\317\377\177\000\000\070jG\001\000\000\000\000\306\037\034\313", '\000' "\360, N\233\311\377\177\000\000\332Ѕ", '\000' , "Oj\224b", '\000' "\250, nG\001", '\000' , "Oj\224b\000\000\000\000\002\000\000\000\000\000\000\000"..., base = { count = 0, start = 0x0, end = 0x7fffc99b54d0 }, list = { prev = 0x2002, next = 0x7ffff0002558 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 8407892, end_lsn = 0 } #12 0x00000000008e5dbb in row_purge_remove_sec_if_poss_leaf (node=0x20b1dc8, index=0x7fffbc00d988, entry=0x7ffff0002558) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:383 success = mtr = { memo = { heap = 0x0, used = 48, data = "7", '\000' , "\003\000\000\000\000\000\000\000`\352}\317\377\177\000\000\002\000\000\000\000\000\000\000ु\317\377\177\000\000\240\370\n\002\000\000\000\000V\000\000\000\000\000\000\000\377\377\377\377\000\000\000\000\064\a\000\000\000\000\000\000&\000F\320\377\177\000\000<\300v\352\377\177\000\000\000\000\000\000\000\000\000\000\240\000\000\000\000\000\000\000\002", '\000' , "\002", '\000' , "8", '\000' , "\002", '\000' , "8", '\000' , "\002", '\000' , "\002", '\000' , "\002", '\000' , "\002", '\000' , "\002", '\000' , "\002", '\000' ..., base = { count = 34283048, start = 0x0, end = 0x1476a38 }, list = { prev = 0x0, next = 0xe } }, log = { heap = 0x0, used = 0, data = "\252\004\213\200\000\002\000\002\177\377\200\b\000\200", '\000' , "\024\003\000\000\000\000\000\000\240\033\000\360\377\177\000\000\001", '\000' "\310, \035\v\002\000\000\000\000 S\233\311\377\177\000\000h\321\000\274\377\177\000\000(\036\v\002", '\000' , "p\000\000\000\000\000\000\000\002\000\207'$\217\000\004\000\201\006\000\062\360\377\377\377\377\002\000\201\006\000\066\000\004\000\201\006\000\070\360\377\377\377\377\002\000\201\006\000<\000\004\000\201\006\000.\000\004\000\205\356\035\262\360\377\377\377\377\001\000\000\005\027\200\353\001\000\000\005\027\200\353\004\000\000\000:\201>\b\000\205\356\035r\000\000\000\000\000\004\000\205\356\035\256\360\372\005\034\343\004\000\201\006\000*\000\037", '\000' , "\004\004\002\000\372\272\227\001\004\000\b\023\200\253\001\004\000\b\023\200\253\004\000\207A\020\303\360\377\377\377\377\004\000\207A\020\317\000\037\037\305\000\037", '\000' ..., base = { count = 472446402679, start = 0x7fffc99b5530, end = 0x7ffff0000020 }, list = { prev = 0x7fffc99b5520, next = 0x7fffc99b55c0 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 579, end_lsn = 140736575788400 } pcur = { btr_cur = { index = 0x7fffbc00d988, page_cur = { rec = 0x7fffdb5f286e "nlpefcjarhedddolbrcjtooqeuzrcoqbhnposuoz", block = 0x7fffcf81a5e0 }, purge_node = 0x20b1dc8, left_block = 0x0, thr = 0x20b1c10, flag = BTR_CUR_BINARY, tree_height = 2, up_match = 0, up_bytes = 2, low_match = 2, low_bytes = 0, n_fields = 0, n_bytes = 283467841608, fold = 532575944797, ibuf_cnt = 18446744073709551615, path_arr = 0x7fffc99b55c0 }, latch_mode = 8194, old_stored = 122766467, old_rec = 0x0, old_n_fields = 11076224, rel_pos = 8627616, block_when_stored = 0x7fffc99b55f0, modify_clock = 8409669, pos_state = 1997660512, search_mode = 4, trx_if_known = 0x0, mtr = 0x2, old_rec_buf = 0x0, buf_size = 0 } search_result = #13 0x00000000008e6214 in row_purge_remove_sec_if_poss (node=0x20b1dc8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:433 success = n_tries = 0 #14 row_purge_upd_exist_or_extern (node=0x20b1dc8) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:524 heap = 0x7ffff00024e0 entry = 0x7ffff0002558 index = 0x7fffbc00d988 page_no = offset = i = mtr = { memo = { heap = 0x0, used = 48, data = "8", '\000' , "\002", '\000' , "\002", '\000' , "8", '\000' , "\002", '\000' , "\002", '\000' , "\003", '\000' , "\002", '\000' , "\002", '\000' , "8", '\000' , "\002", '\000' , "\002", '\000' , "\002\000\000\000\000\000\000\000\265m\214\000\000\000\000\000\002\000\000\000\000\000\000\000\000\204\330\001\000\000\000\000\260W\233\311\377\177\000\000<&\214\000\000\000\000\000\002\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000XU\233\311\377\177\000\000h\307\a\002", '\000' ..., base = { count = 140736575789200, start = 0xffffffffff60004e, end = 0x7fffc99b5960 }, list = { prev = 0x7fffc99b58a0, next = 0x0 } }, log = { heap = 0xd584000, used = 140736575789248, data = ")\004`\377\377\377\377\377\357W\277L\000\000\000\000\237U\a\000\000\000\000\000\340X\233\311\377\177\000\000\v\000\000\000\000\000\000\000\220Y\233\311\377\177\000\000mgI\341\060\000\000\000\220Y\233\311\377\177\000\000\024_\214\000\000\000\000\000PY\233\311\377\177\000\000`\254D\001\000\000\000\000\000\002\000\000\000\000\000\000\230\277\000\274\377\177\000\000\000\004\000\000\000\000\000\000\004\000\000\000\000\000\000\000\363C\000\000\000\000\000\000tp\214\000\000\000\000\000pY\233\311\377\177\000\000\360J\003\001\000\000\000\000\002\000\000\000\000\000\000\000\360\212\a\002\000\000\000\000\360J\003\001\000\000\000\000\002\000\000\000\000\000\000\000pY\233\311\377\177\000\000\002ց\000\000\000\000\000\270\210\a\002\000\000\000\000\230\276\000\274\377\177\000\000\025\002\000\000\000\000\000\000\004\000\000\000\000\000\000\000\000@\000\000\000\000\000\000\v\000\000\000\000\000\000\000\200Z\233"..., base = { count = 72, start = 0x20b1208, end = 0x20b1f38 }, list = { prev = 0x7fffc99b5b20, next = 0x8260e7 } }, modifications = 140737219925872, n_log_recs = 0, log_mode = 140736575789856, start_lsn = 0, end_lsn = 4294951699 } #15 0x00000000008e6c18 in row_purge (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:759 roll_ptr = 3377699758480971 purge_needed = 1 updated_extern = 1 trx = 0x20b1208 #16 row_purge_step (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0purge.c:802 node = 0x20b1dc8 #17 0x00000000008dbe25 in que_thr_step (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/que/que0que.c:1247 node = 0x20b1dc8 old_thr = 0x20b1c10 trx = type = #18 que_run_threads_low (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/que/que0que.c:1305 next_thr = 0x20b1c10 #19 que_run_threads (thr=0x20b1c10) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/que/que0que.c:1342 No locals. #20 0x0000000000822a1c in trx_purge (limit=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/trx/trx0purge.c:1184 thr = 0x20b1c10 old_pages_handled = 952679 #21 0x0000000000817374 in srv_master_do_purge (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2584 n_pages_purged = #22 srv_master_thread (arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/srv/srv0srv.c:2816 buf_stat = { n_page_gets = 714146849, n_pages_read = 1837000, n_pages_written = 5362307, n_pages_created = 2301748, n_ra_pages_read = 0, n_ra_pages_evicted = 264565, n_pages_made_young = 2718130, n_pages_not_made_young = 0 } event = 0x4cbf57ef old_activity_count = 19673287 n_bytes_merged = n_pages_flushed = n_bytes_archived = n_tables_to_drop = n_ios = n_pend_ios = next_itr_time = i = #23 0x00000030e1807761 in start_thread (arg=0x7fffc99b6710) at pthread_create.c:301 __res = pd = 0x7fffc99b6710 now = unwind_buf = { cancel_jmp_buf = {{ jmp_buf = {140736575792912, 2852289744870384241, 140737488332800, 140736575793616, 0, 3, -2852241603614137743, 2879099139334677105}, mask_was_saved = 0 }}, priv = { pad = {0x0, 0x0, 0x0, 0x0}, data = { prev = 0x0, cleanup = 0x0, canceltype = 0 } } } not_first_call = sp = freesize = #24 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 No locals. (gdb) (gdb) thread 21 [Switching to thread 21 (Thread 0x7ffff4052710 (LWP 28689))]#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 162 62: movl (%rsp), %edi (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 0x00000000008c7061 in os_cond_wait (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 No locals. #2 os_event_wait_low (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 old_signal_count = 9603 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=2) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 cell = 0x7ffff6ceb0b0 event = 0x7fffbc00b960 #4 0x000000000081d99e in rw_lock_s_lock_spin (lock=0x7fffbc00d1e0, pass=, file_name=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", line=838) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:450 index = 2 i = #5 0x000000000084b558 in rw_lock_s_lock_func (from_left=1, index=0x7fffbc00d168, cursor=0x7ffff404b5b0, line=3368, mtr=0x7ffff404b110, file=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", latch_mode=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/sync0rw.ic:418 file_name = 0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c" pass = 0 #6 mtr_s_lock_func (from_left=1, index=0x7fffbc00d168, cursor=0x7ffff404b5b0, line=3368, mtr=0x7ffff404b110, file=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", latch_mode=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/mtr0mtr.ic:252 file = 0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c" #7 btr_cur_open_at_index_side_func (from_left=1, index=0x7fffbc00d168, cursor=0x7ffff404b5b0, line=3368, mtr=0x7ffff404b110, file=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", latch_mode=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:838 page_cursor = page_no = space = zip_size = height = root_height = 0 node_ptr = savepoint = 0 heap = 0x0 offsets_ = {100, 2, 2147483654, 8, 12, 140737287318240, 140737287335424, 140737287336608, 140737287326240, 140736280538912, 140737287336800, 8697916, 10995520, 3265, 140737287334240, 925, 140737287326304, 140737155203072, 2, 140737287326336, 140737287318336, 0, 0, 1000000, 4, 140736347558248, 1, 140737287318304, 1, 2, 3, 2, 1, 319, 28, 1, 1, 3, 20306, 0, 18446744073709551615, 8506193, 209941738582, 49984829390848, 21458664, 21458608, 13050, 9203828, 140737287318480, 16993008, 0, 21458608, 16993008, 1, 140737287318544, 8513089, 0, 1117, 140737287318576, 8513089, 0, 2756, 140737287336288, 1, 140736672600720, 140736681500560, 140737287318704, 9180772, 0, 4, 140737287318704, 8752206, 140736679971176, 140736679971176, 140737287318704, 8510072, 140736670581400, 0, 140737287318704, 0, 0, 140737287335024, 0, 0, 90, 1, 140737287318880, 9181774, 0, 0, 0, 21458600, 0, 1658075865, 1, 21458496, 21457536, 1, 4214934, 140736681500688} offsets = 0x7ffff4046a00 #8 0x000000000084bca6 in btr_estimate_n_rows_in_range (index=0x7fffbc00d168, tuple1=, mode1=, tuple2=0x7fffb8022f20, mode2=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:3366 path1 = {{ nth_rec = 1, n_recs = 2, page_no = 3, page_level = 2 }, { nth_rec = 1, n_recs = 319, page_no = 28, page_level = 1 }, { nth_rec = 0, n_recs = 3, page_no = 20306, page_level = 0 }, { nth_rec = 18446744073709551615, n_recs = 0, page_no = 0, page_level = 0 }, { nth_rec = 0, n_recs = 0, page_no = 0, page_level = 0 } , { nth_rec = 0, n_recs = 16, page_no = 1, page_level = 0 }, { nth_rec = 0, n_recs = 0, page_no = 0, page_level = 0 } , { nth_rec = 21, n_recs = 0, page_no = 0, page_level = 0 }, { nth_rec = 0, n_recs = 64, page_no = 55, page_level = 0 }, { nth_rec = 3, n_recs = 0, page_no = 3, page_level = 0 }, { nth_rec = 1, n_recs = 0, page_no = 1, page_level = 0 }, { nth_rec = 0, n_recs = 0, page_no = 0, page_level = 0 } , { nth_rec = 0, n_recs = 0, page_no = 140737287334960, page_level = 34621520 }, { nth_rec = 0, n_recs = 0, page_no = 140736280418456, page_level = 140737287351792 }, { nth_rec = 140737287335008, n_recs = 6802413, page_no = 140736347537048, page_level = 140737287336640 }, { nth_rec = 0, n_recs = 140736280418456, page_no = 140737287336016, page_level = 7527053 }} path2 = {{ nth_rec = 1, n_recs = 2, page_no = 3, page_level = 2 }, { nth_rec = 97, n_recs = 319, page_no = 28, page_level = 1 }, { nth_rec = 6, n_recs = 6, page_no = 11887, page_level = 0 }, { nth_rec = 18446744073709551615, n_recs = 0, page_no = 0, page_level = 0 }, { nth_rec = 0, n_recs = 0, page_no = 0, page_level = 0 } , { nth_rec = 1, n_recs = 2, page_no = 3, page_level = 2 }, { nth_rec = 1, n_recs = 319, page_no = 28, page_level = 1 }, { nth_rec = 0, n_recs = 3, page_no = 20306, page_level = 0 }, { nth_rec = 18446744073709551615, n_recs = 0, page_no = 0, page_level = 0 }, { nth_rec = 0, n_recs = 0, page_no = 0, page_level = 0 } , { nth_rec = 0, n_recs = 0, page_no = 1, page_level = 2 }, { nth_rec = 3, n_recs = 2, page_no = 1, page_level = 319 }, { nth_rec = 28, n_recs = 1, page_no = 0, page_level = 3 }, { nth_rec = 20306, n_recs = 0, page_no = 18446744073709551615, page_level = 0 }, { nth_rec = 0, n_recs = 0, page_no = 0, page_level = 0 } } cursor = { index = 0x0, page_cur = { rec = 0x3400000011
, block = 0x7c0000005b }, purge_node = 0x6e00000077, left_block = 0x7ffff404b670, thr = 0x806723, flag = 4093949552, tree_height = 140737287342846, up_match = 140736347558248, up_bytes = 140736280429640, low_match = 380, low_bytes = 8, n_fields = 140736280427952, n_bytes = 140736280538912, fold = 140737287342838, ibuf_cnt = 0, path_arr = 0x7ffff4048d30 } slot1 = slot2 = diverged = diverged_lot = divergence_level = n_rows = is_n_rows_exact = i = mtr = { memo = { heap = 0x0, used = 0, data = "7", '\000' , "\003", '\000' , "\003", '\000' , "\001", '\000' , "\001", '\000' "\260, \256\000\274\377\177\000\000\000\000\000\000\000\000\000\000`\353\000\270\377\177", '\000' "\260, \261\004\364\000\000\000\000p\350\000\270\377\177\000\000\005\000\000\000\000\000\000\000\002", '\000' , "@i\020\002", '\000' , "P\r\000\270\377\177", '\000' , "\025\000\000\000\000\000\000\000\060\001", '\000' , "`\263\004\364\377\177\000\000`.\002\270\377\177\000\000`.\002\270\377\177\000\000\001\000\000\000\000\000\000\000h\321\000\274\377\177\000\000\317ً\000\000\000\000\000\003\000\000\000\377\177\000\000"..., base = { count = 140737287318240, start = 0x1, end = 0x7ffff404b360 }, list = { prev = 0x7fff90013750, next = 0x7ffff404b3f0 } }, log = { heap = 0x0, used = 0, data = "\001\000\000\000\000\000\000\000h\321\000\274\377\177\000\000ծ~\000\000\000\000\000H\204\000\270\377\177\000\000\000\000\000\000\000\000\000\000\070|y\317\377\177\000\000@jG\001\000\000\000\000\025\000\000\000\000\000\000\000\242߁\000\003\001\000\000\260}\000\270\377\177\000\000@;\001\220\377\177\000\000p\264\004\364\377\177\000\000\000\000\000\000\000\000\000\000\334ŷ\312\000\000\000\000\220\267\004\364\377\177\000\000p\353\000\270\377\177\000\000?\000\000\000\000\000\000\000\020\264\004\364\377\177\000\000PH\020\002", '\000' , "pV\000\270\377\177\000\000\320\365\004\364\377\177\000\000@\264\004\364\377\177\000\000\355\313g\000\000\000\000\000\230\071\001\220\377\177\000\000\240\272\004\364\377\177\000\000\000\000\000\000\000\000\000\000pV\000\270\377\177\000\000\060\270\004\364\377\177\000\000\215\332r\000\000\000\000\000\001\000\000\000\000\000\000\000=\232G\341\060\000\000\000(\000\000\000\000\000\000\000\240"..., base = warning: can't find linker symbol for virtual table for `(null)' value { count = 9519800, start = 0x7fffb8022e60, end = 0x7ffff404b790 }, list = { prev = 0x7fffb8022e60, next = 0x7fffb8022f40 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 304, end_lsn = 0 } #9 0x00000000007eaf2e in ha_innobase::records_in_range (this=0x7fff90013750, keynr=, min_key=0x0, max_key=0x7ffff404b780) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/handler/ha_innodb.cc:7477 key = key_val_buff2 = 0x7fffb8007db0 "" n_rows = mode2 = 0 buff2_len = index = 0x7fffbc00d168 mode1 = 23396 heap = 0xfffffffffffffe00 #10 0x0000000000730239 in check_quick_keys (param=0x7ffff404baa0, idx=0, key_tree=0x7fffb800eb70, min_key=, min_key_flag=0, min_keypart=-1, max_key=, max_key_flag=0, max_keypart=-1) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:7788 min_range = { key = 0x7ffff404bbf8 "\211", , length = 0, keypart_map = 18446744073709551615, flag = HA_READ_KEY_EXACT } max_range = { key = 0x7ffff404caf6 "\264s", length = 8, keypart_map = 1, flag = HA_READ_AFTER_KEY } records = 0 tmp_min_flag = 1 tmp_max_flag = 0 min_key_length = max_key_length = tmp_min_keypart = 4294967295 tmp_max_key = 0x7ffff404cafe "" tmp = keynr = 0 tmp_max_keypart = 0 tmp_min_key = 0x7ffff404bbf8 "\211", save_first_null_comp = 0 '\000' #11 0x0000000000730867 in check_quick_select (param=0x7ffff404baa0, idx=, tree=, update_tbl_stats=true) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:7559 records = cpk_scan = key = 0 #12 0x0000000000730ae2 in get_key_scans_params (param=0x7ffff404baa0, tree=0x7fffb800e918, index_read_must_be_used=false, update_tbl_stats=true, read_time=65811.199999999997) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:4959 keynr = 0 read_index_only = cpu_cost = found_records = found_read_time = idx = key = 0x7fffb800e920 end = 0x7fffb800e948 key_to_read = best_records = read_plan = 0x0 pk_is_clustered = true #13 0x000000000073d2d8 in SQL_SELECT::test_quick_select (this=, thd=, keys_to_use=, prev_tables=, limit=, force_quick_range=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.cc:2321 range_trp = rori_trp = can_build_covering = false alloc = { free = 0x7fffb800e860, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 4064, block_num = 5, first_block_usage = 0, error_handler = 0x5f7b90 } tree = key_info = param = { = { thd = 0x2104850, table = 0x7fff9004fc50, cond = 0x7fffb8005468, prev_tables = 0, read_tables = 0, current_table = 1, key_parts = 0x7fffb800e870, key_parts_end = 0x7fffb800e910, mem_root = 0x7ffff404f5d0, old_root = 0x21072b8, keys = 5, using_real_indexes = true, remove_jump_scans = true, real_keynr = {0, 1, 2, 3, 4, 32767, 3487615472, 32767, 127, 0, 15, 0, 8160, 0, 0, 0, 0, 0, 1, 0, 508, 175, 106, 124, 119, 111, 0, 0, 3087007776, 32767, 4093950976, 32767, 8120, 0, 3087089032, 32767, 8627616, 0, 3087089024, 32767, 0, 0, 3087089032, 32767, 3087195696, 32767, 4093950976, 32767, 9162695, 0, 11018152, 0, 34096568, 0, 4093951168, 32767, 3522125425, 32767, 6, 0, 9, 0, 4093951040, 32767}, min_key = "\211\354\215\000\000\000\000\000\n\354\002\270\377\177\000\000\204\357\213\000\000\000\000\000\b\326\004\364\377\177\000\000\"\355\002\270\377\177\000\000\022\000\000\000\000\000\000\000q^\357\321\377\177\000\000y^\357\321\377\177\000\000\b\354\002\270\377\177\000\000@\303\004\364\377\177\000\000\214\220\214\000\000\000\000\000_\002", '\000' , "\001\000\000\000\000\000\000\000\374\001\000\000\257\000\000\000\022\000\000\000\000\000\000\000?]\357\321\377\177\000\000\320\323\004\364\377\177\000\000 \000\000\270\377\177\000\000 \275\004\364\377\177\000\000\270\037\000\000\000\000\000\000\bW\001\270\377\177\000\000\062\001\000\000\000\000\000\000*@\357\321\377\177\000\000\062\001\000\000\000\000\000\000d\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\022\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000\005\000\000\000\000\000\000\000\270E\b\002\000\000\000\000\340\275\004\364\377\177\000\000\243_\357\321\377\177\000\000"..., max_key = "\264s\000\000\000\000\000\000\000\000\070jG\001\000\000\000\000@jG\001\000\000\000\000\001", '\000' "\340, \313\004\364\377\177\000\000\016\227\206\000\000\000\000\000\220\313\004\364\377\177\000\000\315h\000\353\377\177\000\000\023\n", '\000' , "\020\317\004\364\377\177\000\000\251T\205\000\000\000\000\000\220\313\004\364\377\177\000\000\233\300\320\320\377\177\000\000\320\313\004\364\377\177\000\000h\321\000\274\377\177\000\000\260\317\004\364\377\177\000\000\242\300\320\320\377\177\000\000\001\000\000\000\000\000\000\000\242\300\320\320\377\177\000\000\000\323\004\364\377\177\000\000\b\323\004\364\377\177\000\000\360̓\317\377\177\000\000\000\000\000\000\000\000\000\000q\a\000\000\000\000\000\000(~\000\270\377\177\000\000\220\300\320\320\377\177\000\000\216\300\320\320\377\177\000\000\260\317\004\364\377\177\000\000\000\000\000\000\000\000\000\000@\323\004\364\377\177\000\000\230\207\214\000\000\000\000\000\263\001\000\000\000\000\000\000\332Ѕ\000\000\000\000\000\240̓\317\377\177\000\000\200\317\004\364\377\177\000\000\000\000\000\000\000\000\000\000\233"..., alloced_sel_args = 0 }, members of PARAM: key = {0x7fffb800e870, 0x7fffb800e890, 0x7fffb800e8b0, 0x7fffb800e8d0, 0x7fffb800e8f0, 0xa81fa8, 0x2, 0x7ffff404da80, 0x0, 0x20, 0x0, 0x3f, 0x400, 0xfa2b40, 0x7fffbc00e618, 0x7ffff404db60, 0x7fffe915d6bb, 0x2, 0x2600000000000005, 0x112, 0x7ffff404ede8, 0x7ffff404ee03, 0xb, 0x7ffff404de70, 0xa, 0x8, 0x7fffe915d6bb, 0x7fffe915d6bd, 0x7fffbc00e618, 0x7ffff404ee13, 0x8c90bf, 0x25f, 0x1007ffff404e010, 0x7ffff404e660, 0x7ffff404e668, 0x8, 0x7fffe915c8f8, 0x7ffff404ebb0, 0x2, 0x7fffbc00e618, 0x0, 0x2, 0x10f, 0x7fffe915c02a, 0x10f, 0x64, 0x2, 0x80000008, 0xff, 0x107, 0x15, 0x40000329, 0x0, 0x7ffff404e2e0, 0x8c8798, 0x1b3, 0x7ffff404ec70, 0x0, 0x7fffd911658d, 0x8, 0x100000000000001, 0x7ffff404e740, 0x7ffff404e748, 0x7fffcf7389a8}, baseflag = 51543901342, max_key_part = 0, range_count = 1, quick = 2, fields_bitmap_size = 4, needed_fields = { bitmap = 0x7fffb800e910, n_bits = 2, last_word_mask = 4294967292, last_word_ptr = 0x7fffb800e910, mutex = 0x7fffd911549d }, tmp_covered_fields = { bitmap = 0x0, n_bits = 4160743444, last_word_mask = 32767, last_word_ptr = 0x7ffff404dc90, mutex = 0x0 }, needed_reg = 0x7fffb80058b8, imerge_cost_buff = 0x7ffff7ffe8bc, imerge_cost_buff_size = 0, is_ror_scan = false, n_ranges = 1, first_null_comp = 0 '\000' } buff = "\300\364\004\364\377\177\000\000\267\345T\000\000\000\000\000PH\020\002\021\v\373\v8\356\004\220\377\177\000\000\003\000\000\000\000\000\000\000\003", '\000' "\340, R\376\000\000\000\000\000pS\376\000\000\000\000\000\060S\376\000\000\000\000\000\260\365\004\364\377\177\000\000\333\070T\000\000\000\000\000xP\000\270\377\177\000\000\223C\251", '\000' , "\001\000\000\000\000\000\000\000\220\003\232\000\000\000\000\000Φ~\000\000\000\000\000p\365\004\364\377\177\000\000\030D\222\000\000\000\000\000\200\063\341\001\000\000\000\000PH\020\002\000\000\000\000\000v\376\000\000\000\000\000\bK\000\270\377\177\000\000\000\000\000\000\000\000\000\000\210h\020\002\000\000\000\000\260\365\004\364\377\177\000\000\021\210S\000\000\000\000\000\000\000\000\000\377\177\000\000\000\000\000\000\000\000\000\000hV\000\270\377\177\000\000\210(\002\270\377\177\000\000"... key_parts = best_trp = 0x0 best_read_time = 65811.199999999997 idx = scan_time = #14 0x00000000005e4991 in check_quick (thd=0x2104850, table_list=0x7fffb8004b08, fields=..., values=..., conds=0x7fffb8005468, order_num=, order=0x0, limit=5, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ffff4050dd8, updated_return=0x7ffff4050dd0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/opt_range.h:826 tmp = warning: can't find linker symbol for virtual table for `Bitmap<64u>' value warning: found `Item::bring_value()' instead { map = 18446744073709551615 } #15 mysql_update (thd=0x2104850, table_list=0x7fffb8004b08, fields=..., values=..., conds=0x7fffb8005468, order_num=, order=0x0, limit=5, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7ffff4050dd8, updated_return=0x7ffff4050dd0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_update.cc:399 safe_update = used_index = want_privilege = 34629688 __FUNCTION__ = "mysql_update" transactional_table = will_batch = reverse = false table_count = 1 id = used_key_is_modified = false select_lex = res = dup_key_found = found = old_covering_keys = warning: can't find linker symbol for virtual table for `Bitmap<64u>' value warning: found `Item::bring_value()' instead { map = 1 } table = loc_error = need_sort = true updated = select = 0x7fffb8005770 info = { table = 0x0, file = 0x7fff90015a88, forms = 0x4, unlock_row = 0, read_record = 0x7fffb8004ab0, thd = 0x1, select = 0x7ffff404f990, cache_records = 5369257, ref_length = 0, struct_length = 3087028272, reclength = 32767, rec_cache_size = 4, error_offset = 0, index = 3087027528, ref_pos = 0x2104850 "P\b\232", record = 0x7ffff404fa10 "\001", rec_buf = 0x56fb8c "D\017\266U\240H\205\300t2H\213\bL\211\352L\211\346H\211\307\377Q\020D\017\266U\240\203\370\001\017\204\255\001", cache = 0x0, cache_pos = 0x61eb4d "M\205\355t\016L\211\353\351\216\376\377\377f\017\037D", cache_end = 0x7fffb8003600 "wmrrklprblplqwwdxurzwyqtjzhnifkcioroerpnurdoxdcgtwocywpqluifwjysjykfzgcxxbrkunnuqshrtvitsxcescuvnqdhctghuugjtzgtaojuglbmxqifcedcgjuhz", read_positions = 0x0, io_cache = 0x7fffb8004d60, print_error = 240, ignore_not_found_rows = 50 } using_limit = true error = 0 all_fields = warning: can't find linker symbol for virtual table for `List' value { = { = {}, members of base_list: first = 0xfe7600, last = 0x7ffff404f9d0, elements = 0 }, } killed_status = THD::NOT_KILLED #16 0x00000000005771e8 in mysql_execute_command (thd=0x2104850) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:2702 found = 0 updated = 0 up_result = 0 lex = 0x2106168 select_lex = 0x2106838 first_table = 0x7fffb8004b08 unit = 0x2106218 __FUNCTION__ = "mysql_execute_command" res = 0 all_tables = 0x7fffb8004b08 have_table_map_for_update = false #17 0x00000000005792f4 in mysql_parse (thd=0x2104850, rawbuf=, length=31836, parser_state=0x7ffff40519f0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:5499 found_semicolon = lex = 0x2106168 __FUNCTION__ = "mysql_parse" #18 0x000000000057a9b3 in dispatch_command (command=COM_QUERY, thd=0x2104850, packet=, packet_length=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:1029 packet_end = parser_state = { m_lip = { m_thd = 0x2104850, yylineno = 1, yytoklen = 1, yylval = 0x7ffff4050d80, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7fffb801fc8d "gldcquxuhwiwfdvjjjlmiswwhvuavfwanomyututqjmzajuzncjgqcqxmosvlqcaklgoidlnunarwlgkzamyuogdjhpmdyehlbauelcwwpb\001 ", m_tok_start = 0x7fffb801fc8d "gldcquxuhwiwfdvjjjlmiswwhvuavfwanomyututqjmzajuzncjgqcqxmosvlqcaklgoidlnunarwlgkzamyuogdjhpmdyehlbauelcwwpb\001 ", m_tok_end = 0x7fffb801fc8d "gldcquxuhwiwfdvjjjlmiswwhvuavfwanomyututqjmzajuzncjgqcqxmosvlqcaklgoidlnunarwlgkzamyuogdjhpmdyehlbauelcwwpb\001 ", m_end_of_query = 0x7fffb801fc8c "", m_tok_start_prev = 0x7fffb801fc8c "", m_buf = 0x7fffb8018030 "update ignore `blobtest` set `data`='nrkwacgbuahmbiufezvvmoluqbvjulfnjgjmbhlaegqwzwptkxfktvjrkaekmotiucmmksxidbindcsnnkjbuvchlgjswqcrfxdpugbqiyunafepinbhydpmrskkodjtfvpuywsdtkxihngucgxjglvfvlpvuyzdsvq"..., m_buf_length = 31836, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7fffb8025d50 "update ignore `blobtest` set `data`='nrkwacgbuahmbiufezvvmoluqbvjulfnjgjmbhlaegqwzwptkxfktvjrkaekmotiucmmksxidbindcsnnkjbuvchlgjswqcrfxdpugbqiyunafepinbhydpmrskkodjtfvpuywsdtkxihngucgxjglvfvlpvuyzdsvq"..., m_cpp_ptr = 0x7fffb802d9ac "", m_cpp_tok_start = 0x7fffb802d9ac "", m_cpp_tok_start_prev = 0x7fffb802d9ac "", m_cpp_tok_end = 0x7fffb802d9ac "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7fffb802d9ab "5", m_cpp_text_end = 0x7fffb802d9ac "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = 0x2104a30 error = false __FUNCTION__ = "dispatch_command" #19 0x00000000006144bb in do_handle_one_connection (thd_arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:745 net = 0x2104a30 thd = 0x2104850 #20 0x00000000006145bc in handle_one_connection (arg=0x2104850) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:684 thd = 0x2104850 #21 0x00000030e1807761 in start_thread (arg=0x7ffff4052710) at pthread_create.c:301 __res = pd = 0x7ffff4052710 now = unwind_buf = { cancel_jmp_buf = {{ jmp_buf = {140737287366416, 2852289744870384241, 16666976, 140737287367120, 0, 3, -2852266877349191055, 2879099139334677105}, mask_was_saved = 0 }}, priv = { pad = {0x0, 0x0, 0x0, 0x0}, data = { prev = 0x0, cleanup = 0x0, canceltype = 0 } } } not_first_call = sp = freesize = #22 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 No locals. (gdb) (gdb) thread 24 [Switching to thread 24 (Thread 0x7fffc6b10710 (LWP 18065))]#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 162 62: movl (%rsp), %edi (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 0x00000000008c7061 in os_cond_wait (event=0x1a5e3d0, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 No locals. #2 os_event_wait_low (event=0x1a5e3d0, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 old_signal_count = 2 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=1) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 cell = 0x7ffff6ceb060 event = 0x1a5e3d0 #4 0x000000000081e133 in rw_lock_x_lock_wait (lock=0x7fffcf9c6b00, pass=, file_name=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:529 index = 1 i = 0 #5 rw_lock_x_lock_low (lock=0x7fffcf9c6b00, pass=, file_name=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:572 curr_thread = #6 rw_lock_x_lock_func (lock=0x7fffcf9c6b00, pass=, file_name=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:628 index = 140736676522552 i = 0 spinning = 0 #7 0x000000000085d0da in buf_page_get_gen (space=4, zip_size=0, offset=20608, rw_latch=2, guess=, mode=, file=0xa84da0 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c", line=2782, mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/buf/buf0buf.c:3107 block = 0x7fffcf9c6a38 fold = 4214916 access_time = 3413014911 fix_type = must_read = 0 retries = 0 buf_pool = 0x1476a38 #8 0x00000000008961c9 in fseg_alloc_free_page_low (space=4, zip_size=0, seg_inode=0x7fffd99300f2 "", hint=20627, direction=113 'q', mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c:2780 block = 0x7fffcf9c6a38 zip_size = 0 space_header = 0x7fffd5cd8026 "" space_size = seg_id = 0 used = 18840 reserved = 20608 descr = ret_page = 20608 ret_descr = frag_page_allocated = success = n = 18446744073709551615 #9 0x0000000000896b62 in fseg_alloc_free_page_general (seg_header=, hint=20627, direction=113 'q', has_done_reservation=1, mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/fsp/fsp0fsp.c:2868 inode = 0x7fffd99300f2 "" space = 4 flags = 0 zip_size = 0 latch = success = page_no = n_reserved = #10 0x000000000083d194 in btr_page_alloc (index=, hint_page_no=20627, file_direction=113 'q', level=0, mtr=0x7fffc6b0c040) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0btr.c:388 seg_header = root = new_page_no = #11 0x000000000084d743 in btr_store_big_rec_extern_fields (index=0x7fffbc00d168, rec_block=, rec=0x7fffec24b6c1 "", offsets=0x7fffc6b0c5b0, big_rec_vec=0x7fff9008e7a8, local_mtr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:4184 block = page = rec_page_no = 20626 field_ref = 0x7fffec24b9d6 "" extern_len = 38763 store_len = page_no = 140736681500560 space_id = 4 zip_size = 0 prev_page_no = 4294967295 hint_page_no = i = mtr = { memo = { heap = 0x0, used = 96, data = "\002\000\000\000\000\000\000\000\230\376@\317\377\177\000\000\070\000\000\000\000\000\000\000Ȼ\000\274\377\177\000\000\002\000\000\000\000\000\000\000`\244v\317\377\177\000\000\002\000\000\000\000\000\000\000\260\212_\317\377\177\000\000\002\000\000\000\000\000\000\000p\005\233\317\377\177\000\000\003\000\000\000\000\000\000\000\070j\234\317\377\177\000\000!\000\000\000\000\000\000\000~\243\000\220", '\000' "\260, \006\001\270\377\177", '\000' , "\004\000\000\000\000\000\000\000\270\307\003\220\377\177\000\000\004\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000\340\321\000\274\377\177\000\000\250\006\001\270\377\177", '\000' "\222, P\000\000\000\000\000\000\003\000\000\000\000\000\000\000d\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\006\000\000\200\000\000\000\000\b\000\000\000\000\000\000\000"..., base = { count = 0, start = 0x0, end = 0x1c }, list = { prev = 0x3, next = 0x64 } }, log = { heap = 0x0, used = 0, data = "\020\233", '\000' , "\001\000\000\000\000\000\000\000\t\000\000\000\000\000\000\000\257\t\000\000\233\002\000\000\250\000\000\000|\000\000\000x\000\000\000w\000\000\000\260\263\000\220\377\177\000\000 \000\000\220\377\177\000\000`ð\306\377\177\000\000\020\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\060\004", '\000' "\300, ð\306\377\177\000\000\060\270\000\220\377\177\000\000\060\270\000\220\377\177\000\000\000\000\000\000\000\000\000\000pɰ\306\377\177\000\000\317ً\000\000\000\000\000\300ð\306\377\177\000\000\000\004\000\000\000\000\000\000Ÿ\000\220\377\177\000\000h\321\000\274\377\177\000\000\340\273\000\220\377\177\000\000\260\270\000\220\377\177\000\000\004\000\000\000\000\000\000\000\a\000\000\000\000\000\000\000\300ð\306\377\177\000\000\211\354\215", '\000' , "\023\000\000\000\000\000\000\000\020\270\000\220\377\177\000\000\230\267\000\220\377\177\000\000\301"..., base = { count = 140736526861544, start = 0x18, end = 0x0 }, list = { prev = 0x7fff9003c740, next = 0x7fffc6b0c970 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 8724908, end_lsn = 140736526861552 } heap = 0x0 page_zip = 0x0 c_stream = { next_in = 0x7fffb80106a8 "h", , avail_in = 33, total_in = 140736526861696, next_out = 0x852fc1 "\270\001", avail_out = 332, total_out = 140736347558248, msg = 0x7fffc6b0c5b0 "d", state = 0x7fffec24b6c1, zalloc = 0x4, zfree = 0x7, opaque = 0x7fffc6b0c580, data_type = 9301129, adler = 140737155217089, reserved = 140735609554752 } #12 0x000000000080e3ac in row_upd_clust_rec (node=, index=0x7fffbc00d168, thr=, mtr=0x7fffc6b0c970) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:1808 offsets_ = {100, 4, 3221225480, 8, 14, 21, 1073742633, 0, 140736526862000, 140735609633056, 0, 0, 140736673379496, 21457464, 140736526862032, 8769704, 0, 1658090556, 0, 21458600, 0, 1658090554, 1, 21458496, 21457536, 5, 4202101, 0, 0, 1, 140736526863776, 140736347558248, 0, 140736673379496, 140736526862256, 140736526863664, 140736526863216, 8710485, 140736526863144, 140736526863136, 140736347537584, 140736749142059, 140736749142056, 140736749142057, 140735609380656, 140736347558824, 18446744073709551584, 2, 1, 2416005662, 0, 140736347537584, 0, 0, 4, 140735609554872, 4, 4, 140736347558368, 140736347537576, 0, 0, 140736681500560, 140736681500560, 879, 140736526862704, 140736526862464, 8782085, 12, 1, 1922, 10966768, 2, 140736681500688, 0, 1653894492, 2, 21458496, 21457536, 140735609473088, 1811, 140736670349072, 140736526863080, 144115188075857683, 0, 140736280463016, 2, 140736526862704, 1922, 10966768, 140736526862608, 8727824, 10979536, 140736347558248, 140736526864688, 140737155217089, 4, 7, 140736526862608, 9301129} rec = 0x7fffec24b6c1 "" heap = 0x7fff9000b3b0 big_rec = 0x7fff9008e7a8 pcur = 0x7fffb80106a8 btr_cur = 0x7fffb80106a8 err = #13 0x0000000000811847 in row_upd_clust_step (node=, thr=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:2032 index = pcur = success = err = mtr = 0x7fffc6b0c970 mtr_buf = { memo = { heap = 0x0, used = 112, data = "8\000\000\000\000\000\000\000\340\321\000\274\377\177\000\000\003\000\000\000\000\000\000\000\230\376@\317\377\177\000\000\003\000\000\000\000\000\000\000@\004\265\317\377\177\000\000\003\000\000\000\000\000\000\000\220_\350\317\377\177\000\000\002\000\000\000\000\000\000\000\250tl\317\377\177\000\000\002\000\000\000\000\000\000\000\220_\350\317\377\177\000\000\002\000\000\000\000\000\000\000H\201\254\317\377\177\000\000\070", '\000' , "\002", '\000' , "\025\000\000\000\000\000\000\000w\000\000\000n\000\000\000\300\020\001\220\377\177\000\000\000\003\000\000\000\000\000\000`\000\000\000\000\000\000\000\226\274\000\000\000\000\000\000\230\217\a\220\377\177\000\000\223P", '\000' , "\004\000\000\000\000\000\000\000P˰\306\377\177\000\000&\240\204\000\000\000\000\000@\307\003\220\377\177\000\000 \000\000\220\377\177\000\000\060˰\306\377\177\000\000"..., base = { count = 140736347558248, start = 0x7fffbc007e50, end = 0x7fffc6b0cc40 }, list = warning: can't find linker symbol for virtual table for `(null)' value { prev = 0x8c1a4e, next = 0x7fff90078c98 } }, log = { heap = 0x0, used = 0, data = "*\004\300P\222\000\004\000\001\200\b\200\006\200\a\177\377\066\301&\004\300P\222\000\004\000\001\200\b\200\006\200\a\177\377\000c\206c\000\b\000\306\377\177\000\000&)\205\000\000\000\000\000\002\000\000\000\000\000\000\000\340", '\000' "\226, \277\000\000\000\000\000\000@̰\306\377\177\000\000x\220\000\274\377\177\000\000\001\000\000\000\000\000\000\000\370\201\000\220\377\177\000\000h\321\000\274\377\177\000\000P~\000\274\377\177\000\000\220հ\306\377\177\000\000䣀\000\000\000\000\000H\303\000\274\377\177\000\000\003\000\000\000\000\000\000\000c\250T\364\377\177\000\000p'\213\000\000\000\000\000\000@\351\327\377\177\000\000\301\266$\354\377\177\000\000\001Ͱ\306\377\177\000\000\060Ͱ\306\377\177\000\000\001\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\300\"\001\220\377\177\000\001\001", '\000' , "\001\000\000\000\000\000\000\000\377\032\214\000\000\000\000\000h\321\000\274\377\177\000\000"..., base = { count = 3, start = 0x7fffc6b0cba8, end = 0x7fff9000bcb8 }, list = { prev = 0x0, next = 0x7fff9003c7b8 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 179897939013, end_lsn = 179897939898 } rec = 0x1
heap = 0x0 offsets_ = {100, 4, 3221225480, 8, 14, 21, 1073742633, 8627616, 140733193388035, 0, 140736526864960, 140735609473408, 140735609473408, 140736526865400, 0, 0, 21, 140735609376960, 140735609376960, 0, 100, 4, 3221225480, 8, 14, 21, 1073742633, 140735609381688, 1, 0, 140735609473408, 140735609472888, 140736526865400, 140736526865400, 140736526865008, 9285180, 140735609376960, 0, 140735609473088, 0, 140735609472768, 140735609472888, 140736526865400, 140736526865400, 140736526865088, 9286943, 140736526865088, 8591958, 140735609340408, 140735609340920, 140736526865136, 8563126, 140735609473088, 140735609340408, 140735609472888, 17116776, 140736526865296, 9287379, 140735609473088, 140735609340408, 140735609340408, 140736526865328, 140736526865296, 9336474, 1, 1, 140735609473408, 140735609473528, 1, 28710447743181325, 0, 0, 140736526865456, 140735609554752, 140735609554752, 1, 0, 9165263, 140736526865456, 140735609555152, 10981504, 8627616, 0, 0, 10981504, 140735609554752, 140736526865456, 9162695, 140735609340408, 0, 140736526865600, 140735609402176, 140735609402176, 140735609402176, 12, 140735609307168, 140736526865600, 176, 10997512, 8627616} offsets = referenced = 0 #14 0x0000000000812326 in row_upd (thr=0x7fffbc009968) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:2082 err = 10 #15 row_upd_step (thr=0x7fffbc009968) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0upd.c:2215 node = 0x7fffbc0096b8 sel_node = 0x0 parent = 0x7fffbc009968 err = trx = 0x7fff900081f8 #16 0x00000000007fdaee in row_update_for_mysql (mysql_rec=, prebuilt=0x7fffbc009078) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0mysql.c:1444 savept = { least_undo_no = 1 } err = 140736526865888 thr = 0x7fffbc009968 was_lock_wait = clust_index = node = 0x7fffbc0096b8 table = trx = 0x7fff900081f8 #17 0x00000000007eeadf in ha_innobase::update_row (this=0x7fffbc007c50, old_row=0x7fffbc007e68 "\376\360S", new_row=0x7fffbc007e50 "\376\360S") at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/handler/ha_innodb.cc:5238 uvect = 0x7fffbc0097c0 error = 0 trx = 0x7fff900081f8 #18 0x0000000000678ec1 in handler::ha_update_row (this=0x7fffbc007c50, old_data=0x7fffbc007e68 "\376\360S", new_data=0x7fffbc007e50 "\376\360S") at /home/sbester/build/bzr/mysql-5.5-innodb/sql/handler.cc:4758 error = log_func = 0x67b840 #19 0x00000000005e5474 in mysql_update (thd=0x211c600, table_list=0x7fff90004b08, fields=, values=..., conds=0x7fff90005468, order_num=, order=0x7fffc6b0d930, limit=2, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7fffc6b0edd8, updated_return=0x7fffc6b0edd0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_update.cc:707 skip_record = safe_update = used_index = want_privilege = 34727400 __FUNCTION__ = "mysql_update" transactional_table = true will_batch = false reverse = false table_count = 1 id = used_key_is_modified = select_lex = res = dup_key_found = 32767 found = 4 old_covering_keys = warning: can't find linker symbol for virtual table for `Bitmap<64u>' value warning: found `Item::bring_value()' instead { map = 4 } table = loc_error = need_sort = false updated = 1 select = 0x7fff90005770 info = { table = 0x7fffbc00aeb0, file = 0x7fffbc007c50, forms = 0x7fffc6b0d930, unlock_row = 0x58f900 , read_record = 0x743470 , thd = 0x211c600, select = 0x7fff90005770, cache_records = 0, ref_length = 8, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0x7fffbc007e50 "\376\360S", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, io_cache = 0x0, print_error = true, ignore_not_found_rows = false } using_limit = true error = 0 all_fields = warning: can't find linker symbol for virtual table for `List' value { = { = {}, members of base_list: first = 0xfe7600, last = 0x7fffc6b0d9d0, elements = 0 }, } killed_status = THD::NOT_KILLED #20 0x00000000005771e8 in mysql_execute_command (thd=0x211c600) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:2702 found = 0 updated = 0 up_result = 0 lex = 0x211df18 select_lex = 0x211e5e8 first_table = 0x7fff90004b08 unit = 0x211dfc8 __FUNCTION__ = "mysql_execute_command" res = 0 all_tables = 0x7fff90004b08 have_table_map_for_update = false #21 0x00000000005792f4 in mysql_parse (thd=0x211c600, rawbuf=, length=39599, parser_state=0x7fffc6b0f9f0) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:5499 found_semicolon = lex = 0x211df18 __FUNCTION__ = "mysql_parse" #22 0x000000000057a9b3 in dispatch_command (command=COM_QUERY, thd=0x211c600, packet=, packet_length=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_parse.cc:1029 packet_end = parser_state = { m_lip = { m_thd = 0x211c600, yylineno = 1, yytoklen = 1, yylval = 0x7fffc6b0ed80, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7fff9004ae50 "teggydgjtjgcleszazpoveqsfbefaaagnmtcaaickhegqzginvfbeqjpojefrhtfgmojmdpvgkfeekhxpovdnvxryyjrndimgcazwont\301<", m_tok_start = 0x7fff9004ae50 "teggydgjtjgcleszazpoveqsfbefaaagnmtcaaickhegqzginvfbeqjpojefrhtfgmojmdpvgkfeekhxpovdnvxryyjrndimgcazwont\301<", m_tok_end = 0x7fff9004ae50 "teggydgjtjgcleszazpoveqsfbefaaagnmtcaaickhegqzginvfbeqjpojefrhtfgmojmdpvgkfeekhxpovdnvxryyjrndimgcazwont\301<", m_end_of_query = 0x7fff9004ae4f "", m_tok_start_prev = 0x7fff9004ae4f "", m_buf = 0x7fff900413a0 "update ignore `blobtest` set `data`='lastqnjymksllxmrpzxjpriefffmlucelqxzgbcdhuxrljnlijrnirbbdsncypooitbvyxkqwdqxqgvkpxnqxlggwvvfqjqfqdolflwosjwlwggptvwnsvqzizzobacvgnkdyvedrakgpezkiauzzjbzbqwaphtrpsm"..., m_buf_length = 39599, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7fff90018b70 "update ignore `blobtest` set `data`='lastqnjymksllxmrpzxjpriefffmlucelqxzgbcdhuxrljnlijrnirbbdsncypooitbvyxkqwdqxqgvkpxnqxlggwvvfqjqfqdolflwosjwlwggptvwnsvqzizzobacvgnkdyvedrakgpezkiauzzjbzbqwaphtrpsm"..., m_cpp_ptr = 0x7fff9002261f "", m_cpp_tok_start = 0x7fff9002261f "", m_cpp_tok_start_prev = 0x7fff9002261f "", m_cpp_tok_end = 0x7fff9002261f "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT, m_cpp_text_start = 0x7fff9002261e "5", m_cpp_text_end = 0x7fff9002261f "", m_underscore_cs = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ } } net = 0x211c7e0 error = false __FUNCTION__ = "dispatch_command" #23 0x00000000006144bb in do_handle_one_connection (thd_arg=) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:745 net = 0x211c7e0 thd = 0x211c600 #24 0x00000000006145bc in handle_one_connection (arg=0x211c600) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_connect.cc:684 thd = 0x211c600 #25 0x00000030e1807761 in start_thread (arg=0x7fffc6b10710) at pthread_create.c:301 __res = pd = 0x7fffc6b10710 now = unwind_buf = { cancel_jmp_buf = {{ jmp_buf = {140736526878480, 2852289744870384241, 16666976, 140736526879184, 0, 3, -2852235379132784015, 2879099139334677105}, mask_was_saved = 0 }}, priv = { pad = {0x0, 0x0, 0x0, 0x0}, data = { prev = 0x0, cleanup = 0x0, canceltype = 0 } } } not_first_call = sp = freesize = #26 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 No locals. (gdb) (gdb) thread 26 [Switching to thread 26 (Thread 0x7fffc8fb5710 (LWP 26448))]#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 162 62: movl (%rsp), %edi (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 0x00000000008c7061 in os_cond_wait (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:194 No locals. #2 os_event_wait_low (event=0x7fffbc00b960, reset_sig_count=) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/os/os0sync.c:621 old_signal_count = 9603 #3 0x000000000081d74f in sync_array_wait_event (arr=0x1034af0, index=0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0arr.c:457 cell = 0x7ffff6ceb010 event = 0x7fffbc00b960 #4 0x000000000081d99e in rw_lock_s_lock_spin (lock=0x7fffbc00d1e0, pass=, file_name=0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c", line=511) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/sync/sync0rw.c:450 index = 0 i = #5 0x000000000084e922 in rw_lock_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7fff900514b8, mode=4, latch_mode=2, cursor=0x7fffc8fb2460, has_search_latch=0, file=0xa8fcc8 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c", line=2002, mtr=0x7fffc8fb1bb0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/sync0rw.ic:418 file_name = 0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c" pass = 0 #6 mtr_s_lock_func (index=0x7fffbc00d168, level=0, tuple=0x7fff900514b8, mode=4, latch_mode=2, cursor=0x7fffc8fb2460, has_search_latch=0, file=0xa8fcc8 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c", line=2002, mtr=0x7fffc8fb1bb0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/include/mtr0mtr.ic:252 file = 0xa7c740 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c" #7 btr_cur_search_to_nth_level (index=0x7fffbc00d168, level=0, tuple=0x7fff900514b8, mode=4, latch_mode=2, cursor=0x7fffc8fb2460, has_search_latch=0, file=0xa8fcc8 "/home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c", line=2002, mtr=0x7fffc8fb1bb0) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/btr/btr0cur.c:511 page = block = space = guess = 0x7fffcf40fe98 height = page_no = up_match = up_bytes = low_match = low_bytes = savepoint = 0 rw_latch = page_mode = buf_mode = estimate = 0 zip_size = 0 page_cursor = btr_op = BTR_NO_OP root_height = 0 info = 0x7fffbc00d3a8 heap = 0x0 offsets_ = {100, 0, 140736673804816, 21457464, 140736565285808, 8769704, 6, 39691322159858817, 0, 21458600, 0, 1658070297, 1, 21458496, 21457536, 0, 4214614, 140736673804944, 0, 0, 140736673804816, 21457464, 140736565285952, 8769704, 20306, 140736347537576, 0, 21458600, 0, 1658070297, 1, 21458496, 21457536, 0, 4214614, 140736673804944, 0, 20306, 0, 140736833552384, 0, 4, 20306, 140736347537576, 140736565286064, 8685253, 10991544, 53, 140736565287392, 140736673804944, 0, 20306, 140736347558368, 140736347537576, 0, 140736673804816, 140736565286240, 140736565287392, 140736565287104, 8700648, 140736565287392, 579, 140736565287392, 2, 2147483654, 8, 18446744073709551584, 1, 0, 2, 140736347558368, 140736347558248, 140736347537584, 0, 579, 10948968, 4, 0, 1, 20306, 100, 2, 2147483654, 8, 12, 0, 140737292083212, 9119600, 261, 109, 140736565286400, 140736347875584, 140736347875584, 140736565287856, 0, 0, 140736681694728, 140736565286432, 140736565286560, 9181774} offsets = 0x7fffc8fb12e0 #8 0x00000000008e36cb in row_ins_index_entry_low (mode=2, index=0x7fffbc00d168, entry=0x7fff900514b8, n_ext=0, thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2000 cursor = { index = 0x7fffbc00d168, page_cur = warning: can't find linker symbol for virtual table for `(null)' value warning: found `open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*)' instead { rec = 0x540635 "ƅ\220\375\377\377", block = 0x7fffc8fb24b0 }, purge_node = 0x5e15ec, left_block = 0x3704db11c8fb24b0, thr = 0x7fff9004ee38, flag = BTR_CUR_BINARY, tree_height = 34305088, up_match = 34305280, up_bytes = 140736565291536, low_match = 140736565290688, low_bytes = 140736347523848, n_fields = 140736565290224, n_bytes = 6803477, fold = 140736347525240, ibuf_cnt = 18446744073709551615, path_arr = 0x0 } search_mode = modify = 0 insert_rec = 0x20b8d58 "0\n\232" err = n_unique = big_rec = 0x0 mtr = { memo = { heap = 0x0, used = 0, data = '\000' , "\005\000\000\000\061\000\000\000[\000\000\000|\000\000\000w\000\000\000n\000\000\000\200~\000\274\377\177\000\000 \000\000\274\377\177\000\000`\034\373\310\377\177\000\000@", '\000' , "\001\000\000\000\000\000\000\000`\034\373\310\377\177\000\000k\276a\000\000\000\000\000\000u\v\002\000\000\000\000xN\000\274\377\177\000\000\000u\v\002\000\000\000\000EL\222\000\000\000\000\000\300I\000\274\377\177\000\000xN\000\274\377\177\000\000\300\034\373\310\377\177\000\000\305\342a\000\000\000\000\000\220\034\373\310\377\177\000\000\024\350\377\367\377\177\000\000h\035\373\310\377\177\000\000\000\000\000\000\000\000\000\000\260\034\373\310\377\177\000\000\000u\v\002\000\000\000\000xN\000\274\377\177\000\000\060\035\373\310\377\177\000\000e\213\240N\000\000\000\000\020$\373\310\377\177\000\000\240\035\373\310\377\177\000\000~\360a", '\000' ..., base = { count = 140736565289032, start = 0x0, end = 0x7fffbc005100 }, list = { prev = 0x7fffbc0051b4, next = 0x0 } }, log = { heap = 0x0, used = 0, data = "\004\000\000\000\000\000\000\000\b\000\000\300\000\000\000\000\b\000\000\000\000\000\000\000\016\000\000\000\000\000\000\000\025\000\000\000\000\000\000\000test\000blobtest\000\000\000\000\000\a\000\000\000\000\000\b\356\000\274\377\177\000\000\000\356\000\274\377\177\000\000\000\000\000\000\001", '\000' , "\025", '\000' "\360, ?@t\v\002\000\000\000\000L#\373\310\001\000\000\000d\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000\b\000\000\200\000\000\000\000\b\000\000\000\000\000\000\000\016\000\000\000\000\000\000\000\025\000\000\000\000\000\000\000@\037\373\310\377\177\000\000\235p\220\000\000\000\000\000\000\037\373\310\377\177\000\000\370\036\373\310\377\177\000\000\313\303\022\002\000\000\000\000\\\037\373\310\377\177\000\000@\"\373\310\377\177\000\000\b\037\373\310\377\177"..., base = warning: can't find linker symbol for virtual table for `(null)' value { count = 9465216, start = 0x20b7440, end = 0x981cab2b }, list = { prev = 0x20b7440, next = 0xe00000000 } }, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = 140736347525888, end_lsn = 140736565289136 } heap = 0x0 #9 0x00000000008e58d1 in row_ins_index_entry (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2171 err = foreign = 1 n_ext = 0 #10 row_ins_index_entry_step (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2256 No locals. #11 row_ins (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2388 No locals. #12 row_ins_step (thr=0x7fff9004ee38) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0ins.c:2498 node = 0x7fffb8073ae8 parent = sel_node = 0x0 trx = 0x7fffbc008248 err = #13 0x00000000007ff766 in row_insert_for_mysql (mysql_rec=, prebuilt=0x7fffb8010848) at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/row/row0mysql.c:1199 savept = { least_undo_no = 0 } thr = 0x7fff9004ee38 err = 140736347537992 was_lock_wait = trx = node = 0x7fffb8073ae8 #14 0x00000000007f16b6 in ha_innobase::write_row (this=0x7fffb8025860, record=0x7fffb8025a60 "\376p~") at /home/sbester/build/bzr/mysql-5.5-innodb/storage/innobase/handler/ha_innodb.cc:4942 error_result = 0 error = auto_inc_used = 1 sql_command = 40 trx = 0x7fffbc008248 #15 0x0000000000678f7a in handler::ha_write_row (this=0x7fffb8025860, buf=0x7fffb8025a60 "\376p~") at /home/sbester/build/bzr/mysql-5.5-innodb/sql/handler.cc:4733 error = log_func = 0x67b870 #16 0x000000000055ffd4 in write_record (thd=0x20b7440, table=0x7fffb8008c90, info=0x7fffc8fb2920) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_insert.cc:1516 key = 0x0 save_read_set = 0x7fffb8008d78 save_write_set = 0x7fffb8008d98 insert_id_for_cur_row = 0 error = trg_error = 0 prev_insert_id = 0 #17 0x0000000000565efa in mysql_insert (thd=0x20b7440, table_list=0x7fffbc004b08, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /home/sbester/build/bzr/mysql-5.5-innodb/sql/sql_insert.cc:935 was_insert_delayed = false counter = lock_type = TL_WRITE_DEFAULT value_count = info = { records = 1, deleted = 0, updated = 0, copied = 0, error_count = 0, touched = 0, handle_duplicates = DUP_REPLACE, escape_char = 0, last_errno = 0, ignore = false, update_fields = 0x20b9920, update_values = 0x20b9908, view = 0x0 } context = 0x7fffbc005770 log_on = true res = joins_freed = false changed = id = its = warning: can't find linker symbol for virtual table for `List_iterator_fast >' value warning: found `Item::bring_value()' instead { = { list = 0x20b9938, el = 0x7fffbc005050, prev = 0x0, current = 0x0 }, } values = 0x7fffbc005038 unused_conds = 0x0 __FUNCTION__ = "mysql_insert" error = 0 table = 0x7fffb8008c90 ctx_state = Asked for position 0 of stack, stack only has 0 elements on it. (gdb)