This issue also records lock action in database, I run query on local demo Jetty/HSQLDB 18.6.0. And depending on how many times it happens, that many records will be presented in the table.
SELECT * FROM xwikilock
Results into
XWL_DOC_ID
XWL_AUTHOR
XWL_DATE
3906721010564700566
XWiki.Admin
2026-08-13 16:13:26.886000
And as stacktrace stated, such record never goes away from database due to failed deletion transaction
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from xwikilock where XWL_DOC_ID=?
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6)
If image attachments aren't displayed, see this article.