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

Thread hang in 'Update' state on 2nd INSERT

    XMLWordPrintable

Details

    Description

      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      CREATE SERVER s FOREIGN DATA WRAPPER mysql OPTIONS(HOST '1');
      CREATE TABLE t(c INT)ENGINE=Spider COMMENT='WRAPPER "mysql",SRV "s",TABLE "foo"';
      INSERT INTO t VALUES(1);   # ERROR 1429 (HY000): Unable to connect to foreign data source: s
      INSERT INTO t VALUES(1);   # Hangs
      

      Will thread-hang in 'Update' state on the second INSERT.

      CS 11.2.6 e91a79945822def1452787f825e6047c6a64dbd9 (Debug)

      11.2.6-dbg>SHOW PROCESSLIST;
      +----+-------------+-----------+------+---------+------+----------------------------------------------------+-------------------------+----------+
      | Id | User        | Host      | db   | Command | Time | State                                              | Info                    | Progress |
      +----+-------------+-----------+------+---------+------+----------------------------------------------------+-------------------------+----------+
      |  4 | root        | localhost | test | Query   | 2003 | Update                                             | INSERT INTO t VALUES(1) |    0.000 |
      |  5 | system user |           | NULL | Daemon  | NULL | Spider table background statistics action handler  | NULL                    |    0.000 |
      |  6 | system user |           | NULL | Daemon  | NULL | Spider table background cardinality action handler | NULL                    |    0.000 |
      |  9 | root        | localhost | test | Query   |    0 | starting                                           | SHOW PROCESSLIST        |    0.000 |
      +----+-------------+-----------+------+---------+------+----------------------------------------------------+-------------------------+----------+
      4 rows in set (0.000 sec)
      

      Bug confirmed in 10.5 opt, 11.2 dbg and 11.7 opt - deemed to be present in all versions/build types.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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