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

SELECT SLEEP(1) Hangs indefinitely with Time 0

    XMLWordPrintable

    Details

      Description

      The following:

      INSERT INTO t VALUES (1);
      CREATE TABLE parent (a INT KEY,b INT);
      CREATE TABLE t (a INT KEY,FOREIGN KEY(a) REFERENCES parent (a) ON DELETE CASCADE) COLLATE=BIG5_nopad_bin;
      SET GLOBAL innodb_status_output=1;
      SELECT SLEEP (1);
      

      When replayed using the C connector produces the following:

      10.8.1 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566 (Debug)

      MariaDB [(none)]> show processlist;
      +----+------+-----------+------+---------+------+------------+------------------+----------+
      | Id | User | Host      | db   | Command | Time | State      | Info             | Progress |
      +----+------+-----------+------+---------+------+------------+------------------+----------+
      |  7 | root | localhost | test | Query   |    0 | User sleep | SELECT SLEEP (1) |    0.000 |
      |  8 | root | localhost | NULL | Query   |    0 | starting   | show processlist |    0.000 |
      +----+------+-----------+------+---------+------+------------+------------------+----------+
      2 rows in set (0.000 sec)
      

      i.e. the sleep hangs, seemingly perpetually, and always with 0 time (using single threaded replay). Killing the query (KILL 7;) reports "OK" but the state remains unchanged.

        Attachments

          Activity

            People

            Assignee:
            Roel Roel Van de Paar
            Reporter:
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.