Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL), 11.7
Description
I do not really consider this a bug (as such 'Trivial') and/or a duplciate of MDEV-24706, but it does show some interesting Spider-specific outputs that may be worth having a look at in this ticket. It also causes GOT_ERROR|Got error 12714|'unknown' from SPIDER to be filtered.
INSTALL PLUGIN Spider SONAME 'ha_spider.so'; |
CREATE SERVER srv FOREIGN DATA WRAPPER mysql OPTIONS (SOCKET '../socket.sock',DATABASE'',USER'',PASSWORD''); |
CREATE OR REPLACE TABLE mysql.general_log (a INT) ENGINE=Spider COMMENT='WRAPPER "mysql",SRV "srv",TABLE "t"'; |
SET GLOBAL general_log=TRUE; |
SET GLOBAL table_open_cache=0; |
SET GLOBAL log_output='TABLE,FILE'; |
SHUTDOWN;
|
Leads to a hang on SHUTDOWN and/or:
CS 11.2.6 12a91b57e27b979819924cf89614e6e51f24b37b (Debug) |
2024-10-29 10:14:53 0 [Note] /test/MD141024-mariadb-11.2.6-linux-x86_64-dbg/bin/mariadbd: ready for connections.
|
Version: '11.2.6-MariaDB-debug' socket: '/test/MD141024-mariadb-11.2.6-linux-x86_64-dbg/socket.sock' port: 12324 MariaDB Server
|
[WARN SPIDER RESULT] Wait share->init too long, table_name ./mysql/general_log 3306
|
2024-10-29 10:15:10 8 [ERROR] Failed to write to mysql.general_log: Got error 12714 'unknown' from SPIDER
|
[WARN SPIDER RESULT] Wait share->init too long, table_name ./mysql/general_log 3306
|
2024-10-29 10:15:20 8 [ERROR] Failed to write to mysql.general_log: Got error 12714 'unknown' from SPIDER
|
[WARN SPIDER RESULT] Wait share->init too long, table_name ./mysql/general_log 3306
|
2024-10-29 10:15:29 9 [ERROR] Failed to write to mysql.general_log: Got error 12714 'unknown' from SPIDER
|
[WARN SPIDER RESULT] Wait share->init too long, table_name ./mysql/general_log 3306
|
2024-10-29 10:15:30 8 [ERROR] Failed to write to mysql.general_log: Got error 12714 'unknown' from SPIDER
|
[WARN SPIDER RESULT] Wait share->init too long, table_name ./mysql/general_log 3306
|
2024-10-29 10:15:40 9 [ERROR] Failed to write to mysql.general_log: Got error 12714 'unknown' from SPIDER
|
[WARN SPIDER RESULT] Wait share->init too long, table_name ./mysql/general_log 3306
|
2024-10-29 10:15:40 8 [ERROR] Failed to write to mysql.general_log: Table mysql.general_log open timeout
|
2024-10-29 10:15:40 0 [Note] /test/MD141024-mariadb-11.2.6-linux-x86_64-dbg/bin/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
|
2024-10-29 10:15:40 8 [ERROR] Failed to write to mysql.general_log:
|
mariadbd: /test/11.2_dbg/sql/transaction.cc:79: bool trans_check(THD*): Assertion `thd->transaction->stmt.is_empty()' failed.
|
Present in 10.5-11.7 opt+dbg.
Attachments
Issue Links
- relates to
-
MDEV-24706 Assertion `thd->transaction->stmt.is_empty() || thd->in_sub_stmt' failed in mysql_execute_command (from mysql_parse) and in trans_check
- Confirmed