MySQL Forums
Forum List  »  Connector/JDBC and Java

Database dead lock
Posted by: jacques couzteau
Date: May 11, 2009 04:50PM

Ocassionally my database locks up and all write requests fail either with
2009-05-09 04:33:45,197 INFO [STDOUT] 2009-05-09 04:33:45,197 WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1317, SQLState: 70100
2009-05-09 04:33:45,197 INFO [STDOUT] 2009-05-09 04:33:45,197 ERROR [org.hibernate.util.JDBCExceptionReporter] - Query execution was interrupted
2009-05-09 04:33:45,207 ERROR [STDERR] org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [select distinct ...


SQL Error: 1205, SQLState: 41000
2009-05-09 13:09:42,917 INFO [STDOUT] 2009-05-09 13:09:42,917 ERROR [org.hibernate.util.JDBCExceptionReporter] - Lock wait timeout exceeded; try restarting transaction

Read access still works fine. These errors started occuring after I migrated to new Hardware. At the same time I updated the mysqld version from 5.0.45 to 5.0.67

I'm not sure if there is a connection with the hardware / software upgrade though.

I use the JDBC driver 5.1.6, The app is hosted in JBoss 4.2.2GA running on Redhat 4.

I see error 1317, SQLState: 70100 increasingly often in my logfiles.

What can I do to find out what is happening?

Restarting JBoss fixes the problem temporarily. Currently this problem limits my uptime to a few days.

Is it likely the the problem occurs due to lacking resources to register transactions?

I really don't know where to start with this problem, all suggestions welcome.



Options: ReplyQuote

Written By
Database dead lock
May 11, 2009 04:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.