Set session lock_wait_timeout value to its default value before executing FTWRL

Bug #1410339 reported by Alexey Kopytov
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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.