Re: Deadlock error

More info.. the transaction isolation level in my.cnf
is set to REPEATABLE-READ.
My google research suggested setting this to
READ-COMMITED, need to review th implications before
changing this.
Also, not sure if this is the source of the problem.
Thanks,
Raj

my.cnf:

# Set the default transaction isolation level. Levels
available are:
# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ,
SERIALIZABLE
transaction_isolation = REPEATABLE-READ

--- Raj <[email protected]> wrote:

> All,
> 
> Getting a deadlock related error intermittently.
> The stack trace is as shown below.
> 
> Torque version: 3.2
> Mysql version: mysql  Ver 14.12 Distrib 5.0.33, for
> apple-darwin8.8.4 (i686) using  EditLine wrapper
> 
> Any hints?
> 
> Thanks,
> Raj
> 
> 
> org.apache.torque.TorqueException:
> java.sql.SQLException: Deadlock found when trying to
> get lock; Try restarting transaction message from
> server: "Lock wait timeout exceeded; try restarting
> transaction"
>         at
>
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:103)
>         at
>
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:639)
>         at
>
org.apache.torque.util.BasePeer.access$000(BasePeer.java:73)
>         at
>
org.apache.torque.util.BasePeer$IOUProcessCallback.process(BasePeer.java:1254)
>         at
>
org.apache.torque.util.BasePeer.processTables(BasePeer.java:1645)
>         at
>
org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1234)
> 
> 
> 
>      
>
____________________________________________________________________________________
> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now. 
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [email protected]
> For additional commands, e-mail:
> [email protected]
> 
> 



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ