[CONNECTORS-1114] SQL exception calling deleteDocument()

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 1.7.2
• Fix Version/s: ManifoldCF 1.8, ManifoldCF 2.0
• Component/s: Framework crawler agent
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 25/Nov/14 09:41
• Updated: 25/Nov/14 10:12
• Resolved: 25/Nov/14 10:12

Description

Calling removeDocument(identifier) causes the following exception to be thrown:

2014-11-25 08:30:07,868 ERROR [Worker thread '1'] org.apache.manifoldcf.crawlerthreads: Worker thread aborting and restarting due to database connection reset: Database exception: SQLException doing query (HY0000): You need to set exactly 3 parameters on the prepared statement
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (HY0000): You need to set exactly 3 parameters on the prepared statement
    at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.finishUp(Database.java:702)
    at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:728)
    at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:762)
    at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1435)
    at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146)
    at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:191)
    at org.apache.manifoldcf.core.database.DBInterfaceMySQL.performQuery(DBInterfaceMySQL.java:875)
    at org.apache.manifoldcf.core.database.BaseTable.performQuery(BaseTable.java:221)
    at org.apache.manifoldcf.agents.incrementalingest.IncrementalIngester.findRowIdsForDocIds(IncrementalIngester.java:1518)
    at org.apache.manifoldcf.agents.incrementalingest.IncrementalIngester.documentRemoveMultiple(IncrementalIngester.java:1377)
    at org.apache.manifoldcf.agents.incrementalingest.IncrementalIngester.documentRemove(IncrementalIngester.java:803)
    at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.removeDocument(WorkerThread.java:1674)
    at com.example.mcf.TestConnector.processDocuments(TestConnector.java:278)
    at org.apache.manifoldcf.crawler.connectors.BaseRepositoryConnector.processDocuments(BaseRepositoryConnector.java:670)
    at org.apache.manifoldcf.crawler.connectors.BaseRepositoryConnector.processDocuments(BaseRepositoryConnector.java:649)
    at org.apache.manifoldcf.crawler.connectors.BaseRepositoryConnector.processDocuments(BaseRepositoryConnector.java:402)
    at org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:380)
Caused by: java.sql.SQLException: You need to set exactly 3 parameters on the prepared statement
    at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149)
    at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
    at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264)
    at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288)
    at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:302)
    at org.mariadb.jdbc.MySQLPreparedStatement.executeQuery(MySQLPreparedStatement.java:112)
    at org.apache.manifoldcf.core.database.Database.execute(Database.java:880)
    at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)
Caused by: org.mariadb.jdbc.internal.common.QueryException: You need to set exactly 3 parameters on the prepared statement