Comment 2 for bug 1274336

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: INSERT INTO SELECT | Crash with debug build and PFS | storage/perfschema/pfs.cc:4527: PSI_statement_locker* refine_statement_v1(PSI_statement_locker*, PSI_statement_key): Assertion `klass->is_mutable()' failed

Releavant backtrace (from full bt):

#0 0x00007fa2856128ac in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000aed3ce in my_write_core (sig=6) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/mysys/stacktrace.c:422
#2 0x0000000000754a1d in handle_fatal_signal (sig=6) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/signal_handler.cc:254
#3 <signal handler called>
#4 0x00007fa283c75925 in raise () from /lib64/libc.so.6
#5 0x00007fa283c77105 in abort () from /lib64/libc.so.6
#6 0x00007fa283c6ea4e in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007fa283c6eb10 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000b43618 in refine_statement_v1 (locker=0x49bf588, key=7) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/storage/perfschema/pfs.cc:4527
#9 0x000000000080428d in inline_mysql_refine_statement (locker=0x49bf588, key=7) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/include/mysql/psi/mysql_statement.h:172
#10 0x0000000000817e4c in mysql_parse (thd=0x49bda20, rawbuf=0x7fa1b0004c30 "INSERT IGNORE INTO testdb.sbtest89910 SELECT * FROM sbtest89", length=60, parser_state=0x7fa2581b2720) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/sql_parse.cc:7139
#11 0x00000000008174e0 in wsrep_mysql_parse (thd=0x49bda20, rawbuf=0x7fa1b0004c30 "INSERT IGNORE INTO testdb.sbtest89910 SELECT * FROM sbtest89", length=60, parser_state=0x7fa2581b2720) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/sql_parse.cc:6940
#12 0x000000000080854d in dispatch_command (command=COM_QUERY, thd=0x49bda20, packet=0x49c20c1 "INSERT IGNORE INTO testdb.sbtest89910 SELECT * FROM sbtest89", packet_length=60) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/sql_parse.cc:1630
#13 0x0000000000806dd7 in do_command (thd=0x49bda20) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/sql_parse.cc:1133
#14 0x00000000007cd8a1 in do_handle_one_connection (thd_arg=0x49bda20) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/sql_connect.cc:1557
#15 0x00000000007cd388 in handle_one_connection (arg=0x49bda20) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/sql/sql_connect.cc:1461
#16 0x0000000000b3e1bb in pfs_spawn_thread (arg=0x48cb130) at /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.15/storage/perfschema/pfs.cc:1858
#17 0x00007fa28560d9d1 in start_thread () from /lib64/libpthread.so.0
#18 0x00007fa283d2bb6d in clone () from /lib64/libc.so.6