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

galera.galera_create_table_as_select fails sporadically

Details

    Description

      galera.galera_create_table_as_select 'innodb' w12 [ fail ]
      		 
              Test ended at 2024-04-19 10:05:38
      		 
       
      		 
      CURRENT_TEST: galera.galera_create_table_as_select
      		 
      mysqltest: At line 129: query 'reap' failed with wrong errno ER_LOCK_DEADLOCK (1213): 'Deadlock found when trying to get lock; try restarting transaction', instead of ER_TABLE_EXISTS_ERROR (1050)...

      see e.g. https://buildbot.mariadb.org/#/builders/557/builds/5462

      It's easy to repeat even in debug build, run, for example

      ./mtr galera.galera_create_table_as_select --repeat 200 --rr=-h

      to get a good rr trace

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-33073 always green buildbot

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            denis.protivensky Denis Protivensky made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ] Denis Protivensky [ JIRAUSER52676 ]
            denis.protivensky Denis Protivensky made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            denis.protivensky Denis Protivensky added a comment -

            The fix: https://github.com/MariaDB/server/pull/3246

            denis.protivensky Denis Protivensky added a comment - The fix: https://github.com/MariaDB/server/pull/3246
            denis.protivensky Denis Protivensky made changes -
            Assignee Denis Protivensky [ JIRAUSER52676 ] Julius Goryavsky [ sysprg ]
            denis.protivensky Denis Protivensky made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            sysprg Julius Goryavsky made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            sysprg Julius Goryavsky made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sysprg Julius Goryavsky added a comment -

            Fix merged with head revision: https://github.com/MariaDB/server/commit/a6b7203d6564728089df66231739e0cc77b039d7

            sysprg Julius Goryavsky added a comment - Fix merged with head revision: https://github.com/MariaDB/server/commit/a6b7203d6564728089df66231739e0cc77b039d7
            sysprg Julius Goryavsky made changes -
            Fix Version/s 10.5.26 [ 29832 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.6.19 [ 29833 ]
            Fix Version/s 10.11.9 [ 29834 ]
            Fix Version/s 11.1.6 [ 29835 ]
            Fix Version/s 11.2.5 [ 29836 ]
            Fix Version/s 11.4.3 [ 29837 ]

            People

              sysprg Julius Goryavsky
              serg Sergei Golubchik
              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.