[OAK-3937] Batch createOrUpdate() may fail with primary key violation

• Type: Technical task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.15, 1.4
• Component/s: core, rdbmk
• Assignee: Julian Reschke
• Reporter: Marcel Reutegger
• Created: 28/Jan/16 08:28
• Updated: 02/Mar/16 15:22
• Resolved: 02/Feb/16 12:54

Description

In some cases the batch createOrUpdate() method may fail on RDBMK with a primary key violation exception.

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]

See the currently disabled test MultiDocumentStoreTest.concurrentBatchUpdate().

Issue Links

• is cloned by: OAK-3959 RDBDocumentStore: always upsert in the bulk updates
• is related to: OAK-3977 RDBDocumentStore: remove PostgreSQL workaround after upgrading to JDBC driver 9.4.1208