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

    • Type: Bug
    • Status: Stalled (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 10.4.20, 10.4.21
    • Fix Version/s: 10.4
    • Component/s: Galera
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              seppo Seppo Jaakola
              Reporter:
              jfillatre jordane fillatre
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration