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

ERRORS: Invalid default value for 'check_time', DDL_LOG: Got error 1062 ... for entry 1 of type 'rename table', 1146: Table 'mysql.spider_table_sts' doesn't exist, ER_TABLE_EXISTS_ERROR and Got error 12524 'unknown' from SPIDER on RENAME/DROP TABLE

Details

    Description

      The bug is highly sporadic, and there are likely a number of extraneous clauses in the testcase which are not necessary to reproduce the bug. Currently repeating the testcase about 500-1000 times, using the CLI, with a fresh server start for each t/c loop, reproduces the issue.

      SET sql_mode='traditional', max_heap_table_size=1048576;
      		 
      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      		 
      SET GLOBAL sql_mode=(SELECT CONCAT (@@sql_mode,',pipes_as_concat'));
      		 
      CREATE TABLE t2 (pk INT(1) NOT NULL,c_int_nokey INT(1),c_intk INT(1),cvck CHAR(1),cvc_nokey VARCHAR(1),PRIMARY KEY(pk),KEY c_intk (c_intk),KEY cvck (cvck,c_intk)) ENGINE=Spider AUTO_INCREMENT=+ 1 DEFAULT CHARSET=latin1;
      		 
      CREATE TABLE t (i1 INT NOT NULL,a INT,PRIMARY KEY(i1)) ENGINE=Spider;
      		 
      ALTER TABLE t2 ENGINE=InnoDB;
      		 
      DROP TABLE t;
      		 
      DROP TABLE t,t2,t3,t4;
      		 
      CREATE TABLE t3 (c INT,c2 CHAR(1)) ENCRYPTION="Y" ENGINE=Spider;
      		 
      RENAME TABLE t TO t2;

      Leads to:

      11.1.0 2b61ff8f2221745f0a96855a0feb0825c426f993 (Debug)

      		 
      2023-04-22 15:37:10 0 [Note] /test/MD010423-mariadb-11.1.0-linux-x86_64-dbg/bin/mariadbd: ready for connections.
      		 
      Version: '11.1.0-MariaDB-debug'  socket: '/test/MD010423-mariadb-11.1.0-linux-x86_64-dbg/socket.sock'  port: 10910  MariaDB Server
      		 
      [ERROR] Invalid default value for 'check_time'
      		 
      2023-04-22 15:37:10 4 [ERROR] DDL_LOG: Got error 1062 when trying to execute action for entry 1 of type 'rename table'

      Further attempts to improve the test setup (MTR vs CLI), testcase length and reproducibility still in progress. Currently observed in 11.1 only, but likely present in other versions.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34660 DDL_LOG: Got error 1032 when trying to execute action for entry 1/2/4 of type 'rename table' upon RENAME TABLE

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33196 [ERROR] Got error 12524 when reading table './test/t'

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              Roel Roel Van de Paar
              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.