[MDEV-18562] [ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2.16
Fix Version/s: 10.2.28, 10.3.19, 10.4.9
Component/s: Galera
Labels:
Environment:
Ubuntu 18.04

Description

Hello.

we are occasionally receiving error:

[ERROR] InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `schema`.`child_table`;

What could be the cause for such error?
Is there any way to trace this issue?

Thanks for answer.

Regards,
Marko

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

error.log
2019-09-25 20:22
7 kB
Mark Ruys
mysql.tar.gz
2019-09-25 20:20
4 kB
Mark Ruys
st_monitor_20190925_2208CEST.sql
2019-09-25 20:19
0.7 kB
Mark Ruys

Issue Links

relates to

MDEV-26062 InnoDB: WSREP: referenced FK check fail: Lock wait index `PRIMARY` table `schema`.`child_table`

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Marko

Votes:: 2 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 2019-02-12 20:05

Updated:: 2021-07-15 11:21

Resolved:: 2019-10-30 08:17

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.