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

    XMLWordPrintable

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

        1. mariadb1_mysql_error.log
          486 kB
          jordane fillatre
        2. mariadb1-10.4.20-core.232870.gz
          7.54 MB
          jordane fillatre
        3. reibert_mariadb.service.log
          453 kB
          Mark Reibert
        4. reibert_mariadb.service-2.log
          3.31 MB
          Mark Reibert
        5. reibert_mysqld-abort-stacktrace.txt
          401 kB
          Mark Reibert
        6. reibert_mysqld-abort-stacktrace-2.txt
          368 kB
          Mark Reibert

        Issue Links

          Activity

            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.