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

Select sequence next value crash a cluster

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.16
    • 10.6, 10.11
    • Sequences
    • None

    Description

      Our architecture is 3-node galera cluster - 2 DB nodes + 1 arbitrator in different locations. Plus running haproxy as the front end.

      One of the DB nodes (node 2) hit signal 6. The error log shows a SQL shortly after this error:
      Query (0x7fc6243ba4b0): select nextval(noti_msg_seq) into @nextSeq from dual

      Please advise the cause and fix. Thanks!

      I'm going to upload the MariaDB error log at both nodes for your review.

      Attachments

        Activity

          LawrenceMan Lawrence Man created issue -
          LawrenceMan Lawrence Man made changes -
          Field Original Value New Value
          Description Our architecture is 3-node galera cluster - 2 DB nodes + 1 arbitrator in different locations. Plus running haproxy as the front end.

          One of the DB nodes (node 2) hit signal 6. The error log shows a SQL shortly after this error:
          Query (0x7fc6243ba4b0): select nextval(noti_msg_seq) into @nextSeq from dual

          Please advise the cause and fix. Thanks!

          I'm going to upload the MariaDB error log at both nodes for your review.
          LawrenceMan Lawrence Man made changes -
          Attachment mariadb-error-node1.log [ 74411 ]
          LawrenceMan Lawrence Man made changes -
          Attachment mariadb-error-node2.log [ 74412 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.6 [ 24028 ]
          Fix Version/s 10.11 [ 27614 ]
          serg Sergei Golubchik made changes -
          Assignee Jan Lindström [ JIRAUSER53125 ]

          People

            janlindstrom Jan Lindström
            LawrenceMan Lawrence Man
            Votes:
            1 Vote for this issue
            Watchers:
            3 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.