Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
5.5(EOL)
-
None
-
5.5.59
Description
A concurrent test hangs like this (setting lock_wait_timeout to a reasonable value does not help):
*************************** 1. row ***************************
|
Id: 1
|
User: root
|
Host: 127.0.0.1:51738
|
db: test
|
Command: Sleep
|
Time: 1792
|
State:
|
Info: NULL
|
Progress: 0.000
|
*************************** 2. row ***************************
|
Id: 9
|
User: root
|
Host: 127.0.0.1:51746
|
db: test
|
Command: Killed
|
Time: 1729
|
State: rename result table
|
Info: ALTER TABLE `BB` ADD COLUMN p INTEGER /* QUERY_NO 1425 CON_ID 9 */
|
Progress: 0.000
|
*************************** 3. row ***************************
|
Id: 10
|
User: root
|
Host: 127.0.0.1:51747
|
db: test
|
Command: Killed
|
Time: 1729
|
State: Filling schema table
|
Info: SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table2 ON ( table2.`ACCESS_TIME` = table1.`next_page_no` ) ) WHERE ( table2.`IS_OLD` = table2.`INDEX_NAME` AND table1.`flush_type` >= table1.`page_no`) LIMIT 8 /* QUERY_NO 3013 CON_ID 10 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QUERY_NO 3021 CON_ID 10 */
|
Progress: 0.000
|
*************************** 4. row ***************************
|
Id: 11
|
User: root
|
Host: 127.0.0.1:51748
|
db: test
|
Command: Killed
|
Time: 1369
|
State: creating table
|
Info: CREATE TABLE transforms.insert_select_41698 SELECT * FROM test.`CC` AS table1 WHERE NOT table1.`col_int_nokey` = 'hx' LIMIT 1 /* QUERY_NO 4230 CON_ID 11 */ /* QUERY_NO 4242 CON_ID 11 */
|
Progress: 0.000
|
*************************** 5. row ***************************
|
Id: 12
|
User: root
|
Host: 127.0.0.1:51749
|
db: test
|
Command: Killed
|
Time: 1729
|
State: checking permissions
|
Info: DROP TABLE transforms.insert_select_41700 /* QUERY_NO 3831 CON_ID 12 */
|
Progress: 0.000
|
*************************** 6. row ***************************
|
Id: 169
|
User: root
|
Host: 127.0.0.1:51908
|
db: test
|
Command: Query
|
Time: 899
|
State: Filling schema table
|
Info: /* GenTest::Transform::OrderBy */ SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table2 ON ( table2.`ACCESS_TIME` = table1.`next_page_no` ) ) WHERE ( table2.`IS_OLD` = table2.`INDEX_NAME` AND table1.`flush_type` >= table1.`page_no`) ORDER BY 1 /* TRANSFORM_OUTCOME_SUPERSET */ /* QUERY_NO 3026 CON_ID 10 */
|
Progress: 0.000
|
*************************** 7. row ***************************
|
Id: 265
|
User: root
|
Host: 127.0.0.1:52008
|
db: test
|
Command: Query
|
Time: 0
|
State: closing tables
|
Info: show full processlist
|
Progress: 0.000
|
Thread 10 (Thread 0x7f3515bff700 (LWP 41675)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f3528e995b0, mp=0x7f3528e99500, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f3528e995b0, mutex=0x7f3528e99500) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f3528e99500, reset_sig_count=10) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=2) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b225c4 in mutex_spin_wait (mutex=0x7f3528f2f078, file_name=0xe83860 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c", line=1311) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0sync.c:639
|
#6 0x0000000000b936a1 in mutex_enter_func (mutex=0x7f3528f2f078, file_name=0xe83860 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c", line=1311) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0sync.ic:219
|
#7 0x0000000000b93765 in pfs_mutex_enter_func (mutex=0x7f3528f2f078, file_name=0xe83860 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c", line=1311) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0sync.ic:248
|
#8 0x0000000000b98020 in buf_flush_page (buf_pool=0x7f3528f2f078, bpage=0x7f3520beb540, flush_type=BUF_FLUSH_LIST) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c:1311
|
#9 0x0000000000b98615 in buf_flush_try_neighbors (space=0, offset=9, flush_type=BUF_FLUSH_LIST, n_flushed=0, n_to_flush=33) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c:1541
|
#10 0x0000000000b98969 in buf_flush_page_and_try_neighbors (bpage=0x7f3520beb540, flush_type=BUF_FLUSH_LIST, n_to_flush=33, count=0x7f3515bfe5c8) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c:1638
|
#11 0x0000000000b98d36 in buf_flush_flush_list_batch (buf_pool=0x7f3528f2f078, min_n=33, lsn_limit=15283520) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c:1768
|
#12 0x0000000000b98e3b in buf_flush_batch (buf_pool=0x7f3528f2f078, flush_type=BUF_FLUSH_LIST, min_n=33, lsn_limit=15283520) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c:1848
|
#13 0x0000000000b9933a in buf_flush_list (min_n=33, lsn_limit=15283520) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0flu.c:2065
|
#14 0x0000000000b17df6 in srv_master_thread (arg=0x0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/srv/srv0srv.c:3681
|
#15 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#16 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#17 0x0000000000000000 in ?? ()
|
Thread 9 (Thread 0x7f35153fe700 (LWP 41676)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f351fd6dab0, mp=0x7f351fd6da00, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f351fd6dab0, mutex=0x7f351fd6da00) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f351fd6da00, reset_sig_count=3) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b21210 in rw_lock_x_lock_wait (lock=0x7f3520bec670, file_name=0xe7b680 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c", line=261) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:534
|
#6 0x0000000000b212fc in rw_lock_x_lock_low (lock=0x7f3520bec670, pass=0, file_name=0xe7b680 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c", line=261) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:580
|
#7 0x0000000000b213fb in rw_lock_x_lock_func (lock=0x7f3520bec670, pass=0, file_name=0xe7b680 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c", line=261) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:643
|
#8 0x0000000000b8442b in pfs_rw_lock_x_lock_func (lock=0x7f3520bec670, pass=0, file_name=0xe7b680 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c", line=261) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0rw.ic:694
|
#9 0x0000000000b8d683 in buf_page_get_gen (space=0, zip_size=0, offset=8, rw_latch=2, guess=0x0, mode=10, file=0xe7b680 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c", line=261, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/buf/buf0buf.c:2959
|
#10 0x0000000000b67cbe in btr_block_get_func (space=0, zip_size=0, page_no=8, mode=2, file=0xe7b680 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c", line=261, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/btr0btr.ic:59
|
#11 0x0000000000b68eec in btr_cur_latch_leaves (page=0x7f35289d0000 "\373\257\353@", space=0, zip_size=0, page_no=8, latch_mode=2, cursor=0x7f352938d6d8, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c:260
|
#12 0x0000000000b6aabc in btr_cur_search_to_nth_level (index=0x7f3532c50578, level=0, tuple=0x7f35140501f8, mode=4, latch_mode=2, cursor=0x7f352938d6d8, has_search_latch=0, file=0xeb62e0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c", line=98, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0cur.c:871
|
#13 0x0000000000b788d3 in btr_pcur_open_with_no_init_func (index=0x7f3532c50578, tuple=0x7f35140501f8, mode=4, latch_mode=2, cursor=0x7f352938d6d8, has_search_latch=0, file=0xeb62e0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c", line=98, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/btr0pcur.ic:482
|
#14 0x0000000000b79431 in btr_pcur_restore_position_func (latch_mode=2, cursor=0x7f352938d6d8, file=0xeb62e0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c", line=98, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/btr/btr0pcur.c:342
|
#15 0x0000000000c897e6 in row_purge_reposition_pcur (mode=2, node=0x7f352938d678, mtr=0x7f35153fd740) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c:97
|
#16 0x0000000000c89944 in row_purge_remove_clust_if_poss_low (node=0x7f352938d678, mode=2) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c:148
|
#17 0x0000000000c89b99 in row_purge_remove_clust_if_poss (node=0x7f352938d678) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c:211
|
#18 0x0000000000c8a36e in row_purge_del_mark (node=0x7f352938d678) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c:502
|
#19 0x0000000000c8ac87 in row_purge (node=0x7f352938d678, thr=0x7f3532c521c0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c:776
|
#20 0x0000000000c8adae in row_purge_step (thr=0x7f3532c521c0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0purge.c:816
|
#21 0x0000000000c72274 in que_thr_step (thr=0x7f3532c521c0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/que/que0que.c:1259
|
#22 0x0000000000c724a2 in que_run_threads_low (thr=0x7f3532c521c0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/que/que0que.c:1319
|
#23 0x0000000000c725c6 in que_run_threads (thr=0x7f3532c521c0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/que/que0que.c:1356
|
#24 0x0000000000b2c0dd in trx_purge (limit=20) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/trx/trx0purge.c:1220
|
#25 0x0000000000b1921c in srv_purge_thread (arg=0x0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/srv/srv0srv.c:4206
|
#26 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#27 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#28 0x0000000000000000 in ?? ()
|
Thread 6 (Thread 0x7f35353c1700 (LWP 41695)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f351fd89ab0, mp=0x7f351fd89a00, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f351fd89ab0, mutex=0x7f351fd89a00) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f351fd89a00, reset_sig_count=373) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=1) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b21210 in rw_lock_x_lock_wait (lock=0x1d5eb60 <dict_operation_lock>, file_name=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:534
|
#6 0x0000000000b212fc in rw_lock_x_lock_low (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:580
|
#7 0x0000000000b213fb in rw_lock_x_lock_func (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:643
|
#8 0x0000000000ae428d in pfs_rw_lock_x_lock_func (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0rw.ic:694
|
#9 0x0000000000aeaa28 in row_mysql_lock_data_dictionary_func (trx=0x7f3512477c78, file=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c:1849
|
#10 0x0000000000aed3e6 in row_drop_table_for_mysql (name=0x7f35353bb770 "test/#sql2-a2b9-9#P#p5", trx=0x7f3512477c78, drop_db=0, create_failed=0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c:3295
|
#11 0x0000000000abb08d in ha_innobase::delete_table (this=0x7f3513827fd8, name=0x7f35353bbc30 "./test/#sql2-a2b9-9#P#p5") at /home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/ha_innodb.cc:8777
|
#12 0x00000000007dd698 in handler::ha_delete_table (this=0x7f3513827fd8, name=0x7f35353bbc30 "./test/#sql2-a2b9-9#P#p5") at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:3723
|
#13 0x0000000000cb9e17 in ha_partition::del_ren_cre_table (this=0x7f35137de3c8, from=0x7f35353bd8c0 "./test/#sql2-a2b9-9", to=0x0, table_arg=0x0, create_info=0x0) at /home/mariadb/git/5.5-mdev10504/sql/ha_partition.cc:2043
|
#14 0x0000000000cb64a2 in ha_partition::delete_table (this=0x7f35137de3c8, name=0x7f35353bd8c0 "./test/#sql2-a2b9-9") at /home/mariadb/git/5.5-mdev10504/sql/ha_partition.cc:477
|
#15 0x00000000007dd698 in handler::ha_delete_table (this=0x7f35137de3c8, name=0x7f35353bd8c0 "./test/#sql2-a2b9-9") at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:3723
|
#16 0x00000000007da586 in ha_delete_table (thd=0x7f351efa1060, table_type=0x7f3532cff720, path=0x7f35353bd8c0 "./test/#sql2-a2b9-9", db=0x7f3513557788 "test", alias=0x7f35353bdd60 "#sql2-a2b9-9", generate_warning=false) at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:2154
|
#17 0x00000000006b11e0 in quick_rm_table (base=0x7f3532cff720, db=0x7f3513557788 "test", table_name=0x7f35353bdd60 "#sql2-a2b9-9", flags=3) at /home/mariadb/git/5.5-mdev10504/sql/sql_table.cc:2491
|
#18 0x00000000006be092 in mysql_alter_table (thd=0x7f351efa1060, new_db=0x7f3513557788 "test", new_name=0x7f3513557180 "BB", create_info=0x7f35353bf4f0, table_list=0x7f35135571b8, alter_info=0x7f35353bf450, order_num=0, order=0x0, ignore=false, require_online=false) at /home/mariadb/git/5.5-mdev10504/sql/sql_table.cc:7250
|
#19 0x00000000009545bb in Alter_table_statement::execute (this=0x7f3513557890, thd=0x7f351efa1060) at /home/mariadb/git/5.5-mdev10504/sql/sql_alter.cc:106
|
#20 0x000000000061bdb4 in mysql_execute_command (thd=0x7f351efa1060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:4514
|
#21 0x000000000061f316 in mysql_parse (thd=0x7f351efa1060, rawbuf=0x7f3513557078 "ALTER TABLE `BB` ADD COLUMN p INTEGER /* QUERY_NO 1425 CON_ID 9 */", length=66, parser_state=0x7f35353c0610) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:5934
|
#22 0x00000000006125ff in dispatch_command (command=COM_QUERY, thd=0x7f351efa1060, packet=0x7f35196a9061 "ALTER TABLE `BB` ADD COLUMN p INTEGER /* QUERY_NO 1425 CON_ID 9 */ ", packet_length=67) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:1079
|
#23 0x0000000000611750 in do_command (thd=0x7f351efa1060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:793
|
#24 0x000000000071f906 in do_handle_one_connection (thd_arg=0x7f351efa1060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1270
|
#25 0x000000000071f693 in handle_one_connection (arg=0x7f351efa1060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1186
|
#26 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#27 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#28 0x0000000000000000 in ?? ()
|
Thread 5 (Thread 0x7f3535378700 (LWP 41697)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f351fd6c3b0, mp=0x7f351fd6c300, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f351fd6c3b0, mutex=0x7f351fd6c300) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f351fd6c300, reset_sig_count=1) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=3) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b225c4 in mutex_spin_wait (mutex=0x7f3520beb618, file_name=0xe5b2d8 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/include/buf0buf.ic", line=376) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0sync.c:639
|
#6 0x0000000000ac904a in mutex_enter_func (mutex=0x7f3520beb618, file_name=0xe5b2d8 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/include/buf0buf.ic", line=376) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0sync.ic:219
|
#7 0x0000000000ac9110 in pfs_mutex_enter_func (mutex=0x7f3520beb618, file_name=0xe5b2d8 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/include/buf0buf.ic", line=376) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0sync.ic:248
|
#8 0x0000000000ac9d66 in buf_page_get_mutex_enter (bpage=0x7f3520beb540) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/buf0buf.ic:376
|
#9 0x0000000000ad4a4a in i_s_innodb_buffer_pool_pages_blob_fill (thd=0x7f35196ae060, tables=0x7f3513c25c38, cond=0x7f3513da7a38) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/i_s.cc:6670
|
#10 0x00000000006a573f in get_schema_tables_result (join=0x7f3513f3bfe8, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/mariadb/git/5.5-mdev10504/sql/sql_show.cc:7792
|
#11 0x000000000064b7ab in JOIN::exec (this=0x7f3513f3bfe8) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:2360
|
#12 0x000000000064e22f in mysql_select (thd=0x7f35196ae060, rref_pointer_array=0x7f35196b1ce0, tables=0x7f3513c25c38, wild_num=1, fields=..., conds=0x7f3513da7bb0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684652288, result=0x7f3513f3bfc8, unit=0x7f35196b1390, select_lex=0x7f35196b1a70) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:3094
|
#13 0x0000000000644787 in handle_select (thd=0x7f35196ae060, lex=0x7f35196b12e0, result=0x7f3513f3bfc8, setup_tables_done_option=0) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:319
|
#14 0x000000000061c5b9 in execute_sqlcom_select (thd=0x7f35196ae060, all_tables=0x7f3513c25c38) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:4689
|
#15 0x0000000000615176 in mysql_execute_command (thd=0x7f35196ae060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:2234
|
#16 0x000000000061f316 in mysql_parse (thd=0x7f35196ae060, rawbuf=0x7f3513c25078 "SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table2 ON ( table2.`ACCESS_TIME` = table1.`next_page_no` ) ) WHERE"..., length=394, parser_state=0x7f3535377610) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:5934
|
#17 0x00000000006125ff in dispatch_command (command=COM_QUERY, thd=0x7f35196ae060, packet=0x7f35196b3061 " SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table2 ON ( table2.`ACCESS_TIME` = table1.`next_page_no` ) ) WHER"..., packet_length=396) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:1079
|
#18 0x0000000000611750 in do_command (thd=0x7f35196ae060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:793
|
#19 0x000000000071f906 in do_handle_one_connection (thd_arg=0x7f35196ae060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1270
|
#20 0x000000000071f693 in handle_one_connection (arg=0x7f35196ae060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1186
|
#21 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#22 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#23 0x0000000000000000 in ?? ()
|
Thread 4 (Thread 0x7f353532f700 (LWP 41699)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f351fd899b0, mp=0x7f351fd89900, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f351fd899b0, mutex=0x7f351fd89900) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f351fd89900, reset_sig_count=1554) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=7) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b2161a in rw_lock_x_lock_func (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe51ce0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/ha_innodb.cc", line=8480) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:713
|
#6 0x0000000000ae428d in pfs_rw_lock_x_lock_func (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe51ce0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/ha_innodb.cc", line=8480) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0rw.ic:694
|
#7 0x0000000000aeaa28 in row_mysql_lock_data_dictionary_func (trx=0x7f3512875278, file=0xe51ce0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/ha_innodb.cc", line=8480) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c:1849
|
#8 0x0000000000aba69b in ha_innobase::create (this=0x7f3512adf078, name=0x7f353532c800 "./transforms/insert_select_41698", form=0x7f353532b300, create_info=0x7f353532deb0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/ha_innodb.cc:8480
|
#9 0x00000000007dd71e in handler::ha_create (this=0x7f3512adf078, name=0x7f353532c800 "./transforms/insert_select_41698", form=0x7f353532b300, info=0x7f353532deb0) at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:3755
|
#10 0x00000000007de427 in ha_create_table (thd=0x7f35196b8060, path=0x7f353532c800 "./transforms/insert_select_41698", db=0x7f3512825268 "transforms", table_name=0x7f3512825278 "insert_select_41698", create_info=0x7f353532deb0, update_create_info=false) at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:4084
|
#11 0x00000000006f9d2d in rea_create_table (thd=0x7f35196b8060, path=0x7f353532c800 "./transforms/insert_select_41698", db=0x7f3512825268 "transforms", table_name=0x7f3512825278 "insert_select_41698", create_info=0x7f353532deb0, create_fields=..., keys=0, key_info=0x7f3511ce8cf8, file=0x7f351298d078) at /home/mariadb/git/5.5-mdev10504/sql/unireg.cc:503
|
#12 0x00000000006b6d7e in mysql_create_table_no_lock (thd=0x7f35196b8060, db=0x7f3512825268 "transforms", table_name=0x7f3512825278 "insert_select_41698", create_info=0x7f353532deb0, alter_info=0x7f353532de10, internal_tmp_table=false, select_field_count=15, is_trans=0x0) at /home/mariadb/git/5.5-mdev10504/sql/sql_table.cc:4527
|
#13 0x00000000005ffe7f in create_table_from_items (thd=0x7f35196b8060, create_info=0x7f353532deb0, create_table=0x7f35128252d0, alter_info=0x7f353532de10, items=0x7f35196bbb88, lock=0x7f353532d8c8, hooks=0x7f353532d900) at /home/mariadb/git/5.5-mdev10504/sql/sql_insert.cc:3940
|
#14 0x00000000006004f8 in select_create::prepare (this=0x7f3512826728, values=..., u=0x7f35196bb390) at /home/mariadb/git/5.5-mdev10504/sql/sql_insert.cc:4103
|
#15 0x0000000000646411 in JOIN::prepare (this=0x7f3512826800, rref_pointer_array=0x7f35196bbce0, tables_init=0x7f3512825a10, wild_num=1, conds_init=0x7f3512826358, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f35196bba70, unit_arg=0x7f35196bb390) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:904
|
#16 0x000000000064e179 in mysql_select (thd=0x7f35196b8060, rref_pointer_array=0x7f35196bbce0, tables=0x7f3512825a10, wild_num=1, fields=..., conds=0x7f3512826358, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416216832, result=0x7f3512826728, unit=0x7f35196bb390, select_lex=0x7f35196bba70) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:3074
|
#17 0x0000000000644787 in handle_select (thd=0x7f35196b8060, lex=0x7f35196bb2e0, result=0x7f3512826728, setup_tables_done_option=0) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:319
|
#18 0x0000000000616055 in mysql_execute_command (thd=0x7f35196b8060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:2622
|
#19 0x000000000061f316 in mysql_parse (thd=0x7f35196b8060, rawbuf=0x7f3512825078 "CREATE TABLE transforms.insert_select_41698 SELECT * FROM test.`CC` AS table1 WHERE NOT table1.`col_int_nokey` = 'hx' LIMIT 1 /* QUERY_NO 4230 CON_ID 11 */ /* QUERY_NO 4242 CON_ID 11 */", length=187, parser_state=0x7f353532e610) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:5934
|
#20 0x00000000006125ff in dispatch_command (command=COM_QUERY, thd=0x7f35196b8060, packet=0x7f35196bd061 "CREATE TABLE transforms.insert_select_41698 SELECT * FROM test.`CC` AS table1 WHERE NOT table1.`col_int_nokey` = 'hx' LIMIT 1 /* QUERY_NO 4230 CON_ID 11 */ /* QUERY_NO 4242 CON_ID 11 */ ", packet_length=188) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:1079
|
#21 0x0000000000611750 in do_command (thd=0x7f35196b8060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:793
|
#22 0x000000000071f906 in do_handle_one_connection (thd_arg=0x7f35196b8060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1270
|
#23 0x000000000071f693 in handle_one_connection (arg=0x7f35196b8060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1186
|
#24 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#25 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#26 0x0000000000000000 in ?? ()
|
Thread 3 (Thread 0x7f35352e6700 (LWP 41701)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f351fd899b0, mp=0x7f351fd89900, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f351fd899b0, mutex=0x7f351fd89900) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f351fd89900, reset_sig_count=1554) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=4) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b2161a in rw_lock_x_lock_func (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0rw.c:713
|
#6 0x0000000000ae428d in pfs_rw_lock_x_lock_func (lock=0x1d5eb60 <dict_operation_lock>, pass=0, file_name=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0rw.ic:694
|
#7 0x0000000000aeaa28 in row_mysql_lock_data_dictionary_func (trx=0x7f3512479a78, file=0xe60658 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c", line=3295) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c:1849
|
#8 0x0000000000aed3e6 in row_drop_table_for_mysql (name=0x7f35352e3210 "transforms/insert_select_41700", trx=0x7f3512479a78, drop_db=0, create_failed=0) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/row/row0mysql.c:3295
|
#9 0x0000000000abb08d in ha_innobase::delete_table (this=0x7f35125d0078, name=0x7f35352e4940 "./transforms/insert_select_41700") at /home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/ha_innodb.cc:8777
|
#10 0x00000000007dd698 in handler::ha_delete_table (this=0x7f35125d0078, name=0x7f35352e4940 "./transforms/insert_select_41700") at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:3723
|
#11 0x00000000007da586 in ha_delete_table (thd=0x7f35196c2060, table_type=0x7f3532cfee60, path=0x7f35352e4940 "./transforms/insert_select_41700", db=0x7f3512425178 "transforms", alias=0x7f3512425188 "insert_select_41700", generate_warning=true) at /home/mariadb/git/5.5-mdev10504/sql/handler.cc:2154
|
#12 0x00000000006b0906 in mysql_rm_table_no_locks (thd=0x7f35196c2060, tables=0x7f35124251e0, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false) at /home/mariadb/git/5.5-mdev10504/sql/sql_table.cc:2313
|
#13 0x00000000006afc53 in mysql_rm_table (thd=0x7f35196c2060, tables=0x7f35124251e0, if_exists=0 '\000', drop_temporary=0 '\000') at /home/mariadb/git/5.5-mdev10504/sql/sql_table.cc:1953
|
#14 0x0000000000617a24 in mysql_execute_command (thd=0x7f35196c2060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:3177
|
#15 0x000000000061f316 in mysql_parse (thd=0x7f35196c2060, rawbuf=0x7f3512425078 "DROP TABLE transforms.insert_select_41700 /* QUERY_NO 3831 CON_ID 12 */", length=71, parser_state=0x7f35352e5610) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:5934
|
#16 0x00000000006125ff in dispatch_command (command=COM_QUERY, thd=0x7f35196c2060, packet=0x7f35196c7061 "DROP TABLE transforms.insert_select_41700 /* QUERY_NO 3831 CON_ID 12 */ ", packet_length=72) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:1079
|
#17 0x0000000000611750 in do_command (thd=0x7f35196c2060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:793
|
#18 0x000000000071f906 in do_handle_one_connection (thd_arg=0x7f35196c2060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1270
|
#19 0x000000000071f693 in handle_one_connection (arg=0x7f35196c2060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1186
|
#20 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#21 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#22 0x0000000000000000 in ?? ()
|
Thread 2 (Thread 0x7f3533749700 (LWP 41977)):
|
#0 0x00007f35343bcd84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#1 0x0000000000cfea3f in safe_cond_wait (cond=0x7f3528e995b0, mp=0x7f3528e99500, file=0xeaa7b0 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c", line=207) at /home/mariadb/git/5.5-mdev10504/mysys/thr_mutex.c:493
|
#2 0x0000000000c4a026 in os_cond_wait (cond=0x7f3528e995b0, mutex=0x7f3528e99500) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:207
|
#3 0x0000000000c4a83d in os_event_wait_low (event=0x7f3528e99500, reset_sig_count=10) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/os/os0sync.c:609
|
#4 0x0000000000b1f390 in sync_array_wait_event (arr=0x7f3532ce72c0, index=8) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0arr.c:459
|
#5 0x0000000000b225c4 in mutex_spin_wait (mutex=0x7f3528f2f078, file_name=0xe5b678 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/i_s.cc", line=6666) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/sync/sync0sync.c:639
|
#6 0x0000000000ac904a in mutex_enter_func (mutex=0x7f3528f2f078, file_name=0xe5b678 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/i_s.cc", line=6666) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0sync.ic:219
|
#7 0x0000000000ac9110 in pfs_mutex_enter_func (mutex=0x7f3528f2f078, file_name=0xe5b678 "/home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/i_s.cc", line=6666) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/include/sync0sync.ic:248
|
#8 0x0000000000ad4a1a in i_s_innodb_buffer_pool_pages_blob_fill (thd=0x7f35196f3060, tables=0x7f352947ac38, cond=0x7f3529483a38) at /home/mariadb/git/5.5-mdev10504/storage/xtradb/handler/i_s.cc:6666
|
#9 0x00000000006a573f in get_schema_tables_result (join=0x7f35294b30c0, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/mariadb/git/5.5-mdev10504/sql/sql_show.cc:7792
|
#10 0x000000000064b7ab in JOIN::exec (this=0x7f35294b30c0) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:2360
|
#11 0x000000000064e22f in mysql_select (thd=0x7f35196f3060, rref_pointer_array=0x7f35196f6ce0, tables=0x7f352947ac38, wild_num=1, fields=..., conds=0x7f3529483bb0, og_num=1, order=0x7f3529483d60, group=0x0, having=0x0, proc_param=0x0, select_options=2684652288, result=0x7f35294b30a0, unit=0x7f35196f6390, select_lex=0x7f35196f6a70) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:3094
|
#12 0x0000000000644787 in handle_select (thd=0x7f35196f3060, lex=0x7f35196f62e0, result=0x7f35294b30a0, setup_tables_done_option=0) at /home/mariadb/git/5.5-mdev10504/sql/sql_select.cc:319
|
#13 0x000000000061c5b9 in execute_sqlcom_select (thd=0x7f35196f3060, all_tables=0x7f352947ac38) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:4689
|
#14 0x0000000000615176 in mysql_execute_command (thd=0x7f35196f3060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:2234
|
#15 0x000000000061f316 in mysql_parse (thd=0x7f35196f3060, rawbuf=0x7f352947a078 "/* GenTest::Transform::OrderBy */ SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table2 ON ( table2.`ACCESS_TIME"..., length=395, parser_state=0x7f3533748610) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:5934
|
#16 0x00000000006125ff in dispatch_command (command=COM_QUERY, thd=0x7f35196f3060, packet=0x7f35196fd061 "/* GenTest::Transform::OrderBy */ SELECT * FROM (INFORMATION_SCHEMA.`INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 INNER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table2 ON ( table2.`ACCESS_TIME"..., packet_length=396) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:1079
|
#17 0x0000000000611750 in do_command (thd=0x7f35196f3060) at /home/mariadb/git/5.5-mdev10504/sql/sql_parse.cc:793
|
#18 0x000000000071f906 in do_handle_one_connection (thd_arg=0x7f35196f3060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1270
|
#19 0x000000000071f693 in handle_one_connection (arg=0x7f35196f3060) at /home/mariadb/git/5.5-mdev10504/sql/sql_connect.cc:1186
|
#20 0x00007f35343b8e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#21 0x00007f3533ae5cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
#22 0x0000000000000000 in ?? ()
|
|
RQG command line |
perl ./runall.pl --threads=4 --queries=100M --mtr-build-thread=50 --duration=600 --querytimeout=600 --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --mysqld=--sql-mode=ONLY_FULL_GROUP_BY --mysqld=--lock-wait-timeout=120 --validators=TransformerNoComparator --transformers=DisableOptimizations,EnableOptimizations,ExecuteAsInsertSelect,ExecuteAsSelectItem,NullIf,OrderBy,StraightJoin --grammar=conf/runtime/information_schema.yy \
|
--basedir=<basedir> --vardir=<vardir>
|
Attachments
Activity
svoj was right, it turns out to be unrelated to his patch that I initially suspected. I've finally reproduced it on 5.5.50 as well, not sure why I previously had so much more luck on recent builds.
Thus, it's not an immediate regression, I'm reducing the priority back to normal.
It might be related to INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB though, as said in the comment above. So far I don't have a record of an occurrence that proves otherwise.
Still reproducible on the current 5.5 (as of 2e8fa1c2b286). The setup on perro is still in place.
I'm keeping fix version as 5.5 for now because it's reproducible there. If you decide to fix it only in later versions, please change the field accordingly.
Can't reproduce on any current 10.x.
As it appears from previous comments, it was ever only reproducible on 5.5. Given the involvement of an InnoDB I_S table and radical changes in InnoDB since 5.5, there is no point in trying to bisect.
Maybe it has something to do with i_s_innodb_buffer_pool_pages_blob_fill. I have another hanging server (modified sources, but based on the current 5.5 tree), where it hangs with literally one active user connection:
[Thread debugging using libthread_db enabled]Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".0x00007f33468b3d3d in poll () at ../sysdeps/unix/syscall-template.S:81Thread 21 (Thread 0x7f3345bff700 (LWP 10337)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff060, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=0, message1=0x7f3345bfee90, message2=0x7f3345bfee88, type=0x7f3345bfee80, space_id=0x7f3345bfee78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=0) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa440 <n>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f3345bff700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 20 (Thread 0x7f333a7ff700 (LWP 10338)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff0b0, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=1, message1=0x7f333a7fee90, message2=0x7f333a7fee88, type=0x7f333a7fee80, space_id=0x7f333a7fee78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=1) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa448 <n+8>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f333a7ff700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 19 (Thread 0x7f3339ffe700 (LWP 10339)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff100, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=2, message1=0x7f3339ffde90, message2=0x7f3339ffde88, type=0x7f3339ffde80, space_id=0x7f3339ffde78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=2) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa450 <n+16>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f3339ffe700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 18 (Thread 0x7f33397fd700 (LWP 10340)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff100, segment=1, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=3, message1=0x7f33397fce90, message2=0x7f33397fce88, type=0x7f33397fce80, space_id=0x7f33397fce78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=3) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa458 <n+24>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f33397fd700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 17 (Thread 0x7f3338ffc700 (LWP 10341)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff100, segment=2, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=4, message1=0x7f3338ffbe90, message2=0x7f3338ffbe88, type=0x7f3338ffbe80, space_id=0x7f3338ffbe78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=4) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa460 <n+32>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f3338ffc700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 16 (Thread 0x7f33387fb700 (LWP 10342)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff100, segment=3, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=5, message1=0x7f33387fae90, message2=0x7f33387fae88, type=0x7f33387fae80, space_id=0x7f33387fae78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=5) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa468 <n+40>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f33387fb700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 15 (Thread 0x7f3337ffa700 (LWP 10343)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff150, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=6, message1=0x7f3337ff9e90, message2=0x7f3337ff9e88, type=0x7f3337ff9e80, space_id=0x7f3337ff9e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=6) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa470 <n+48>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f3337ffa700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 14 (Thread 0x7f33377f9700 (LWP 10344)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff150, segment=1, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=7, message1=0x7f33377f8e90, message2=0x7f33377f8e88, type=0x7f33377f8e80, space_id=0x7f33377f8e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=7) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa478 <n+56>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f33377f9700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 13 (Thread 0x7f3336ff8700 (LWP 10345)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff150, segment=2, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=8, message1=0x7f3336ff7e90, message2=0x7f3336ff7e88, type=0x7f3336ff7e80, space_id=0x7f3336ff7e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=8) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa480 <n+64>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f3336ff8700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 12 (Thread 0x7f33367f7700 (LWP 10346)):#0 0x00007f3347c2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1#1 0x0000000000ad62da in os_aio_linux_collect (array=0x7f3345fff150, segment=3, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4749#2 0x0000000000ad66cc in os_aio_linux_handle (global_seg=9, message1=0x7f33367f6e90, message2=0x7f33367f6e88, type=0x7f33367f6e80, space_id=0x7f33367f6e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4895#3 0x0000000000a780a3 in fil_aio_wait (segment=9) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5697#4 0x00000000009aea50 in io_handler_thread (arg=0x14fa488 <n+72>) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497#5 0x00007f3347e390a4 in start_thread (arg=0x7f33367f7700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 11 (Thread 0x7f3334fff700 (LWP 10348)):#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238#1 0x0000000000cb0e86 in safe_cond_timedwait (cond=0x7f334497c9b0, mp=0x7f334497c900, abstime=0x7f3334ffee40, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547#2 0x0000000000ad86d2 in os_cond_wait_timed (cond=0x7f334497c9b0, mutex=0x7f334497c900, abstime=0x7f3334ffee40) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171#3 0x0000000000ad91a0 in os_event_wait_time_low (event=0x7f334497c900, time_in_usec=1000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716#4 0x00000000009aa8d5 in srv_lock_timeout_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2823#5 0x00007f3347e390a4 in start_thread (arg=0x7f3334fff700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 10 (Thread 0x7f33347fe700 (LWP 10349)):#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185#1 0x0000000000cb0bb3 in safe_cond_wait (cond=0x7f3345de4ab0, mp=0x7f3345de4a00, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=207) at /data/src/5.5-bug/mysys/thr_mutex.c:493#2 0x0000000000ad87cd in os_cond_wait (cond=0x7f3345de4ab0, mutex=0x7f3345de4a00) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:207#3 0x0000000000ad8fe2 in os_event_wait_low (event=0x7f3345de4a00, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:609#4 0x00000000009b3155 in sync_array_wait_event (arr=0x7f3345dec2c0, index=3) at /data/src/5.5-bug/storage/xtradb/sync/sync0arr.c:459#5 0x00000000009b6397 in mutex_spin_wait (mutex=0x1d06440 <srv_innodb_monitor_mutex>, file_name=0xdf71a8 "/data/src/5.5-bug/storage/xtradb/srv/srv0srv.c", line=2043) at /data/src/5.5-bug/storage/xtradb/sync/sync0sync.c:639#6 0x00000000009a5acb in mutex_enter_func (mutex=0x1d06440 <srv_innodb_monitor_mutex>, file_name=0xdf71a8 "/data/src/5.5-bug/storage/xtradb/srv/srv0srv.c", line=2043) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:219#7 0x00000000009a5b8f in pfs_mutex_enter_func (mutex=0x1d06440 <srv_innodb_monitor_mutex>, file_name=0xdf71a8 "/data/src/5.5-bug/storage/xtradb/srv/srv0srv.c", line=2043) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:248#8 0x00000000009a8a63 in srv_refresh_innodb_monitor_stats () at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2043#9 0x00000000009aabd4 in srv_error_monitor_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2964#10 0x00007f3347e390a4 in start_thread (arg=0x7f33347fe700) at pthread_create.c:309#11 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 9 (Thread 0x7f3333ffd700 (LWP 10350)):#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185#1 0x0000000000cb0bb3 in safe_cond_wait (cond=0x7f33444bb3b0, mp=0x7f33444bb300, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=207) at /data/src/5.5-bug/mysys/thr_mutex.c:493#2 0x0000000000ad87cd in os_cond_wait (cond=0x7f33444bb3b0, mutex=0x7f33444bb300) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:207#3 0x0000000000ad8fe2 in os_event_wait_low (event=0x7f33444bb300, reset_sig_count=3) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:609#4 0x00000000009b3155 in sync_array_wait_event (arr=0x7f3345dec2c0, index=2) at /data/src/5.5-bug/storage/xtradb/sync/sync0arr.c:459#5 0x00000000009b6397 in mutex_spin_wait (mutex=0x7f3345c48878, file_name=0xe0d378 "/data/src/5.5-bug/storage/xtradb/buf/buf0buf.c", line=4984) at /data/src/5.5-bug/storage/xtradb/sync/sync0sync.c:639#6 0x0000000000a15892 in mutex_enter_func (mutex=0x7f3345c48878, file_name=0xe0d378 "/data/src/5.5-bug/storage/xtradb/buf/buf0buf.c", line=4984) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:219#7 0x0000000000a15956 in pfs_mutex_enter_func (mutex=0x7f3345c48878, file_name=0xe0d378 "/data/src/5.5-bug/storage/xtradb/buf/buf0buf.c", line=4984) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:248#8 0x0000000000a23fc7 in buf_stats_get_pool_info (buf_pool=0x7f3345c48878, pool_id=0, all_pool_info=0x7f3332834238) at /data/src/5.5-bug/storage/xtradb/buf/buf0buf.c:4984#9 0x0000000000a24a8e in buf_print_io (file=0x7f3345c4e700) at /data/src/5.5-bug/storage/xtradb/buf/buf0buf.c:5218#10 0x00000000009a9461 in srv_printf_innodb_monitor (file=0x7f3345c4e700, nowait=1, trx_start=0x0, trx_end=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2260#11 0x00000000009aa5f9 in srv_monitor_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2709#12 0x00007f3347e390a4 in start_thread (arg=0x7f3333ffd700) at pthread_create.c:309#13 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 8 (Thread 0x7f33337fc700 (LWP 10351)):#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238#1 0x0000000000cb0e86 in safe_cond_timedwait (cond=0x7f334497ccb0, mp=0x7f334497cc00, abstime=0x7f33337fbe70, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547#2 0x0000000000ad86d2 in os_cond_wait_timed (cond=0x7f334497ccb0, mutex=0x7f334497cc00, abstime=0x7f33337fbe70) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171#3 0x0000000000ad91a0 in os_event_wait_time_low (event=0x7f334497cc00, time_in_usec=5000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716#4 0x00000000009aaeb9 in srv_LRU_dump_restore_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:3083#5 0x00007f3347e390a4 in start_thread (arg=0x7f33337fc700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 7 (Thread 0x7f3331fff700 (LWP 10352)):#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185#1 0x0000000000cb0bb3 in safe_cond_wait (cond=0x7f33444bb3b0, mp=0x7f33444bb300, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=207) at /data/src/5.5-bug/mysys/thr_mutex.c:493#2 0x0000000000ad87cd in os_cond_wait (cond=0x7f33444bb3b0, mutex=0x7f33444bb300) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:207#3 0x0000000000ad8fe2 in os_event_wait_low (event=0x7f33444bb300, reset_sig_count=3) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:609#4 0x00000000009b3155 in sync_array_wait_event (arr=0x7f3345dec2c0, index=0) at /data/src/5.5-bug/storage/xtradb/sync/sync0arr.c:459#5 0x00000000009b6397 in mutex_spin_wait (mutex=0x7f3345c48878, file_name=0xe100c0 "/data/src/5.5-bug/storage/xtradb/buf/buf0flu.c", line=1311) at /data/src/5.5-bug/storage/xtradb/sync/sync0sync.c:639#6 0x0000000000a25159 in mutex_enter_func (mutex=0x7f3345c48878, file_name=0xe100c0 "/data/src/5.5-bug/storage/xtradb/buf/buf0flu.c", line=1311) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:219#7 0x0000000000a2521d in pfs_mutex_enter_func (mutex=0x7f3345c48878, file_name=0xe100c0 "/data/src/5.5-bug/storage/xtradb/buf/buf0flu.c", line=1311) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:248#8 0x0000000000a29a88 in buf_flush_page (buf_pool=0x7f3345c48878, bpage=0x7f333c292cc0, flush_type=BUF_FLUSH_LIST) at /data/src/5.5-bug/storage/xtradb/buf/buf0flu.c:1311#9 0x0000000000a2a07a in buf_flush_try_neighbors (space=0, offset=2752, flush_type=BUF_FLUSH_LIST, n_flushed=56, n_to_flush=200) at /data/src/5.5-bug/storage/xtradb/buf/buf0flu.c:1541#10 0x0000000000a2a3c6 in buf_flush_page_and_try_neighbors (bpage=0x7f333c293380, flush_type=BUF_FLUSH_LIST, n_to_flush=200, count=0x7f3331ffe658) at /data/src/5.5-bug/storage/xtradb/buf/buf0flu.c:1638#11 0x0000000000a2a797 in buf_flush_flush_list_batch (buf_pool=0x7f3345c48878, min_n=200, lsn_limit=18446744073709551615) at /data/src/5.5-bug/storage/xtradb/buf/buf0flu.c:1768#12 0x0000000000a2a89c in buf_flush_batch (buf_pool=0x7f3345c48878, flush_type=BUF_FLUSH_LIST, min_n=200, lsn_limit=18446744073709551615) at /data/src/5.5-bug/storage/xtradb/buf/buf0flu.c:1848#13 0x0000000000a2ad9a in buf_flush_list (min_n=200, lsn_limit=18446744073709551615) at /data/src/5.5-bug/storage/xtradb/buf/buf0flu.c:2065#14 0x00000000009acdc8 in srv_master_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:3997#15 0x00007f3347e390a4 in start_thread (arg=0x7f3331fff700) at pthread_create.c:309#16 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 6 (Thread 0x7f33317fe700 (LWP 10353)):#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185#1 0x0000000000cb0bb3 in safe_cond_wait (cond=0x7f3345de4cb0, mp=0x7f3345de4c00, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=207) at /data/src/5.5-bug/mysys/thr_mutex.c:493#2 0x0000000000ad87cd in os_cond_wait (cond=0x7f3345de4cb0, mutex=0x7f3345de4c00) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:207#3 0x0000000000ad8fe2 in os_event_wait_low (event=0x7f3345de4c00, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:609#4 0x00000000009ad26b in srv_purge_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:4183#5 0x00007f3347e390a4 in start_thread (arg=0x7f33317fe700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 5 (Thread 0x7f3327fff700 (LWP 10354)):#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238#1 0x0000000000cb0e86 in safe_cond_timedwait (cond=0x1d005c0 <COND_checkpoint>, mp=0x1d00500 <LOCK_checkpoint>, abstime=0x7f3327ffee30, file=0xe55a10 "/data/src/5.5-bug/storage/maria/ma_servicethread.c", line=116) at /data/src/5.5-bug/mysys/thr_mutex.c:547#2 0x0000000000b827a8 in inline_mysql_cond_timedwait (that=0x1d005c0 <COND_checkpoint>, mutex=0x1d00500 <LOCK_checkpoint>, abstime=0x7f3327ffee30, src_file=0xe55a10 "/data/src/5.5-bug/storage/maria/ma_servicethread.c", src_line=116) at /data/src/5.5-bug/include/mysql/psi/mysql_thread.h:1017#3 0x0000000000b82ca1 in my_service_thread_sleep (control=0x139d900 <checkpoint_control>, sleep_time=30000000000) at /data/src/5.5-bug/storage/maria/ma_servicethread.c:115#4 0x0000000000b773c3 in ma_checkpoint_background (arg=0x1e) at /data/src/5.5-bug/storage/maria/ma_checkpoint.c:704#5 0x00007f3347e390a4 in start_thread (arg=0x7f3327fff700) at pthread_create.c:309#6 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 4 (Thread 0x7f334822a700 (LWP 10355)):#0 do_sigwait (set=<optimized out>, sig=0x7f3348229ec8) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63#1 0x00007f3347e40693 in __sigwait (set=0x7f3348229e30, sig=0x0) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:97#2 0x0000000000554f8c in signal_hand (arg=0x0) at /data/src/5.5-bug/sql/mysqld.cc:3056#3 0x00007f3347e390a4 in start_thread (arg=0x7f334822a700) at pthread_create.c:309#4 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 3 (Thread 0x7f33481e1700 (LWP 10357)):#0 0x00007f3347e3fadd in read () at ../sysdeps/unix/syscall-template.S:81#1 0x0000000000cee6aa in vio_read (vio=0x7f3345c543e0, buf=0x7f3335bd6060 "\a", size=4) at /data/src/5.5-bug/vio/viosocket.c:72#2 0x000000000055f0c5 in my_real_read (net=0x7f333b7e3370, complen=0x7f33481e0d80) at /data/src/5.5-bug/sql/net_serv.cc:840#3 0x000000000055f728 in my_net_read (net=0x7f333b7e3370) at /data/src/5.5-bug/sql/net_serv.cc:1026#4 0x00000000005fbad8 in do_command (thd=0x7f333b7e3060) at /data/src/5.5-bug/sql/sql_parse.cc:739#5 0x00000000006fdf0f in do_handle_one_connection (thd_arg=0x7f333b7e3060) at /data/src/5.5-bug/sql/sql_connect.cc:1270#6 0x00000000006fdc9c in handle_one_connection (arg=0x7f333b7e3060) at /data/src/5.5-bug/sql/sql_connect.cc:1186#7 0x00007f3347e390a4 in start_thread (arg=0x7f33481e1700) at pthread_create.c:309#8 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 2 (Thread 0x7f3348198700 (LWP 10369)):#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185#1 0x0000000000cb0bb3 in safe_cond_wait (cond=0x7f333b9856b0, mp=0x7f333b985600, file=0xe361a8 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=207) at /data/src/5.5-bug/mysys/thr_mutex.c:493#2 0x0000000000ad87cd in os_cond_wait (cond=0x7f333b9856b0, mutex=0x7f333b985600) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:207#3 0x0000000000ad8fe2 in os_event_wait_low (event=0x7f333b985600, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:609#4 0x00000000009b3155 in sync_array_wait_event (arr=0x7f3345dec2c0, index=1) at /data/src/5.5-bug/storage/xtradb/sync/sync0arr.c:459#5 0x00000000009b6397 in mutex_spin_wait (mutex=0x7f333c292d98, file_name=0xde8f08 "/data/src/5.5-bug/storage/xtradb/include/buf0buf.ic", line=376) at /data/src/5.5-bug/storage/xtradb/sync/sync0sync.c:639#6 0x000000000095e996 in mutex_enter_func (mutex=0x7f333c292d98, file_name=0xde8f08 "/data/src/5.5-bug/storage/xtradb/include/buf0buf.ic", line=376) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:219#7 0x000000000095ea5c in pfs_mutex_enter_func (mutex=0x7f333c292d98, file_name=0xde8f08 "/data/src/5.5-bug/storage/xtradb/include/buf0buf.ic", line=376) at /data/src/5.5-bug/storage/xtradb/include/sync0sync.ic:248#8 0x000000000095f6c1 in buf_page_get_mutex_enter (bpage=0x7f333c292cc0) at /data/src/5.5-bug/storage/xtradb/include/buf0buf.ic:376#9 0x0000000000969eb3 in i_s_innodb_buffer_pool_pages_blob_fill (thd=0x7f3335bdb060, tables=0x7f332593a3f0, cond=0x0) at /data/src/5.5-bug/storage/xtradb/handler/i_s.cc:6670#10 0x000000000068a784 in get_schema_tables_result (join=0x7f332593b498, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/5.5-bug/sql/sql_show.cc:7792#11 0x0000000000633c95 in JOIN::exec (this=0x7f332593b498) at /data/src/5.5-bug/sql/sql_select.cc:2360#12 0x00000000006364b8 in mysql_select (thd=0x7f3335bdb060, rref_pointer_array=0x7f3335bdece0, tables=0x7f332593a3f0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f332593b478, unit=0x7f3335bde390, select_lex=0x7f3335bdea70) at /data/src/5.5-bug/sql/sql_select.cc:3094#13 0x000000000062cd9e in handle_select (thd=0x7f3335bdb060, lex=0x7f3335bde2e0, result=0x7f332593b478, setup_tables_done_option=0) at /data/src/5.5-bug/sql/sql_select.cc:319#14 0x000000000060620b in execute_sqlcom_select (thd=0x7f3335bdb060, all_tables=0x7f332593a3f0) at /data/src/5.5-bug/sql/sql_parse.cc:4689#15 0x00000000005ff55c in mysql_execute_command (thd=0x7f3335bdb060) at /data/src/5.5-bug/sql/sql_parse.cc:2234#16 0x0000000000608dd6 in mysql_parse (thd=0x7f3335bdb060, rawbuf=0x7f332593a078 "SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB", length=69, parser_state=0x7f33481976a0) at /data/src/5.5-bug/sql/sql_parse.cc:5934#17 0x00000000005fcaeb in dispatch_command (command=COM_QUERY, thd=0x7f3335bdb060, packet=0x7f3335be0061 "SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB", packet_length=69) at /data/src/5.5-bug/sql/sql_parse.cc:1079#18 0x00000000005fbca5 in do_command (thd=0x7f3335bdb060) at /data/src/5.5-bug/sql/sql_parse.cc:793#19 0x00000000006fdf0f in do_handle_one_connection (thd_arg=0x7f3335bdb060) at /data/src/5.5-bug/sql/sql_connect.cc:1270#20 0x00000000006fdc9c in handle_one_connection (arg=0x7f3335bdb060) at /data/src/5.5-bug/sql/sql_connect.cc:1186#21 0x00007f3347e390a4 in start_thread (arg=0x7f3348198700) at pthread_create.c:309#22 0x00007f33468bc87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111Thread 1 (Thread 0x7f3348249780 (LWP 10335)):#0 0x00007f33468b3d3d in poll () at ../sysdeps/unix/syscall-template.S:81#1 0x0000000000558e97 in handle_connections_sockets () at /data/src/5.5-bug/sql/mysqld.cc:5614#2 0x0000000000558274 in mysqld_main (argc=43, argv=0x7f3345c4d3b0) at /data/src/5.5-bug/sql/mysqld.cc:5063#3 0x0000000000550426 in main (argc=43, argv=0x7ffdc697f9a8) at /data/src/5.5-bug/sql/main.cc:25