[MDEV-20616] MariaDB-Galera 10.4.8 | Transaction aborted | Sig 6 Shutdown Created: 2019-09-18  Updated: 2021-10-04  Resolved: 2020-05-19

Status: Closed
Project: MariaDB Server
Component/s: wsrep
Affects Version/s: 10.4.8
Fix Version/s: 10.4.13, 10.5.3

Type: Bug Priority: Critical
Reporter: Florian Strankowski Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: galera
Environment:

CentOS 7 / MariaDB, Galera

Attachments: Text File mariadb-crash.txt    

 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.

 Comments   
Comment by Jan Lindström (Inactive) [ 2019-09-18 ]

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

Comment by Florian Strankowski [ 2019-09-18 ]

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

Comment by Jan Lindström (Inactive) [ 2019-09-18 ]

Thanks, can you provide that trigger definition also ?

Comment by Florian Strankowski [ 2019-09-18 ]

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

Comment by Jan Lindström (Inactive) [ 2019-09-18 ]

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

Comment by Marko Mäkelä [ 2020-03-02 ]

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

Generated at Thu Feb 08 09:00:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.