[CONNECTORS-1092] MySQL load test records errors in log

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 1.7.1
• Fix Version/s: ManifoldCF 1.7.2, ManifoldCF 1.8, ManifoldCF 2.0
• Component/s: Framework core
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 03/Nov/14 11:06
• Updated: 03/Nov/14 17:10
• Resolved: 03/Nov/14 12:25

Description

Apparently there's a lock timeout we aren't catching:

ERROR 2014-11-02 19:49:37,053 (Assessment thread) - Exception tossed: Lock wait timeout exceeded; try restarting transaction
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Lock wait timeout exceeded; try restarting transaction
        at org.apache.manifoldcf.core.database.DBInterfaceMySQL.reinterpretException(DBInterfaceMySQL.java:136)
        at org.apache.manifoldcf.core.database.DBInterfaceMySQL.performQuery(DBInterfaceMySQL.java:879)
        at org.apache.manifoldcf.core.database.BaseTable.performQuery(BaseTable.java:221)
        at org.apache.manifoldcf.crawler.jobs.Jobs.assessMarkedJobs(Jobs.java:1949)
        at org.apache.manifoldcf.crawler.jobs.JobManager.assessMarkedJobs(JobManager.java:667)
        at org.apache.manifoldcf.crawler.system.AssessmentThread.run(AssessmentThread.java:65)
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
        at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:1578)
        at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1434)
        at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2925)
        at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:477)
        at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2631)

        at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1800)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2221)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2127)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
        at org.apache.manifoldcf.core.database.Database.execute(Database.java:880)
        at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)