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

Bug #1384632 reported by Ramesh Sivaraman on 2014-10-23
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Unassigned
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
High
Unassigned

Bug Description

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

tags: added: qa
Ramesh Sivaraman (rameshvs02) wrote :

Core, GDB, error log etc

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

Ramesh Sivaraman (rameshvs02) wrote :

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

description: updated
Ramesh Sivaraman (rameshvs02) wrote :

******* 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;

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) wrote :

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.

tags: added: upstream
Roel Van de Paar (roel11) wrote :

Upstream bug was fixed.

Roel Van de Paar (roel11) wrote :

Fixed in MS 5.6.27, 5.7.9, 5.8.0

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

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

Other bug subscribers

Related blueprints

Remote bug watches

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