Thread 40 (process 23447): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c866289b8, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c866289b8, sync=0x7f3c722ccc00, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c722ccc00, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c722ccc00, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x248e9b0, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c722ccd1f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x248e9b0, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x248e9b0, record=0x7f3c8136e498, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c86982ae0, transaction=0x248e9b0, source=0x7f3c8136e498, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c857234e8, recordNumber=1995, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c857234e8, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c80ef3ef0, buf=0x7f3c80ef46d0 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x00000000008253b9 in ha_partition::rnd_next (this=0x7f3c80ef3a50, buf=0x7f3c80ef46d0 "ÚÚÚ") at ha_partition.cc:3541 #14 0x00000000008118a3 in rr_sequential (info=0x7f3c722cd430) at records.cc:390 #15 0x000000000079d4d5 in mysql_delete (thd=0x7f3c6c00f058, table_list=0x2266138, conds=0x0, order=0x7f3c6c010fc0, limit=6, options=0, reset_auto_increment=false) at sql_delete.cc:296 #16 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c00f058) at sql_parse.cc:3259 #17 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c00f058, inBuf=0x2265f10 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` LIMIT 6", length=65, found_semicolon=0x7f3c722cef00) at sql_parse.cc:5763 #18 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c00f058, packet=0x7f3c6c02d229 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` LIMIT 6", packet_length=65) at sql_parse.cc:1009 #19 0x00000000006e0b03 in do_command (thd=0x7f3c6c00f058) at sql_parse.cc:691 #20 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c00f058) at sql_connect.cc:1146 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 39 (process 23439): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c86607db0, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c86607db0, sync=0x7f3c723d05e0, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c723d05e0, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c723d05e0, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x2491130, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c723d06ff) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x2491130, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x2491130, record=0x7f3c8136e498, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c86982ae0, transaction=0x2491130, source=0x7f3c8136e498, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c85691218, recordNumber=1995, lockForUpdate=true) at StorageDatabase.cpp:289 ---Type to continue, or q to quit--- #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c85691218, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x21dd8d0, buf=0x21e0cb0 "Ú©Ú") at ha_falcon.cpp:646 #13 0x00000000008253b9 in ha_partition::rnd_next (this=0x21b5630, buf=0x21e0cb0 "Ú©Ú") at ha_partition.cc:3541 #14 0x0000000000815780 in find_all_keys (param=0x7f3c723d0e70, select=0x222fe00, sort_keys=0x7f3c6c0d7388, buffpek_pointers=0x7f3c723d0b50, tempfile=0x7f3c723d0ce0, indexfile=0x0) at filesort.cc:587 #15 0x0000000000816171 in filesort (thd=0x2214838, table=0x21e03c8, sortorder=0x222ffe0, s_length=1, select=0x222fe00, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c723d1500) at filesort.cc:245 #16 0x000000000079d01d in mysql_delete (thd=0x2214838, table_list=0x222f230, conds=0x222f9d8, order=0x22167a0, limit=9, options=0, reset_auto_increment=false) at sql_delete.cc:237 #17 0x00000000006d9940 in mysql_execute_command (thd=0x2214838) at sql_parse.cc:3259 #18 0x00000000006de9ef in mysql_parse (thd=0x2214838, inBuf=0x222ef80 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` WHERE `enum_utf8_not_null_key` <> 2 ORDER BY `set_latin1_not_null_key` LIMIT 9", length=134, found_semicolon=0x7f3c723d2f00) at sql_parse.cc:5763 #19 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x2214838, packet=0x221f169 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` WHERE `enum_utf8_not_null_key` <> 2 ORDER BY `set_latin1_not_null_key` LIMIT 9", packet_length=134) at sql_parse.cc:1009 #20 0x00000000006e0b03 in do_command (thd=0x2214838) at sql_parse.cc:691 #21 0x00000000006ce9cd in handle_one_connection (arg=0x2214838) at sql_connect.cc:1146 #22 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #23 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 38 (process 23437): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c865fdd40, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c865fdd40, sync=0x7f3c724115e0, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c724115e0, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c724115e0, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x24e4900, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c724116ff) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x24e4900, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x24e4900, record=0x7f3c8136e498, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c86982ae0, transaction=0x24e4900, source=0x7f3c8136e498, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c8577df68, recordNumber=1995, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c8577df68, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c80f2a1b0, buf=0x7f3c80f2a990 "ÚÚØ") at ha_falcon.cpp:646 #13 0x00000000008253b9 in ha_partition::rnd_next (this=0x7f3c80f29cd0, buf=0x7f3c80f2a990 "ÚÚØ") at ha_partition.cc:3541 #14 0x0000000000815780 in find_all_keys (param=0x7f3c72411e70, select=0x0, sort_keys=0x2556bd8, buffpek_pointers=0x7f3c72411b50, tempfile=0x7f3c72411ce0, indexfile=0x0) at filesort.cc:587 #15 0x0000000000816171 in filesort (thd=0x21a7cd8, table=0x7f3c80f293e8, sortorder=0x2205b08, s_length=1, select=0x0, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c72412500) at filesort.cc:245 #16 0x000000000079d01d in mysql_delete (thd=0x21a7cd8, table_list=0x22052b8, conds=0x0, order=0x21a9c40, limit=1, options=0, reset_auto_increment=false) at sql_delete.cc:237 #17 0x00000000006d9940 in mysql_execute_command (thd=0x21a7cd8) at sql_parse.cc:3259 ---Type to continue, or q to quit--- #18 0x00000000006de9ef in mysql_parse (thd=0x21a7cd8, inBuf=0x2205050 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` ORDER BY `char_64_utf8_not_null` LIMIT 1", length=97, found_semicolon=0x7f3c72413f00) at sql_parse.cc:5763 #19 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x21a7cd8, packet=0x21f5239 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` ORDER BY `char_64_utf8_not_null` LIMIT 1", packet_length=97) at sql_parse.cc:1009 #20 0x00000000006e0b03 in do_command (thd=0x21a7cd8) at sql_parse.cc:691 #21 0x00000000006ce9cd in handle_one_connection (arg=0x21a7cd8) at sql_connect.cc:1146 #22 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #23 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 37 (process 23461): #0 0x000000000098ef53 in SyncObject::lock (this=0x100000000d9c5dd, sync=0x7f3c867bd470, type=32572, timeout=-2038432112) at SyncObject.cpp:313 #1 0x000000000098d895 in Sync::lock (this=0x7f3c72100890, type=Shared) at Sync.cpp:58 #2 0x00000000009bb6ad in Cache::fetchPage (this=0x7f3c867bd400, dbb=0x7f3c8694ec88, pageNumber=12, pageType=PAGE_btree, lockType=Shared) at Cache.cpp:236 #3 0x00000000009e1960 in Dbb::fetchPage (this=0x7f3c8694ec88, pageNumber=12, pageType=PAGE_btree, lockType=Shared) at Dbb.cpp:219 #4 0x00000000009e1b88 in Dbb::handoffPage (this=0x7f3c8694ec88, bdb=0x7f3c86821170, pageNumber=12, pageType=PAGE_btree, lockType=Shared) at Dbb.cpp:268 #5 0x00000000009ff154 in IndexRootPage::findRoot (dbb=0x7f3c8694ec88, indexId=6, rootPage=0, lockType=Shared, transId=12519) at IndexRootPage.cpp:353 #6 0x0000000000a000bd in IndexRootPage::findInsertionLeaf (dbb=0x7f3c8694ec88, indexId=6, indexKey=0x7f3c72100ae0, recordNumber=7698, transId=12519, isRoot=0x0) at IndexRootPage.cpp:262 #7 0x0000000000a0046c in IndexRootPage::deleteIndexEntry (dbb=0x7f3c8694ec88, indexId=6, key=0x7f3c72103600, recordNumber=7698, transId=12519) at IndexRootPage.cpp:627 #8 0x00000000009e0f3b in Dbb::deleteIndexEntry (this=0x7f3c8694ec88, indexId=6, indexVersion=1, key=0x7f3c72103600, recordNumber=7698, transId=12519) at Dbb.cpp:706 #9 0x00000000009fbf2d in Index::garbageCollect (this=0x7f3c865cf9b0, leaving=0x7f3c8136d9e8, staying=0x0, transaction=0x7f3c80fb00f8, quiet=true) at Index.cpp:687 #10 0x000000000099a7a9 in Table::garbageCollect (this=0x7f3c8696cf88, leaving=0x7f3c8136d9e8, staying=0x0, transaction=0x7f3c80fb00f8, quiet=true) at Table.cpp:2162 #11 0x000000000099ac79 in Table::rollbackRecord (this=0x7f3c8696cf88, recordToRollback=0x7f3c8136d9e8, transaction=0x7f3c80fb00f8) at Table.cpp:1083 #12 0x0000000000a2cf08 in RecordVersion::rollback (this=0x7f3c8136d9e8, transaction=0x7f3c80fb00f8) at RecordVersion.cpp:168 #13 0x00000000009ab63b in Transaction::rollback (this=0x7f3c80fb00f8) at Transaction.cpp:410 #14 0x00000000009cbd7c in Connection::rollback (this=0x7f3c86637f08) at Connection.cpp:282 #15 0x000000000097c115 in StorageConnection::rollback (this=0x7f3c86637e50) at StorageConnection.cpp:191 #16 0x00000000009814a3 in StorageHandler::rollback (this=0x7f3c86792048, mySqlThread=0x7f3c6c0aa348) at StorageHandler.cpp:317 #17 0x0000000000974772 in StorageInterface::rollback (hton=0x7f3c801c65f8, thd=0x7f3c6c0aa348, all=true) at ha_falcon.cpp:1321 #18 0x000000000081ef10 in ha_rollback_trans (thd=0x7f3c6c0aa348, all=true) at handler.cc:1297 #19 0x00000000008ede55 in trans_rollback (thd=0x7f3c6c0aa348) at transaction.cc:205 #20 0x00000000006dc640 in mysql_execute_command (thd=0x7f3c6c0aa348) at sql_parse.cc:4055 #21 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c0aa348, inBuf=0x250d390 "ROLLBACK", length=8, found_semicolon=0x7f3c72107f00) at sql_parse.cc:5763 #22 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c0aa348, packet=0x7f3c6c0862b9 "ROLLBACK", packet_length=8) at sql_parse.cc:1009 #23 0x00000000006e0b03 in do_command (thd=0x7f3c6c0aa348) at sql_parse.cc:691 #24 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c0aa348) at sql_connect.cc:1146 #25 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #26 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 36 (process 23463): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c8665ef30, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c8665ef30, sync=0x7f3c720c4c60, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c720c4c60, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c720c4c60, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c8102bd08, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c720c4d7f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c8102bd08, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c8102bd08, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c8102bd08, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c85734bf8, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c85734bf8, recordNumber=7660, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x2281770, buf=0x2281b60 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x00000000008118a3 in rr_sequential (info=0x7f3c720c5430) at records.cc:390 #14 0x000000000079d4d5 in mysql_delete (thd=0x7f3c6c08a2f8, table_list=0x2540950, conds=0x25410c8, order=0x7f3c6c08c260, limit=2, options=0, reset_auto_increment=false) at sql_delete.cc:296 #15 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c08a2f8) at sql_parse.cc:3259 #16 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c08a2f8, inBuf=0x2540770 "DELETE FROM `table10_falcon_int_autoinc` WHERE `int_unsigned` <= 4 LIMIT 2", length=75, found_semicolon=0x7f3c720c6f00) at sql_parse.cc:5763 #17 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c08a2f8, packet=0x7f3c6c0c1bf9 "DELETE FROM `table10_falcon_int_autoinc` WHERE `int_unsigned` <= 4 LIMIT 2", packet_length=75) at sql_parse.cc:1009 #18 0x00000000006e0b03 in do_command (thd=0x7f3c6c08a2f8) at sql_parse.cc:691 #19 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c08a2f8) at sql_connect.cc:1146 #20 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #21 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 35 (process 23396): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c86591f28) at Synchronize.cpp:123 #2 0x00000000009bc4cf in Cache::ioThread (this=0x7f3c867bd400) at Cache.cpp:985 #3 0x00000000009bc6e1 in Cache::ioThread (arg=0x7f3c867bd400) at Cache.cpp:775 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c86591f28) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c86591f28) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 34 (process 23455): #0 0x000000000098faac in inline_cas (target=0x7f3c86684788, compare=1, exchange=0) at Interlock.h:106 #1 0x000000000098e86e in SyncObject::unlock (this=0x7f3c86684720, sync=0x7f3c721c7ff0, type=Shared) at SyncObject.cpp:531 #2 0x000000000098db78 in ~Sync (this=0x7f3c721c7ff0) at Sync.cpp:51 #3 0x0000000000a282ea in RecordLeaf::fetch (this=0x7f3c866843f0, id=90) at RecordLeaf.cpp:75 #4 0x0000000000aa2578 in RecordGroup::fetch (this=0x7f3c866074f8, id=1290) at RecordGroup.cpp:69 ---Type to continue, or q to quit--- #5 0x0000000000998bcc in Table::fetchNext (this=0x7f3c8696cf88, start=1290) at Table.cpp:534 #6 0x000000000097f4ad in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x2361ca0, recordNumber=1290, lockForUpdate=false) at StorageDatabase.cpp:282 #7 0x00000000009867d9 in StorageTable::next (this=0x2361ca0, recordNumber=0, lockForUpdate=false) at StorageTable.cpp:158 #8 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c6c09cb70, buf=0x7f3c6c053f70 "ØÚÚ") at ha_falcon.cpp:646 #9 0x0000000000815780 in find_all_keys (param=0x7f3c721c8b90, select=0x2576530, sort_keys=0x2557968, buffpek_pointers=0x7f3c721c8870, tempfile=0x7f3c721c8a00, indexfile=0x0) at filesort.cc:587 #10 0x0000000000816171 in filesort (thd=0x7f3c6c099948, table=0x7f3c6c09d1b8, sortorder=0x2529678, s_length=1, select=0x2576530, max_rows=18446744073709551615, sort_positions=false, examined_rows=0x7f3c721c8d90) at filesort.cc:245 #11 0x0000000000753d26 in create_sort_index (thd=0x7f3c6c099948, join=0x278cbc0, order=0x2528b30, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=false) at sql_select.cc:19023 #12 0x0000000000778071 in JOIN::exec (this=0x278cbc0) at sql_select.cc:2824 #13 0x0000000000772ede in mysql_select (thd=0x7f3c6c099948, rref_pointer_array=0x7f3c6c09b8e0, tables=0x2528070, wild_num=0, fields=@0x7f3c6c09b800, conds=0x2528868, og_num=1, order=0x2528b30, group=0x0, having=0x0, proc_param=0x0, select_options=2148289024, result=0x2528bf8, unit=0x7f3c6c09b290, select_lex=0x7f3c6c09b6f8) at sql_select.cc:3062 #14 0x0000000000778687 in handle_select (thd=0x7f3c6c099948, lex=0x7f3c6c09b1f0, result=0x2528bf8, setup_tables_done_option=0) at sql_select.cc:314 #15 0x00000000006d5023 in execute_sqlcom_select (thd=0x7f3c6c099948, all_tables=0x2528070) at sql_parse.cc:4768 #16 0x00000000006d6627 in mysql_execute_command (thd=0x7f3c6c099948) at sql_parse.cc:2069 #17 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c099948, inBuf=0x2527840 "SELECT `set_latin1_not_null_key` , `set_utf8` , `char_64_utf8` , `enum_latin1_not_null` FROM `table10_falcon_int_autoinc` WHERE `int_unsigned_not_null` <= '20041220120308' ORDER BY `set_utf8_not_nul"..., length=206, found_semicolon=0x7f3c721caf00) at sql_parse.cc:5763 #18 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c099948, packet=0x7f3c6c0b5e39 "SELECT `set_latin1_not_null_key` , `set_utf8` , `char_64_utf8` , `enum_latin1_not_null` FROM `table10_falcon_int_autoinc` WHERE `int_unsigned_not_null` <= '20041220120308' ORDER BY `set_utf8_not_nul"..., packet_length=207) at sql_parse.cc:1009 #19 0x00000000006e0b03 in do_command (thd=0x7f3c6c099948) at sql_parse.cc:691 #20 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c099948) at sql_connect.cc:1146 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 33 (process 23457): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c86633900, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c86633900, sync=0x7f3c72187640, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c72187640, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c72187640, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c80fb4128, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7218775f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c80fb4128, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c80fb4128, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c80fb4128, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x2356850, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x2356850, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x2564300, buf=0x253efb0 "ÚÚÚ") at ha_falcon.cpp:646 ---Type to continue, or q to quit--- #13 0x0000000000815780 in find_all_keys (param=0x7f3c72187e70, select=0x0, sort_keys=0x254c048, buffpek_pointers=0x7f3c72187b50, tempfile=0x7f3c72187ce0, indexfile=0x0) at filesort.cc:587 #14 0x0000000000816171 in filesort (thd=0x7f3c6c04d4e8, table=0x253e6c8, sortorder=0x25331d0, s_length=1, select=0x0, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c72188500) at filesort.cc:245 #15 0x000000000079d01d in mysql_delete (thd=0x7f3c6c04d4e8, table_list=0x25329b8, conds=0x0, order=0x7f3c6c04f450, limit=8, options=0, reset_auto_increment=false) at sql_delete.cc:237 #16 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c04d4e8) at sql_parse.cc:3259 #17 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c04d4e8, inBuf=0x25327e0 "DELETE FROM `table10_falcon_int_autoinc` ORDER BY `set_utf8` LIMIT 8", length=69, found_semicolon=0x7f3c72189f00) at sql_parse.cc:5763 #18 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c04d4e8, packet=0x7f3c6c092439 "DELETE FROM `table10_falcon_int_autoinc` ORDER BY `set_utf8` LIMIT 8", packet_length=69) at sql_parse.cc:1009 #19 0x00000000006e0b03 in do_command (thd=0x7f3c6c04d4e8) at sql_parse.cc:691 #20 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c04d4e8) at sql_connect.cc:1146 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 32 (process 23394): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x00000000006c5dea in handle_connections_sockets () at mysqld.cc:5188 #2 0x00000000006c98ec in main (argc=46, argv=0x7fff8f5aa6b8) at mysqld.cc:4696 Thread 31 (process 23413): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x0000000000b12060 in os_thread_sleep (tm=1000000) at os/os0thread.c:267 #2 0x0000000000b37675 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1914 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 30 (process 23459): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c866355a8, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c866355a8, sync=0x7f3c72146640, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c72146640, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c72146640, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c81068a98, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7214675f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c81068a98, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c81068a98, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c81068a98, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c85758880, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c85758880, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c80f13b90, buf=0x7f3c80f13f80 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x0000000000815780 in find_all_keys (param=0x7f3c72146e70, select=0x0, sort_keys=0x7f3c80f27438, buffpek_pointers=0x7f3c72146b50, ---Type to continue, or q to quit--- tempfile=0x7f3c72146ce0, indexfile=0x0) at filesort.cc:587 #14 0x0000000000816171 in filesort (thd=0x7f3c6c096478, table=0x7f3c80f132a8, sortorder=0x22df508, s_length=1, select=0x0, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c72147500) at filesort.cc:245 #15 0x000000000079d01d in mysql_delete (thd=0x7f3c6c096478, table_list=0x22decc8, conds=0x0, order=0x7f3c6c0983e0, limit=1, options=0, reset_auto_increment=false) at sql_delete.cc:237 #16 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c096478) at sql_parse.cc:3259 #17 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c096478, inBuf=0x22deae0 "DELETE FROM `table10_falcon_int_autoinc` ORDER BY `int_unsigned_key` LIMIT 1", length=77, found_semicolon=0x7f3c72148f00) at sql_parse.cc:5763 #18 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c096478, packet=0x7f3c6c0a6309 "DELETE FROM `table10_falcon_int_autoinc` ORDER BY `int_unsigned_key` LIMIT 1", packet_length=77) at sql_parse.cc:1009 #19 0x00000000006e0b03 in do_command (thd=0x7f3c6c096478) at sql_parse.cc:691 #20 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c096478) at sql_connect.cc:1146 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 29 (process 23398): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c86595b68, milliseconds=1000, callersMutex=0x0) at Synchronize.cpp:183 #2 0x0000000000a80bbf in Synchronize::sleep (this=0x7f3c86595b68, milliseconds=1000) at Synchronize.cpp:136 #3 0x00000000009d43a5 in Database::ticker (this=0x7f3c86792be0) at Database.cpp:1943 #4 0x00000000009d43df in Database::ticker (database=0x7f3c86792be0) at Database.cpp:1932 #5 0x00000000009a3fa1 in Thread::thread (this=0x7f3c86595b68) at Thread.cpp:166 #6 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c86595b68) at Thread.cpp:145 #7 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #8 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 28 (process 23414): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x0000000000b12060 in os_thread_sleep (tm=1000000) at os/os0thread.c:267 #2 0x0000000000b37be2 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2140 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 27 (process 23400): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c8659c158) at Synchronize.cpp:123 #2 0x00000000009d4dea in Database::scavengerThreadMain (this=0x7f3c86792be0) at Database.cpp:1970 #3 0x00000000009d4e33 in Database::scavengerThreadMain (database=0x7f3c86792be0) at Database.cpp:1954 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c8659c158) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c8659c158) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 26 (process 23453): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 ---Type to continue, or q to quit--- #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c8662f130, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c8662f130, sync=0x7f3c72209640, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c72209640, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c72209640, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c80fafc08, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7220975f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c80fafc08, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c80fafc08, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c80fafc08, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x236ad18, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x236ad18, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c6c08d790, buf=0x7f3c6c12a050 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x0000000000815780 in find_all_keys (param=0x7f3c72209e70, select=0x0, sort_keys=0x7f3c6c09de78, buffpek_pointers=0x7f3c72209b50, tempfile=0x7f3c72209ce0, indexfile=0x0) at filesort.cc:587 #14 0x0000000000816171 in filesort (thd=0x7f3c6c039c08, table=0x7f3c6c08cea8, sortorder=0x22f3438, s_length=1, select=0x0, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c7220a500) at filesort.cc:245 #15 0x000000000079d01d in mysql_delete (thd=0x7f3c6c039c08, table_list=0x22f2bf8, conds=0x0, order=0x7f3c6c03bb70, limit=9, options=0, reset_auto_increment=false) at sql_delete.cc:237 #16 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c039c08) at sql_parse.cc:3259 #17 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c039c08, inBuf=0x22f2a10 "DELETE FROM `table10_falcon_int_autoinc` ORDER BY `int_not_null_key` LIMIT 9", length=77, found_semicolon=0x7f3c7220bf00) at sql_parse.cc:5763 #18 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c039c08, packet=0x7f3c6c0494a9 "DELETE FROM `table10_falcon_int_autoinc` ORDER BY `int_not_null_key` LIMIT 9", packet_length=77) at sql_parse.cc:1009 #19 0x00000000006e0b03 in do_command (thd=0x7f3c6c039c08) at sql_parse.cc:691 #20 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c039c08) at sql_connect.cc:1146 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 25 (process 23403): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c865a0218) at Synchronize.cpp:123 #2 0x0000000000a96bca in Gopher::gopherThread (this=0x7f3c86592a40) at Gopher.cpp:58 #3 0x0000000000a96df3 in Gopher::gopherThread (arg=0x7f3c86592a40) at Gopher.cpp:37 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865a0218) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865a0218) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 24 (process 23397): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c86592068) at Synchronize.cpp:123 #2 0x00000000009bc4cf in Cache::ioThread (this=0x7f3c867bd400) at Cache.cpp:985 #3 0x00000000009bc6e1 in Cache::ioThread (arg=0x7f3c867bd400) at Cache.cpp:775 ---Type to continue, or q to quit--- #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c86592068) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c86592068) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 23 (process 23449): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c8662a108, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c8662a108, sync=0x7f3c7228bc60, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c7228bc60, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c7228bc60, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c80f99398, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7228bd7f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c80f99398, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c80f99398, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c80f99398, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c85705c00, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c85705c00, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x2279340, buf=0x228d520 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x00000000008118a3 in rr_sequential (info=0x7f3c7228c430) at records.cc:390 #14 0x000000000079d4d5 in mysql_delete (thd=0x7f3c6c0265d8, table_list=0x22bded0, conds=0x0, order=0x7f3c6c028540, limit=5, options=0, reset_auto_increment=false) at sql_delete.cc:296 #15 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c0265d8) at sql_parse.cc:3259 #16 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c0265d8, inBuf=0x22bdd20 "DELETE FROM `table10_falcon_int_autoinc` LIMIT 5", length=50, found_semicolon=0x7f3c7228df00) at sql_parse.cc:5763 #17 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c0265d8, packet=0x7f3c6c06afa9 "DELETE FROM `table10_falcon_int_autoinc` LIMIT 5", packet_length=50) at sql_parse.cc:1009 #18 0x00000000006e0b03 in do_command (thd=0x7f3c6c0265d8) at sql_parse.cc:691 #19 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c0265d8) at sql_connect.cc:1146 #20 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #21 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 22 (process 23409): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c60f49 in safe_cond_wait (cond=0x7f3c80a4c060, mp=0x7f3c80a4bfb0, file=0xe7b74a "os/os0sync.c", line=422) at thr_mutex.c:424 #2 0x0000000000b11951 in os_event_wait_low (event=0x7f3c80a4bfb0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000b107b7 in os_aio_simulated_handle (global_segment=0, message1=0x7f3c780b60b8, message2=0x7f3c780b60b0, type=0x7f3c780b60a8) at os/os0file.c:4207 #4 0x0000000000aec073 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #5 0x0000000000b38bee in io_handler_thread (arg=0x1597e80) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 21 (process 23399): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c8659c018) at Synchronize.cpp:123 #2 0x00000000009d3546 in Database::cardinalityThreadMain (this=0x7f3c86792be0) at Database.cpp:2469 #3 0x00000000009d358b in Database::cardinalityThreadMain (database=0x7f3c86792be0) at Database.cpp:2456 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c8659c018) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c8659c018) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 20 (process 23435): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c865efb38, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c865efb38, sync=0x7f3c724524b0, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c724524b0, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c724524b0, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c80f99888, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c724525cf) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c80f99888, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c80f99888, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c80f99888, source=0x7f3c8136baf8, usingIndex=true) at Table.cpp:3515 #10 0x000000000097f03f in StorageDatabase::nextIndexed (this=0x7f3c86591208, storageTable=0x7f3c856d46e8, recordBitmap=0x7f3c865aea38, recordNumber=7665, lockForUpdate=true) at StorageDatabase.cpp:432 #11 0x000000000098679b in StorageTable::nextIndexed (this=0x7f3c856d46e8, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:171 #12 0x00000000009763ba in StorageInterface::index_next (this=0x222af90, buf=0x222c120 "ØÚÚ") at ha_falcon.cpp:1848 #13 0x0000000000975244 in StorageInterface::read_range_first (this=0x222af90, start_key=0x222b070, end_key=0x222b090, eq_range_arg=false, sorted=true) at ha_falcon.cpp:1749 #14 0x0000000000817fe4 in handler::multi_range_read_next (this=0x222af90, range_info=0x7f3c72452980) at handler.cc:4342 #15 0x00000000009760a2 in StorageInterface::multi_range_read_next (this=0x222af90, rangeInfo=0x7f3c72452980) at ha_falcon.cpp:1977 #16 0x00000000007f5a63 in QUICK_RANGE_SELECT::get_next (this=0x7f3c64003430) at opt_range.cc:8558 #17 0x0000000000815608 in find_all_keys (param=0x7f3c72452e70, select=0x21a2a50, sort_keys=0x7f3c64000b28, buffpek_pointers=0x7f3c72452b50, tempfile=0x7f3c72452ce0, indexfile=0x0) at filesort.cc:569 #18 0x0000000000816171 in filesort (thd=0x7f3c80ec6238, table=0x222b838, sortorder=0x21a2c30, s_length=1, select=0x21a2a50, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c72453500) at filesort.cc:245 #19 0x000000000079d01d in mysql_delete (thd=0x7f3c80ec6238, table_list=0x21a1e90, conds=0x21a2630, order=0x7f3c80ec81a0, limit=1, options=0, reset_auto_increment=false) at sql_delete.cc:237 #20 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c80ec6238) at sql_parse.cc:3259 #21 0x00000000006de9ef in mysql_parse (thd=0x7f3c80ec6238, inBuf=0x21a1c60 "DELETE FROM `table10_falcon_int_autoinc` WHERE `int_unsigned_key` <= 'is' ORDER BY `enum_latin1_not_null` LIMIT 1", length=113, found_semicolon=0x7f3c72454f00) at sql_parse.cc:5763 #22 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c80ec6238, packet=0x7f3c80ed0b69 "DELETE FROM `table10_falcon_int_autoinc` WHERE `int_unsigned_key` <= 'is' ORDER BY `enum_latin1_not_null` LIMIT 1", packet_length=113) at sql_parse.cc:1009 #23 0x00000000006e0b03 in do_command (thd=0x7f3c80ec6238) at sql_parse.cc:691 ---Type to continue, or q to quit--- #24 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c80ec6238) at sql_connect.cc:1146 #25 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #26 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 19 (process 23412): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c60f49 in safe_cond_wait (cond=0x7f3c80a4c3c0, mp=0x7f3c80a4c310, file=0xe7b74a "os/os0sync.c", line=422) at thr_mutex.c:424 #2 0x0000000000b11951 in os_event_wait_low (event=0x7f3c80a4c310, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000b107b7 in os_aio_simulated_handle (global_segment=3, message1=0x7f3c762b30b8, message2=0x7f3c762b30b0, type=0x7f3c762b30a8) at os/os0file.c:4207 #4 0x0000000000aec073 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #5 0x0000000000b38bee in io_handler_thread (arg=0x1597e98) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 18 (process 23401): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c8659c298) at Synchronize.cpp:123 #2 0x0000000000a244d0 in PageWriter::writer (this=0x7f3c8692adb0) at PageWriter.cpp:171 #3 0x0000000000a245e9 in PageWriter::writer (arg=0x7f3c8692adb0) at PageWriter.cpp:160 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c8659c298) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c8659c298) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 17 (process 23451): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c8662cec0, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c8662cec0, sync=0x7f3c7224ac60, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c7224ac60, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c7224ac60, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c8101bc48, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7224ad7f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c8101bc48, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c8101bc48, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c8101bc48, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x7f3c856cecc0, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x7f3c856cecc0, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c80ed5850, buf=0x7f3c80ed5c40 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x00000000008118a3 in rr_sequential (info=0x7f3c7224b430) at records.cc:390 #14 0x000000000079d4d5 in mysql_delete (thd=0x7f3c6c016008, table_list=0x22cfd20, conds=0x0, order=0x7f3c6c017f70, limit=3, options=0, reset_auto_increment=false) at sql_delete.cc:296 #15 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c6c016008) at sql_parse.cc:3259 ---Type to continue, or q to quit--- #16 0x00000000006de9ef in mysql_parse (thd=0x7f3c6c016008, inBuf=0x22cfb70 "DELETE FROM `table10_falcon_int_autoinc` LIMIT 3", length=50, found_semicolon=0x7f3c7224cf00) at sql_parse.cc:5763 #17 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c6c016008, packet=0x7f3c6c05bf59 "DELETE FROM `table10_falcon_int_autoinc` LIMIT 3", packet_length=50) at sql_parse.cc:1009 #18 0x00000000006e0b03 in do_command (thd=0x7f3c6c016008) at sql_parse.cc:691 #19 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c6c016008) at sql_connect.cc:1146 #20 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #21 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 16 (process 23402): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c865a00d8) at Synchronize.cpp:123 #2 0x0000000000a96bca in Gopher::gopherThread (this=0x7f3c86592a80) at Gopher.cpp:58 #3 0x0000000000a96df3 in Gopher::gopherThread (arg=0x7f3c86592a80) at Gopher.cpp:37 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865a00d8) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865a00d8) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 15 (process 23405): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c865a0498) at Synchronize.cpp:123 #2 0x0000000000a96bca in Gopher::gopherThread (this=0x7f3c865929c0) at Gopher.cpp:58 #3 0x0000000000a96df3 in Gopher::gopherThread (arg=0x7f3c865929c0) at Gopher.cpp:37 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865a0498) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865a0498) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 14 (process 23406): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c865a05d8) at Synchronize.cpp:123 #2 0x0000000000a96bca in Gopher::gopherThread (this=0x7f3c865917b8) at Gopher.cpp:58 #3 0x0000000000a96df3 in Gopher::gopherThread (arg=0x7f3c865917b8) at Gopher.cpp:37 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865a05d8) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865a05d8) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 13 (process 23407): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c865bdaf8, milliseconds=60000, callersMutex=0x0) at Synchronize.cpp:183 #2 0x0000000000a80bbf in Synchronize::sleep (this=0x7f3c865bdaf8, milliseconds=60000) at Synchronize.cpp:136 #3 0x0000000000a3e9e0 in Scheduler::schedule (this=0x7f3c8659b378) at Scheduler.cpp:150 #4 0x0000000000a3ea51 in Scheduler::schedule (lpParameter=0x7f3c8659b378) at Scheduler.cpp:159 ---Type to continue, or q to quit--- #5 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865bdaf8) at Thread.cpp:166 #6 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865bdaf8) at Thread.cpp:145 #7 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #8 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 12 (process 23416): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c61226 in safe_cond_timedwait (cond=0x1d9a180, mp=0x1d9a0e0, abstime=0x7f3c72f19080, file=0xea2396 "ma_checkpoint.c", line=715) at thr_mutex.c:478 #2 0x0000000000c149e1 in ma_checkpoint_background (arg=0x1e) at ma_checkpoint.c:715 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 11 (process 23408): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c865be8b0) at Synchronize.cpp:123 #2 0x0000000000a3e9f9 in Scheduler::schedule (this=0x7f3c8659b288) at Scheduler.cpp:152 #3 0x0000000000a3ea51 in Scheduler::schedule (lpParameter=0x7f3c8659b288) at Scheduler.cpp:159 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865be8b0) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865be8b0) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 10 (process 23411): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c60f49 in safe_cond_wait (cond=0x7f3c80a4c2a0, mp=0x7f3c80a4c1f0, file=0xe7b74a "os/os0sync.c", line=422) at thr_mutex.c:424 #2 0x0000000000b11951 in os_event_wait_low (event=0x7f3c80a4c1f0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000b107b7 in os_aio_simulated_handle (global_segment=2, message1=0x7f3c76cb40b8, message2=0x7f3c76cb40b0, type=0x7f3c76cb40a8) at os/os0file.c:4207 #4 0x0000000000aec073 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #5 0x0000000000b38bee in io_handler_thread (arg=0x1597e90) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 9 (process 23417): #0 0x000000315b00ee7b in sigwait () from /lib64/libpthread.so.0 #1 0x00000000006c4839 in signal_hand (arg=0x0) at mysqld.cc:2892 #2 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #3 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 8 (process 23410): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c60f49 in safe_cond_wait (cond=0x7f3c80a4c180, mp=0x7f3c80a4c0d0, file=0xe7b74a "os/os0sync.c", line=422) at thr_mutex.c:424 #2 0x0000000000b11951 in os_event_wait_low (event=0x7f3c80a4c0d0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000b107b7 in os_aio_simulated_handle (global_segment=1, message1=0x7f3c776b50b8, message2=0x7f3c776b50b0, type=0x7f3c776b50a8) ---Type to continue, or q to quit--- at os/os0file.c:4207 #4 0x0000000000aec073 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #5 0x0000000000b38bee in io_handler_thread (arg=0x1597e88) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 7 (process 23404): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80f11 in Synchronize::sleep (this=0x7f3c865a0358) at Synchronize.cpp:123 #2 0x0000000000a96bca in Gopher::gopherThread (this=0x7f3c86592a00) at Gopher.cpp:58 #3 0x0000000000a96df3 in Gopher::gopherThread (arg=0x7f3c86592a00) at Gopher.cpp:37 #4 0x00000000009a3fa1 in Thread::thread (this=0x7f3c865a0358) at Thread.cpp:166 #5 0x00000000009a41e7 in Thread::thread (parameter=0x7f3c865a0358) at Thread.cpp:145 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 6 (process 23415): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c60f49 in safe_cond_wait (cond=0x7f3c801d9660, mp=0x7f3c801d95b0, file=0xe7b74a "os/os0sync.c", line=422) at thr_mutex.c:424 #2 0x0000000000b11951 in os_event_wait_low (event=0x7f3c801d95b0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000b3855f in srv_master_thread (arg=0x0) at srv/srv0srv.c:2629 #4 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #5 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 5 (process 23443): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c86623948, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c86623948, sync=0x7f3c7234e5e0, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c7234e5e0, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c7234e5e0, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x2490750, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7234e6ff) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x2490750, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x2490750, record=0x7f3c8136e498, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c86982ae0, transaction=0x2490750, source=0x7f3c8136e498, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x23158b0, recordNumber=1995, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x23158b0, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x7f3c80ee4130, buf=0x7f3c80f0d500 "ÚÚÚ") at ha_falcon.cpp:646 #13 0x00000000008253b9 in ha_partition::rnd_next (this=0x7f3c80ee5340, buf=0x7f3c80f0d500 "ÚÚÚ") at ha_partition.cc:3541 #14 0x0000000000815780 in find_all_keys (param=0x7f3c7234ee70, select=0x0, sort_keys=0x7f3c80f11928, buffpek_pointers=0x7f3c7234eb50, tempfile=0x7f3c7234ece0, indexfile=0x0) at filesort.cc:587 #15 0x0000000000816171 in filesort (thd=0x2274728, table=0x7f3c80ee3848, sortorder=0x2277da8, s_length=1, select=0x0, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c7234f500) at filesort.cc:245 ---Type to continue, or q to quit--- #16 0x000000000079d01d in mysql_delete (thd=0x2274728, table_list=0x2277558, conds=0x0, order=0x2276690, limit=4, options=0, reset_auto_increment=false) at sql_delete.cc:237 #17 0x00000000006d9940 in mysql_execute_command (thd=0x2274728) at sql_parse.cc:3259 #18 0x00000000006de9ef in mysql_parse (thd=0x2274728, inBuf=0x22772f0 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` ORDER BY `datetime_not_null_key` LIMIT 4", length=97, found_semicolon=0x7f3c72350f00) at sql_parse.cc:5763 #19 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x2274728, packet=0x2295fc9 "DELETE FROM `table10_falcon_key_pk_parts_2_int_autoinc` ORDER BY `datetime_not_null_key` LIMIT 4", packet_length=97) at sql_parse.cc:1009 #20 0x00000000006e0b03 in do_command (thd=0x2274728) at sql_parse.cc:691 #21 0x00000000006ce9cd in handle_one_connection (arg=0x2274728) at sql_connect.cc:1146 #22 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #23 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 4 (process 23418): #0 0x000000315b00df5b in read () from /lib64/libpthread.so.0 #1 0x0000000000c29069 in vio_read (vio=0x7f3c80e8b018, buf=0x7f3c80eb3888 "\a", size=4) at viosocket.c:44 #2 0x00000000006b519b in my_real_read (net=0x7f3c80c9f840, complen=0x7f3c724d6fe8) at net_serv.cc:837 #3 0x00000000006b594b in my_net_read (net=0x7f3c80c9f840) at net_serv.cc:1020 #4 0x00000000006e096b in do_command (thd=0x7f3c80c9f728) at sql_parse.cc:637 #5 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c80c9f728) at sql_connect.cc:1146 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 3 (process 23433): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c865ea718, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c865ea718, sync=0x7f3c72493640, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c72493640, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c72493640, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c80fb14b8, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7249375f) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c80fb14b8, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c80fb14b8, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c80fb14b8, source=0x7f3c8136baf8, usingIndex=false) at Table.cpp:3515 #10 0x000000000097f4e0 in StorageDatabase::nextRow (this=0x7f3c86591208, storageTable=0x235c278, recordNumber=7664, lockForUpdate=true) at StorageDatabase.cpp:289 #11 0x00000000009867d9 in StorageTable::next (this=0x235c278, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:158 #12 0x0000000000976b27 in StorageInterface::rnd_next (this=0x2540290, buf=0x254c1c0 "ÚÙÚ") at ha_falcon.cpp:646 #13 0x0000000000815780 in find_all_keys (param=0x7f3c72493e70, select=0x217bc48, sort_keys=0x7f3c80f27618, buffpek_pointers=0x7f3c72493b50, tempfile=0x7f3c72493ce0, indexfile=0x0) at filesort.cc:587 #14 0x0000000000816171 in filesort (thd=0x7f3c80eb78c8, table=0x253c718, sortorder=0x217be28, s_length=1, select=0x217bc48, max_rows=18446744073709551615, sort_positions=true, examined_rows=0x7f3c72494500) at filesort.cc:245 #15 0x000000000079d01d in mysql_delete (thd=0x7f3c80eb78c8, table_list=0x217afc8, conds=0x217b788, order=0x7f3c80eb9830, limit=3, options=0, ---Type to continue, or q to quit--- reset_auto_increment=false) at sql_delete.cc:237 #16 0x00000000006d9940 in mysql_execute_command (thd=0x7f3c80eb78c8) at sql_parse.cc:3259 #17 0x00000000006de9ef in mysql_parse (thd=0x7f3c80eb78c8, inBuf=0x217ad80 "DELETE FROM `table10_falcon_int_autoinc` WHERE `char_64_utf8` <> '20010418022222' ORDER BY `char_64_latin1_not_null` LIMIT 3", length=124, found_semicolon=0x7f3c72495f00) at sql_parse.cc:5763 #18 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x7f3c80eb78c8, packet=0x7f3c80ec21f9 "DELETE FROM `table10_falcon_int_autoinc` WHERE `char_64_utf8` <> '20010418022222' ORDER BY `char_64_latin1_not_null` LIMIT 3", packet_length=124) at sql_parse.cc:1009 #19 0x00000000006e0b03 in do_command (thd=0x7f3c80eb78c8) at sql_parse.cc:691 #20 0x00000000006ce9cd in handle_one_connection (arg=0x7f3c80eb78c8) at sql_connect.cc:1146 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 2 (process 23441): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a80dc7 in Synchronize::sleep (this=0x7f3c8660d710, milliseconds=1000, callersMutex=0x7f3c80fb0308) at Synchronize.cpp:183 #2 0x000000000098edb7 in SyncObject::wait (this=0x7f3c80fb02f8, type=Shared, thread=0x7f3c8660d710, sync=0x7f3c7238fad0, timeout=1000) at SyncObject.cpp:633 #3 0x000000000098f434 in SyncObject::lock (this=0x7f3c80fb02f8, sync=0x7f3c7238fad0, type=Shared, timeout=1000) at SyncObject.cpp:449 #4 0x000000000098d826 in Sync::lock (this=0x7f3c7238fad0, type=Shared, timeout=1000) at Sync.cpp:66 #5 0x00000000009a7d38 in Transaction::waitForTransaction (this=0x7f3c80fb00f8) at Transaction.cpp:1077 #6 0x00000000009a7efd in Transaction::waitForTransaction (this=0x7f3c80fb2388, transaction=0x7f3c80fb00f8, transId=0, deadlock=0x7f3c7238fbef) at Transaction.cpp:1044 #7 0x00000000009a8149 in Transaction::getRelativeState (this=0x7f3c80fb2388, transaction=0x7f3c80fb00f8, transId=12519, flags=1) at Transaction.cpp:892 #8 0x00000000009a8258 in Transaction::getRelativeState (this=0x7f3c80fb2388, record=0x7f3c8136baf8, flags=1) at Transaction.cpp:845 #9 0x0000000000997e39 in Table::fetchForUpdate (this=0x7f3c8696cf88, transaction=0x7f3c80fb2388, source=0x7f3c8136baf8, usingIndex=true) at Table.cpp:3515 #10 0x000000000097f03f in StorageDatabase::nextIndexed (this=0x7f3c86591208, storageTable=0x7f3c856af500, recordBitmap=0x7f3c865940b0, recordNumber=7665, lockForUpdate=true) at StorageDatabase.cpp:432 #11 0x000000000098679b in StorageTable::nextIndexed (this=0x7f3c856af500, recordNumber=0, lockForUpdate=true) at StorageTable.cpp:171 #12 0x00000000009763ba in StorageInterface::index_next (this=0x218e760, buf=0x218eb50 "ÚÚÚ") at ha_falcon.cpp:1848 #13 0x0000000000975244 in StorageInterface::read_range_first (this=0x218e760, start_key=0x218e840, end_key=0x0, eq_range_arg=false, sorted=true) at ha_falcon.cpp:1749 #14 0x0000000000817fe4 in handler::multi_range_read_next (this=0x218e760, range_info=0x7f3c7238ffa0) at handler.cc:4342 #15 0x00000000009760a2 in StorageInterface::multi_range_read_next (this=0x218e760, rangeInfo=0x7f3c7238ffa0) at ha_falcon.cpp:1977 #16 0x00000000007f5a63 in QUICK_RANGE_SELECT::get_next (this=0x7f3c64002210) at opt_range.cc:8558 #17 0x000000000081193a in rr_quick (info=0x7f3c72390430) at records.cc:322 #18 0x000000000079d4d5 in mysql_delete (thd=0x22357e8, table_list=0x224a698, conds=0x224ae40, order=0x2237750, limit=1, options=0, reset_auto_increment=false) at sql_delete.cc:296 #19 0x00000000006d9940 in mysql_execute_command (thd=0x22357e8) at sql_parse.cc:3259 #20 0x00000000006de9ef in mysql_parse (thd=0x22357e8, inBuf=0x224a4a0 "DELETE FROM `table10_falcon_int_autoinc` WHERE `int_not_null_key` <> 'know' LIMIT 1", length=84, found_semicolon=0x7f3c72391f00) at sql_parse.cc:5763 #21 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x22357e8, packet=0x2240329 "DELETE FROM `table10_falcon_int_autoinc` WHERE `int_not_null_key` <> 'know' LIMIT 1", packet_length=84) at sql_parse.cc:1009 #22 0x00000000006e0b03 in do_command (thd=0x22357e8) at sql_parse.cc:691 #23 0x00000000006ce9cd in handle_one_connection (arg=0x22357e8) at sql_connect.cc:1146 ---Type to continue, or q to quit--- #24 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #25 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 1 (process 23445): #0 0x000000315b00c216 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000c5ac25 in my_write_core (sig=6) at stacktrace.c:309 #2 0x00000000006c5596 in handle_segfault (sig=6) at mysqld.cc:2690 #3 #4 0x000000315a432ed5 in raise () from /lib64/libc.so.6 #5 0x000000315a434a43 in abort () from /lib64/libc.so.6 #6 0x000000316a2c58e4 in __gnu_cxx::__verbose_terminate_handler () from /usr/lib64/libstdc++.so.6 #7 0x000000316a2c3ce6 in ?? () from /usr/lib64/libstdc++.so.6 #8 0x000000316a2c3d13 in std::terminate () from /usr/lib64/libstdc++.so.6 #9 0x000000316a2c3dfa in __cxa_throw () from /usr/lib64/libstdc++.so.6 #10 0x0000000000a07dc7 in IO::readPage (this=0x7f3c8694ec90, bdb=0x7f3c867fa600) at IO.cpp:302 #11 0x00000000009bb899 in Cache::fetchPage (this=0x7f3c867bd400, dbb=0x7f3c8694ec88, pageNumber=1954, pageType=PAGE_btree, lockType=Shared) at Cache.cpp:289 #12 0x00000000009e1960 in Dbb::fetchPage (this=0x7f3c8694ec88, pageNumber=1954, pageType=PAGE_btree, lockType=Shared) at Dbb.cpp:219 #13 0x00000000009e1b88 in Dbb::handoffPage (this=0x7f3c8694ec88, bdb=0x7f3c8681c540, pageNumber=1954, pageType=PAGE_btree, lockType=Shared) at Dbb.cpp:268 #14 0x0000000000a0139f in IndexRootPage::findLeaf (dbb=0x7f3c8694ec88, indexId=36, rootPage=46, indexKey=0x15919a0, lockType=Shared, transId=0) at IndexRootPage.cpp:248 #15 0x0000000000a0187e in IndexRootPage::scanIndex (dbb=0x7f3c8694ec88, indexId=36, rootPage=46, lowKey=0x15919a0, highKey=0x238b5b0, searchFlags=0, transId=0, bitmap=0x7f3c865c57b0) at IndexRootPage.cpp:382 #16 0x00000000009fdabe in Index::scanIndex (this=0x7f3c865dd5c0, lowKey=0x0, highKey=0x238b5b0, searchFlags=0, transaction=0x2496a10, bitmap=0x7f3c865c57b0) at Index.cpp:510 #17 0x000000000097e2ef in StorageDatabase::indexScan (this=0x7f3c86591208, index=0x7f3c865dd5c0, lower=0x0, upper=0x238b5a8, searchFlags=0, storageConnection=0x7f3c866268b8, bitmap=0x7f3c865c57b0) at StorageDatabase.cpp:784 #18 0x00000000009865d0 in StorageTable::indexScan (this=0x2388af0, indexOrder=0) at StorageTable.cpp:259 #19 0x0000000000974ef3 in StorageInterface::scanRange (this=0x7f3c80f44580, start_key=0x0, end_key=0x7f3c80f27d70, eqRange=false) at ha_falcon.cpp:1805 #20 0x00000000009751fe in StorageInterface::read_range_first (this=0x7f3c80f44580, start_key=0x0, end_key=0x7f3c80f27d70, eq_range_arg=false, sorted=true) at ha_falcon.cpp:1746 #21 0x00000000008268da in ha_partition::handle_ordered_index_scan (this=0x7f3c80f27c40, buf=0x7f3c80f82ca0 "ÚÚÚ", reverse_order=false) at ha_partition.cc:4602 #22 0x000000000082702a in ha_partition::common_index_read (this=0x7f3c80f27c40, buf=0x7f3c80f82ca0 "ÚÚÚ", have_start_key=false) at ha_partition.cc:3979 #23 0x00000000008271d0 in ha_partition::read_range_first (this=0x7f3c80f27c40, start_key=0x0, end_key=0x7f3c80f27d40, eq_range_arg=false, sorted=true) at ha_partition.cc:4235 #24 0x0000000000817fe4 in handler::multi_range_read_next (this=0x7f3c80f27c40, range_info=0x7f3c7230dc60) at handler.cc:4342 #25 0x00000000007f5a63 in QUICK_RANGE_SELECT::get_next (this=0x7f3c6c0aced0) at opt_range.cc:8558 #26 0x000000000081193a in rr_quick (info=0x7f3c6c0e2fd8) at records.cc:322 #27 0x000000000074d173 in join_init_read_record (tab=0x7f3c6c0e2f50) at sql_select.cc:17028 #28 0x00000000007509ab in sub_select (join=0x7f3c6c0d9ee0, join_tab=0x7f3c6c0e2f50, end_of_records=false) at sql_select.cc:16222 #29 0x000000000075e359 in do_select (join=0x7f3c6c0d9ee0, fields=0x0, table=0x7f3c6c0e4c70, procedure=0x0) at sql_select.cc:15786 #30 0x0000000000776ae7 in JOIN::exec (this=0x7f3c6c0d9ee0) at sql_select.cc:2463 #31 0x0000000000772ede in mysql_select (thd=0x22a1d88, rref_pointer_array=0x22a3d20, tables=0x228a8c0, wild_num=1, fields=@0x22a3c40, conds=0x228b0a8, og_num=2, order=0x228b840, group=0x228b368, having=0x228b5a0, proc_param=0x0, select_options=2149337600, result=0x228b910, unit=0x22a36d0, select_lex=0x22a3b38) at sql_select.cc:3062 ---Type to continue, or q to quit--- #32 0x0000000000778687 in handle_select (thd=0x22a1d88, lex=0x22a3630, result=0x228b910, setup_tables_done_option=0) at sql_select.cc:314 #33 0x00000000006d5023 in execute_sqlcom_select (thd=0x22a1d88, all_tables=0x228a8c0) at sql_parse.cc:4768 #34 0x00000000006d6627 in mysql_execute_command (thd=0x22a1d88) at sql_parse.cc:2069 #35 0x00000000006de9ef in mysql_parse (thd=0x22a1d88, inBuf=0x228a480 "SELECT * FROM `table10_falcon_key_pk_parts_2_int_autoinc` WHERE `char_64_latin1_not_null_key` <= 'like' GROUP BY `enum_utf8_not_null` HAVING `enum_latin1_not_null_key` <> 'tell' ORDER BY `int_unsigned"..., length=209, found_semicolon=0x7f3c7230ff00) at sql_parse.cc:5763 #36 0x00000000006df5da in dispatch_command (command=COM_QUERY, thd=0x22a1d88, packet=0x7f3c6c00b019 "SELECT * FROM `table10_falcon_key_pk_parts_2_int_autoinc` WHERE `char_64_latin1_not_null_key` <= 'like' GROUP BY `enum_utf8_not_null` HAVING `enum_latin1_not_null_key` <> 'tell' ORDER BY `int_unsigned"..., packet_length=209) at sql_parse.cc:1009 #37 0x00000000006e0b03 in do_command (thd=0x22a1d88) at sql_parse.cc:691 #38 0x00000000006ce9cd in handle_one_connection (arg=0x22a1d88) at sql_connect.cc:1146 #39 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #40 0x000000315a4e627d in clone () from /lib64/libc.so.6