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

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CoR for Spider table, DDL_LOG: Got error 1032 or 12524 when trying to execute action for entry 1/2/3/4/5/6/7 of type 'rename table'

Details

    Description

      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      		 
      CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET'',DATABASE'',USER'',PASSWORD 'PWD0');
      		 
      CREATE TABLE t (a INT KEY AUTO_INCREMENT) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';
      		 
      ALTER TABLE t ADD b TEXT;
      		 
      CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;

      Leads to:

      bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Optimized)

      		 
      10.11.0-opt>CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;
      		 
      ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY'

      bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Optimized)

      		 
      2022-10-15 16:40:29 25 [Warning] Access denied for user ''@'localhost' (using password: YES)
      		 
      2022-10-15 16:40:29 4 [ERROR] mysqld: Can't find record in 'spider_tables'
      		 
      2022-10-15 16:40:29 4 [ERROR] DDL_LOG: Got error 1032 when trying to execute action for entry 6 of type 'rename table'

      Before MDEV-25292 it passes.

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25292 Atomic CREATE OR REPLACE TABLE

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29583 Disallow Spider self/dual/multi/cross-referencing tables, consider not executing/skipping/disabling init_connect for Spider user

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            		2d 1h 58m 1
            Aleksey Midenkov made transition -
            In Progress Stalled
            		28m 21s 1
            Alexey Botchkov made transition -
            Stalled In Progress
            		7d 4m 1
            Alexey Botchkov made transition -
            In Progress In Review
            		1d 4h 37m 1
            Nayuta Yanagisawa (Inactive) made transition -
            In Review Stalled
            		17h 32m 1
            Alexey Botchkov made transition -
            Stalled Closed
            		4h 18m 1
            Sergei Golubchik made transition -
            Closed Stalled
            		1d 5h 32m 1
            Roel Van de Paar made transition -
            Stalled Open
            		85d 7h 26m 1
            Roel Van de Paar made transition -
            Open Confirmed
            		4s 1
            Aleksey Midenkov made transition -
            Confirmed In Progress
            		4d 12h 10m 1
            Aleksey Midenkov made transition -
            In Progress Closed
            		2h 1m 1

            People

              midenok Aleksey Midenkov
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.