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

wsrep.variables failed in buildbot with deadlock on CREATE USER

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-x86/builds/7149

      wsrep.variables                          w1 [ fail ]
              Test ended at 2018-10-30 10:53:07
       
      CURRENT_TEST: wsrep.variables
      mysqltest: At line 132: query 'create user test@localhost' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      gcomm://
      SHOW STATUS LIKE 'threads_connected';
      Variable_name	Value
      Threads_connected	1
      SHOW STATUS LIKE 'wsrep_thread_count';
      Variable_name	Value
      wsrep_thread_count	2
       
      SET @wsrep_slave_threads_saved= @@global.wsrep_slave_threads;
      SET GLOBAL wsrep_slave_threads= 10;
      # Wait for applier threads to get created.
      SHOW STATUS LIKE 'threads_connected';
      Variable_name	Value
      Threads_connected	1
      SHOW STATUS LIKE 'wsrep_thread_count';
      Variable_name	Value
      wsrep_thread_count	11
      set wsrep_on=0;
      set wsrep_on=1;
      create user test@localhost;
      

      Attachments

        Issue Links

          Activity

            Last time it failed on bb on 03.01.2020:
            http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/5267

            10.1 1adc559370cc53ca69e225739a942287

            wsrep.variables                          w2 [ fail ]
                    Test ended at 2020-01-03 21:34:09
             
            CURRENT_TEST: wsrep.variables
            --- /usr/share/mysql/mysql-test/suite/wsrep/r/variables.result	2020-01-03 12:44:19.000000000 -0500
            +++ /dev/shm/var/2/log/variables.reject	2020-01-03 21:34:09.045400914 -0500
            @@ -154,7 +154,7 @@
             Threads_connected	1
             SHOW STATUS LIKE 'wsrep_thread_count';
             Variable_name	Value
            -wsrep_thread_count	11
            +wsrep_thread_count	9
             set wsrep_on=0;
             set wsrep_on=1;
             create user test@localhost;
             
            mysqltest: Result length mismatch
             
             - saving '/dev/shm/var/2/log/wsrep.variables/' to '/dev/shm/var/log/wsrep.variables/'
             
            Retrying test wsrep.variables, attempt(2/3)...
             
            worker[2] > Restart  - not started
            

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - Last time it failed on bb on 03.01.2020: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/5267 10.1 1adc559370cc53ca69e225739a942287 wsrep.variables w2 [ fail ] Test ended at 2020-01-03 21:34:09   CURRENT_TEST: wsrep.variables --- /usr/share/mysql/mysql-test/suite/wsrep/r/variables.result 2020-01-03 12:44:19.000000000 -0500 +++ /dev/shm/var/2/log/variables.reject 2020-01-03 21:34:09.045400914 -0500 @@ -154,7 +154,7 @@ Threads_connected 1 SHOW STATUS LIKE 'wsrep_thread_count'; Variable_name Value -wsrep_thread_count 11 +wsrep_thread_count 9 set wsrep_on=0; set wsrep_on=1; create user test@localhost;   mysqltest: Result length mismatch   - saving '/dev/shm/var/2/log/wsrep.variables/' to '/dev/shm/var/log/wsrep.variables/'   Retrying test wsrep.variables, attempt(2/3)...   worker[2] > Restart - not started

            It failed also on Azure: 10.2.30-5-MariaDB-enterprise, run #20200113.1 and on 10.3.21-5-MariaDB-enterprise, run #20200104.2.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - - edited It failed also on Azure: 10.2.30-5-MariaDB-enterprise, run #20200113.1 and on 10.3.21-5-MariaDB-enterprise, run #20200104.2.

            Increased the priority since it failed on Azure.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - Increased the priority since it failed on Azure.

            It hasn't been merged into 10.3 yet (and obviously not into ES), so naturally it still fails there.

            elenst Elena Stepanova added a comment - It hasn't been merged into 10.3 yet (and obviously not into ES), so naturally it still fails there.

            People

              jplindst Jan Lindström (Inactive)
              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.