Bug #80670 Assertion `thd->variables.gtid_next.type == AUTOMATIC_GROUP' failed
Submitted: 9 Mar 2016 9:16 Modified: 9 Mar 2016 9:48
Reporter: Ramesh Sivaraman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.7.11 OS:CentOS
Assigned to: CPU Architecture:Any
Tags: debug

[9 Mar 2016 9:16] Ramesh Sivaraman
Description:
Error info :

Version: '5.7.11-debug-log'  socket: '/dev/shm/1457512173/socket.sock'  port: 37256  MySQL Community Server (GPL)
mysqld: /sda/ps57/mysql-server_dbg/sql/rpl_gtid_state.cc:378: void Gtid_state::update_gtids_impl(THD*, bool): Assertion `thd->variables.gtid_next.type == AUTOMATIC_GROUP' failed.

GDB info

#0  0x00007f4f8ca2a771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000180fa8c in my_write_core (sig=6) at /sda/ps57/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000e6af64 in handle_fatal_signal (sig=6) at /sda/ps57/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f4f8abb65c9 in raise () from /lib64/libc.so.6
#5  0x00007f4f8abb7cd8 in abort () from /lib64/libc.so.6
#6  0x00007f4f8abaf536 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f4f8abaf5e2 in __assert_fail () from /lib64/libc.so.6
#8  0x000000000173415d in Gtid_state::update_gtids_impl (this=0x7f4f813cb400, thd=0x7f4f33c19000, is_commit=false) at /sda/ps57/mysql-server_dbg/sql/rpl_gtid_state.cc:378
#9  0x0000000001733bc1 in Gtid_state::update_on_rollback (this=0x7f4f813cb400, thd=0x7f4f33c19000) at /sda/ps57/mysql-server_dbg/sql/rpl_gtid_state.cc:177
#10 0x0000000001460150 in close_temporary_tables (thd=0x7f4f33c19000) at /sda/ps57/mysql-server_dbg/sql/sql_base.cc:1808
#11 0x0000000001748b66 in Start_log_event_v3::do_apply_event (this=0x7f4f33d31260, rli=0x7f4f33c7a000) at /sda/ps57/mysql-server_dbg/sql/log_event.cc:5136
#12 0x000000000174983c in Format_description_log_event::do_apply_event (this=0x7f4f33d31220, rli=0x7f4f33c7a000) at /sda/ps57/mysql-server_dbg/sql/log_event.cc:5377
#13 0x0000000001743318 in Log_event::apply_event (this=0x7f4f33d31260, rli=0x7f4f33c7a000) at /sda/ps57/mysql-server_dbg/sql/log_event.cc:3324
#14 0x0000000001791377 in mysql_client_binlog_statement (thd=0x7f4f33c19000) at /sda/ps57/mysql-server_dbg/sql/sql_binlog.cc:275
#15 0x00000000014ec1fb in mysql_execute_command (thd=0x7f4f33c19000, first_level=true) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:4765
#16 0x00000000014ee081 in mysql_parse (thd=0x7f4f33c19000, parser_state=0x7f4f8d020560) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:5518
#17 0x00000000014e393b in dispatch_command (thd=0x7f4f33c19000, com_data=0x7f4f8d020cb0, command=COM_QUERY) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:1428
#18 0x00000000014e2805 in do_command (thd=0x7f4f33c19000) at /sda/ps57/mysql-server_dbg/sql/sql_parse.cc:996
#19 0x000000000160ecc7 in handle_connection (arg=0x7f4f587fe960) at /sda/ps57/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#20 0x0000000001845888 in pfs_spawn_thread (arg=0x7f4f583f4120) at /sda/ps57/mysql-server_dbg/storage/perfschema/pfs.cc:2192
#21 0x00007f4f8ca25df3 in start_thread () from /lib64/libpthread.so.0
#22 0x00007f4f8ac771ad in clone () from /lib64/libc.so.6

How to repeat:
Testcase

Startup options : --server-id=100 --log-bin=binlog

DROP DATABASE test;CREATE DATABASE test;USE test;
SET SESSION AUTOCOMMIT=0;
create temporary table t1(f1 int);
BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
[9 Mar 2016 9:48] MySQL Verification Team
Hello Ramesh,

Thank you for the report and test case.
Observed that 5.7.11 debug build is affected.

Thanks,
Umesh