Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Assertion failure in file rem0rec.cc : line 580, is it schema related ?

Description

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-x...r/+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 to wsrep_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

(this is a repost of my forum entry, sorry for duplicatas)

Thank you,

Environment

None

Attachments

1

Smart Checklist

Activity

Show:
Incomplete

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created August 22, 2019 at 8:52 AM
Updated March 6, 2024 at 10:07 PM
Resolved April 4, 2020 at 10:56 AM
Loading...