You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (JIRA)" <ji...@apache.org> on 2014/11/25 11:12:13 UTC
[jira] [Resolved] (CONNECTORS-1114) SQL exception calling
deleteDocument()
[ https://issues.apache.org/jira/browse/CONNECTORS-1114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-1114.
-------------------------------------
Resolution: Fixed
> SQL exception calling deleteDocument()
> --------------------------------------
>
> Key: CONNECTORS-1114
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1114
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework crawler agent
> Affects Versions: ManifoldCF 1.7.2
> Reporter: Karl Wright
> Assignee: Karl Wright
> Fix For: ManifoldCF 1.8, ManifoldCF 2.0
>
>
> Calling removeDocument(identifier) causes the following exception to be thrown:
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)