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

Slow log entries causing main.subselect mtr failures.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.4.31
    • 10.4.32
    • Tests
    • None

    Description

      In MDEV-7445, a test required an empty table as a data source. mysql.slow_log was chosen as this table, but some CI testers enable this in a worker as a command line option, meaning that this table may no longer be empty. If the table returns more than 1 row, the query fails, causing test failure.

      This will clearly be a random failure, depending on OS workload.

      Attachments

        Issue Links

          Activity

            I assume this is the failure that's being referred to?

            CURRENT_TEST: main.subselect
            /mnt/buildbot/build/mariadb-10.4.32/client//mysqltest: Error on delete of '/mnt/buildbot/build/mariadb-10.4.32/mysql-test/var/1/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory")
            mysqltest: At line 5993: query 'Select 
            (Select Sum(`TestCase`.Revenue) From mysql.slow_log E           
            Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2)
            ) As `ControlRev`
            From 
            (Select  3 as Revenue, 4 as TemplateID) As `TestCase` 
            Group By  TestCase.Revenue, TestCase.TemplateID' failed: 1242: Subquery returns more than 1 row
            

            knielsen Kristian Nielsen added a comment - I assume this is the failure that's being referred to? CURRENT_TEST: main.subselect /mnt/buildbot/build/mariadb-10.4.32/client//mysqltest: Error on delete of '/mnt/buildbot/build/mariadb-10.4.32/mysql-test/var/1/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory") mysqltest: At line 5993: query 'Select (Select Sum(`TestCase`.Revenue) From mysql.slow_log E Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) ) As `ControlRev` From (Select 3 as Revenue, 4 as TemplateID) As `TestCase` Group By TestCase.Revenue, TestCase.TemplateID' failed: 1242: Subquery returns more than 1 row
            elenst Elena Stepanova added a comment - - edited

            If it's about the failure above, it happens upon executing

            main.log_slow main.subselect
            

            or

            main.log_slow main.subselect_no_exists_to_in

            without any special command-line options.

            elenst Elena Stepanova added a comment - - edited If it's about the failure above, it happens upon executing main.log_slow main.subselect or main.log_slow main.subselect_no_exists_to_in without any special command-line options.
            Johnston Rex Johnston added a comment -

            Yes knielsen elenst, this is the offending error.

            Johnston Rex Johnston added a comment - Yes knielsen elenst , this is the offending error.

            1. See Monty's fix (and it is already pushed)
            2. Did you removed the original fix and checked that it fails in your variant?
            3. I think that slow_log should be controlled after other tests run to be clear

            sanja Oleksandr Byelkin added a comment - 1. See Monty's fix (and it is already pushed) 2. Did you removed the original fix and checked that it fails in your variant? 3. I think that slow_log should be controlled after other tests run to be clear

            People

              Unassigned Unassigned
              Johnston Rex Johnston
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.