Percona XtraDB Cluster - HA scalable solution for MySQL

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

Reported by Alex Yurchenko on 2013-09-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Undecided
Unassigned
Percona XtraDB Cluster
Status tracked in Trunk
5.6
Undecided
Unassigned
Trunk
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>}

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

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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers