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

[WARN SPIDER RESULT] Wait share->init too long, Got error 12714 'unknown' from SPIDER

    XMLWordPrintable

Details

    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

          Activity

            People

              ycp Yuchen Pei
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.