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

galera.galera_bf_kill_debug MTR failed: A long semaphore wait

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5.9, 10.4(EOL)
    • 10.5
    • Galera, Tests
    • None
    • kvm-rpm-centos74-amd64-debug

    Description

      galera.galera_bf_kill_debug failed on BB 10.5 CS: "A long semaphore wait".
      It seems to be a sporadic issue.

      stdio.log:

      10.5.9, 39378e1366f78b38c05e45103b9fb9c829cc5f4f, kvm-rpm-centos74-amd64-debug

      galera.galera_bf_kill_debug 'innodb'     w2 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2020-12-21 19:46:40
      line
      2020-12-21 19:45:52 0 [Warning] InnoDB: A long semaphore wait:
      2020-12-21 19:46:07 0 [Warning] InnoDB: A long semaphore wait:
      2020-12-21 19:46:22 0 [Warning] InnoDB: A long semaphore wait:
      2020-12-21 19:46:37 0 [Warning] InnoDB: A long semaphore wait:
      ^ Found warnings in /dev/shm/var/2/log/mysqld.2.err
      ok
       
       - skipping '/dev/shm/var/2/log/galera.galera_bf_kill_debug-innodb/'
       
      Retrying test galera.galera_bf_kill_debug, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

      10.5 Server logs.

      But on BB 10.6 CS it failed with another output: "safe_mutex: Found wrong usage of mutex 'LOCK_thd_kill' and 'mutex'".

      stdio.log:

      10.6.0, 30dc4287ec3d46bae7593f56383b9f3738e3c4e6, kvm-rpm-centos74-amd64-debug

      galera.galera_bf_kill_debug 'innodb'     w2 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2020-12-19 12:47:06
      line
      safe_mutex: Found wrong usage of mutex 'LOCK_thd_kill' and 'mutex'
      ^ Found warnings in /dev/shm/var/2/log/mysqld.2.err
      ok
       
       - skipping '/dev/shm/var/2/log/galera.galera_bf_kill_debug-innodb/'
       
      Retrying test galera.galera_bf_kill_debug, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      galera.galera_bf_kill_debug 'innodb'     w2 [ retry-pass ]   2059
       
      Retrying test galera.galera_bf_kill_debug, attempt(3/3)...
       
      galera.galera_bf_kill_debug 'innodb'     w2 [ retry-fail ]  Found warnings/errors in server log file!
              Test ended at 2020-12-19 12:47:14
      line
      safe_mutex: Found wrong usage of mutex 'mutex' and 'LOCK_thd_data'
      ^ Found warnings in /dev/shm/var/2/log/mysqld.2.err
      ok
       
       - skipping '/dev/shm/var/2/log/galera.galera_bf_kill_debug-innodb/'
      worker[2] > Restart  - using different config file
      worker[2] > Restart  - using different config file
      

      10.6 Server logs.

      Attachments

        Issue Links

          Activity

            People

              seppo Seppo Jaakola
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.