Sherry Lake (May 07 2024 at 15:53): Sherry Lake (May 07 2024 at 15:53):I have a dataset that has been "locked" for over 24 hours. The guides say to "remove the lock". Is it as simple as deleting that line in the database (database table datasetlock)?
Then the instructions say to restart the application server - I assume this means payara?
Philip Durbin 🚀 (May 07 2024 at 16:05):Yes, the application server is Payara.
Philip Durbin 🚀 (May 07 2024 at 16:05):I'm surprised a restart is required. I don't see anything about this at https://guides.dataverse.org/en/5.14/admin/troubleshooting.html#a-dataset-is-locked-and-cannot-be-edited-or-published
Philip Durbin 🚀 (May 07 2024 at 16:06):And no, you shouldn't delete from the database directly. You should use the API. Please see https://guides.dataverse.org/en/5.14/api/native-api.html#dataset-locks
Sherry Lake (May 07 2024 at 16:06):@Philip Durbin
If a dataset has been in this state for a long period of time, for hours or longer, it is somewhat safe to assume that it is stuck (for example, the process may have been interrupted by an application server restart, or a system crash), so you may want to remove the lock (to be safe, do restart the application server, to ensure that the job is no longer running in the background) and advise the user to try publishing again
Sherry Lake (May 07 2024 at 16:07):Thanks for the API hint..... I hadn't seen that.
Philip Durbin 🚀 (May 07 2024 at 16:09):Huh. If it were a snake, it would have bit me. :snake:
Sherry Lake (May 07 2024 at 16:17):Now, @Philip Durbin is there something on that Troubleshooting link that pointed back to the API? I don't see that (at least this :snake: )
Philip Durbin 🚀 (May 07 2024 at 17:25):@Sherry Lake not that I see. Want to make a pull request? :grinning:
Sherry Lake (May 07 2024 at 17:36):Will do after I unlock and remove 1000+ files from a dataset :melt:
Last updated: Oct 30 2025 at 06:21 UTC