[ https://issues.apache.org/jira/browse/CONNECTORS-583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-583. ------------------------------------ Resolution: Fixed > MySQL locks time out and are not caught > --------------------------------------- > > Key: CONNECTORS-583 > URL: https://issues.apache.org/jira/browse/CONNECTORS-583 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Affects Versions: ManifoldCF 1.0.1 > Reporter: Karl Wright > Assignee: Karl Wright > Fix For: ManifoldCF 1.1 > > > MySQL locks time out and are not caught. The SQL code is 41000. Here's the > exception: > 012/12/07 23:08:14 ERROR (Stuffer thread) - Stuffer thread aborting and > restarting due to database connection reset: Database exception: SQLException > doing query (41000): Lock wait timeout exceeded; try restarting transaction > org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database > exception: SQLException doing query (41000): Lock wait timeout exceeded; try > restarting transaction > at > org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:681) > at > org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:709) > at > org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1394) > at > org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) > at > org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:186) > at > org.apache.manifoldcf.core.database.DBInterfaceMySQL.performQuery(DBInterfaceMySQL.java:882) > at > org.apache.manifoldcf.crawler.jobs.JobManager.fetchAndProcessDocuments(JobManager.java:2260) > at > org.apache.manifoldcf.crawler.jobs.JobManager.getNextDocuments(JobManager.java:2066) > at > org.apache.manifoldcf.crawler.system.StufferThread.run(StufferThread.java:157) > 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.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) > at > org.apache.manifoldcf.core.database.Database.execute(Database.java:826) > at > org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:641) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira