Assertion `pfs_thread->m_events_statements_count == 0' failed in 5.6 branch

[Alex Yurchenko]

Running standard sqlgen load gave:

mysqld: /home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc:3331: PSI_idle_locker* start_idle_wait_v1(PSI_idle_locker_state*, const char*, uint): Assertion `pfs_thread->m_events_statements_count == 0' failed.

backtrace:
#7 0x00007f209e832eb2 in __GI___assert_fail (assertion=0x106ef60 "pfs_thread->m_events_statements_count == 0", file=0x106e730 "/home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc",
    line=3331, function=0x10705e0 <start_idle_wait_v1::__PRETTY_FUNCTION__> "PSI_idle_locker* start_idle_wait_v1(PSI_idle_locker_state*, const char*, uint)") at assert.c:101
#8 0x0000000000b5f5ee in start_idle_wait_v1 (state=0x2be56f0, src_file=0xe53f28 "/home/ayurchen/codership/mysql/5.6/sql/mysqld.cc", src_line=925)
    at /home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc:3331
#9 0x000000000060cbbd in inline_mysql_start_idle_wait (state=0x2be56f0, src_file=0xe53f28 "/home/ayurchen/codership/mysql/5.6/sql/mysqld.cc", src_line=925)
    at /home/ayurchen/codership/mysql/5.6/include/mysql/psi/mysql_idle.h:73
#10 0x000000000060d416 in net_before_header_psi (net=0x2be3a80, user_data=0x2be3870) at /home/ayurchen/codership/mysql/5.6/sql/mysqld.cc:925
#11 0x0000000000719555 in net_read_packet_header (net=0x2be3a80) at /home/ayurchen/codership/mysql/5.6/sql/net_serv.cc:744
#12 0x0000000000719665 in net_read_packet (net=0x2be3a80, complen=0x7f204559dd10) at /home/ayurchen/codership/mysql/5.6/sql/net_serv.cc:810
#13 0x00000000007197fb in my_net_read (net=0x2be3a80) at /home/ayurchen/codership/mysql/5.6/sql/net_serv.cc:888
#14 0x00000000007cf41b in do_command (thd=0x2be3870) at /home/ayurchen/codership/mysql/5.6/sql/sql_parse.cc:1001
#15 0x0000000000798936 in do_handle_one_connection (thd_arg=0x2be3870) at /home/ayurchen/codership/mysql/5.6/sql/sql_connect.cc:1002
#16 0x0000000000798420 in handle_one_connection (arg=0x2be3870) at /home/ayurchen/codership/mysql/5.6/sql/sql_connect.cc:911
#17 0x0000000000b5c993 in pfs_spawn_thread (arg=0x2b3e290) at /home/ayurchen/codership/mysql/5.6/storage/perfschema/pfs.cc:1858
#18 0x00007f209f3f0f8e in start_thread (arg=0x7f204559e700) at pthread_create.c:311
#19 0x00007f209e8fce1d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

[Teemu Ollakka (teemu-ollakka)]

Fix pushed: http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/3980

[Shahriyar Rzayev (rzayev-sehriyar)]

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