[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' - Jira

Roel Van de Paar created issue - 2022-10-15 05:44

Roel Van de Paar made changes - 2022-10-15 05:44

Field	Original Value	New Value
Link		This issue is caused by MDEV-25292 [ MDEV-25292 ]

Roel Van de Paar made changes - 2022-10-15 05:46

Description

{code:sql}
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',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;
{code}

Leads to:

{noformat:title=bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Opt)}
10.11.0-opt>CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;
ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY'
{noformat}
Before MDEV-25292 it passes.

{code:sql}
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',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;
{code}

Leads to:

{noformat:title=bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Opt)}
10.11.0-opt>CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;
ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY'
{noformat}

{noformat:title=bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Opt)}
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'
{noformat}
Before MDEV-25292 it passes.

Roel Van de Paar made changes - 2022-10-15 05:46

Summary

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CORT for Spider table

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CORT for Spider table, DDL_LOG: Got error 1032 when trying to execute action for entry 6 of type 'rename table'

Roel Van de Paar made changes - 2022-10-15 05:47

Description

{code:sql}
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',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;
{code}

Leads to:

{noformat:title=bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Opt)}
10.11.0-opt>CREATE OR REPLACE TABLE t (a INT) ENGINE=Spider;
ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY'
{noformat}

{noformat:title=bb-10.11-midenok 80625038c703d46e2e01d32da5de234a6c31acb8 (Opt)}
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'
{noformat}
Before MDEV-25292 it passes.

{code:sql}
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',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;
{code}

Leads to:

{noformat:title=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'
{noformat}

{noformat:title=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'
{noformat}
Before MDEV-25292 it passes.

Roel Van de Paar made changes - 2022-10-15 05:47

Link

This issue relates to TODO-3120 [ TODO-3120 ]

Roel Van de Paar made changes - 2022-10-15 05:58

Summary

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CORT for Spider table, DDL_LOG: Got error 1032 when trying to execute action for entry 6 of type 'rename table'

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CoR for Spider table, DDL_LOG: Got error 1032 when trying to execute action for entry 6 of type 'rename table'

Roel Van de Paar made changes - 2022-10-16 20:22

Description

{code:sql}
INSTALL PLUGIN Spider SONAME 'ha_spider.so';
CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',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;
{code}

Leads to:

{noformat:title=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'
{noformat}

{noformat:title=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'
{noformat}
Before MDEV-25292 it passes.

{code:sql}
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;
{code}

Leads to:

{noformat:title=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'
{noformat}

{noformat:title=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'
{noformat}
Before MDEV-25292 it passes.

Roel Van de Paar made changes - 2022-10-16 20:32

Link

This issue relates to ~~MDEV-29583~~ [ ~~MDEV-29583~~ ]

Aleksey Midenkov made changes - 2022-10-17 07:43

Status

Open [ 1 ]

In Progress [ 3 ]

Aleksey Midenkov made changes - 2022-10-17 08:11

Assignee

Aleksey Midenkov [ midenok ]

Nayuta Yanagisawa [ JIRAUSER47117 ]

Aleksey Midenkov made changes - 2022-10-17 08:11

Assignee

Nayuta Yanagisawa [ JIRAUSER47117 ]

Aleksey Midenkov [ midenok ]

Aleksey Midenkov made changes - 2022-10-17 08:11

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Aleksey Midenkov made changes - 2022-10-17 08:11

Assignee

Aleksey Midenkov [ midenok ]

Nayuta Yanagisawa [ JIRAUSER47117 ]

Roel Van de Paar made changes - 2022-10-20 03:19

Summary

ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CoR for Spider table, DDL_LOG: Got error 1032 when trying to execute action for entry 6 of type 'rename table'

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 6 of type 'rename table'

Roel Van de Paar made changes - 2022-10-20 05:32

Summary

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 6 of type 'rename table'

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 2/36 of type 'rename table'

Roel Van de Paar made changes - 2022-10-20 05:32

Summary

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 2/36 of type 'rename table'

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 2/3/6 of type 'rename table'

Roel Van de Paar made changes - 2022-10-20 05:36

Labels

affects-tests regression

Roel Van de Paar made changes - 2022-10-20 05:36

Labels

affects-tests regression

affects-tests errors regression

Nayuta Yanagisawa (Inactive) made changes - 2022-10-20 07:14

Assignee

Nayuta Yanagisawa [ JIRAUSER47117 ]

Alexey Botchkov [ holyfoot ]

Roel Van de Paar made changes - 2022-10-22 00:10

Summary

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 2/3/6 of type 'rename table'

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'

Alexey Botchkov made changes - 2022-10-24 08:15

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Alexey Botchkov made changes - 2022-10-25 12:53

Assignee	Alexey Botchkov [ holyfoot ]	Nayuta Yanagisawa [ JIRAUSER47117 ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Nayuta Yanagisawa (Inactive) made changes - 2022-10-26 06:25

Assignee	Nayuta Yanagisawa [ JIRAUSER47117 ]	Alexey Botchkov [ holyfoot ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Alexey Botchkov made changes - 2022-10-26 10:44

Fix Version/s		10.11.1 [ 28454 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2022-10-27 16:16

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2022-10-27 16:16

Fix Version/s		10.11 [ 27614 ]
Fix Version/s	10.11.1 [ 28454 ]

Sergei Golubchik made changes - 2022-11-01 13:52

Priority

Blocker [ 1 ]

Critical [ 2 ]

Roel Van de Paar made changes - 2023-01-20 23:42

Status

Stalled [ 10000 ]

Open [ 1 ]

Roel Van de Paar made changes - 2023-01-20 23:42

Status

Open [ 1 ]

Confirmed [ 10101 ]

Aleksey Midenkov made changes - 2023-01-25 11:53

Assignee

Alexey Botchkov [ holyfoot ]

Aleksey Midenkov [ midenok ]

Aleksey Midenkov made changes - 2023-01-25 11:53

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Aleksey Midenkov made changes - 2023-01-25 13:54

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.11 [ 27614 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

MariaDB Server

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

Attachments

Issue Links

Activity

People

Dates

Git Integration