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

main.delayed sporadically fails with "query 'REPLACE DELAYED t1 VALUES (5)' failed: 1317: Query execution was interrupted"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5.29
    • Fix Version/s: 5.5.29
    • Component/s: None
    • Labels:
      None

      Description

      Here is an extract that helps to reproduce the problem quite easily:

      drop table if exists t1;
      
      --disable_query_log
      --disable_result_log
      
      --let $run=1000
      
      while ($run)
      {
        --echo # $run attempts left...
        CREATE TABLE t1 ( f1 INTEGER AUTO_INCREMENT, PRIMARY KEY (f1)) ENGINE=MyISAM;
        INSERT DELAYED t1 VALUES (4);
        --error ER_TABLE_EXISTS_ERROR
        CREATE TABLE t1 AS SELECT 1 AS f1;
      
        REPLACE DELAYED t1 VALUES (5);
        DROP TABLE t1;
        --dec $run
      }
      
      --echo # All done
      

      Normally it would go to the end and print "All done". With the bug, it stops in the middle with "Query execution was interrupted". Tried Linux and Windows, release and debug builds (particularly, BUILD/compile-pentium-debug-max-no-ndb).

      It started happening after MDEV-3941 - CREATE TABLE xxx IF NOT EXISTS should not block if table exists Complete , with this revision:

      revno: 3593
      revision-id: monty@askmonty.org-20121216141317-77vdudlfczp9sd84
      parent: monty@askmonty.org-20121216100426-23v67jvuacc9rtk1
      committer: Michael Widenius <monty@askmonty.org>
      branch nick: maria-5.5
      timestamp: Sun 2012-12-16 16:13:17 +0200
      message:
        Implemented MDEV-3941: CREATE TABLE xxx IF NOT EXISTS should not block if table exists.
        - Added option to check_if_table_exists() to quickly check if table exists (either SHARE or .FRM)
        - Extended lock_table_names() to not wait for meta data locks if CREATE IF NOT EXISTS is used.
      

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: