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

Galera cluster slave abort with Assertion `mode_ == m_local || transaction_.is_streaming()' failed despite primary added for all tables

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.20, 10.4.21
    • 10.4.23
    • Galera
    • Centos8

    Description

      Hi, Despite have add Primary Key to all tables, we still encounter the `Assertion `mode_ == m_local || transaction_.is_streaming()' failed.` Galera failure.
      We operate 3 Mariadb Server 10.4.20 nodes (galera-4-26.4.6-1.el8.x86_64). Our aplications reach cluster using maxscale 2.2.9 configured with a read write splite router.

      It seems to be related to a specfic request, ans some times both slaves fails and produce a core:

      mysqld: 
      /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.20/wsrep-lib/include/wsrep/client_state.hpp:668: int wsrep::client_state::bf_abort(wsrep::seqno): Assertion `mode_ == m_local || transaction_.is_streaming()' failed.
      		 
      210802 11:55:00 [ERROR] mysqld got signal 6 ;

      Please found in attachment:

      • the Master general query log rd-devops-sql2.log
      • A Slave core
      • A Slave mysql error log

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25551 Assertion `mode_ == m_local || transaction_.is_streaming()` failed in BF abort

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            jfillatre jordane fillatre created issue -
            jfillatre jordane fillatre made changes -
            Field Original Value New Value
            muhammad.irfan Muhammad Irfan made changes -
            Affects Version/s 10.4.21 [ 26030 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.4 [ 22408 ]
            ramesh Ramesh Sivaraman made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            ramesh Ramesh Sivaraman made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ] Seppo Jaakola [ seppo ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            Labels replication need_feedback replication
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2021-09-30 11:37:03.0 2021-09-30 11:37:03.632
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4.22 [ 26031 ]
            Fix Version/s 10.5.13 [ 26026 ]
            Fix Version/s 10.6.5 [ 26034 ]
            Fix Version/s 10.4 [ 22408 ]
            Assignee Seppo Jaakola [ seppo ] Jan Lindström [ jplindst ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            julien.fritsch Julien Fritsch made changes -
            Labels need_feedback replication replication
            jplindst Jan Lindström (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5.13 [ 26026 ]
            Fix Version/s 10.4.22 [ 26031 ]
            Fix Version/s 10.6.5 [ 26034 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Seppo Jaakola [ seppo ]
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            jplindst Jan Lindström (Inactive) made changes -
            Priority Critical [ 2 ] Blocker [ 1 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 124067 ] MariaDB v4 [ 143702 ]
            mreibert Mark Reibert made changes -
            Attachment reibert_mariadb.service.log [ 61136 ]
            Attachment reibert_mysqld-abort-stacktrace.txt [ 61137 ]
            mreibert Mark Reibert made changes -
            Attachment reibert_mariadb.service-2.log [ 61170 ]
            Attachment reibert_mysqld-abort-stacktrace-2.txt [ 61171 ]
            julien.fritsch Julien Fritsch made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            julien.fritsch Julien Fritsch made changes -
            Status In Progress [ 3 ] Needs Feedback [ 10501 ]
            jplindst Jan Lindström (Inactive) made changes -
            Priority Blocker [ 1 ] Major [ 3 ]
            elenst Elena Stepanova made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2022-02-24 09:11:04.0 2022-02-24 09:11:04.498
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4.23 [ 26807 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 144997 145774 164166 124586

            People

              seppo Seppo Jaakola
              jfillatre jordane fillatre
              Votes:
              3 Vote for this issue
              Watchers:
              14 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.