[MDEV-18032] MDEV-15611 apparently still occuring with MariaDB 10.2.16 Created: 2018-12-19  Updated: 2021-05-02  Resolved: 2019-03-18

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.2.16
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Hartmut Holzgraefe Assignee: Jan Lindström (Inactive)
Resolution: Incomplete Votes: 0
Labels: need_feedback

Issue Links:
Relates
relates to MDEV-15611 Due to the failure of foreign key det... Closed

 Description   

Still seen on a MariaDB 10.2.16 instance, although it was supposed to be fixed with 10.2.15

"Could not execute Delete_rows_v1 event on table ...; Cannot delete or update a parent row: a foreign key constraint fails"

and node being shut down after four failed retries.

 Comments   
Comment by Jan Lindström (Inactive) [ 2019-02-08 ]

I could not yet repeat the issue so I would need some additional information from the customer.

(1) galera configuration
(2) show create table bamboo-gs.VCS_LOCATION;
(3) REFERENCES VCS_LOCATION (`VCS_LOCATION_ID`)) looks like a self reference is that true ?
(4) When this problem happened did user check from effected node
database is there really offending row that would cause delete to fail ?
(6) what is value of wsrep_sync_wait configuration variable ?

Generated at Thu Feb 08 08:40:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.