Not the answer you need?
Register and ask your own question!

Xtradb cluster and assertions failure in file rem0rec : is my schema responsible ?

YoannLaCancelleraYoannLaCancellera EntrantCurrent User Role Novice
Hi,

We encountered crashes with our Xtradb Clusters (5.6.44) : assertions failure in file rem0rec line 580
The exact same situation of https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1589919, the stacktrace is identical


Now, if I can believe the stacktrace it crashed while deleting row, and it looks related to foreign keys stuff

I looked into the schema and noticed :
- I had ~40 tables without primary keys (innodb)
- Some of them even have ON DELETE CASCADE FK constraints

Galera does not support DELETE without primary keys, so it make sense it should not support ON DELETE CASCADE on tables without primary keys ?


It looks like it work (I guess thanks towsrep_certify_nonpk and an internal PK), and we know this kind of queries are being made everyday without apparent issues, but I wonder if this is a valid concern regarding this assertion failure crash



If someone is willing to dig into this crash, I'm available

Thank you,
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.