Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug] deadlocks on operator database creation attempts #1126

Open
vixns opened this issue Jan 16, 2025 · 1 comment · May be fixed by #1127
Open

[Bug] deadlocks on operator database creation attempts #1126

vixns opened this issue Jan 16, 2025 · 1 comment · May be fixed by #1127
Labels
bug Something isn't working

Comments

@vixns
Copy link
Contributor

vixns commented Jan 16, 2025 •
edited
Loading

Documentation

  • [ x] I acknowledge that I have read the relevant documentation.

Describe the bug

During database contents import, "CREATE DATABASE IF NOT EXISTS..." raise a deadlock

Expected behaviour

No Deadlocks!

Steps to reproduce the bug

  1. run a big database sql import
  2. wait for the operator to reconcile Database resource
  3. deadlock, import fails

Tested on MariaDB 10.11 Galera clusters using a migration script from a spring + hibernate java app. The mariadb user does not have LOCK privilege, that's not an issue about using locks with galera clusters.
@vixns vixns added the bug Something isn't working label Jan 16, 2025
@vixns vixns linked a pull request Jan 16, 2025 that will close this issue
Open
@vixns vixns changed the title [Bug] dedlocks on operator database creation attempts [Bug] deadlocks on operator database creation attempts Jan 16, 2025
@vixns
Copy link
Contributor Author

vixns commented Jan 16, 2025

https://stackoverflow.com/questions/6169263/mysqls-create-database-if-not-exists-misbehaves-when-database-has-live-connec

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

prevent deadlocks on database reconcile while transactions are running vixns/mariadb-operator
1 participant
@vixns