OptimisticLockException in Dataverse

[Steven FEREY]

Hello Dataverse Community,

We regularly have OptimisticLockException errors in our Dataverse (currently V5.12.1). It is possible that a user has multiple browser tabs open on the same Dataset generating this error.

Does the Dataverse community also encounter this error?

We have observed this error when updating a Dataset in the database, for example:
SubmitDatasetForReviewCommand.java L57 or PublishDatasetCommand.java L175

We think this can create a problem in some cases.
For example when submitting for review, in summary, it goes like this:

-> DatasetLock "InReview" on dataset
-> Updated modification dates
-> Dataset merge
-> Send notifications to users

The problem is that in case of an "OptimisticLockException" type error, the merge is KO (dates not modified and notifications not sent) while the DatasetLock is created.

Example of Java stack trace is attached.

Thank you so much,

Steven for the Recherche Data Gouv team.

[Don Sizemore]

Hello,

I believe I've seen two of these recently (on 5.9) but admittedly haven't dug into them as deeply as you have (so this message is just a simple "me too").

Thank you,

Don Sizemore

--
You received this message because you are subscribed to the Google Groups "Dataverse Users Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataverse-commu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/0b7511a9-cef0-4951-a00e-b2c8cac41067n%40googlegroups.com.

[Maylein, Leonhard]

Hello,

same here (on 5.12.1). Due to lack of time I didn't take a closer look at this case but only unlocked the dataset via API. The second attempt then went through without any problem.

Leonhard Maylein

---

Von: dataverse...@googlegroups.com <dataverse...@googlegroups.com> im Auftrag von Don Sizemore <don.si...@gmail.com>
Gesendet: Freitag, 10. März 2023 15:37
An: dataverse...@googlegroups.com
Betreff: Re: [Dataverse-Users] OptimisticLockException in Dataverse

 

To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/CAPfMOayLSs61WNQFjXmVY5rqznzDxNFoaLcfrKkgKQ9JXZSBVQ%40mail.gmail.com.

[Philip Durbin]

Please feel free (all three of you), to create issues about this.

Thanks!

Phil

To view this discussion on the web visit https://groups.google.com/d/msgid/dataverse-community/79f010b349954c37a578a3916ae6cf29%40ub.uni-heidelberg.de.

--

Philip Durbin
Software Developer for http://dataverse.org
http://www.iq.harvard.edu/people/philip-durbin

[Steven FEREY]

Hello Dataverse Community,

Thank you very much for your feedback.

I created an issue on this topic : https://github.com/IQSS/dataverse/issues/9470

Steven.