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

RBR aborts with ER_SLAVE_CONVERSION_FAILED, Internal MariaDB error code: 1677 upon INSERT DELAYED inside trx

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 11.0(EOL), 11.3(EOL)
    • 10.5, 10.6, 10.11, 11.2
    • Replication
    • None

    Description

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      SET autocommit=0;
       
      CREATE TABLE t1 (c1 INT);
       
      --error ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SQL_LOG_BIN
      CALL sys.statement_performance_analyzer('OVERALL', NULL, 'with_full_table_scans');
       
      DROP TABLES t1;
      CREATE TABLE t1 (c1 VARCHAR(64), PRIMARY KEY(c1)) ENGINE=MyISAM;
      INSERT DELAYED t1 VALUES (1);
       
      --sync_slave_with_master
      --source include/rpl_end.inc
      

      Leads to:

      11.4.0 8bf9f21855606ddeb0fe90fb1e70165adbec6746 (Debug)

      2024-02-03 13:30:37 6 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16000',replication starts at GTID position ''
      2024-02-03 13:30:37 7 [ERROR] Slave SQL: Column 0 of table 'test.t1' cannot be converted from type 'varchar(64 octets)' to type 'int(11)', Gtid 0-1-2, Internal MariaDB error code: 1677
      2024-02-03 13:30:37 7 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 485; GTID position '0-1-1'
      2024-02-03 13:30:37 7 [Note] Slave SQL thread exiting, replication stopped in log 'master-bin.000001' at position 485; GTID position '0-1-1', master: 127.0.0.1:16000
      

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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