Set session lock_wait_timeout value to its default value before executing FTWRL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Wishlist
|
Alexey Kopytov | ||
2.2 |
Fix Released
|
Wishlist
|
Alexey Kopytov | ||
2.3 |
Fix Released
|
Wishlist
|
Alexey Kopytov |
Bug Description
On some server the lock_wait_timeout variable can be configured to low values due to application requirements.
Since PXB in most cases has different requirements (for example, failing after 1 second of waiting for FTWRL does not make much sense), it should configure the session value of lock_wait_timeout before executing FTWRL.
The exact value to set to the session variable should be configurable, with 31536000 (1 year) as the default to match the server variable.
Unfortunately, XtraBackup already has the option named --lock-wait-timeout which has a different meaning and is used for the "Improved FLUSH TABLES WITH READ LOCK" feature, so another name should be used for the server's lock_wait_timeout variable. We can name it --server-
Related branches
- Alexey Kopytov (community): Approve
- Diff: 92 lines (+63/-0)
- Alexey Kopytov (community): Approve
- Diff: 92 lines (+63/-0)
tags: | added: low-hanging-fruit |
Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-1011