My application is designed to avoid concurency rows locking. It means that I
should never access two rows at the same time during a transaction. I also
get an error messgage when I insert a row. Here is the error message I get:
java.sql.SQLException: General error, message from server: "Deadlock found
when trying to get lock; Try restarting transaction"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1628)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
at com.mysql.jdbc.Connection.execSQL(Connection.java:1809)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:207)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:207)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:504)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:444)
at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:717)
at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:605)
at ...
What is important to kwown I have 1,6 GB of data distributed into CLOB
(longtext) and BLOB (longblob) that correspond to ~25'000 entries and a
create or access this data during my tests.
What is exactly the problem ?
Regards. Yvan
-----Original Message-----
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: lundi, 20. octobre 2003 15:03
To: [EMAIL PROTECTED]
Subject: Re: Lock wait timeout exceeded problem
Hess Yvan <[EMAIL PROTECTED]> wrote:
> I am doing a lot of inserts, updates and reads with big among of data into
> longtext and longblob fields using JDBC driver and mysql 4.0.15 for
Windows
> with innodb tables.
> After 1 hours of intensive working the database sent me a message "Lock
wait
> timeout exceeded; Try restarting transaction" SQL code: 1205".
> I doing know how I can solve this problem ? How I have do configure mysql
or
> is it a bug ?
>
> Environment:
>
> 6 Java Virtual machine using each their own connections pool.
> O/R mapping is done with Hibernate version 2.0.
>
You can increase value of innodb_lock_wait_timeout variable:
http://www.mysql.com/doc/en/InnoDB_start.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
