[Bug] Terminating all Active test sessions results in an error

[olw-medcom]

Hey there,

I've experienced a minor issue that I wanted to report. It doesn't really have an impact, but still it might be confusing for some.

When I use the button as an administrator "Terminate all" in the Session dashboard, it gives me an "unexpected error" dialog, but when I refresh the page, it has worked anyway?

20260127-1141-04.8416583.mp4

This is the log:

27/01/2026 11:41:11 ERROR o.pac4j.play.filters.SecurityFilter - Exception during authentication procedure
java.sql.SQLException: Record has changed since last read in table 'testresults'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:988)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1166)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1101)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1448)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1084)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10.$anonfun$run$14(JdbcActionComponent.scala:345)
	at slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10.run(JdbcActionComponent.scala:341)
	at slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10.run(JdbcActionComponent.scala:340)
	at slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction.run(JdbcActionComponent.scala:32)
	at slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction.run(JdbcActionComponent.scala:29)
	at slick.basic.BasicBackend$BasicDatabaseDef.liftedTree1$1(BasicBackend.scala:323)
	at slick.basic.BasicBackend$BasicDatabaseDef.$anonfun$runSynchronousDatabaseAction$2(BasicBackend.scala:323)
	at slick.basic.BasicBackend$BasicDatabaseDef.$anonfun$runSynchronousDatabaseAction$2$adapted(BasicBackend.scala:318)
	at slick.util.AsyncExecutor$$anon$1$$anon$2.runAndCleanUp(AsyncExecutor.scala:187)
	at slick.util.AsyncExecutor$$anon$1$$anon$2.run(AsyncExecutor.scala:196)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
27/01/2026 11:41:11 ERROR ErrorHandler - Error [NHHWOWUURO]
java.sql.SQLException: Record has changed since last read in table 'testresults'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:988)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1166)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1101)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1448)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1084)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10.$anonfun$run$14(JdbcActionComponent.scala:345)
	at slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10.run(JdbcActionComponent.scala:341)
	at slick.jdbc.JdbcActionComponent$UpdateActionExtensionMethodsImpl$$anon$10.run(JdbcActionComponent.scala:340)
	at slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction.run(JdbcActionComponent.scala:32)
	at slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction.run(JdbcActionComponent.scala:29)
	at slick.basic.BasicBackend$BasicDatabaseDef.liftedTree1$1(BasicBackend.scala:323)
	at slick.basic.BasicBackend$BasicDatabaseDef.$anonfun$runSynchronousDatabaseAction$2(BasicBackend.scala:323)
	at slick.basic.BasicBackend$BasicDatabaseDef.$anonfun$runSynchronousDatabaseAction$2$adapted(BasicBackend.scala:318)
	at slick.util.AsyncExecutor$$anon$1$$anon$2.runAndCleanUp(AsyncExecutor.scala:187)
	at slick.util.AsyncExecutor$$anon$1$$anon$2.run(AsyncExecutor.scala:196)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
27/01/2026 11:41:11 ERROR actors.SessionUpdateActor - Error during test session finalisation for session [911b7b9c-600c-43e6-871c-7a6c4d0771cd]

[... more of the same ...]

[costas80]

Thanks for reporting this @olw-medcom. Even though the termination takes place you should never be getting this error on the UI - we'll fix this asap and I'll let you know when the nightly build is updated with the patch.

[costas80]

Hi @olw-medcom. I was not able to replicate this issue on my end but after reviewing the implementation, I see how such issues could potentially come up. The session termination processing is now improved to merge separate actions into a single operation. This should avoid this issue coming up.

Could you check on your end - after pulling the latest build - if the problem still appears? Thanks!

[olw-medcom]

I can confirm that the issue has been resolved! Closing this