Assertion `klass->m_flags & (1 << 1)' failed in 5.6 branch

Bug #1225236 reported by Alex Yurchenko
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
Undecided
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
Undecided
Unassigned

Bug Description

Backtrace:

#7 0x00007f2b36a02eb2 in __GI___assert_fail (assertion=0x106ff47 "klass->m_flags & (1 << 1)", file=0x106f5f0 "/home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc", line=4527,
    function=0x1070fe0 <refine_statement_v1::__PRETTY_FUNCTION__> "PSI_statement_locker* refine_statement_v1(PSI_statement_locker*, PSI_statement_key)") at assert.c:101
#8 0x0000000000b625cf in refine_statement_v1 (locker=0x3727ba0, key=6) at /home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc:4527
#9 0x00000000007ce0dc in inline_mysql_refine_statement (locker=0x3727ba0, key=6) at /home/ayurchen/codership/mysql/5.6/include/mysql/psi/mysql_statement.h:172
#10 0x00000000007dfc70 in mysql_parse (thd=0x37262a0,
    rawbuf=0x7f2aac026bb0 "INSERT IGNORE INTO comm00 VALUES (0, 1, 1, 1, RAND(), NULL),(1, 1, 1, 1, RAND(), NULL),(2, 1, 1, 1, RAND(), NULL),(3, 1, 1, 1, RAND(), NULL),(4, 1, 1, 1, RAND(), NULL),(5, 1, 1, 1, RAND(), NULL),(6, 1"..., length=88922, parser_state=0x7f2ae5c19690) at /home/ayurchen/codership/mysql/5.6/sql/sql_parse.cc:6716
#11 0x00000000007df3ed in wsrep_mysql_parse (thd=0x37262a0,
    rawbuf=0x7f2aac026bb0 "INSERT IGNORE INTO comm00 VALUES (0, 1, 1, 1, RAND(), NULL),(1, 1, 1, 1, RAND(), NULL),(2, 1, 1, 1, RAND(), NULL),(3, 1, 1, 1, RAND(), NULL),(4, 1, 1, 1, RAND(), NULL),(5, 1, 1, 1, RAND(), NULL),(6, 1"..., length=88922, parser_state=0x7f2ae5c19690) at /home/ayurchen/codership/mysql/5.6/sql/sql_parse.cc:6546
#12 0x00000000007d1719 in dispatch_command (command=COM_QUERY, thd=0x37262a0,
    packet=0x372a861 "INSERT IGNORE INTO comm00 VALUES (0, 1, 1, 1, RAND(), NULL),(1, 1, 1, 1, RAND(), NULL),(2, 1, 1, 1, RAND(), NULL),(3, 1, 1, 1, RAND(), NULL),(4, 1, 1, 1, RAND(), NULL),(5, 1, 1, 1, RAND(), NULL),(6, 1"..., packet_length=88922) at /home/ayurchen/codership/mysql/5.6/sql/sql_parse.cc:1535
#13 0x00000000007d022d in do_command (thd=0x37262a0) at /home/ayurchen/codership/mysql/5.6/sql/sql_parse.cc:1129
#14 0x000000000079925a in do_handle_one_connection (thd_arg=0x372c990) at /home/ayurchen/codership/mysql/5.6/sql/sql_connect.cc:1002
#15 0x0000000000798d44 in handle_one_connection (arg=0x372c990) at /home/ayurchen/codership/mysql/5.6/sql/sql_connect.cc:911
#16 0x0000000000b5d677 in pfs_spawn_thread (arg=0x36a5300) at /home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc:1858
#17 0x00007f2b375c0f8e in start_thread (arg=0x7f2ae5c1b700) at pthread_create.c:311
#18 0x00007f2b36acce1d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
(gdb) f 8
#8 0x0000000000b625cf in refine_statement_v1 (locker=0x3727ba0, key=6) at /home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc:4527
4527 DBUG_ASSERT(klass->m_flags & PSI_FLAG_MUTABLE);
(gdb) p klass->m_flags
$1 = 0
(gdb) p *klass
$2 = {<PFS_instr_class> = {m_type = PFS_CLASS_STATEMENT, m_enabled = true, m_timed = true, m_flags = 0, m_event_name_index = 5, m_name = "statement/sql/insert", '\000' <repeats 107 times>,
    m_name_length = 20, m_timer = 0x14c15cc <statement_timer>}, <No data fields>}

Revision history for this message
Teemu Ollakka (teemu-ollakka) wrote :

Does not reproduce anymore, marking fixed.

Changed in codership-mysql:
milestone: none → 5.6.14-24.1
status: New → Fix Committed
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

I am still seeing

"[12:06:23] Raghavendra Prabhu: "mysqld: /mnt/workspace/build-xtradb-cluster-binaries-56/BUILD_TYPE/debug/label_exp/centos6-64/Percona-XtraDB-Cluster-5.6.14/storage/perfschema/pfs.cc:4527: PSI_statement_locker* refine_statement_v1(PSI_statement_locker*, PSI_statement_key): Assertion `klass->m_flags & (1 << 1)' failed.""

when PFS is enabled.

Changed in codership-mysql:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1438

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.