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

DDL_LOG: Got error 1032 when trying to execute action for entry 1/2 of type 'rename table' upon RENAME TABLE

    XMLWordPrintable

Details

    Description

      DROP DATABASE test;
      CREATE DATABASE test;
      USE test;
      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      CREATE TABLE t1 (c INT) ENGINE=Spider;
      CREATE TABLE t2 (c INT) ENGINE=Spider;
      RENAME TABLE t2 TO doesnotexist.t;
      

      Leads to:

      11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug)

      11.2.5-dbg>RENAME TABLE t2 TO doesnotexist.t;
      ERROR 1049 (42000): Unknown database 'doesnotexist'
      

      In the client. However, in the error log we see:

      11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug)

      2024-07-29 10:11:18 4 [ERROR] mariadbd: Can't find record in 'spider_tables'
      2024-07-29 10:11:18 4 [ERROR] DDL_LOG: Got error 1032 when trying to execute action for entry 2 of type 'rename table'
      

      Removing either the DROP/CREATE/USE test db, or the t1 table creation changes the output to:

      11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug)

      2024-07-29 10:14:54 4 [ERROR] mariadbd: Can't find record in 'spider_tables'
      2024-07-29 10:14:54 4 [ERROR] DDL_LOG: Got error 1032 when trying to execute action for entry 1 of type 'rename table'
      

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              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.