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

Testing and improving 'cluster conflict resolving' with 10.4 and later

Details

    Description

      There are a number of bug reports of cluster wide conflict resolving related crashes or hangs. To troubleshoot these, it would be good to run generic cluster conflict tests, just for easier reproducing of the issue(s).

      Run high intensity write-write conflict load in the cluster, with varying SQL access patterns.
      Also, some mtr tests exercising high priority victim aborting, appear to be disabled in 10.4. Enable these and fix the test if it appears to be non-deterministic.

      Analyze and troubleshoot issues surfacing from the testing.

      Attachments

        1. mysql.err
          1.02 MB
        2. oltp.zz
          2 kB
        3. oltp_and_ddl_v1.yy
          4 kB
        4. bt_all.txt
          115 kB
        5. new.err
          1.21 MB
        6. all_bt_28102022.txt
          116 kB
        7. bt_all_v2.txt
          117 kB
        8. oltp_and_ddl_v2.yy
          3 kB

        Issue Links

          Activity

            seppo Seppo Jaakola created issue -
            jplindst Jan Lindström (Inactive) made changes -
            Field Original Value New Value
            Priority Major [ 3 ] Critical [ 2 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Seppo Jaakola [ seppo ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Due Date 2022-10-10 2022-10-28
            jplindst Jan Lindström (Inactive) made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Ramesh Sivaraman [ JIRAUSER48189 ]
            Roel Roel Van de Paar made changes -
            Summary Testing and improving cluster conflcit resolving with 10.4 and later Testing and improving 'cluster conflict resolving' with 10.4 and later
            ramesh Ramesh Sivaraman made changes -
            Attachment mysql.err [ 66031 ]
            ramesh Ramesh Sivaraman made changes -
            Attachment oltp_and_ddl_v1.yy [ 66032 ]
            Attachment oltp.zz [ 66033 ]
            ramesh Ramesh Sivaraman made changes -
            Attachment bt_all.txt [ 66034 ]
            ramesh Ramesh Sivaraman made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ] Seppo Jaakola [ seppo ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            Attachment new.err [ 66051 ]
            ramesh Ramesh Sivaraman made changes -
            Attachment all_bt_28102022.txt [ 66211 ]
            jplindst Jan Lindström (Inactive) made changes -
            Due Date 2022-10-28 2023-10-28
            ramesh Ramesh Sivaraman made changes -
            Attachment bt_all_v2.txt [ 66857 ]
            ramesh Ramesh Sivaraman made changes -
            Attachment oltp_and_ddl_v2.yy [ 67462 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Seppo Jaakola [ seppo ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Seppo Jaakola [ seppo ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Seppo Jaakola [ seppo ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Jan Lindström [ jplindst ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2023-01-16 05:37:35.0 2023-01-16 05:37:35.695
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4.28 [ 28509 ]
            Fix Version/s 10.5.19 [ 28511 ]
            Fix Version/s 10.6.12 [ 28513 ]
            Fix Version/s 10.7.8 [ 28515 ]
            Fix Version/s 10.8.7 [ 28517 ]
            Fix Version/s 10.9.5 [ 28519 ]
            Fix Version/s 10.10.3 [ 28521 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            People

              jplindst Jan Lindström (Inactive)
              seppo Seppo Jaakola
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.