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

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

zsebacsizsebacsi EntrantCurrent User Role Beginner
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?



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.