topic Re: Is it possible that nuxeo generates duplicate uid with his UIDSequencer? in Nuxeo Forum

Is it possible that nuxeo generates duplicate uid with his UIDSequencer?

ftorchet_ — Wed, 08 Apr 2015 20:19:34 GMT

We use the extension poins "generators" to generate references stored in uid:uid ... Now we have documents that have the same references. After analyzing the creation timestamp, I would say that these are documents created simultaneously ... When I look at the code, I would say it is possible: the last index is read in base, incremented by the code and persisted. If two accesses occur at the same time, it must result in duplicate uid right?

(Obviously, this behavior is a bit problematic for us...)

We use nuxeo 5.8.0-HF30...

Re: Is it possible that nuxeo generates duplicate uid with his UIDSequencer?

Florent_Guillau — Thu, 09 Apr 2015 14:24:15 GMT

Yes, UIDSequencer has a flawed implementation that's not thread-safe, which is a problem in many situations. We don't recommend using it anymore.

To generate truly unique sequential ids, we recommend using a SQL directory with <autoincrementIdField>true</autoincrementIdField> specified, and inserting new entries when needed. Although this makes the directory grow, which may or may not be a problem.

Otherwise use an external mechanism to get incremental ids, like a Hibernate sequence, or a Redis INCR-based counter.

Re: Is it possible that nuxeo generates duplicate uid with his UIDSequencer?

ftorchet_ — Wed, 09 Sep 2015 15:22:31 GMT

Using SQL directory is not possible in my case, I choose to specialize postgreSQL dialect (add a function to get next value of a sequence with insertion BEFORE return) for nxuidsequencer... It's not easy to test (mandatory postgreSQL) but it works without external tool...

Re: Is it possible that nuxeo generates duplicate uid with his UIDSequencer?

Alice_J — Fri, 02 Oct 2020 13:20:50 GMT

Hello,