Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno | sig 6 in sql/sql_error.h:655

[Ramesh Sivaraman]

mysqld: /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_error.h:655: uint Diagnostics_area
::sql_errno() const: Assertion `m_status == DA_ERROR' failed.
01:37:57 UTC - mysqld got signal 6 ;

** Asserting query

SELECT COUNT(*) FROM information_schema.key_column_usage WHERE REFERENCED_TABLE_NAME in ('t1', 't2')

** GDB info

#0 0x00007ff91213b771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007ff910d3f5c9 in raise () from /lib64/libc.so.6
#5 0x00007ff910d40cd8 in abort () from /lib64/libc.so.6
#6 0x00007ff910d38536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007ff910d385e2 in __assert_fail () from /lib64/libc.so.6
#8 0x000000000064f02c in Diagnostics_area::sql_errno (this=0x2b84e30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_error.h:655
#9 0x000000000063f5f5 in ha_rollback_low (thd=0x2b81620, all=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:1639
#10 0x0000000000719a67 in TC_LOG_DUMMY::rollback (this=0x1875fa0 <tc_log_dummy>, thd=0x2b81620, all=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/log.h:138
#11 0x000000000063f759 in ha_rollback_trans (thd=0x2b81620, all=true) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:1690
#12 0x00000000008b740e in trans_rollback_implicit (thd=0x2b81620) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/transaction.cc:372
#13 0x00000000007ea27a in mysql_execute_command (thd=0x2b81620) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:5522
#14 0x00000000007ed193 in mysql_parse (thd=0x2b81620, rawbuf=0x7ff8b82d42e0 "SELECT COUNT(*) FROM information_schema.key_column_usage WHERE REFERENCED_TABLE_NAME in ('t1', 't2')", length=100, parser_state=0x7ff8f4566e30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#15 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2b81620, packet=0x3380261 "", packet_length=101) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#16 0x00000000007de528 in do_command (thd=0x2b81620) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#17 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x2b81620) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#18 0x00000000007a5fed in handle_one_connection (arg=0x2b81620) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#19 0x0000000000dc5bac in pfs_spawn_thread (arg=0x333d890) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#20 0x00007ff912136df3 in start_thread () from /lib64/libpthread.so.0
#21 0x00007ff910e0001d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

Core, GDB, error log etc

There was no master (single threaded, single mysqld run)

[Ramesh Sivaraman (rameshvs02)]

s/There was no master (single threaded, single mysqld run)/Single threaded run, single mysqld involved/

[Ramesh Sivaraman (rameshvs02)]

******* Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 INT NOT NULL,c2 CHAR NOT NULL)ENGINE=csv;
CREATE TABLE t3(c1 INT UNSIGNED NOT NULL,c2 INT NULL,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT,index idx(c2,c7));
LOCK TABLES t1 WRITE,t3 WRITE;
INSERT INTO t1 VALUES(0,0);
select get_lock('test3',0);
check table t1 extended;
LOCK TABLES performance_schema.table_io_waits_summary_by_table WRITE;
xa start 'test2';
SELECT COUNT(*)FROM information_schema.key_column_usage;

[Laurynas Biveinis (laurynas-biveinis)]

At line 8: query 'LOCK TABLES performance_schema.table_io_waits_summary_by_table WRITE' failed: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_io_waits_summary_by_table'

[Roel Van de Paar (roel11)]

Not directly reproducible in PS 5.6, but reproducible in MS 5.7. Marked as upstream and leaving as confirmed for PS bug tracking. Please correct if needed.

[Roel Van de Paar (roel11)]

Upstream bug was fixed.

[Roel Van de Paar (roel11)]

Fixed in MS 5.6.27, 5.7.9, 5.8.0

[Roel Van de Paar (roel11)]

Also see;
https://bugs.mysql.com/bug.php?id=76912
https://bugs.mysql.com/bug.php?id=86260
https://bugs.launchpad.net/percona-server/+bug/1689736

[Shahriyar Rzayev (rzayev-sehriyar)]

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