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

Sporadic main.events_2 test failure with extra 'event_scheduler' entry in results

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      After uploading 1:10.11.7-4 to Debian I noticed in the Debian CI this failure on arch s390x:

      main.events_2                            w3 [ fail ]
              Test ended at 2024-04-14 17:03:00
       
      CURRENT_TEST: main.events_2
      --- /usr/share/mysql/mysql-test/main/events_2.result       2024-02-01 17:36:14.000000000 +0000
      +++ /tmp/tmp.uWNTARTvas/var/3/log/events_2.reject  2024-04-14 17:02:59.813195822 +0000
      @@ -38,6 +38,7 @@
       where (user='event_scheduler')
       order by info;
       user      host    db      command state   info
      +event_scheduler   localhost       NULL    Connect Initialized     NULL
       select release_lock("test_lock1");
       release_lock("test_lock1")
       1
      @@ -60,6 +61,7 @@
       order by info;
       user      host    db      command state   info
       event_scheduler   localhost       NULL    Daemon  Waiting for next activation     NULL
      +event_scheduler   localhost       NULL    Connect Initialized     NULL
       root      localhost       events_test     Connect User lock       select get_lock("test_lock2", 20)
       "Release the mutex, the event worker should finish."
       select release_lock("test_lock2");
      @@ -78,6 +80,7 @@
       order by info;
       user      host    db      command state   info
       event_scheduler   localhost       NULL    Daemon  Waiting for next activation     NULL
      +event_scheduler   localhost       NULL    Connect Initialized     NULL
       root      localhost       events_test     Connect User lock       select get_lock("test_lock2_1", 20)
       set global event_scheduler=off;
       "Should have only our process now:"
       
      mysqltest: Result length mismatch
      

      Full log at https://ci.debian.net/packages/m/mariadb/unstable/s390x/45408211/

      This is similar to what Marko observed on 10.6 in 2021 in https://jira.mariadb.org/browse/MDEV-13277?focusedCommentId=195741&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-195741

      There is also MDEV-9944 from 2016 with very similar mismatch in result.

      This was sporadic, as a re-run passed.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.