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

Highly sporadic hang, likely on SHOW CREATE SERVER

    XMLWordPrintable

Details

    Description

      The following testcase:

      USE test;
      INSTALL PLUGIN spider SONAME 'ha_spider.so';
      CREATE USER spider@localhost IDENTIFIED BY '';
      SHOW CREATE SERVER srv;
      CREATE SERVER s3 FOREIGN DATA WRAPPER mysql OPTIONS (HOST 'localhost', PORT 3307);
      SHOW CREATE SERVER srv;
      SELECT * FROM mysql.servers;
      ALTER SERVER s3 OPTIONS (HOST '192.168.0.3', PORT 3306);
      CREATE OR REPLACE SERVER srv FOREIGN DATA WRAPPER foo OPTIONS (HOST "LOCALHOST", PORT "12345");
      DROP SERVER s5000;
      CREATE TABLE t1_s3 (c INT) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "s3", TABLE "t2"';
      SHOW CREATE SERVER srv;
      

      Will hang, very sporadically. Reduction has proven challeging given delay in waiting for hangs combined with high sporadicity.

      ycp Work is ongoing on attempting to get a better testcase, but perhaps you may know where the issue could be in the code and double check?

      Trying to run the testcase as provided is guaranteed to fail: time between occurences can be 8+ hours, even with many threads.

      Attachments

        Activity

          People

            Roel Roel Van de Paar
            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.