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

Slave SQL thread halts with 1944 error upon INSERT ... DELAYED

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      --source include/master-slave.inc
      CREATE GLOBAL TEMPORARY TABLE t (c INT) ON COMMIT DELETE ROWS;
      SET sql_log_bin=0;
      DROP TABLE t;
      CREATE TABLE t (c INT);
      INSERT DELAYED INTO t VALUES (0);
      --sync_slave_with_master
      DROP TABLE t;
      --source include/rpl_end.inc
      

      Leads to:

      MDEV-35915-v11 CS 12.2.0 8934bac9ea05b79f7a5109d9e980cb939a24d4e3 (Optimized, Clang 21.1.3-20250923) Build 19/01/2026

      mysqltest: At line 7: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 705, 300, '')' returned NULL indicating slave SQL thread failure
      ...
      Slave_IO_Running	Yes
      Slave_SQL_Running	No
      

      When DELAYED is removed from the testcase, the test succeeds.

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.