lucee 5.3.8.206, Tomcat 8.5 with sql server driver...
# lucee
t
lucee 5.3.8.206, Tomcat 8.5 with sql server driver 7.4.1.jre8 logs started filling up with
"was not able to stop controller thread running for 4664839ms
stack trace in thread, I found https://dev.lucee.org/t/application-log-was-not-able-to-stop-controller-thread-solved/2368 and tried messing with the time sync but no luck, has anybody come across it recently a restart of Lucee has stopped it for now
Copy code
"ERROR","Thread-7","04/04/2022","11:06:08","controler","was not able to stop controller thread running for 4664839ms;java.lang.Throwable;java.lang.Throwable
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
        at java.net.SocketInputStream.read(SocketInputStream.java:171)
        at java.net.SocketInputStream.read(SocketInputStream.java:141)
        at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2023)
        at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6465)
        at com.microsoft.sqlserver.jdbc.TDSReader.nextPacket(IOBuffer.java:6368)
        at com.microsoft.sqlserver.jdbc.TDSReader.ensurePayload(IOBuffer.java:6346)
        at com.microsoft.sqlserver.jdbc.TDSReader.peekTokenType(IOBuffer.java:6553)
        at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:61)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1620)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.processResults(SQLServerStatement.java:1294)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.processBatch(SQLServerStatement.java:1285)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.processExecuteResults(SQLServerStatement.java:1278)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.processResponse(SQLServerPreparedStatement.java:530)
        at com.microsoft.sqlserver.jdbc.TDSCommand.close(IOBuffer.java:7264)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.discardLastExecutionResults(SQLServerStatement.java:143)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.closeInternal(SQLServerStatement.java:654)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closeInternal(SQLServerPreparedStatement.java:328)
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.close(SQLServerStatement.java:669)
        at lucee.commons.db.DBUtil.closeEL(DBUtil.java:71)
        at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:331)
        at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
        at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226)
        at lucee.runtime.type.scope.storage.db.Ansi92.clean(Ansi92.java:218)
        at lucee.runtime.type.scope.storage.clean.DatasourceStorageScopeCleaner.clean(DatasourceStorageScopeCleaner.java:76)
        at lucee.runtime.type.scope.storage.clean.DatasourceStorageScopeCleaner._clean(DatasourceStorageScopeCleaner.java:57)
        at lucee.runtime.type.scope.storage.clean.StorageScopeCleanerSupport.clean(StorageScopeCleanerSupport.java:59)
        at lucee.runtime.type.scope.storage.StorageScopeEngine.clean(StorageScopeEngine.java:44)
        at lucee.runtime.type.scope.ScopeContext.clearUnused(ScopeContext.java:829)
        at lucee.runtime.engine.Controler.control(Controler.java:292)
        at lucee.runtime.engine.Controler.control(Controler.java:244)
        at lucee.runtime.engine.Controler.access$000(Controler.java:58)
        at lucee.runtime.engine.Controler$ControlerThread.run(Controler.java:113)
"
z
do you have any hung queries showing up in the db?
t
nope clean as a whistle there was an issue late friday but the errors started early sunday
z
how big is your session table?
t
not big it is a test install a few thousand rows maybe
hang on I will take that back
70000 rows I will investigate, thanks zack