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

MariaDB-Galera 10.4.8 | Transaction aborted | Sig 6 Shutdown

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.4.8
    • 10.4.13, 10.5.3
    • wsrep
    • CentOS 7 / MariaDB, Galera

    Description

      During daily business we've noticed a sudden crash of some of our MariaDB-Clusters members . It seems like we've hit some kind of assertion error which led to MariaDB shutting down.

      E.g.:

      /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.8/wsrep-lib/src/client_state.cpp:235: int wsrep::client_state::after_statement(): Assertion `transaction_.state() == wsrep::transaction::s_aborted' failed.

      Attached the appropriate parts of the messages log.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jplindst Jan Lindström (Inactive) added a comment -

          Hi, could you please provide show create table for table where original operation is done and definition of the trigger that causes the crash.

          jplindst Jan Lindström (Inactive) added a comment - Hi, could you please provide show create table for table where original operation is done and definition of the trigger that causes the crash.
          fstrankowskiwt Florian Strankowski added a comment -

          Here you go:

          CREATE TABLE `lease4_stat` (
          		 
            `subnet_id` int(10) unsigned NOT NULL,
          		 
            `state` int(10) unsigned NOT NULL,
          		 
            `leases` bigint(20) DEFAULT NULL,
          		 
            PRIMARY KEY (`subnet_id`,`state`)
          		 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8

          fstrankowskiwt Florian Strankowski added a comment - Here you go: CREATE TABLE `lease4_stat` ( `subnet_id` int (10) unsigned NOT NULL , `state` int (10) unsigned NOT NULL , `leases` bigint (20) DEFAULT NULL , PRIMARY KEY (`subnet_id`,`state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
          jplindst Jan Lindström (Inactive) added a comment -

          Thanks, can you provide that trigger definition also ?

          jplindst Jan Lindström (Inactive) added a comment - Thanks, can you provide that trigger definition also ?
          fstrankowskiwt Florian Strankowski added a comment - - edited

          I cannot provide any triggers because i do not have any in this database table.

          fstrankowskiwt Florian Strankowski added a comment - - edited I cannot provide any triggers because i do not have any in this database table.
          jplindst Jan Lindström (Inactive) added a comment -

          Somewhere is trigger like: UPDATE lease4_stat SET leases = leases - 1 WHERE subnet_id = OLD.subnet_id AND state = OLD.state

          jplindst Jan Lindström (Inactive) added a comment - Somewhere is trigger like: UPDATE lease4_stat SET leases = leases - 1 WHERE subnet_id = OLD.subnet_id AND state = OLD.state
          marko Marko Mäkelä added a comment -

          https://github.com/MariaDB/server/pull/1454 should address this.

          marko Marko Mäkelä added a comment - https://github.com/MariaDB/server/pull/1454 should address this.

          People

            jplindst Jan Lindström (Inactive)
            fstrankowskiwt Florian Strankowski
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.