When I run any procedure on my percona xtradb cluster 8.0. someimes
I got the error.
Deadlock found when trying to get lock; try restarting transaction.
and did not allow to run the mysql procedure.
any idea.
Thanks in advance.
When I run any procedure on my percona xtradb cluster 8.0. someimes
I got the error.
Deadlock found when trying to get lock; try restarting transaction.
and did not allow to run the mysql procedure.
any idea.
Thanks in advance.
Hi, have a look at https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_print_all_deadlocks option. This should give you some pointers in the error log to identify the conflicting transactions.
Also check awesome tool that helped me: pt-deadlock-logger
.
With it I was able to fast solve all deadlock problems .
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.