[ https://issues.apache.org/jira/browse/OAK-3937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15126343#comment-15126343 ] 

Tomek Rękawek commented on OAK-3937:
------------------------------------

Does it fail on the current trunk or the trunk+patch? On my machine DB2 passes 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.DocumentStoreException: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary 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-185]
> {noformat}
> See the currently disabled test {{MultiDocumentStoreTest.concurrentBatchUpdate()}}.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)