Return-Path: X-Original-To: apmail-manifoldcf-user-archive@www.apache.org Delivered-To: apmail-manifoldcf-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 49901C632 for ; Mon, 4 Jun 2012 10:29:58 +0000 (UTC) Received: (qmail 29205 invoked by uid 500); 4 Jun 2012 10:29:58 -0000 Delivered-To: apmail-manifoldcf-user-archive@manifoldcf.apache.org Received: (qmail 29170 invoked by uid 500); 4 Jun 2012 10:29:57 -0000 Mailing-List: contact user-help@manifoldcf.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@manifoldcf.apache.org Delivered-To: mailing list user@manifoldcf.apache.org Received: (qmail 29158 invoked by uid 99); 4 Jun 2012 10:29:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jun 2012 10:29:57 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of daddywri@gmail.com designates 209.85.215.50 as permitted sender) Received: from [209.85.215.50] (HELO mail-lpp01m010-f50.google.com) (209.85.215.50) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jun 2012 10:29:52 +0000 Received: by lahm15 with SMTP id m15so2915130lah.9 for ; Mon, 04 Jun 2012 03:29:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=JrYnhx/jnklmzG6oVthKZVXfRwjSPWL1WTzLyxPbqpo=; b=Yh7x9lqp19u+ugAbbZRmnhfHFGjQjhP53tOmOLrx8lX22mJV1uSinJ/GtMB7/plosl rWkVlVfcVf9DqHcDrNW+ldXQgYmMezPVikUUN1xC88OJ1Tu5Hwbq2c4V4ALfE4ebZcWS piB1B4PjauQP5P3GNxsADTqUZJ6cJOnuDB3daBvr5cX6OM6FkPJIJglhMu16qXZRKJAg 70CPDK2SHMi7gFi0srfVSy+iQsrDbcQ5GItvbBdW0Qs10RBWzWgqRrvHxzpiR7oSN4uB hA/zKjyU3oAk3RdHpjUMIdS25erG48x6qtfK0bQTsrUd0CHImRLVrd1mrjtj40Vqi4mI PMRA== MIME-Version: 1.0 Received: by 10.152.125.236 with SMTP id mt12mr11961923lab.12.1338805770753; Mon, 04 Jun 2012 03:29:30 -0700 (PDT) Received: by 10.112.94.38 with HTTP; Mon, 4 Jun 2012 03:29:30 -0700 (PDT) In-Reply-To: References: Date: Mon, 4 Jun 2012 06:29:30 -0400 Message-ID: Subject: Re: Derby DB up-to-date? From: Karl Wright To: user@manifoldcf.apache.org Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Thanks, this is exactly what I was looking for. I'll put it in the ticket and have a look at this later today. Karl On Mon, Jun 4, 2012 at 6:20 AM, Marcin Goss wrot= e: > This is all I've got. I am sorry for the polish fragments, I can't seem t= o change it anywhere. Anyway, hopefully you should be able to get all the i= nformation you need. > > ERROR 2012-06-04 11:22:25,449 (Worker thread '42') - Worker thread aborti= ng and restarting due to database connection reset: Database exception: Exc= eption doing query: Instrukcja zosta=B3a przerwana, poniewa=BF mog=B3a spow= odowa=E6 powstanie duplikatu warto=B6ci klucza w regule ograniczaj=B1cej kl= ucz unikalny lub podstawowy albo w unikalnym indeksie identyfikowanym przez= obiekt 'C1338469165883' zdefiniowany dla 'EVENTS'. > org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database excep= tion: Exception doing query: Instrukcja zosta=B3a przerwana, poniewa=BF mog= =B3a spowodowa=E6 powstanie duplikatu warto=B6ci klucza w regule ograniczaj= =B1cej klucz unikalny lub podstawowy albo w unikalnym indeksie identyfikowa= nym przez obiekt 'C1338469165883' zdefiniowany dla 'EVENTS'. > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.Database.executeVia= Thread(Database.java:680) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.Database.executeUnc= achedQuery(Database.java:726) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.Database$QueryCache= Executor.create(Database.java:1393) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.cachemanager.CacheManager.fi= ndObjectsAndExecute(CacheManager.java:144) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.Database.executeQue= ry(Database.java:185) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.DBInterfaceDerby.pe= rformModification(DBInterfaceDerby.java:831) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.DBInterfaceDerby.pe= rformInsert(DBInterfaceDerby.java:222) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.BaseTable.performIn= sert(BaseTable.java:68) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.crawler.jobs.EventManager.createE= vent(EventManager.java:123) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.crawler.jobs.JobManager.beginEven= tSequence(JobManager.java:4217) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.crawler.system.WorkerThread$Versi= onActivity.beginEventSequence(WorkerThread.java:1236) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.crawler.connectors.webcrawler.Web= crawlerConnector.lookupIPAddress(WebcrawlerConnector.java:4737) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.crawler.connectors.webcrawler.Web= crawlerConnector.getDocumentVersions(WebcrawlerConnector.java:634) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.crawler.system.WorkerThread.run(W= orkerThread.java:318) > Caused by: java.sql.SQLIntegrityConstraintViolationException: Instrukcja = zosta=B3a przerwana, poniewa=BF mog=B3a spowodowa=E6 powstanie duplikatu wa= rto=B6ci klucza w regule ograniczaj=B1cej klucz unikalny lub podstawowy alb= o w unikalnym indeksie identyfikowanym przez obiekt 'C1338469165883' zdefin= iowany dla 'EVENTS'. > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQL= Exception(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.Util.generateCsSQLException(= Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrap= InSQLException(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.TransactionResourceImpl.hand= leException(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.EmbedConnection.handleExcept= ion(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.ConnectionChild.handleExcept= ion(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.EmbedStatement.executeStatem= ent(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execu= teStatement(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execu= teUpdate(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.Database.execute(Da= tabase.java:839) > =A0 =A0 =A0 =A0at org.apache.manifoldcf.core.database.Database$ExecuteQue= ryThread.run(Database.java:640) > Caused by: java.sql.SQLException: Instrukcja zosta=B3a przerwana, poniewa= =BF mog=B3a spowodowa=E6 powstanie duplikatu warto=B6ci klucza w regule ogr= aniczaj=B1cej klucz unikalny lub podstawowy albo w unikalnym indeksie ident= yfikowanym przez obiekt 'C1338469165883' zdefiniowany dla 'EVENTS'. > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLEx= ception(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapAr= gsForTransportAcrossDRDA(Unknown Source) > =A0 =A0 =A0 =A0... 11 more > Caused by: ERROR 23505: Instrukcja zosta=B3a przerwana, poniewa=BF mog=B3= a spowodowa=E6 powstanie duplikatu warto=B6ci klucza w regule ograniczaj=B1= cej klucz unikalny lub podstawowy albo w unikalnym indeksie identyfikowanym= przez obiekt 'C1338469165883' zdefiniowany dla 'EVENTS'. > =A0 =A0 =A0 =A0at org.apache.derby.iapi.error.StandardException.newExcept= ion(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.IndexChanger.insertAn= dCheckDups(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.IndexChanger.doInsert= (Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.IndexChanger.insert(U= nknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.IndexSetChanger.inser= t(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.RowChangerImpl.insert= Row(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.InsertResultSet.norma= lInsertCore(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.execute.InsertResultSet.open(= Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.GenericPreparedStatement.exec= uteStmt(Unknown Source) > =A0 =A0 =A0 =A0at org.apache.derby.impl.sql.GenericPreparedStatement.exec= ute(Unknown Source) > =A0 =A0 =A0 =A0... 5 more > > > /Marcin > > -----Original Message----- > From: Karl Wright [mailto:daddywri@gmail.com] > Sent: Monday, June 04, 2012 12:17 PM > To: user@manifoldcf.apache.org > Subject: Re: Derby DB up-to-date? > > I've created CONNECTORS-478 to track this issue. =A0But please do send al= ong 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 wrote: >> Can you provide the rest of the exception? =A0(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. =A0That was part of the >> reason why the 0.5.1 release was necessary. =A0It'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 w= rote: >>> Hello Karl, >>> >>> Thank you for answering. >>> =A0I am using Manifold 0.5.1 and what I am doing is a simple indexing o= f a wiki page. The error that I am getting looks like this: >>> >>> Caused by: java.sql.SQLIntegrityConstraintViolationException: The state= ment was aborted because it would have caused a duplicate key value in a un= ique or primary key constraint or unique index identified by 'XXXXXXXX' def= ined on 'EVENTS'. >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn >>> own Source) >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown >>> Source) >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException >>> (Unknown Source) >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Un >>> known Source) >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown >>> Source) >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown >>> Source) >>> =A0 =A0 =A0 =A0at >>> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown >>> Source) >>> >>> /Marcin >>> >>> -----Original Message----- >>> From: Karl Wright [mailto:daddywri@gmail.com] >>> Sent: Wednesday, May 30, 2012 12:42 PM >>> To: user@manifoldcf.apache.org >>> Subject: Re: Derby DB up-to-date? >>> >>> Also, the ManifoldCF tests passed for these releases, so I'm wondering = exactly what you are seeing. =A0Can you provide more details, including exc= eptions? >>> >>> Karl >>> >>> On Wed, May 30, 2012 at 6:38 AM, Karl Wright wrote= : >>>> Which version of ManifoldCF are you using? =A0The 0.5 release uses 10.= 8.2.2. >>>> >>>> Karl >>>> >>>> On Wed, May 30, 2012 at 5:21 AM, Marcin Goss 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? >>>>> >>>>> >>> >>> > >