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

deadlocks after upgrade from 10.4.12 to 10.5.4

Details

    Description

      A couple of weeks ago we have upgraded our MariaDB + Galera (3 nodes) cluster to the last stable version - 10.5.4. In our configuration, all writes go to 1 node only. And we started facing deadlocks (gap locking) issue on that node. Nothing was changed from the DB side except upgrade and nothing was changed from the application side.

      Could you please advise on this and please let me know what additional information will you require for further investigation?

      Thank you.

      Attachments

        1. galera_error_log_part.log
          274 kB
        2. galera_error.log_2node.gz
          4.17 MB
        3. galera_error.log_3node.gz
          4.88 MB
        4. galera.cnf
          5 kB
        5. screenshot-1.png
          screenshot-1.png
          1.23 MB

        Activity

          sun4ezzz Aleksandr Omelchuk created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Component/s Galera [ 10124 ]
          Fix Version/s 10.5 [ 23123 ]
          Assignee Jan Lindström [ jplindst ]
          sun4ezzz Aleksandr Omelchuk made changes -
          Description A couple of weeks ago we have upgraded our MariaDB + Galera (3 nodes) cluster to the last stable version - 10.5.4. And we started facing deadlocks (gap locking) issue. Nothing was changed from the DB side except upgrade and nothing was changed from the application side.

          Could you please advise on this and please let me know what additional information will you require for further investigation?

          Thank you.
          A couple of weeks ago we have upgraded our MariaDB + Galera (3 nodes) cluster to the last stable version - 10.5.4. In our configuration, all writes go to 1 node only. And we started facing deadlocks (gap locking) issue on that node. Nothing was changed from the DB side except upgrade and nothing was changed from the application side.

          Could you please advise on this and please let me know what additional information will you require for further investigation?

          Thank you.
          jplindst Jan Lindström (Inactive) made changes -
          Labels upgrade need_feedback upgrade
          sun4ezzz Aleksandr Omelchuk made changes -
          Attachment galera_error_log_part.log [ 52980 ]
          Attachment galera.cnf [ 52981 ]
          jplindst Jan Lindström (Inactive) made changes -
          Labels need_feedback upgrade upgrade
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s N/A [ 14700 ]
          Fix Version/s 10.5 [ 23123 ]
          Resolution Not a Bug [ 6 ]
          Status Open [ 1 ] Closed [ 6 ]
          jplindst Jan Lindström (Inactive) made changes -
          Resolution Not a Bug [ 6 ]
          Status Closed [ 6 ] Stalled [ 10000 ]
          sun4ezzz Aleksandr Omelchuk made changes -
          Attachment galera_error.log_2node.gz [ 53241 ]
          Attachment galera_error.log_3node.gz [ 53242 ]
          sun4ezzz Aleksandr Omelchuk made changes -
          Attachment screenshot-1.png [ 53245 ]
          jplindst Jan Lindström (Inactive) made changes -
          Labels upgrade need_feedback upgrade
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2020-09-14 09:00:58.0 2020-09-14 09:00:58.59
          jplindst Jan Lindström (Inactive) made changes -
          Resolution Cannot Reproduce [ 5 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 111722 ] MariaDB v4 [ 158148 ]

          People

            jplindst Jan Lindström (Inactive)
            sun4ezzz Aleksandr Omelchuk
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.