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

Details

    Description

      I do not really consider this a bug (as such 'Trivial') and/or a duplicate 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

            Happy to create an MTR testcase if needed.

            Roel Roel Van de Paar added a comment - Happy to create an MTR testcase if needed.
            ycp Yuchen Pei added a comment - - edited

            Interesting: when I run the following case I get a hanging at shutdown

            --disable_query_log
            --disable_result_log
            --source ../../t/test_init.inc
            --enable_result_log
            --enable_query_log
             
            set spider_same_server_link= 1;
            evalp CREATE SERVER srv FOREIGN DATA WRAPPER mysql
            OPTIONS (SOCKET "$MASTER_MYSOCK", DATABASE 'test',user 'root');
             
            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';
             
            drop server srv;
            shutdown;
             
            --disable_query_log
            --disable_result_log
            --source ../../t/test_deinit.inc
            --enable_result_log
            --enable_query_log

            tested at 10.5 432856c473feb92ddd69442a4c164ee88a0d28d7 and its parent commit

            ycp Yuchen Pei added a comment - - edited Interesting: when I run the following case I get a hanging at shutdown --disable_query_log --disable_result_log --source ../../t/test_init.inc --enable_result_log --enable_query_log   set spider_same_server_link= 1; evalp CREATE SERVER srv FOREIGN DATA WRAPPER mysql OPTIONS (SOCKET "$MASTER_MYSOCK" , DATABASE 'test' , user 'root' );   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' ;   drop server srv; shutdown;   --disable_query_log --disable_result_log --source ../../t/test_deinit.inc --enable_result_log --enable_query_log tested at 10.5 432856c473feb92ddd69442a4c164ee88a0d28d7 and its parent commit

            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.