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 2011/09/06 10:28:09 UTC
[jira] [Resolved] (CONNECTORS-249) HSQLDB gets primary key
constraint on multiple job cleanup
[ https://issues.apache.org/jira/browse/CONNECTORS-249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-249.
------------------------------------
Resolution: Fixed
> HSQLDB gets primary key constraint on multiple job cleanup
> ----------------------------------------------------------
>
> Key: CONNECTORS-249
> URL: https://issues.apache.org/jira/browse/CONNECTORS-249
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework core
> Affects Versions: ManifoldCF 0.3
> Reporter: Karl Wright
> Assignee: Karl Wright
> Fix For: ManifoldCF 0.3
>
>
> Create two jobs which overlap. Crawl both of them. Then delete one, and then the other. You will get stack traces like this:
> ERROR 2011-09-02 07:38:26,485 (Delete startup thread) - Exception tossed: integr
> ity constraint violation: unique constraint or index violation; SYS_PK_10121 tab
> le: JOBQUEUE
> org.apache.manifoldcf.core.interfaces.ManifoldCFException: integrity constraint
> violation: unique constraint or index violation; SYS_PK_10121 table: JOBQUEUE
> at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.reinterpretExce
> ption(DBInterfaceHSQLDB.java:587)
> at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performModifica
> tion(DBInterfaceHSQLDB.java:607)
> at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.performUpdate(D
> BInterfaceHSQLDB.java:242)
> at org.apache.manifoldcf.core.database.BaseTable.performUpdate(BaseTable
> .java:88)
> at org.apache.manifoldcf.crawler.jobs.JobQueue.prepareDeleteScan(JobQueu
> e.java:461)
> at org.apache.manifoldcf.crawler.jobs.JobManager.prepareDeleteScan(JobMa
> nager.java:4951)
> at org.apache.manifoldcf.crawler.system.StartDeleteThread.run(StartDelet
> eThread.java:107)
> Caused by: java.sql.SQLException: integrity constraint violation: unique constra
> int or index violation; SYS_PK_10121 table: JOBQUEUE
> at org.hsqldb.jdbc.Util.sqlException(Util.java:255)
> at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStateme
> nt.java:4659)
> at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedState
> ment.java:311)
> at org.apache.manifoldcf.core.database.Database.execute(Database.java:60
> 6)
> at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(D
> atabase.java:421)
> Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique cons
> traint or index violation; SYS_PK_10121 table: JOBQUEUE
> at org.hsqldb.error.Error.error(Error.java:134)
> at org.hsqldb.Constraint.getException(Constraint.java:914)
> at org.hsqldb.index.IndexAVL.insert(IndexAVL.java:731)
> at org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:171)
> at org.hsqldb.persist.RowStoreAVLDisk.indexRow(RowStoreAVLDisk.java:169)
> at org.hsqldb.TransactionManagerMVCC.addInsertAction(TransactionManagerM
> VCC.java:401)
> at org.hsqldb.Session.addInsertAction(Session.java:434)
> at org.hsqldb.Table.insertSingleRow(Table.java:2553)
> at org.hsqldb.StatementDML.update(StatementDML.java:1032)
> at org.hsqldb.StatementDML.executeUpdateStatement(StatementDML.java:541)
> at org.hsqldb.StatementDML.getResult(StatementDML.java:196)
> at org.hsqldb.StatementDMQL.execute(StatementDMQL.java:190)
> at org.hsqldb.Session.executeCompiledStatement(Session.java:1344)
> at org.hsqldb.Session.execute(Session.java:997)
> at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStateme
> nt.java:4651)
> ... 3 more
> This only happens on HSQLDB, and is probably related to CONNECTORS-248 and CONNECTORS-246.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira