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

Highly sporadic hang, likely on SHOW CREATE SERVER

    XMLWordPrintable

Details

    • Not for Release Notes

    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

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 2h 50m
                  2h 50m

                  Git Integration

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