Bug #90640 `head->variables.gtid_next.type != UNDEFINED_GTID'

Submitted: 26 Apr 2018 4:20 Modified: 16 Oct 2018 11:28
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: debug build

[26 Apr 2018 4:20] Roel Van de Paar
Description:
mysqld: /git/mysql-server_dbg/sql/binlog.cc:1343: bool MYSQL_BIN_LOG::assign_automatic_gtids_to_flush_group(THD*): Assertion `head->variables.gtid_next.type != UNDEFINED_GTID' failed.
03:24:14 UTC - mysqld got signal 6 ;

(gdb) bt
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1  0x000055f0ed8744a5 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.cc:278
#2  0x000055f0ec5fb18c in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:249
#3  <signal handler called>
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5  0x00007fec2b3d4801 in __GI_abort () at abort.c:79
#6  0x00007fec2b3c439a in __assert_fail_base (fmt=0x7fec2b54b7d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
    assertion=assertion@entry=0x55f0eece0a70 "head->variables.gtid_next.type != UNDEFINED_GTID", 
    file=file@entry=0x55f0eece04b8 "/git/mysql-server_dbg/sql/binlog.cc", line=line@entry=1343, 
    function=function@entry=0x55f0eece5360 <MYSQL_BIN_LOG::assign_automatic_gtids_to_flush_group(THD*)::__PRETTY_FUNCTION__> "bool MYSQL_BIN_LOG::assign_automatic_gtids_to_flush_group(THD*)") at assert.c:92
#7  0x00007fec2b3c4412 in __GI___assert_fail (assertion=0x55f0eece0a70 "head->variables.gtid_next.type != UNDEFINED_GTID", 
    file=0x55f0eece04b8 "/git/mysql-server_dbg/sql/binlog.cc", line=1343, 
    function=0x55f0eece5360 <MYSQL_BIN_LOG::assign_automatic_gtids_to_flush_group(THD*)::__PRETTY_FUNCTION__> "bool MYSQL_BIN_LOG::assign_automatic_gtids_to_flush_group(THD*)") at assert.c:101
#8  0x000055f0ed489a77 in MYSQL_BIN_LOG::assign_automatic_gtids_to_flush_group (this=0x55f0efedf6c0 <mysql_bin_log>, first_seen=
    0x7febfd823000) at /git/mysql-server_dbg/sql/binlog.cc:1343
#9  0x000055f0ed4a1a08 in MYSQL_BIN_LOG::process_flush_stage_queue (this=0x55f0efedf6c0 <mysql_bin_log>, 
    total_bytes_var=0x7fec2b38fbf0, rotate_var=0x7fec2b38fbe2, out_queue_var=0x7fec2b38fbf8)
    at /git/mysql-server_dbg/sql/binlog.cc:8196
#10 0x000055f0ed4a31e5 in MYSQL_BIN_LOG::ordered_commit (this=0x55f0efedf6c0 <mysql_bin_log>, thd=0x7febfd823000, all=true, 
    skip_commit=false) at /git/mysql-server_dbg/sql/binlog.cc:8759
#11 0x000055f0ed4a1661 in MYSQL_BIN_LOG::commit (this=0x55f0efedf6c0 <mysql_bin_log>, thd=0x7febfd823000, all=true)
    at /git/mysql-server_dbg/sql/binlog.cc:8104
#12 0x000055f0ec773219 in ha_commit_trans (thd=0x7febfd823000, all=true, ignore_global_read_lock=false)
    at /git/mysql-server_dbg/sql/handler.cc:1684
#13 0x000055f0ec5a6fc4 in trans_commit (thd=0x7febfd823000, ignore_global_read_lock=false)
    at /git/mysql-server_dbg/sql/transaction.cc:251
#14 0x000055f0ec563c61 in fix_autocommit (self=0x55f0efeb74c0 <Sys_autocommit>, thd=0x7febfd823000, type=OPT_SESSION)
    at /git/mysql-server_dbg/sql/sys_vars.cc:4506
#15 0x000055f0ec380c23 in sys_var::update (this=0x55f0efeb74c0 <Sys_autocommit>, thd=0x7febfd823000, var=0x7febe0875aa8)
    at /git/mysql-server_dbg/sql/set_var.cc:259
#16 0x000055f0ec381317 in sys_var::set_default (this=0x55f0efeb74c0 <Sys_autocommit>, thd=0x7febfd823000, var=0x7febe0875aa8)
    at /git/mysql-server_dbg/sql/set_var.cc:344
#17 0x000055f0ec383284 in set_var::update (this=0x7febe0875aa8, thd=0x7febfd823000) at /git/mysql-server_dbg/sql/set_var.cc:1008
#18 0x000055f0ec382681 in sql_set_variables (thd=0x7febfd823000, var_list=0x7febfd828a80, opened=true)
    at /git/mysql-server_dbg/sql/set_var.cc:771
#19 0x000055f0ec45949f in mysql_execute_command (thd=0x7febfd823000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3268
#20 0x000055f0ec45ebb2 in mysql_parse (thd=0x7febfd823000, parser_state=0x7fec2b392330) at /git/mysql-server_dbg/sql/sql_parse.cc:4935
#21 0x000055f0ec454713 in dispatch_command (thd=0x7febfd823000, com_data=0x7fec2b392c90, command=COM_QUERY)
    at /git/mysql-server_dbg/sql/sql_parse.cc:1589
#22 0x000055f0ec452fee in do_command (thd=0x7febfd823000) at /git/mysql-server_dbg/sql/sql_parse.cc:1214
#23 0x000055f0ec5e8a70 in handle_connection (arg=0x7febdfc6e420)
    at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:308
#24 0x000055f0edf08cf8 in pfs_spawn_thread (arg=0x7fec1efe7820) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2814
#25 0x00007fec2cdbe6db in start_thread (arg=0x7fec2b393700) at pthread_create.c:463
#26 0x00007fec2b4b588f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

How to repeat:
# mysqld options required for replay:  --binlog_format=STATEMENT
SOURCE file.sql  # Attached
[26 Apr 2018 4:24] Roel Van de Paar
file.sql

Attachment: file.sql (application/sql, text), 332 bytes.

[26 Apr 2018 4:51] MySQL Verification Team
Hello Roel,

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

Thanks,
Umesh
[27 Apr 2018 11:21] Erlend Dahl
Posted by developer:
 
The problem actually reproduces on 5.7 if you turn on binlogging (which is default on in 8.0): --log-bin=1. It doesn't reproduce on 5.6 though.
[16 Oct 2018 11:28] Margaret Fisher
Posted by developer:
 
Changelog entry added for MySQL 5.7.25 and 8.0.14:

An assertion was raised in debug builds if an XA ROLLBACK statement was issued for an unknown transaction identifier when the gtid_next value had been set manually. The server now does not attempt to update the GTID state if an XA ROLLBACK statement fails with an error.
[21 Dec 2018 12:15] Margaret Fisher
Posted by developer:
 
Test case fix, no change needed to existing changelog entry.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.058 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.