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

  1. Series 5.6
  2. Bug #1581949
  3. Comment #7

Comment 7 for bug 1581949

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Re: Reproducible Percona Server 5.6 by selecting data from GLOBAL_TEMPORARY_TABLES when Temporary Tables are created

full stack #2 crash must be due to I_S query catching Thread 26 at a wrong time

Thread 26 (Thread 0x7f09f47f5700 (LWP 115689)):
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
#1 0x00007f09f42c84ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
#2 0x00007f09f42c8468 in __GI___pthread_mutex_lock (mutex=0x7ef1be3db0e0) at ../nptl/pthread_mutex_lock.c:134
#3 0x000000000067b077 in inline_mysql_mutex_lock (src_line=2194, src_file=0xb812a0 "/mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sql_base.cc", that=0x7ef1be3db0e0) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/include/mysql/psi/mysql_thread.h:688
#4 close_temporary_table (thd=thd@entry=0x7ef1be3db000, table=table@entry=0x7ef1bfceec00, free_share=free_share@entry=true, delete_table=delete_table@entry=true) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sql_base.cc:2194
#5 0x000000000067b12f in drop_temporary_table (thd=thd@entry=0x7ef1be3db000, table_list=table_list@entry=0x7ef1bffeb2a0, is_trans=is_trans@entry=0x7f09f47f1072) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sql_base.cc:2177
#6 0x000000000071af22 in mysql_rm_table_no_locks (thd=thd@entry=0x7ef1be3db000, tables=tables@entry=0x7ef1bffeb2a0, if_exists=true, drop_temporary=false, drop_view=drop_view@entry=false, dont_log_query=dont_log_query@entry=false) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sql_table.cc:2387
#7 0x000000000071c32e in mysql_rm_table (thd=thd@entry=0x7ef1be3db000, tables=tables@entry=0x7ef1bffeb2a0, if_exists=<optimized out>, drop_temporary=<optimized out>) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sql_table.cc:2224
#8 0x00000000006c64c8 in mysql_execute_command (thd=thd@entry=0x7ef1be3db000) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sql_parse.cc:4105
#9 0x00000000007e9d13 in sp_instr_stmt::exec_core (this=0x7ef1bffe3ad8, thd=0x7ef1be3db000, nextp=0x7f09f47f2384) at /mnt/workspace/percona-server-5.6-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.6-5.6.29-76.2/sql/sp_instr.cc:953
...