i have deadlock in part of system when code tries insert
table.
the exception is:
sqlstate[40001]: serialization failure: 1213 deadlock found when trying lock; try restarting transaction
what thought of doing, right after execute insert
command, i'll use show engine innodb status
, store in table later inspection.
when created table looks output of show engine innodb status
, tried use insert
command insert data, received error.
is there way store show engine innodb status
's output in table further use? or maybe should choose different way deadlocks information need resolve issue?
Comments
Post a Comment