Not the answer you need?
Register and ask your own question!

Random deadlocks in read-only tables in Percona XtraDB Cluster

ofriasofrias ContributorInactive User Role Novice
Hi.

We are seeing random deadlock errors when reading data from tables which are not being modified at the time of the select (they are updated only in nightly maintenance tasks). How is this possible? I thought deadlocks could only happen when there was some modification, but not when only reading, even if there is concurrent reading as is our case.
The exact error message is "WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction".
We are using a PXC with 2 nodes and:

wsrep_retry_autocommit=5 wsrep_drupal_282555_workaround=ON Percona Server version: 5.7.17-11-57-log - Percona XtraDB Cluster (GPL), Release rel11, Revision e2a7fdd, WSREP version 27.20, wsrep_27.20
How can we fix this?

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    I would suggest to set wsrep_debug=ON and then share the error log here as soon as you can reproduce the issue. sharing your my.cnf will help as well.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.