Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1113388
  2. Comment #12

Comment 12 for bug 1113388

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Re: field.cc:3822: virtual longlong Field_long::val_int(): Assertion `table->in_use == _current_thd()' failed | Failure on concurrent ALTER TABLE and SELECT from I_S

Thread 45 (LWP 26461):
+bt
#0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000a50fe3 in os_cond_wait (fast_mutex=0x3836360, cond=0x38363a0) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/os/os0sync.cc:214
#2 os_event_wait_low (event=0x3836360, reset_sig_count=165) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/os/os0sync.cc:610
#3 0x0000000000aee651 in sync_array_wait_event (arr=0x32204a0, index=4) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/sync/sync0arr.cc:424
#4 0x0000000000af2e3c in mutex_spin_wait (mutex=0x3836268, file_name=0xda5e28 "/bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc", line=4705) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/sync/sync0sync.cc:583
#5 0x00000000009e75bb in mutex_enter_func (line=4705, file_name=0xda5e28 "/bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc", mutex=0x3836268) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/include/sync0sync.ic:220
#6 pfs_mutex_enter_func (line=4705, file_name=0xda5e28 "/bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc", mutex=0x3836268) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/include/sync0sync.ic:251
#7 innobase_build_index_translation (share=0x7f8f68073f20, ib_table=0x7f8f680651d8, table=0x7f8f680776d0) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc:4705
#8 ha_innobase::open (this=0x7f8f7c087d70, name=0x7f9000ec5b90 "./test/#sql-63a4_20#P#p0", mode=<optimized out>, test_if_locked=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc:5183
#9 0x00000000005b547a in handler::ha_open (this=0x7f8f7c087d70, table_arg=0x7f8f680776d0, name=0x7f9000ec5b90 "./test/#sql-63a4_20#P#p0", mode=7, test_if_locked=2) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/handler.cc:2473
#10 0x00000000005b7671 in handler::clone (this=0x7f8f6807d390, name=0x7f9000ec5b90 "./test/#sql-63a4_20#P#p0", mem_root=0x3a2f1b8) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/handler.cc:2389
#11 0x00000000009d8d8e in ha_innobase::clone (this=0x7f8f6807d390, name=0x7f9000ec5b90 "./test/#sql-63a4_20#P#p0", mem_root=0x3a2f1b8) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/innobase/handler/ha_innodb.cc:5352
#12 0x0000000000c4b3b7 in ha_partition::open (this=0x7f8f680589d8, name=0x7f8f680782d0 "./test/#sql-63a4_20", mode=1745284816, test_if_locked=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/ha_partition.cc:3243
#13 0x00000000005b547a in handler::ha_open (this=0x7f8f680589d8, table_arg=0x7f8f680776d0, name=0x7f8f680782d0 "./test/#sql-63a4_20", mode=7, test_if_locked=1026) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/handler.cc:2473
#14 0x0000000000c469e8 in ha_partition::clone (this=0x7f8f6807cd20, name=0x7f8f680782d0 "./test/#sql-63a4_20", mem_root=0x3a2f1b8) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/ha_partition.cc:3412
#15 0x00000000007485ad in store_temporary_table_record (thd=0x3a2bbb0, table=0x7f8f7c07d0c0, tmp_table=0x7f8f680776d0, db=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_show.cc:3950
#16 0x0000000000757959 in fill_global_temporary_tables (thd=0x392c830, tables=0x7f8f7c004ec8, cond=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_show.cc:4035
#17 0x000000000074c1b4 in do_fill_table (join_table=<optimized out>, table_list=0x7f8f7c004ec8, thd=0x392c830) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_show.cc:7684
#18 get_schema_tables_result (join=0x7f8f7c0062c8, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_show.cc:7785
#19 0x0000000000739de5 in JOIN::prepare_result (this=0x7f8f7c0062c8, columns_list=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_select.cc:823
#20 0x00000000006f2171 in JOIN::exec (this=0x7f8f7c0062c8) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_executor.cc:116
#21 0x000000000073c800 in mysql_execute_select (free_join=true, select_lex=0x392f2f8, thd=0x392c830) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_select.cc:1101
#22 mysql_select (thd=0x392c830, tables=0x7f8f7c004ec8, wild_num=1, fields=..., conds=0x0, order=<optimized out>, group=0x392f3f8, having=0x0, select_options=2684619520, result=0x7f8f7c0062a0, unit=0x392ecb0, select_lex=0x392f2f8) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_select.cc:1222
#23 0x000000000073d2c3 in handle_select (thd=0x392c830, result=0x7f8f7c0062a0, setup_tables_done_option=0) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_select.cc:111
#24 0x0000000000712fad in execute_sqlcom_select (thd=0x392c830, all_tables=0x7f8f7c004ec8) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:5280
#25 0x0000000000716cc0 in mysql_execute_command (thd=0x392c830) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:2749
#26 0x000000000071b8b8 in mysql_parse (thd=0x392c830, rawbuf=0x392ebe8 "p\234\065\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:6451
#27 0x000000000071c923 in dispatch_command (command=COM_QUERY, thd=0x392c830, packet=0x3930191 "SELECT * FROM INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES", packet_length=56) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:1376
#28 0x000000000071d86b in do_command (thd=0x392c830) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_parse.cc:1051
#29 0x00000000006e261f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_connect.cc:1615
#30 0x00000000006e2707 in handle_one_connection (arg=0x392c830) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/sql/sql_connect.cc:1526
#31 0x00000000009beb49 in pfs_spawn_thread (arg=0x394a940) at /bzr/5.6_dbg/Percona-Server-5.6.11-rc60.3/storage/perfschema/pfs.cc:1853
#32 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0
#33 0x0000003fddee890d in clone () from /lib64/libc.so.6