Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4.8, 10.4.10
-
Ubuntu 16
Description
Hi,
Since we are using MariaDB 10.4.8 we've been getting several issues. We have a cluster of 3 nodes with Galera. In the last week, we've got some crashes everyday. Yesterday, we experienced a crash every 5 mins that usually meant two severs down.
For this reason, we upgraded to 10.4.10 to see if this version patched anything related to our crashes. However, we again were in the same escenario.
Finally, we had to perform a rollback to an older version: 10.2.29. And since yesterday we do not have any crashes.
I'm attaching logs from 10.4.8 and 10.4.10 that were continuously crashing. Everytime same traces. We cannot reproduce this again as we are in production and need stability, so we are not in that version again, a bit worried to upgrade again in a near future.
Some key lines in the logs:
For 10.4.8:
Nov 20 13:55:04 be61 mysqld[46559]: mysqld: /home/buildbot/buildbot/build/mariadb-10.4.8/wsrep-lib/src/transaction.cpp:951: void wsrep::transaction::after_replay(const wsrep::transaction&): Assertion `other.state() == s_committed || other.state() == s_aborted' failed.
|
Nov 20 13:55:04 be61 mysqld[46559]: 191120 13:55:04 [ERROR] mysqld got signal 6 ;
|
For 10.4.10:
Nov 20 19:45:52 be60 mysqld[3322]: mysqld: /home/buildbot/buildbot/build/mariadb-10.4.10/wsrep-lib/src/transaction.cpp:1038: void wsrep::transaction::after_replay(const wsrep::transaction&): Assertion `other.state() == s_committed || other.state() == s_aborted' failed.
|
Nov 20 19:45:52 be60 mysqld[3322]: 191120 19:45:52 [ERROR] mysqld got signal 6 ;
|
Do you need any more information?
Attachments
Issue Links
- duplicates
-
MDEV-20793 Server crash, Assertion `other.state() == s_committed || other.state() == s_aborted' failed
- Closed
- relates to
-
MDEV-20222 Update or clarify documentation regarding mysql_upgrade and datadir permissions.
- Closed
I confirm
this error takes place to be
we have assembled a cluster of 3 servers as well, only on Centos 7
Mariadb version 10.4.10
at 4 am one of the servers crashed with an error:
Dec 4 04:07:51 mysql1 mysqld: mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.10/wsrep-lib/src/transaction.cpp:1038: void wsrep::transaction::after_replay(const wsrep::transaction&): Assertion `other.state() == s_committed || other.state() == s_aborted' failed.
Dec 4 04:07:51 mysql1 mysqld: 191204 4:07:51 [ERROR] mysqld got signal 6 ;
After the error, mysql itself restarted and connected to the cluster, but its status changed to:
we did not update from old versions
originally built the cluster on version 10.4.10
PS there are no other errors preceding this failure.