We just encountered a stuck lock on a BaseX database. It was during repeated calls to a RESTXQ operation that modifies the database. The operations were working OK, then one returned an error:
[db:lock] Database 'd7c552cc-1f5e-47dc-ba91-37054695aabf' is currently opened by another process.
This error then appeared for any further attempt to update the database, and persisted for several days (although it seems to have cleared now).
It's possible that two updates were being processed concurrently, but they would have been processed by the same Java VM because the RESTXQ server is the only active interface to the database.
We have seen this error before, but it's difficult to reproduce.
Do you know how this might have happened? And is there a procedure for clearing down an erroneous database lock if it happens?
We are running BaseX version 9.1.2.
Thanks,
Martin Iggulden Screen Systems Martin Iggulden | Software Engineer | SCREEN Main Line : +44 1473 831700 | Direct Dial: +44 1473 831700 Fax : +44 1473 830078 Martin.Iggulden@screensystems.tvmailto:Martin.Iggulden@screensystems.tv
Visit us at Broadcast Asia 18-20th June 2019, Suntec Singapore, stand 6J4-02
[http://www.subtitling.com]http://www.subtitling.com/ [https://www.linkedin.com/company/screen-subtitling-systems-ltd] https://www.linkedin.com/company/screen-subtitling-systems-ltd [https://www.youtube.com/channel/Screen Subtitling Systems] https://www.youtube.com/channel/UCBp2nyUeNbIFz9cD66Ym3AQ [https://twitter.com/ScreenSystems] https://twitter.com/ScreenSystems
[cid:SS2979-sasquatch-final-logos_landscape-logo-w236-h56_0717b6a0-e87e-466e-ba39-e63542a11eee.jpg]https://mysasquatch.info P Before printing, think about the environment
This message may contain confidential and/or privileged information. If you are not the intended recipient you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. Screen Subtitling Systems Ltd. Registered in England No. 2596832. Registered Office: The Old Rectory, Claydon Church Lane, Claydon, Ipswich, Suffolk, IP6 0EQ
