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

Internal MariaDB error code: 1944 on GTT referencing BINLOG command

    XMLWordPrintable

Details

    • Unexpected results

    Description

      CREATE GLOBAL TEMPORARY TABLE t1 (c INT);
      BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC ';
      SET pseudo_slave_mode=1;
      BINLOG 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I + kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu';
      

      Leads to:

      MDEV-35915-v10 CS 12.2.0 2ef81706c8c4782b2f8a45a05ac90377403de2e1 (Optimized, Clang 21.1.3-20250923) Build 31/12/2025

      12.2.0-opt>CREATE GLOBAL TEMPORARY TABLE t1 (c INT);
      Query OK, 0 rows affected (0.006 sec)
       
      12.2.0-opt>BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC ';
      Query OK, 0 rows affected (0.000 sec)
       
      12.2.0-opt>SET pseudo_slave_mode=1;
      Query OK, 0 rows affected, 1 warning (0.000 sec)
       
      12.2.0-opt>binlog 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I + kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu';
      ERROR 1944 (HY000): Failed to open t1.test
      

      And:

      MDEV-35915-v10 CS 12.2.0 2ef81706c8c4782b2f8a45a05ac90377403de2e1 (Optimized, Clang 21.1.3-20250923) Build 31/12/2025

      2026-01-07 15:51:56 4 [ERROR]  BINLOG_BASE64_EVENT: Error executing row event: 'Failed to open t1.test', Internal MariaDB error code: 1944
      

      Testcase is CLI and MTR compatible. MTR will fail with ER_GTID_OPEN_TABLE_FAILED, then check error log (var/log/mysqld.1.err)

      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.