I should mention that the following scenario is possible in our Lucee application:
simultaneous requests - some combining ORM calls with queryExecute within the same page context - connecting to the same database.
In fact, as I write this, we’re experiencing not only hung requests, but also threaddeath. Even without us using transactions.
I have also noticed something else with regard to the “failed to stop thread” error. Namely that most of the errors occur in pairs. First, an error caused by a system application called “controller”, followed a couple of seconds later by an error caused by a system application called “thread”. See attached requesttimeout log. _requesttimeout.log (43.1 KB)
A further update. We thought we had deleted every transaction. However, a colleague has just discovered the following snippet of code in a CFC somewhere else in the same application
From what we can see there is no direct interaction between this CFC and the ones causing the error. Or, might the error be caused by indirect interaction between requests and the database?
@BK_BK sorry for the late response.
Hope this issue was solved in the lucee hibernate version 3.5.5.84 or 3.5.587-SNASPHOT.
So can please you ensure the locking issue happens in the latest hibernate 3.5.5 version(note 5.4 still the issue exists)?
In addition, once the locking happened then we must have to restart the SQL server. Otherwise, that locking will occur on all the operations in that particular table.
Thank you, @cfmitrah.
We shall check whether the issue exists in the latest version of Hibernate 3.5.5.x. We shall also follow your advice to restart the SQL server.
Hi @cfmitrah,
We’re still busy with this. Two questions have arisen in our team.
We’re now on Lucee 5.3.9.163-SNAPSHOT on CommandBox, with Hibernate extension version 3.5.5.84. From what we can see, that is the latest stable version. Currently, the newest versions are either 3.5.5.87-SNAPSHOT or 5.4.29.15-BETA. Is it OK to use either on a production server? If so, which would you recommend?
You mentioned restarting the SQL server. Could you please let us know why that matters? We need a reason to convince our server admin. The SQL server is never restarted, unless when there are system updates.