Lock wait timeout exceeded

[Ryan Lado, modificado hace 12 años.]

Hi All,

I am getting this error on my logs. Is there anyone encounter this error before?
Thanks.

20:04:44,826 ERROR [ErrorLogger:2166] An error occured while firing trigger 'com.liferay.portlet.blogs.messaging.Linkba
ckMessageListener.com.liferay.portlet.blogs.messaging.LinkbackMessageListener'
org.quartz.JobPersistenceException: Couldn't store trigger 'com.liferay.portlet.blogs.messaging.LinkbackMessageListener
' for 'com.liferay.portlet.blogs.messaging.LinkbackMessageListener' job:Lock wait timeout exceeded; try restarting tran
saction [See nested exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1241)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2932)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$38.execute(JobStoreSupport.java:2842)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2836)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:339)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTrigger(StdJDBCDelegate.java:1295)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1227)
... 5 more
20:49:44,792 ERROR [ErrorLogger:2166] An error occured while firing trigger 'com.liferay.portlet.blogs.messaging.Linkba
ckMessageListener.com.liferay.portlet.blogs.messaging.LinkbackMessageListener'

[Bijan Vakili, modificado hace 12 años.]

Looks like a fluke. See http://stackoverflow.com/questions/2766785/fixing-lock-wait-timeout-exceeded-try-restarting-transaction-for-a-stuck-my

[Fuad Efendi, modificado hace 7 años.]

Liferay 7 CE GA3 uses weird version of MySQL/MariaDB JDBC driver (probably due to licensing restrictions).

Try to download proper version of JDBC driver directly, and remove Liferay provided drivers. It worked for me with Liferay 7 CE GA3.