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

InnoDB: Rollback on timeout #5719

Open
staabm opened this issue May 23, 2023 · 0 comments
Open

InnoDB: Rollback on timeout #5719

staabm opened this issue May 23, 2023 · 0 comments
Labels
Core REDAXO Core related things Enhancement Improvements for existing features

Comments

@staabm
Copy link
Member

staabm commented May 23, 2023

Feature description / Feature Beschreibung
bin heute über folgenden artikel gestolpert:
https://severalnines.com/blog/how-fix-lock-wait-timeout-exceeded-error-mysql/

darin ist beschrieben dass MySQL InnoDB von haus aus bei einem Lock Wait Timeout nur das letzte statement einer transaktion zurückrollt:

This means, by following the default setting, MySQL is not going to fail and rollback the whole transaction, nor retrying again the timed out statement and just process the next statements until it reaches COMMIT or ROLLBACK. This explains why transaction T2 was partially committed!

d.h. das verhalten was man erwarten würde und auch dem ACID modell entspricht tritt per default bei Lock Wait Timeout nicht ein.

-> sollten wir ggf. bei der installation/im setup o.ä. warnen falls hier das innodb_rollback_on_timeout setting falsch eingestellt ist?
@gharlan gharlan added Enhancement Improvements for existing features Core REDAXO Core related things labels Jul 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Core REDAXO Core related things Enhancement Improvements for existing features
Milestone
No milestone
Development

No branches or pull requests
2 participants
@staabm @gharlan