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

Deadlock failure that does not occur elsewhere

Details

    Description

      MariaDB gets the following deadlock error:

      localhost-dir: sql_create.c:837-5 Fill File table Query failed: INSERT INTO File
      (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
      batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat,
      batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN
      Filename ON (batch.Name = Filename.Name): ERR=Deadlock found when trying to get
      lock;

      When running the Bacula 9.0.1 regression script named: three-pool-virtual-test
      This does not occur on any version of MySQL, nor the Ubuntu version 10.0 of MariaDB. The code has been stable for many years.

      I am running all instances of MariaDB and MySQL out of the box. I have changed no parameters.

      This appears to be a false deadlock detection. Note, it is 100% reproducible.

      Attachments

        1. mariadb-bug
          1 kB
        2. mdev13333.test
          2 kB
        3. output_b
          6.44 MB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16067 Invalid deadlock detection

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16709 InnoDB: Error: trx already had an AUTO-INC lock

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17561 Deadlocks happen often when updating different rows

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11080 InnoDB: Failing assertion: table->n_waiting_or_granted_auto_inc_locks > 0

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            kern Kern Sibbald created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Labels need_feedback
            kern Kern Sibbald made changes -
            Attachment mariadb-bug [ 43862 ]
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Assignee Alice Sherepa [ alice ]
            alice Alice Sherepa made changes -
            Attachment output_b [ 43865 ]
            alice Alice Sherepa made changes -
            Attachment output_b [ 43866 ]
            alice Alice Sherepa made changes -
            Attachment output_b [ 43867 ]
            alice Alice Sherepa made changes -
            Attachment output_b [ 43867 ]
            alice Alice Sherepa made changes -
            Attachment output_b [ 43865 ]
            alice Alice Sherepa made changes -
            Attachment mdev13333.test [ 43870 ]
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Component/s Locking [ 10900 ]
            Fix Version/s 10.2 [ 14601 ]
            Assignee Alice Sherepa [ alice ] Sergey Vojtovich [ svoj ]
            elenst Elena Stepanova made changes -
            alice Alice Sherepa made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            alice Alice Sherepa made changes -
            Assignee Sergey Vojtovich [ svoj ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.1.36 [ 23117 ]
            Fix Version/s 10.2.18 [ 23112 ]
            Fix Version/s 10.3.10 [ 23140 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Affects Version/s 10.3.6 [ 23003 ]
            Affects Version/s 10.2.14 [ 22911 ]
            Affects Version/s 10.1.32 [ 22908 ]
            Affects Version/s 10.2.7 [ 22543 ]
            marko Marko Mäkelä made changes -
            Labels regression
            marko Marko Mäkelä made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            akalantari Ali Kalantari made changes -
            marko Marko Mäkelä made changes -
            Support case ID 25849
            marko Marko Mäkelä made changes -
            Affects Version/s 10.3.0 [ 22127 ]
            Affects Version/s 10.2.2 [ 22013 ]
            Affects Version/s 10.2.14 [ 22911 ]
            Affects Version/s 10.3.6 [ 23003 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 81683 ] MariaDB v4 [ 152493 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 187207

            People

              jplindst Jan Lindström (Inactive)
              kern Kern Sibbald
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.