[innobackupex] WSREP detected deadlock/conflict and aborted the transaction.

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

hi
I’m trying to implement a backup solution with innobackupex (we would like to create incremental backups). We have a 3 node galera PXC on mysql 5.7
I’m using a publicly available simple backup script - can’t find the URL right now - which utilizes innobackupex to create the backups

It’s a production environment with around 1TB data and lots of schemas in it.
I used lock-ddl-per-table option, because lock-ddl was stopping the whole system, now I get this error after a few hours:

Error: failed to execute query SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 47098: WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction

tried to google, no luck.

any suggestions where should I start?

T.

2

Hi,
Are any of your big tables partitioned? If so, you may be hitting: [url][PXB-1698] Percona Xtrabackup scanning all rows of partitioned tables when using --lock-ddl-per-table - Percona JIRA and in such case, --lock-ddl-per-table is just unsafe till the bug will be fixed.