Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

  1. Bug #1271177
  2. Comment #1

Comment 1 for bug 1271177

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: FTWRL and wsrep_causal_reads

This is not repeatable for 5.6 for 'SHOW' commands but for select.

For 5.5, it is repeatable for 'SHOW' as well.

Regarding blocking on select and failing later with lock_wait_timeout, it needs to be seen if this is intended when the provider on that node has been paused. The behavior of apply and commit monitors with a paused provider needs to be checked.

Also note that this returns ER_LOCK_WAIT_TIMEOUT which can be confusing since changing innodb_lock_wait_timeout has no effect on this behavior, it is the causal_read_timeout (default: 30s) which needs to be changed for this.