No such thing as a small change | |
PerlMonks |
Re: fetchrow_hashref failed problemby vinoth.ree (Monsignor) |
on Jul 21, 2015 at 05:46 UTC ( [id://1135531]=note: print w/replies, xml ) | Need Help?? |
If you are using InnoDB or any row-level transactional RDBMS, then it is possible that any write transaction can cause a deadlock, even in perfectly normal situations. Larger tables, larger writes, and long transaction blocks will often increase the likelihood of deadlocks occurring. The only way to truly handle deadlocks is to write your code to expect them. This generally is not very difficult if your database code is well written. Often you can just put a try/catch around the query execution logic and look for a deadlock when errors occur. If you catch one, the normal thing to do is just attempt to execute the failed query again. Read How to Cope with Deadlocks Source from Working around MySQL error "Deadlock found when trying to get lock; try restarting transaction" All is well. I learn by answering your questions...
In Section
Seekers of Perl Wisdom
|
|