percona-xtrabackup icon indicating copy to clipboard operation
percona-xtrabackup copied to clipboard

Published 20 hours ago • verified publisher icon percona

PXB-2809 wsrep_sync_wait<>0 causes Lock wait timeout exceeded; try re…

Open rahulmalik87 opened this issue 2 years ago • 5 comments

…starting transaction

https://jira.percona.com/browse/PXB-2809

Problem: wsrep_sync_wait<>0 causes Lock wait timeout exceeded; try restarting transaction

Fix: SET SESSION wsrep_sync_wait=0 right after connection to PXC

rahulmalik87 avatar Jul 07 '22 14:07 rahulmalik87

Hi @rahulmalik87, as mentioned by @altmannmarcelo in https://github.com/percona/percona-xtrabackup/pull/1370 the extra call to wsrep_causal_reads must also be removed, because it is no longer supported in recent versions (and leads to an unrecoverable error).

fraenki avatar Sep 26 '22 10:09 fraenki

Hi @rahulmalik87, as mentioned by @altmannmarcelo in #1370 the extra call to wsrep_causal_reads must also be removed, because it is no longer supported in recent versions (and leads to an unrecoverable error).

Thnak you @fraenki for the feedback. I have removed wsrep_casual_reads from 8.0

rahulmalik87 avatar Sep 30 '22 07:09 rahulmalik87

@rahulmalik87 did we check if GR also has a similar configuration?

Also please ensure we can run this in any pxc_strict_mode (should not be an issue, but worth checking)

Thanks @altmannmarcelo for suggestion. I have added group-replication-consistency=EVENTUAL , which could help us to avoid lock wait.

rahulmalik87 avatar Sep 30 '22 07:09 rahulmalik87

@rahulmalik87 did we check if GR also has a similar configuration? Also please ensure we can run this in any pxc_strict_mode (should not be an issue, but worth checking)

Thanks @altmannmarcelo for suggestion. I have added group-replication-consistency=EVENTUAL , which could help us to avoid lock wait.

@rahulmalik87 Are you yet to update PR ? the changes about wserp_casual_reads and consistency=EVENTUAL are not yet visible.

satya-bodapati avatar Sep 30 '22 09:09 satya-bodapati

@rahulmalik87 did we check if GR also has a similar configuration? Also please ensure we can run this in any pxc_strict_mode (should not be an issue, but worth checking)

Thanks @altmannmarcelo for suggestion. I have added group-replication-consistency=EVENTUAL , which could help us to avoid lock wait.

@rahulmalik87 Are you yet to update PR ? the changes about wserp_casual_reads and consistency=EVENTUAL are not yet visible.

That is only applicable for 8.0. https://github.com/percona/percona-xtrabackup/pull/1374

rahulmalik87 avatar Sep 30 '22 11:09 rahulmalik87