Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27511

Assertion `rgi->gtid_ev_flags_extra & Gtid_log_event::FL_COMMIT_ALTER_E1' failed in write_bin_log_start_alter

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • None
    • N/A
    • Replication
    • None

    Description

      --source include/have_log_bin.inc
      --source include/have_innodb.inc
      --source include/master-slave.inc
       
      --connection master
       
      CREATE  TABLE t1 (a1 int, d1 int DEFAULT 0);
      INSERT INTO t1 VALUES  (1,1) ;
      set binlog_alter_two_phase=YES;
      ALTER  TABLE t1  WAIT 9 RENAME COLUMN a1 TO a2;
      set  binlog_alter_two_phase=NO;
      ALTER  TABLE t1  ALTER COLUMN d1 DROP DEFAULT;
      --sync_slave_with_master
       
      # Cleanup
      --connection master
      drop table t1;
      --sync_slave_with_master
      --source include/rpl_end.inc
      

      /10.8/sql/log.cc:688: bool write_bin_log_start_alter(THD*, bool&, uint64, bool): Assertion `rgi->gtid_ev_flags_extra & Gtid_log_event::FL_COMMIT_ALTER_E1' failed.
      220114 15:08:50 [ERROR] mysqld got signal 6 ;
       
      sql/log.cc:691(write_bin_log_start_alter(THD*, bool&, unsigned long long, bool))[0x55f559c4a460]
      sql/sql_table.cc:7524(mysql_inplace_alter_table(THD*, TABLE_LIST*, TABLE*, TABLE*, Alter_inplace_info*, MDL_request*, st_ddl_log_state*, TRIGGER_RENAME_PARAM*, Alter_table_ctx*, bool&, unsigned long long&, bool))[0x55f559333121]
      sql/sql_table.cc:10617(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool, bool))[0x55f559349f41]
      sql/sql_alter.cc:543(Sql_cmd_alter_table::execute(THD*))[0x55f55950977b]
      sql/sql_parse.cc:5989(mysql_execute_command(THD*, bool))[0x55f559067161]
      sql/sql_parse.cc:8028(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55f559074987]
      sql/log_event_server.cc:2148(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x55f559cdf138]
      sql/log_event_server.cc:1613(Query_log_event::do_apply_event(rpl_group_info*))[0x55f559cda9eb]
      sql/log_event.h:1518(Log_event::apply_event(rpl_group_info*))[0x55f558dd85b7]
      sql/slave.cc:3881(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x55f558db9954]
      sql/slave.cc:4047(apply_event_and_update_pos(Log_event*, THD*, rpl_group_info*))[0x55f558dba56c]
      sql/slave.cc:4417(exec_relay_log_event(THD*, Relay_log_info*, rpl_group_info*))[0x55f558dbc276]
      sql/slave.cc:5594(handle_slave_sql)[0x55f558dc3e48]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55f55a19b701]
      nptl/pthread_create.c:478(start_thread)[0x7f29e3b06609]
      ??:0(clone)[0x7f29e36d9293]
       
      Query (0x612000083f53): ALTER  TABLE t1  ALTER COLUMN d1 DROP DEFAULT
      

      Attachments

        Activity

          People

            alice Alice Sherepa
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.