deadlock - further information

2006-03-26 Thread Rithish Saralaya
Hello. We have a web application for our intranet, which uses MySQL for db management. The application has a way of logging query errors that are generated in the system. We get a mysql error recorded as - Deadlock found when trying to get lock; try restarting transaction when

Re: deadlock - further information

2006-03-26 Thread Michael Stassen
Rithish Saralaya wrote: snip in 4.1.xx, you can use the my.cnf option innodb_locks_unsafe_for_binlog to make InnoDB to use a consistent read in the SELECT tables in CREATE ... SELECT. Read the caveats about the my.cnf option, though. Thanks. However, whatever is written in

RE: deadlock - further information

2006-03-26 Thread Rithish Saralaya
As 11 4, 4.1.11 is newer than 4.1.4, so this variable is available to you. Gawwddd... I really made an ass of myself that time... :o) Thanks for pointing it out though. 4.1.11 is almost a year old. Have you read the list of bugs fixed since then?

deadlock - further information

2006-03-20 Thread Rithish Saralaya
Hello. We have a web application for our intranet, which uses MySQL for db management. The application has a way of logging query errors that are generated in the system. We get a mysql error recorded as - Deadlock found when trying to get lock; try restarting transaction when one of the files

Re: deadlock - further information

2006-03-20 Thread Heikki Tuuri
Rithish, - Original Message - From: Rithish Saralaya [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, March 20, 2006 10:02 AM Subject: deadlock - further information --=_NextPart_000_0059_01C64C23.16088020 Content-Type: text/plain; charset=iso-8859-1 Content