This is all I've got. I am sorry for the polish fragments, I can't seem to
change it anywhere. Anyway, hopefully you should be able to get all the
information you need.
ERROR 2012-06-04 11:22:25,449 (Worker thread '42') - Worker thread aborting and
restarting due to database connection reset: Database exception: Exception
doing query: Instrukcja została przerwana, ponieważ mogła spowodować powstanie
duplikatu wartości klucza w regule ograniczającej klucz unikalny lub podstawowy
albo w unikalnym indeksie identyfikowanym przez obiekt 'C1338469165883'
zdefiniowany dla 'EVENTS'.
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception:
Exception doing query: Instrukcja została przerwana, ponieważ mogła spowodować
powstanie duplikatu wartości klucza w regule ograniczającej klucz unikalny lub
podstawowy albo w unikalnym indeksie identyfikowanym przez obiekt
'C1338469165883' zdefiniowany dla 'EVENTS'.
at
org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:680)
at
org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:726)
at
org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1393)
at
org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
at
org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:185)
at
org.apache.manifoldcf.core.database.DBInterfaceDerby.performModification(DBInterfaceDerby.java:831)
at
org.apache.manifoldcf.core.database.DBInterfaceDerby.performInsert(DBInterfaceDerby.java:222)
at
org.apache.manifoldcf.core.database.BaseTable.performInsert(BaseTable.java:68)
at
org.apache.manifoldcf.crawler.jobs.EventManager.createEvent(EventManager.java:123)
at
org.apache.manifoldcf.crawler.jobs.JobManager.beginEventSequence(JobManager.java:4217)
at
org.apache.manifoldcf.crawler.system.WorkerThread$VersionActivity.beginEventSequence(WorkerThread.java:1236)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector.lookupIPAddress(WebcrawlerConnector.java:4737)
at
org.apache.manifoldcf.crawler.connectors.webcrawler.WebcrawlerConnector.getDocumentVersions(WebcrawlerConnector.java:634)
at
org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:318)
Caused by: java.sql.SQLIntegrityConstraintViolationException: Instrukcja
została przerwana, ponieważ mogła spowodować powstanie duplikatu wartości
klucza w regule ograniczającej klucz unikalny lub podstawowy albo w unikalnym
indeksie identyfikowanym przez obiekt 'C1338469165883' zdefiniowany dla
'EVENTS'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.apache.manifoldcf.core.database.Database.execute(Database.java:839)
at
org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:640)
Caused by: java.sql.SQLException: Instrukcja została przerwana, ponieważ mogła
spowodować powstanie duplikatu wartości klucza w regule ograniczającej klucz
unikalny lub podstawowy albo w unikalnym indeksie identyfikowanym przez obiekt
'C1338469165883' zdefiniowany dla 'EVENTS'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 11 more
Caused by: ERROR 23505: Instrukcja została przerwana, ponieważ mogła spowodować
powstanie duplikatu wartości klucza w regule ograniczającej klucz unikalny lub
podstawowy albo w unikalnym indeksie identyfikowanym przez obiekt
'C1338469165883' zdefiniowany dla 'EVENTS'.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source)
at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 5 more
/Marcin
-----Original Message-----
From: Karl Wright [mailto:[email protected]]
Sent: Monday, June 04, 2012 12:17 PM
To: [email protected]
Subject: Re: Derby DB up-to-date?
I've created CONNECTORS-478 to track this issue. But please do send along the
rest of the stack trace context because without that I cannot know where,
exactly, the constraint violation is not getting caught.
Thanks,
Karl
On Mon, Jun 4, 2012 at 6:08 AM, Karl Wright <[email protected]> wrote:
> Can you provide the rest of the exception? (The "caused by" clauses
> etc.?)
>
> The fact is that we discovered that 10.8.2.2 throws deadlock and
> constraint violation exceptions in different places (as compared to
> 10.7.1.1) under multi-threaded conditions. That was part of the
> reason why the 0.5.1 release was necessary. It's of course possible
> that we missed some places that (for instance) the wiki connector
> especially tweaks.
>
> Karl
>
>
> On Mon, Jun 4, 2012 at 5:29 AM, Marcin Goss <[email protected]> wrote:
>> Hello Karl,
>>
>> Thank you for answering.
>> I am using Manifold 0.5.1 and what I am doing is a simple indexing of a
>> wiki page. The error that I am getting looks like this:
>>
>> Caused by: java.sql.SQLIntegrityConstraintViolationException: The statement
>> was aborted because it would have caused a duplicate key value in a unique
>> or primary key constraint or unique index identified by 'XXXXXXXX' defined
>> on 'EVENTS'.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn
>> own Source)
>> at
>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
>> (Unknown Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Un
>> known Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
>> Source)
>>
>> /Marcin
>>
>> -----Original Message-----
>> From: Karl Wright [mailto:[email protected]]
>> Sent: Wednesday, May 30, 2012 12:42 PM
>> To: [email protected]
>> Subject: Re: Derby DB up-to-date?
>>
>> Also, the ManifoldCF tests passed for these releases, so I'm wondering
>> exactly what you are seeing. Can you provide more details, including
>> exceptions?
>>
>> Karl
>>
>> On Wed, May 30, 2012 at 6:38 AM, Karl Wright <[email protected]> wrote:
>>> Which version of ManifoldCF are you using? The 0.5 release uses 10.8.2.2.
>>>
>>> Karl
>>>
>>> On Wed, May 30, 2012 at 5:21 AM, Marcin Goss <[email protected]>
>>> wrote:
>>>> I'm getting an error in a default manifoldCF setup (jetty server
>>>> and derby
>>>> db) that is probably caused (my supposition) by this bug in Derby:
>>>> https://issues.apache.org/jira/browse/DERBY-3343. The bug was fixed
>>>> in January 2011. Which version of Derby db is coming with ManifoldCF?
>>>> Is it the one with this bug fixed?
>>>>
>>>>
>>
>>
