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"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 5.5.29
    • 5.5.29
    • None
    • 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, 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

            monty Michael Widenius
            elenst Elena Stepanova
            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.