Database dead lock

[jacques couzteau]

Hi,
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 ...

or

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.

Thanks

Jacques