[MDEV-33196] [ERROR] Got error 12524 when reading table './test/t' - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
Fix Version/s: 10.5, 10.6, 10.11
Component/s: Storage Engine - Spider
Labels:
- affects-tests
- regression

Description

INSTALL PLUGIN spider SONAME 'ha_spider.so';

SET spider_internal_sql_log_off=1;

DROP TABLE mysql.spider_link_mon_servers;

CREATE TABLE t1(c DATE) ENGINE=MyISAM;

CREATE TABLE t(c DATE,PRIMARY KEY(c)) ENGINE=Spider COMMENT='socket "../socket.sock",table "t1 t2"' CONNECTION='mkd "1"';

SELECT * FROM t WHERE c=0;

Leads to:

11.4.0 9bd95e914f3f12d0d9d93e7a1f2c49e6e8841f17 (Optimized)
11.4.0-opt>SELECT * FROM t WHERE c=0;
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

11.4.0 9bd95e914f3f12d0d9d93e7a1f2c49e6e8841f17 (Optimized)
2024-01-08 7:39:50 4 [ERROR] Got error 12524 when reading table './test/t'

Bug confirmed present in:
MariaDB: 10.4.33 (dbg), 10.4.33 (opt), 10.5.24 (dbg), 10.5.24 (opt), 10.6.17 (dbg), 10.6.17 (opt), 10.11.7 (dbg), 10.11.7 (opt), 11.0.5 (dbg), 11.0.5 (opt), 11.1.4 (dbg), 11.1.4 (opt), 11.2.3 (dbg), 11.2.3 (opt), 11.3.2 (dbg), 11.3.2 (opt), 11.4.0 (dbg), 11.4.0 (opt)

Attachments

Issue Links

relates to

MDEV-15696 Implement SHOW CREATE SERVER

Closed

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

Closed

MDEV-34589 Assertion `!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())' failed from mysql_admin_table on CHECK TABLE

Closed

Activity

Ascending order - Click to sort in descending order

View 11 older comments

Roel Van de Paar added a comment - 2024-07-15 01:14

Also observed: ERROR 1969:

DROP DATABASE test;

CREATE DATABASE test;

USE test;

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE TABLE t (a INT) ENGINE=Spider;

SET @@max_statement_time=0.0001;

RENAME TABLE t TO t2,t3 TO t3,t2 TO t;

Leads to:

11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Optimized)
11.2.5-opt>RENAME TABLE t TO t2,t3 TO t3,t2 TO t;
ERROR 1969 (70100): Query execution was interrupted (max_statement_time exceeded)

11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Optimized)
2024-07-15 11:07:49 4 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 1 of type 'rename table'

Similar to the last comment, removing the first 3 lines changes the entry:

11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Optimized)
2024-07-15 11:12:22 4 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 2 of type 'rename table'

Roel Van de Paar added a comment - 2024-07-15 01:14 Also observed: ERROR 1969 : DROP DATABASE test; CREATE DATABASE test; USE test; INSTALL PLUGIN Spider SONAME 'ha_spider.so' ; CREATE TABLE t (a INT ) ENGINE=Spider; SET @@max_statement_time=0.0001; RENAME TABLE t TO t2,t3 TO t3,t2 TO t; Leads to: 11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Optimized) 11.2.5-opt>RENAME TABLE t TO t2,t3 TO t3,t2 TO t; ERROR 1969 (70100): Query execution was interrupted (max_statement_time exceeded) 11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Optimized) 2024-07-15 11:07:49 4 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 1 of type 'rename table' Similar to the last comment, removing the first 3 lines changes the entry: 11.2.5 a21e49cbcc5f4adb1a1b4970ceead6a85e968063 (Optimized) 2024-07-15 11:12:22 4 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 2 of type 'rename table'

Roel Van de Paar added a comment - 2024-07-15 01:20 - edited

It is possible that the RENAME TABLE is a different, though likely related, issue.

Roel Van de Paar added a comment - 2024-07-15 01:20 - edited It is possible that the RENAME TABLE is a different, though likely related, issue.

Roel Van de Paar added a comment - 2024-09-20 05:16

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE TABLE t (c INT);

CREATE OR REPLACE TABLE t (a INT);

CREATE TABLE t2 (t2_i INT KEY,t2_j BLOB) ENGINE=Spider;

DROP TABLE Ｔ１;

DROP TABLE t;

SET max_statement_time=0.000001;

RENAME TABLE t2 TO t,t2 TO t3,t TO t3;

Leads to:

CS 11.7.0 5bbda9711131845ae6b4315a268b4d1710943a85 (Optimized)
2024-09-20 15:08:25 0 [Note] /test/MD090924-mariadb-11.7.0-linux-x86_64-opt/bin/mariadbd: ready for connections.
Version: '11.7.0-MariaDB' socket: '/test/MD090924-mariadb-11.7.0-linux-x86_64-opt/socket.sock' port: 11525 MariaDB Server
2024-09-20 15:08:29 4 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 4 of type 'rename table'

Roel Van de Paar added a comment - 2024-09-20 05:16 INSTALL PLUGIN Spider SONAME 'ha_spider.so' ; CREATE TABLE t (c INT ); CREATE OR REPLACE TABLE t (a INT ); CREATE TABLE t2 (t2_i INT KEY ,t2_j BLOB) ENGINE=Spider; DROP TABLE Ｔ１; DROP TABLE t; SET max_statement_time=0.000001; RENAME TABLE t2 TO t,t2 TO t3,t TO t3; Leads to: CS 11.7.0 5bbda9711131845ae6b4315a268b4d1710943a85 (Optimized) 2024-09-20 15:08:25 0 [Note] /test/MD090924-mariadb-11.7.0-linux-x86_64-opt/bin/mariadbd: ready for connections. Version: '11.7.0-MariaDB' socket: '/test/MD090924-mariadb-11.7.0-linux-x86_64-opt/socket.sock' port: 11525 MariaDB Server 2024-09-20 15:08:29 4 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 4 of type 'rename table'

Roel Van de Paar added a comment - 2024-09-20 06:09

Also seen on 11.7 opt trunk:

CS 11.7.0 5bbda9711131845ae6b4315a268b4d1710943a85 (Optimized)
GOT_ERROR\|Got error 1969\|when trying to execute action for entry 5 of type 'rename table'

And during ~~MDEV-15696~~ testing in bb-11.7-mdev-15696:

bb-11.7-mdev-15696 CS 11.7.0 f19446cc2cacfb7c78ce3c198042b86b4754321e (Optimized)
GOT_ERROR\|Got error 1969\|when trying to execute action for entry 3 of type 'rename table'

Though this is suspected, though not confirmed, to be present in trunk also.

Roel Van de Paar added a comment - 2024-09-20 06:09 Also seen on 11.7 opt trunk: CS 11.7.0 5bbda9711131845ae6b4315a268b4d1710943a85 (Optimized) GOT_ERROR|Got error 1969|when trying to execute action for entry 5 of type 'rename table' And during MDEV-15696 testing in bb-11.7-mdev-15696: bb-11.7-mdev-15696 CS 11.7.0 f19446cc2cacfb7c78ce3c198042b86b4754321e (Optimized) GOT_ERROR|Got error 1969|when trying to execute action for entry 3 of type 'rename table' Though this is suspected, though not confirmed, to be present in trunk also.

Roel Van de Paar added a comment - 2024-10-09 03:33

This sporadic testcase (likely not all options are required):

# mysqld options required for replay:  --max_allowed_packet=33554432 --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=

INSTALL PLUGIN spider SONAME 'ha_spider.so';

FLUSH PRIVILEGES;

CREATE TABLE t936 (c1 INTEGER);

SET @@max_statement_time=0.0001;

INSERT INTO t1 VALUES(8482);

create TABLE t1 (a int,b int) engine=Spider;

CREATE TABLE t2 (a INT) ENGINE = Spider SELECT 1;

CREATE TABLE t1(a int NOT NULL,b blob NOT NULL,c text,PRIMARY KEY (b(10),a),INDEX (c(767)),INDEX(b(767))) ENGINE=Spider ROW_FORMAT=DYNAMIC;

RENAME TABLE t1 to t2;

which besides "Got error 1969 when trying to execute action for entry 2 of type 'rename table'" on 11.2 dbg, can also show "for entry 1" in 11.7:

CS 11.7.0 5bbda9711131845ae6b4315a268b4d1710943a85 (Debug)
Version: '11.7.0-MariaDB-debug' socket: '/test/MD090924-mariadb-11.7.0-linux-x86_64-dbg/socket.sock' port: 11944 MariaDB Server
2024-10-09 14:26:15 1780 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 1 of type 'rename table'
2024-10-09 14:26:15 1782 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 1 of type 'rename table'

However it is not easy to reproduce (sporadic, looping required). There may have been a change between versions leading to a different outcome (2 vs 1).
NTS; kept as /data/KEEP/739672/5179, and reproduced in 11.7 (entry 1) with base_reducer as well as multirun (after fixin w/ ~5 minute interrupt > tt). entry 2 reproduced with multirun (otherwise indentical) in 11.2

Roel Van de Paar added a comment - 2024-10-09 03:33 This sporadic testcase (likely not all options are required): # mysqld options required for replay: --max_allowed_packet=33554432 --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode= INSTALL PLUGIN spider SONAME 'ha_spider.so' ; FLUSH PRIVILEGES ; CREATE TABLE t936 (c1 INTEGER ); SET @@max_statement_time=0.0001; INSERT INTO t1 VALUES (8482); create TABLE t1 (a int ,b int ) engine=Spider; CREATE TABLE t2 (a INT ) ENGINE = Spider SELECT 1; CREATE TABLE t1(a int NOT NULL ,b blob NOT NULL ,c text, PRIMARY KEY (b(10),a), INDEX (c(767)), INDEX (b(767))) ENGINE=Spider ROW_FORMAT= DYNAMIC ; RENAME TABLE t1 to t2; which besides "Got error 1969 when trying to execute action for entry 2 of type 'rename table'" on 11.2 dbg, can also show "for entry 1" in 11.7: CS 11.7.0 5bbda9711131845ae6b4315a268b4d1710943a85 (Debug) Version: '11.7.0-MariaDB-debug' socket: '/test/MD090924-mariadb-11.7.0-linux-x86_64-dbg/socket.sock' port: 11944 MariaDB Server 2024-10-09 14:26:15 1780 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 1 of type 'rename table' 2024-10-09 14:26:15 1782 [ERROR] DDL_LOG: Got error 1969 when trying to execute action for entry 1 of type 'rename table' However it is not easy to reproduce (sporadic, looping required). There may have been a change between versions leading to a different outcome (2 vs 1). NTS; kept as /data/KEEP/739672/5179, and reproduced in 11.7 (entry 1) with base_reducer as well as multirun (after fixin w/ ~5 minute interrupt > tt). entry 2 reproduced with multirun (otherwise indentical) in 11.2

MariaDB Server

[ERROR] Got error 12524 when reading table './test/t'

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration