Investigate stability of ConcurrentModificationTest

[ahus1]

There was this failure:
https://github.com/keycloak/keycloak-benchmark/actions/runs/11906660588/job/33180629035

[ahus1]

This has been happening again, so it would important to investigate it.

[pruivo]

Deadlock reported in the logs with a lot of retries...
ISPN000136: Error executing command RemoveCommand on Cache 'authenticationSessions',

Possible issues

• Hot Rod client retries flooding
• Keycloak retries
• Delete after creation optimization not working as expected

[pruivo]

There is another exception in the logs around the same timestamp but it seems unrelated.

{"timestamp":"2024-11-26T06:01:20.656449319Z","sequence":10763,"loggerClassName":"org.hibernate.engine.jdbc.batch.JdbcBatchLogging_$logger","loggerName":"org.hibernate.orm.jdbc.batch","level":"ERROR","message":"HHH100501: Exception executing batch [org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update OFFLINE_USER_SESSION set BROKER_SESSION_ID=?,CREATED_ON=?,DATA=?,LAST_SESSION_REFRESH=?,REALM_ID=?,USER_ID=?,VERSION=? where OFFLINE_FLAG=? and USER_SESSION_ID=? and VERSION=?], SQL: update OFFLINE_USER_SESSION set BROKER_SESSION_ID=?,CREATED_ON=?,DATA=?,LAST_SESSION_REFRESH=?,REALM_ID=?,USER_ID=?,VERSION=? where OFFLINE_FLAG=? and USER_SESSION_ID=? and VERSION=?","threadName":"org.keycloak.models.sessions.infinispan.changes.PersistentSessionsWorker$BatchWorker","threadId":77,"mdc":{},"ndc":"","hostName":"keycloak-0","processName":"/usr/lib/jvm/java-21-openjdk-21.0.5.0.11-2.el9.aarch64/bin/java","processId":1}