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

Concurrent CREATE OR REPLACE TRIGGER produces Error on rename of './test/tr.TRN~' to './test/tr.TRN' (Errcode: 2 "No such file or directory")

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • N/A
    • Triggers
    • None

    Description

      grammar

      query:
          CREATE OR REPLACE TRIGGER tr AFTER INSERT ON _table FOR EACH ROW BEGIN END
      ;
      

      git clone https://github.com/elenst/rqg rqg
      cd rqg
      perl ./runall-new.pl --threads=2 --duration=300 --vardir=<vardir> --basedir=<basedir> --grammar=<grammar>
      

      It produces multiple

      # 2017-02-08T21:18:58 [32273] Executor::MySQL::execute: Query: CREATE OR REPLACE TRIGGER tr AFTER INSERT ON `BB` FOR EACH ROW BEGIN END /* QUERY_NO 416 CON_ID 8 */  failed: 7 Error on rename of './test/tr.TRN~' to './test/tr.TRN' (Errcode: 2 "No such file or directory")
      # 2017-02-08T21:18:58 [32271] Executor::MySQL::execute: Query: CREATE OR REPLACE TRIGGER tr AFTER INSERT ON `CC` FOR EACH ROW BEGIN END /* QUERY_NO 356 CON_ID 7 */  failed: 7 Error on rename of './test/tr.TRN~' to './test/tr.TRN' (Errcode: 2 "No such file or directory")
      # 2017-02-08T21:18:58 [32273] Executor::MySQL::execute: Query: CREATE OR REPLACE TRIGGER tr AFTER INSERT ON `B` FOR EACH ROW BEGIN END /* QUERY_NO 424 CON_ID 8 */  failed: 7 Error on rename of './test/tr.TRN~' to './test/tr.TRN' (Errcode: 2 "No such file or directory")
      

      See also MDEV-10912.

      Attachments

        Issue Links

          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.