Bug #76406 Assertion `old_value >= 1' failed. | abort (sig=6) in Gtid_state::end_anonymous_
Submitted: 20 Mar 2015 10:06 Modified: 20 May 2015 16:51
Reporter: Roel Van de Paar (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S6 (Debug Builds)
Version:5.7.6, 5.7.8, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[20 Mar 2015 10:06] Roel Van de Paar
Description:
+bt
#0  0x00007f5f34561771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013a521c in my_write_core (sig=6) at /bzr/mysql-5.7.6-m16_dbg/mysys/stacktrace.c:247
#2  0x0000000000bb713c in handle_fatal_signal (sig=6) at /bzr/mysql-5.7.6-m16_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f5f331655c9 in raise () from /lib64/libc.so.6
#5  0x00007f5f33166cd8 in abort () from /lib64/libc.so.6
#6  0x00007f5f3315e536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f5f3315e5e2 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000012cfc99 in Gtid_state::end_anonymous_gtid_violating_transaction (this=0x7f5f2b3e7a00) at /bzr/mysql-5.7.6-m16_dbg/sql/rpl_gtid.h:2567
#9  0x00000000012cdc1e in Gtid_state::end_gtid_violating_transaction (this=0x7f5f2b3e7a00, thd=0x7f5e9001a000) at /bzr/mysql-5.7.6-m16_dbg/sql/rpl_gtid_state.cc:415
#10 0x00000000012cdb39 in Gtid_state::update_gtids_impl (this=0x7f5f2b3e7a00, thd=0x7f5e9001a000, is_commit=true) at /bzr/mysql-5.7.6-m16_dbg/sql/rpl_gtid_state.cc:394
#11 0x00000000012cd47f in Gtid_state::update_on_commit (this=0x7f5f2b3e7a00, thd=0x7f5e9001a000) at /bzr/mysql-5.7.6-m16_dbg/sql/rpl_gtid_state.cc:148
#12 0x000000000130e0c1 in MYSQL_BIN_LOG::gtid_end_transaction (this=0x2658080 <mysql_bin_log>, thd=0x7f5e9001a000) at /bzr/mysql-5.7.6-m16_dbg/sql/binlog.cc:1249
#13 0x00000000010aaf0a in mysql_parse (thd=0x7f5e9001a000, parser_state=0x7f5f34b58e00) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:5167
#14 0x00000000010a0bd4 in dispatch_command (command=COM_QUERY, thd=0x7f5e9001a000, packet=0x7f5e90046011 "", packet_length=14) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:1249
#15 0x000000000109f925 in do_command (thd=0x7f5e9001a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:835
#16 0x00000000011c2fd9 in handle_connection (arg=0x7f5f2b3f78c0) at /bzr/mysql-5.7.6-m16_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#17 0x00000000013d2299 in pfs_spawn_thread (arg=0x7f5f2c3b2d50) at /bzr/mysql-5.7.6-m16_dbg/storage/perfschema/pfs.cc:2147
#18 0x00007f5f3455cdf3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f5f332261ad in clone () from /lib64/libc.so.6

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
create TABLE t1 SELECT 1 a;
BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
CHECK TABLE t5;
[20 Mar 2015 11:02] Umesh Shastry
Hello Roel,

Thank you for the report.
Confirmed the 5.7.8 debug build is affected.

Thanks,
Umesh
[20 Mar 2015 11:02] Umesh Shastry
// 5.7.8 - debug build affected

commit: 4f39cfb13b465bb1bfcadf88c4740e26ce3c45fa
date: 2015-03-14 06:44:57 +0100
build-date: 2015-03-14 18:00:53 +0100
short: 4f39cfb
branch: mysql-5.7

MySQL source 5.7.8

// start up
bin/mysqld --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76401 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.8/76401/log.err 2>&1 &

[umshastr@hod03]/export/umesh/mysql-5.7.8: bin/mysql -uroot -p -S /tmp/mysql_ushastry.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.8-rc-enterprise-commercial-advanced-debug MySQL Enterprise Server - Advanced Edition Debug (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)] > DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 1 row affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test] > create TABLE t1 SELECT 1 a;
Query OK, 1 row affected (0.02 sec)
Records: 1  Duplicates: 0  Warnings: 0

root@localhost [test] > BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
Query OK, 0 rows affected (0.00 sec)

root@localhost [test] > CHECK TABLE t5;
ERROR 2013 (HY000): Lost connection to MySQL server during query
root@localhost [test] > \q
Bye
[1]+  Aborted                 (core dumped) bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76401 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.8/76401/log.err 2>&1
[umshastr@hod03]/export/umesh/mysql-5.7.8: gdb bin/mysqld-debug 76401/core.20817
GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-51.el7
Copyright (C) 2013 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /export/umesh/mysql-5.7.8/bin/mysqld-debug...done.
Illegal process-id: 76401/core.20817.
[New LWP 20848]
[New LWP 20822]
[New LWP 20820]
[New LWP 20844]
[New LWP 20828]
[New LWP 20829]
[New LWP 20827]
[New LWP 20834]
[New LWP 20841]
[New LWP 20833]
[New LWP 20839]
[New LWP 20817]
[New LWP 20837]
[New LWP 20836]
[New LWP 20835]
[New LWP 20845]
[New LWP 20821]
[New LWP 20823]
[New LWP 20840]
[New LWP 20824]
[New LWP 20819]
[New LWP 20826]
[New LWP 20825]
[New LWP 20838]
[New LWP 20842]
[New LWP 20818]
[New LWP 20846]
[New LWP 20843]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/my'.
Program terminated with signal 6, Aborted.
#0  0x00007f6c304e7771 in pthread_kill () from /lib64/libpthread.so.0
Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64
(gdb) bt
#0  0x00007f6c304e7771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018c1abc in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/mysys/stacktrace.c:247
#2  0x0000000000f48b3a in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f6c2f0ed5c9 in raise () from /lib64/libc.so.6
#5  0x00007f6c2f0eecd8 in abort () from /lib64/libc.so.6
#6  0x00007f6c2f0e6536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f6c2f0e65e2 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000017eca37 in Gtid_state::end_anonymous_gtid_violating_transaction (this=0x4e2d930) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/rpl_gtid.h:2573
#9  0x00000000017ea9d2 in Gtid_state::end_gtid_violating_transaction (this=0x4e2d930, thd=0x7f6ba8000bb0)
    at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/rpl_gtid_state.cc:415
#10 0x00000000017ea8ed in Gtid_state::update_gtids_impl (this=0x4e2d930, thd=0x7f6ba8000bb0, is_commit=true)
    at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/rpl_gtid_state.cc:394
#11 0x00000000017ea233 in Gtid_state::update_on_commit (this=0x4e2d930, thd=0x7f6ba8000bb0)
    at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/rpl_gtid_state.cc:148
#12 0x000000000182bab3 in MYSQL_BIN_LOG::gtid_end_transaction (this=0x2dae300 <mysql_bin_log>, thd=0x7f6ba8000bb0)
    at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/binlog.cc:1260
#13 0x00000000015c3179 in mysql_parse (thd=0x7f6ba8000bb0, parser_state=0x7f6c24d0fe30) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5222
#14 0x00000000015b8cb2 in dispatch_command (command=COM_QUERY, thd=0x7f6ba8000bb0, packet=0x7f6ba8009d61 "", packet_length=14)
    at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1249
#15 0x00000000015b7a12 in do_command (thd=0x7f6ba8000bb0) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:835
#16 0x00000000016dbd41 in handle_connection (arg=0x5c0c4a0) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:298
#17 0x0000000001c69855 in pfs_spawn_thread (arg=0x5b2a0a0) at /export/home3/pb2/build/sb_0-14707619-1426353206.99/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147
#18 0x00007f6c304e2df3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f6c2f1ae47d in clone () from /lib64/libc.so.6
(gdb)
[20 Mar 2015 11:03] Umesh Shastry
// release(opt) build is not affected

[umshastr@hod03]/export/umesh/mysql-5.7.8: bin/mysql -uroot -p -S /tmp/mysql_ushastry.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.8-rc-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)] > DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test] > create TABLE t1 SELECT 1 a;
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

root@localhost [test] > BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
Query OK, 0 rows affected (0.00 sec)

root@localhost [test] > CHECK TABLE t5;
+---------+-------+----------+-------------------------------+
| Table   | Op    | Msg_type | Msg_text                      |
+---------+-------+----------+-------------------------------+
| test.t5 | check | Error    | Table 'test.t5' doesn't exist |
| test.t5 | check | status   | Operation failed              |
+---------+-------+----------+-------------------------------+
2 rows in set (0.00 sec)

root@localhost [test] > \q
Bye
[20 Mar 2015 11:09] Umesh Shastry
// 5.8.0

bin/mysqld --basedir=/export/umesh/mysql-5.8.0 --datadir=/export/umesh/mysql-5.8.0/76406 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.8.0/76406/log.err 2>&1 &

// release build not affected

root@localhost [(none)] > show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.8.0                                                   |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.8.0-m17-enterprise-commercial-advanced                |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | Linux                                                   |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

root@localhost [(none)] > CREATE DATABASE test;USE test;
Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test] > create TABLE t1 SELECT 1 a;
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

root@localhost [test] > BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
Query OK, 0 rows affected (0.00 sec)

root@localhost [test] > CHECK TABLE t5;
+---------+-------+----------+-------------------------------+
| Table   | Op    | Msg_type | Msg_text                      |
+---------+-------+----------+-------------------------------+
| test.t5 | check | Error    | Table 'test.t5' doesn't exist |
| test.t5 | check | status   | Operation failed              |
+---------+-------+----------+-------------------------------+
2 rows in set (0.00 sec)

// debug build - affected

root@localhost [(none)] > show variables like '%version%';
+-------------------------+---------------------------------------------------------------+
| Variable_name           | Value                                                         |
+-------------------------+---------------------------------------------------------------+
| innodb_version          | 5.8.0                                                         |
| protocol_version        | 10                                                            |
| slave_type_conversions  |                                                               |
| version                 | 5.8.0-m17-enterprise-commercial-advanced-debug                |
| version_comment         | MySQL Enterprise Server - Advanced Edition Debug (Commercial) |
| version_compile_machine | x86_64                                                        |
| version_compile_os      | Linux                                                         |
+-------------------------+---------------------------------------------------------------+
7 rows in set (0.00 sec)

root@localhost [(none)] > DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 1 row affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
root@localhost [test] > create TABLE t1 SELECT 1 a;
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

root@localhost [test] > BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
Query OK, 0 rows affected (0.00 sec)

root@localhost [test] > CHECK TABLE t5;
ERROR 2013 (HY000): Lost connection to MySQL server during query

(gdb) bt
#0  0x00007f1cc3099771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018c1074 in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/mysys/stacktrace.c:247
#2  0x0000000000f498db in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/signal_handler.cc:221
#3  <signal handler called>
#4  0x00007f1cc1c9f5c9 in raise () from /lib64/libc.so.6
#5  0x00007f1cc1ca0cd8 in abort () from /lib64/libc.so.6
#6  0x00007f1cc1c98536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f1cc1c985e2 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000017ec0e3 in Gtid_state::end_anonymous_gtid_violating_transaction (this=0x46f4930) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/rpl_gtid.h:2575
#9  0x00000000017ea07e in Gtid_state::end_gtid_violating_transaction (this=0x46f4930, thd=0x7f1c34000bb0)
    at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/rpl_gtid_state.cc:415
#10 0x00000000017e9f99 in Gtid_state::update_gtids_impl (this=0x46f4930, thd=0x7f1c34000bb0, is_commit=true)
    at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/rpl_gtid_state.cc:394
#11 0x00000000017e98df in Gtid_state::update_on_commit (this=0x46f4930, thd=0x7f1c34000bb0)
    at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/rpl_gtid_state.cc:148
#12 0x000000000182b115 in MYSQL_BIN_LOG::gtid_end_transaction (this=0x2da9fc0 <mysql_bin_log>, thd=0x7f1c34000bb0)
    at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/binlog.cc:1264
#13 0x00000000015bee5f in mysql_parse (thd=0x7f1c34000bb0, parser_state=0x7f1cb88c2e30) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:5178
#14 0x00000000015b4a5c in dispatch_command (command=COM_QUERY, thd=0x7f1c34000bb0, packet=0x7f1c34009d61 "", packet_length=14)
    at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:1213
#15 0x00000000015b378a in do_command (thd=0x7f1c34000bb0) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/sql_parse.cc:797
#16 0x00000000016d8819 in handle_connection (arg=0x53943c0) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/sql/conn_handler/connection_handler_per_thread.cc:299
#17 0x0000000001cc0351 in pfs_spawn_thread (arg=0x53c6c30) at /export/home3/pb2/build/sb_0-14707582-1426353127.63/mysqlcom-pro-5.8.0-m17/storage/perfschema/pfs.cc:2147
#18 0x00007f1cc3094df3 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f1cc1d6047d in clone () from /lib64/libc.so.6
(gdb)
[20 Mar 2015 11:14] Umesh Shastry
// 5.6.25 - not affected
// release build - not affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.25                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.25-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> create TABLE t1 SELECT 1 a;
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
Query OK, 0 rows affected (0.00 sec)

mysql> CHECK TABLE t5;
+---------+-------+----------+-------------------------------+
| Table   | Op    | Msg_type | Msg_text                      |
+---------+-------+----------+-------------------------------+
| test.t5 | check | Error    | Table 'test.t5' doesn't exist |
| test.t5 | check | status   | Operation failed              |
+---------+-------+----------+-------------------------------+
2 rows in set (0.00 sec)

// debug build - not affected

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------------+
| Variable_name           | Value                                                         |
+-------------------------+---------------------------------------------------------------+
| innodb_version          | 5.6.25                                                        |
| protocol_version        | 10                                                            |
| slave_type_conversions  |                                                               |
| version                 | 5.6.25-enterprise-commercial-advanced-debug                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition Debug (Commercial) |
| version_compile_machine | x86_64                                                        |
| version_compile_os      | linux-glibc2.5                                                |
+-------------------------+---------------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE test;CREATE DATABASE test;USE test;
Query OK, 1 row affected (0.01 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
mysql> create TABLE t1 SELECT 1 a;
Query OK, 1 row affected (0.01 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
Query OK, 0 rows affected (0.00 sec)

mysql> CHECK TABLE t5;
+---------+-------+----------+-------------------------------+
| Table   | Op    | Msg_type | Msg_text                      |
+---------+-------+----------+-------------------------------+
| test.t5 | check | Error    | Table 'test.t5' doesn't exist |
| test.t5 | check | status   | Operation failed              |
+---------+-------+----------+-------------------------------+
2 rows in set (0.00 sec)
[22 Mar 2015 21:25] Roel Van de Paar
Here is what I noticed;

1) This can happen for various statements. From various crashes;

*) Query (7fe7e9c2c020): repair table t1 quick
*) Query (7fade042c020): DROP FUNCTION IF EXISTS sf1
*) The query above

2) The assertion seems to indicate a "gtid violating transaction". So it looks like there could be many.
mysqld: /bzr/mysql-5.7.6-m16_dbg/sql/rpl_gtid.h:2567: void Gtid_state::end_anonymous_gtid_violating_transaction(): Assertion `old_value >= 1' failed.

Based on the above, this seems a serious bug.
[20 May 2015 16:51] David Moss
Thanks for your feedback. This has been fixed in an upcoming version and the following was noted in the 5.7.8 changelog:

When using GTIDs with log-bin=OFF, a combination of statements which included a BINLOG statement executing a Format_description_log_event would cause an assertion. The reason was that the server would run the routine to handle the end of a GTID violating transaction, which was incorrect because when --log-bin=OFF the transaction should not have been handled as an offending transaction. The fix ensures that before the compatibility testing, the state of log_bin is checked. If log_bin=OFF, then the compatibility checks are skipped. This makes the server not activate flags that would then trigger the incorrect run of the routine to handle GTID violating transactions that ultimately resulted in an assertion.
[18 Jun 2016 21:25] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0