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

Test main.cte_nonrecursive on sporadic failures

    XMLWordPrintable

    Details

      Description

      I've noticed several times failures of the main.cte_nonrecursive test. They usually don't repeat when restarting the test, so they seem sporadic.

      Example:

      main.cte_nonrecursive                    w3 [ fail ]
              Test ended at 2021-11-27 23:03:54
       
      CURRENT_TEST: main.cte_nonrecursive
      mysqltest: At line 1220: query 'drop database test' failed: ER_DB_DROP_RMDIR (1010): Error dropping database (can't rmdir './test', errno: 39 "Directory not empty")
       
      The result from queries just before the failure was:
      < snip >
      # MDEV-18460: Server crashed in strmake / tdc_create_key /
      # THD::create_tmp_table_def_key
      #
      connect con1,localhost,root,,;
      CREATE TEMPORARY TABLE test.t (a INT);
      WITH cte AS (SELECT 1) SELECT * FROM cte;
      1
      1
      WITH t AS (SELECT 1) SELECT * FROM t;
      1
      1
      WITH cte AS (SELECT 1) SELECT * FROM t;
      ERROR 3D000: No database selected
      DROP TABLE test.t;
      connection default;
      disconnect con1;
      #
      # MDEV-22781: create view with CTE without default database
      #
      drop database test;
       
      More results from queries before failure can be found in /tmp/tmp.SRpydvPo6F/var/3/log/cte_nonrecursive.log
       
       - saving '/tmp/tmp.SRpydvPo6F/var/3/log/main.cte_nonrecursive/' to '/tmp/tmp.SRpydvPo6F/var/log/main.cte_nonrecursive/'
      

      Occurences:

      I've seen this failure on MariaDB 10.4 a couple of times too, so I don't think it is specific for 10.6.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            otto Otto Kekäläinen
            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.