Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 261AC9E33 for ; Thu, 27 Sep 2012 20:25:09 +0000 (UTC) Received: (qmail 91114 invoked by uid 500); 27 Sep 2012 20:25:08 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 91020 invoked by uid 500); 27 Sep 2012 20:25:08 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 90910 invoked by uid 99); 27 Sep 2012 20:25:08 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Sep 2012 20:25:08 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of curtisr7@gmail.com designates 209.85.223.174 as permitted sender) Received: from [209.85.223.174] (HELO mail-ie0-f174.google.com) (209.85.223.174) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Sep 2012 20:25:00 +0000 Received: by ieak13 with SMTP id k13so6168088iea.33 for ; Thu, 27 Sep 2012 13:24:39 -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; bh=jGJdQDyc900zMDL7ffD5nch8KBtOXh7+30JQtbdiOzY=; b=vNk4ss5Pt6yjpIli4++hrH0HEiGLIEWvnO8tTIia5LOxoiIfzZPlU8j2d08BwP5Py1 dhu5AuJoU8Cfbi+4rEpxiuQC40OoNTR6kVG+qcFm85oe+1d9gfbSLZvslv7xdi41fQ7t f5JwGd1cG0ETUjPM6f7Nzyg48YLy+f025XH/CAU5DZcjMOVMmPP8ldk2CDcXqw7G7dUK crTt4UxHQQt5sfEBA88lCQnCjevRkFDTp+xJyMi+qjAbcLrhWMKjg8Ggzl9R/C8X3AdS TCb4IWj8yNTSlxfQXVdFYgKfOdpjrWP/RwijkyE8SUT4JS4anawNqXMomWFi6SK9ZBbh 5AVA== MIME-Version: 1.0 Received: by 10.50.160.164 with SMTP id xl4mr15410708igb.74.1348777479101; Thu, 27 Sep 2012 13:24:39 -0700 (PDT) Received: by 10.64.33.148 with HTTP; Thu, 27 Sep 2012 13:24:39 -0700 (PDT) In-Reply-To: <1348777235595-7581246.post@n2.nabble.com> References: <1345667358281-7580917.post@n2.nabble.com> <1348680192631-7581226.post@n2.nabble.com> <1348754448750-7581235.post@n2.nabble.com> <1348755214506-7581237.post@n2.nabble.com> <1348777235595-7581246.post@n2.nabble.com> Date: Thu, 27 Sep 2012 15:24:39 -0500 Message-ID: Subject: Re: Duplicate entry issue with multithreaded application From: Rick Curtis To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=14dae934094d85dc3504cab4ba5d --14dae934094d85dc3504cab4ba5d Content-Type: text/plain; charset=ISO-8859-1 Look closer at your exception.... it is quite similar, but coming from a different bit of code. On Thu, Sep 27, 2012 at 3:20 PM, garpinc wrote: > As far as I can tell i'm still getting the exception: > 12-09-27 16:17:48,861 [pool-31-thread-1] [] DEBUG - > c.c.a.r.LinkedDatasetPersist- > 295905694:(0:01:41.017)-(pool-31-thread-1)-Sleeping 5 > secs: > org.apache.openjpa.persistence.RollbackException: The transaction has been > rolled back. See the nested exceptions for details on the errors that > occurred. > FailedObject: > > com.cambridgesemantics.anzo.relationalreplicator.jpa.model.AnzoURIToPKImpl@2319435b > at > > org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:594) > at > > com.cambridgesemantics.anzo.relationalreplicator.ReplicationJob.commitTransaction(ReplicationJob.java:460) > at > > com.cambridgesemantics.anzo.relationalreplicator.LinkedDatasetPersist.finishBatch(LinkedDatasetPersist.java:304) > at > > com.cambridgesemantics.anzo.relationalreplicator.LinkedDatasetPersist.persistDataset(LinkedDatasetPersist.java:231) > at > > com.cambridgesemantics.anzo.relationalreplicator.LinkedDatasetPersist.persistDataset(LinkedDatasetPersist.java:167) > at > > com.cambridgesemantics.anzo.relationalreplicator.LinkedDatasetPersist.persistJob(LinkedDatasetPersist.java:162) > at > > com.cambridgesemantics.anzo.relationalreplicator.ReplicationJob.call(ReplicationJob.java:1189) > at > > com.cambridgesemantics.anzo.relationalreplicator.ReplicationJob.call(ReplicationJob.java:1) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:722) > Caused by: > org.apache.openjpa.persistence.PersistenceException: The transaction has > been rolled back. See the nested exceptions for details on the errors that > occurred. > FailedObject: > > com.cambridgesemantics.anzo.relationalreplicator.jpa.model.AnzoURIToPKImpl@2319435b > at > > org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2337) > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2174) > at > org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2072) > at > org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1990) > at > > org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) > at > org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1514) > at > > org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933) > at > > org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570) > ... 12 more > Caused by: > org.apache.openjpa.persistence.EntityExistsException: Duplicate entry > '31453a33c22a895f9a770f5ee6fe8edeace30e08-734f1c627a629e194f9ea9c' for key > 'U_NZURTPK_URIHASH' {prepstmnt 1776490395 INSERT INTO anzouritopk (pk, > datasetUri, datasetUriHash, persistedFully, typeUri, typeUriHash, uri, > uriHash) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [params=(long) 55190, (Reader) > java.io.StringReader@3c22f76c, (String) N/A, (int) 0, (Reader) > java.io.StringReader@252a69c0, (String) > 734f1c627a629e194f9ea9cf0990bbaead59b188, (Reader) > java.io.StringReader@384cf50, (String) > 31453a33c22a895f9a770f5ee6fe8edeace30e08]} [code=1062, state=23000] > FailedObject: > > com.cambridgesemantics.anzo.relationalreplicator.jpa.model.AnzoURIToPKImpl@2319435b > at > org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4903) > at > > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78) > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:143) > at > > org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79) > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99) > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87) > at > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:357) > at > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:349) > at > > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:97) > at > > org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) > at > > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103) > at > > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76) > at > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:713) > at > > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) > ... 19 more > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Duplicate > entry '31453a33c22a895f9a770f5ee6fe8edeace30e08-734f1c627a629e194f9ea9c' > for > key 'U_NZURTPK_URIHASH' {prepstmnt 1776490395 INSERT INTO anzouritopk (pk, > datasetUri, datasetUriHash, persistedFully, typeUri, typeUriHash, uri, > uriHash) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [params=(long) 55190, (Reader) > java.io.StringReader@3c22f76c, (String) N/A, (int) 0, (Reader) > java.io.StringReader@252a69c0, (String) > 734f1c627a629e194f9ea9cf0990bbaead59b188, (Reader) > java.io.StringReader@384cf50, (String) > 31453a33c22a895f9a770f5ee6fe8edeace30e08]} [code=1062, state=23000] > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223) > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72) > at > > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1162) > at > > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:272) > at > > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1741) > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:267) > at > > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:118) > ... 30 more > > > > > -- *Rick Curtis* --14dae934094d85dc3504cab4ba5d--