It does seem to be in your code. Try psql. The \d <tablename> command should list indexes.
Karl On Tue, Jul 5, 2011 at 10:26 AM, Farzad Valad <[email protected]> wrote: > Just got my week started, was out of town with the family. Here is the > stack trace, coming back to this fresh, I think this is a problem in my > code. I'm not considering the multi-threaded nature of the manifoldcf when > trying to find the next unique number to use. Is there a way to find out > what "i1307564876133" constraint is? I tried to use pgAdmin, but it didn't > show anything in table properties. My code is adding three indexes, file > content hash sum, a unique number, and document URI. > > ERROR 2011-07-01 18:49:09,935 [Worker thread '33'] (WorkerThread.java:893) - > Exception tossed: ERROR: duplicate key value violates unique constraint > "i1307564876133" > org.apache.manifoldcf.core.interfaces.ManifoldCFException: ERROR: duplicate > key value violates unique constraint "i1307564876133" > at > org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.reinterpretException(DBInterfacePostgreSQL.java:621) > at > org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performModification(DBInterfacePostgreSQL.java:641) > at > org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performInsert(DBInterfacePostgreSQL.java:191) > at > org.apache.manifoldcf.core.database.BaseTable.performInsert(BaseTable.java:76) > at > org.apache.manifoldcf.agents.output.dupfinder.DataManager.insertData(DataManager.java:143) > at > org.apache.manifoldcf.agents.output.dupfinder.DupFinderConnector.addOrReplaceDocument(DupFinderConnector.java:161) > at > org.apache.manifoldcf.agents.incrementalingest.IncrementalIngester.addOrReplaceDocument(IncrementalIngester.java:1433) > at > org.apache.manifoldcf.agents.incrementalingest.IncrementalIngester.performIngestion(IncrementalIngester.java:418) > at > org.apache.manifoldcf.agents.incrementalingest.IncrementalIngester.documentIngest(IncrementalIngester.java:313) > at > org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.ingestDocument(WorkerThread.java:1565) > at > org.apache.manifoldcf.crawler.connectors.filesystem.FileConnector.processDocuments(FileConnector.java:275) > at > org.apache.manifoldcf.crawler.connectors.BaseRepositoryConnector.processDocuments(BaseRepositoryConnector.java:423) > at > org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:564) > Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value > violates unique constraint "i1307564876133" > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) > at > org.apache.manifoldcf.core.database.Database.execute(Database.java:606) > at > org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:421) > > On 7/5/2011 2:27 AM, Karl Wright wrote: >> >> Hi Farzad - any luck on getting that stack trace? >> Karl >> >> On Sat, Jul 2, 2011 at 1:09 PM, [email protected]<[email protected]> >> wrote: >>> >>> The unique key violation is not expected - if you could send along a >>> complete stack trace that would be good. >>> >>> The lock clean procedure is to shut down all mcf processes, execute the >>> lock clean, and start them up again. >>> >>> Karl >>> Sent from my Nokia phone >>> -----Original Message----- >>> From: Farzad Valad >>> Sent: 01/07/2011, 12:23 PM >>> To: [email protected] >>> Subject: Sync Dir >>> >>> >>> In a multi process setup, I've noticed if you stop the agent but keep >>> Tomcat going, you most like will hit a key violation error like the one >>> below. I remember reading they don't have to be both restarted, but >>> what if they do? What if I need to issue a LockClean in between? >>> >>> Error: ERROR: duplicate key value violates unique constraint >>> "i1307564876133" >>> > >
