From oak-issues-return-29486-apmail-jackrabbit-oak-issues-archive=jackrabbit.apache.org@jackrabbit.apache.org Mon Feb 1 15:01:44 2016 Return-Path: X-Original-To: apmail-jackrabbit-oak-issues-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-oak-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 75541183F4 for ; Mon, 1 Feb 2016 15:01:44 +0000 (UTC) Received: (qmail 13353 invoked by uid 500); 1 Feb 2016 15:00:46 -0000 Delivered-To: apmail-jackrabbit-oak-issues-archive@jackrabbit.apache.org Received: (qmail 13271 invoked by uid 500); 1 Feb 2016 15:00:46 -0000 Mailing-List: contact oak-issues-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: oak-dev@jackrabbit.apache.org Delivered-To: mailing list oak-issues@jackrabbit.apache.org Received: (qmail 13006 invoked by uid 99); 1 Feb 2016 15:00:45 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Feb 2016 15:00:45 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id D4E362C1F6B for ; Mon, 1 Feb 2016 15:00:45 +0000 (UTC) Date: Mon, 1 Feb 2016 15:00:45 +0000 (UTC) From: =?utf-8?Q?Tomek_R=C4=99kawek_=28JIRA=29?= To: oak-issues@jackrabbit.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (OAK-3937) Batch createOrUpdate() may fail with primary key violation MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/OAK-3937?page=3Dcom.atlassian.j= ira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D151263= 43#comment-15126343 ]=20 Tomek R=C4=99kawek commented on OAK-3937: ------------------------------------ Does it fail on the current trunk or the trunk+patch? On my machine DB2 pas= ses this test everywhere and the PostgreSQL passes it on the patched Oak. What driver & DB2 server do you use? For me it's {{com.ibm.db2:db2:4.16.53}= } and DB2 {{v10.5.0.5}}. Does your DB2 passes all tests in rdb-oddity.patch? > Batch createOrUpdate() may fail with primary key violation > ---------------------------------------------------------- > > Key: OAK-3937 > URL: https://issues.apache.org/jira/browse/OAK-3937 > Project: Jackrabbit Oak > Issue Type: Technical task > Components: core, rdbmk > Reporter: Marcel Reutegger > Assignee: Julian Reschke > Fix For: 1.4 > > Attachments: OAK-3937.patch, rdb-oddity.patch > > > In some cases the batch createOrUpdate() method may fail on RDBMK with a = primary key violation exception. > {noformat} > java.lang.AssertionError: org.apache.jackrabbit.oak.plugins.document.Docu= mentStoreException: org.h2.jdbc.JdbcBatchUpdateException: Unique index or p= rimary key violation: "PRIMARY_KEY_1 ON PUBLIC.DSTEST_NODES(ID) VALUES ('1:= /node-40', 118)"; SQL statement: > insert into dstest_NODES(ID, MODIFIED, HASBINARY, DELETEDONCE, MODCOUNT, = CMODCOUNT, DSIZE, DATA, BDATA) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-18= 5] > {noformat} > See the currently disabled test {{MultiDocumentStoreTest.concurrentBatchU= pdate()}}. -- This message was sent by Atlassian JIRA (v6.3.4#6332)