Set session lock_wait_timeout value to its default value before executing FTWRL

Bug #1410339 reported by Alexey Kopytov on 2015-01-13
6
This bug affects 1 person
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-lock-wait-timeout, for example.

Related branches

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers