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 2012/06/04 12:14:23 UTC

[jira] [Created] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Karl Wright created CONNECTORS-478:
--------------------------------------

             Summary: Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
                 Key: CONNECTORS-478
                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
             Project: ManifoldCF
          Issue Type: Bug
          Components: Framework agents process, Wiki connector
    Affects Versions: ManifoldCF 0.5.1
            Reporter: Karl Wright
            Assignee: Karl Wright


Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:

{code}
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(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)
{code}




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright updated CONNECTORS-478:
-----------------------------------

    Description: 
Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:

{code}
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
{code}




  was:
Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:

{code}
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(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)
{code}




    
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Updated] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright updated CONNECTORS-478:
-----------------------------------

    Attachment: CONNECTORS-478.testpatch

Test patch to see whether we've got the right fix
                
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>         Attachments: CONNECTORS-478.testpatch
>
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288470#comment-13288470 ] 

Karl Wright commented on CONNECTORS-478:
----------------------------------------

I've requested additional exception info, which might give me a clue as to where this is occurring.

                
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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(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)
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288479#comment-13288479 ] 

Karl Wright commented on CONNECTORS-478:
----------------------------------------

I've updated the ticket with the complete exception.

                
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Commented] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288515#comment-13288515 ] 

Karl Wright commented on CONNECTORS-478:
----------------------------------------

r1345930 on trunk.  Verified also that this only affects the Derby driver.


                
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>             Fix For: ManifoldCF 0.6
>
>         Attachments: CONNECTORS-478.testpatch
>
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Updated] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright updated CONNECTORS-478:
-----------------------------------

    Fix Version/s: ManifoldCF 0.6
    
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>             Fix For: ManifoldCF 0.6
>
>         Attachments: CONNECTORS-478.testpatch
>
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

[jira] [Resolved] (CONNECTORS-478) Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations

Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CONNECTORS-478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright resolved CONNECTORS-478.
------------------------------------

    Resolution: Fixed
    
> Wiki crawling with Derby 10.8.2.2 causes unhandled unique constraint violations
> -------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-478
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-478
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: Framework agents process, Wiki connector
>    Affects Versions: ManifoldCF 0.5.1
>            Reporter: Karl Wright
>            Assignee: Karl Wright
>         Attachments: CONNECTORS-478.testpatch
>
>
> Marcin Goss reports the following uncaught exceptions crawling wiki pages with Derby 10.8.2.2:
> {code}
> 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
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira