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

[Warning] WSREP: TO isolation failed for: 1, schema: XXXX, sql: KILL QUERY 1040517. Deadlock error.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.14
    • None
    • Galera, Server
    • None
    • redhat 7 on VMware

    Description

      Our environment is 3-nodes Galera cluster - 2 db nodes + 1 arbitrator. HAProxy passes all DB traffic to one DB. The another DB node is standby.

      during busy time, we found some DB connections were redirected to standby DB node and got many below WSREP deadlock error in standby DB node.

      2024-02-11  2:28:19 1040632 [Warning] WSREP: TO isolation failed for: 1, schema: XXXX, sql: KILL QUERY 1040517. Deadlock error.

      Kindly advise the difference of this WSREP deadlock message and innodb deadlock message?

      Regards,
      William Wong

      Attachments

        Activity

          People

            Unassigned Unassigned
            frelist William Wong
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.