BatchUpdateException while creating a document

Question

I doing performance testing of Nuxeo instance but I am sometime getting BatchUpdateException. I am uploading same file repeatedly with different metadata. I am using Postgres as backend DB.

Failed to save session, java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "hierarchy" ("id", "parentid", "pos", "name", "isproperty", "primarytype", "mixintypes", "ischeckedin", "baseversionid", "majorversion", "minorversion", "isversion", "isretentionactive", "istrashed", "systemchangetoken", "changetoken") VALUES (75680, 909, NULL, 'AADHAAR_CARD.1593524158152', 'FALSE', 'Picture', NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, 0, 0) was aborted: ERROR: duplicate key value violates unique constraint "hierarchy_unique_child"
  Detail: Key (parentid, name)=(909, AADHAAR_CARD.1593524158152) already exists.  Call getNextException to see other errors in the batch.

Florent_Guillau · Accepted Answer

You're trying to create several documents in the same folder with the same name (AADHAAR_CARD). The Nuxeo code attempts to detect pre-existing documents with the same name and provide a new one (AADHAAR_CARD.1593524158152) but this is not perfect, as it will fail if done with high concurrency. You should do your creations with different names for different documents in the same folder.