Re: Avoiding deadlock: beyond the basics

2005-04-28 Thread Gleb Paharenko
Hello. The output of INNODB MONITOR is not clear for me (I hope only for me, and someone more skilled could correct me). At: http://dev.mysql.com/doc/mysql/en/innodb-locks-set.html it is said that, SELECT ... FROM is a consistent read, reading a snapshot of the database and setting no l

Avoiding deadlock: beyond the basics

2005-04-27 Thread Søren Ragsdale
I've been getting the following error in my Python program which accesses InnoDB tables: OperationalError: 1213 Deadlock found when trying to get lock; try restarting transaction I've already tried all the basic steps that the documentation seems to recommend: - Set my TRANSACTION ISOLATIO