Mysql gem reporting deadlock

Andrew_Arrow · 17 August 2007 00:14

I posted this message on the mysql forum:

and the ruby code in question uses the mysql-2.7 gem directly. Not
using active record.

When the deadlock occurs it takes about 2 mins and times out with an
error.

But if the run the same SQL in mysql console with two sessions, I get a
deadlock error right away.

Is there a way to make the ruby mysql gem return the deadlock error
without the 2 min wait?

Thanks.

···

Topic		Replies	Views
Threading and the MySQL ruby-talk	4	55	23 September 2006
Problem with threading mysql queries in ruby ruby-talk	1	123	26 October 2002
Mechanize MySQL and threads - deadlock? ruby-talk	1	127	26 February 2010
Mysql gem memory leak ruby-talk	1	70	19 June 2009
Frustrated: System call timeouts ruby-talk	10	105	11 September 2008