[
https://issues.apache.org/jira/browse/CONNECTORS-1092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14194440#comment-14194440
]
Karl Wright commented on CONNECTORS-1092:
-----------------------------------------
This is from the filesystem load test.
> MySQL load test records errors in log
> -------------------------------------
>
> Key: CONNECTORS-1092
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1092
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework core
> Affects Versions: Manifold 1.7.1
> Reporter: Karl Wright
> Assignee: Karl Wright
> Fix For: ManifoldCF 1.8, ManifoldCF 2.0
>
>
> Apparently there's a lock timeout we aren't catching:
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
