Postgres lock issues when updating user_attribute

Hi,

Pls advise on the below. Thanks.

We are using Keyclock 13, clustered and deployed in EKS and using postgres as a DB.
And we using user federation.
We implemented following interfaces for login
UserStorageProvider,
UserLookupProvider,
CredentialInputUpdater,
CredentialInputValidator

We are getting the below error during isPasswordValid failing our login activity.

[
{
@timestamp”: “2023-02-01 02:50:47.803”,
@message”: {
“log”: “{"log":"\u001b[0m\u001b[33m02:50:47,802 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6718) SQL Error: 0, SQLState: null\n","stream":"stdout","time":"2023-02-01T02:50:47.802707195Z"}”
},
},
{
@timestamp”: “2023-02-01 02:50:47.803”,
@message”: {
“log”: “{"log":"\u001b[0m\u001b[31m02:50:47,802 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-6718) IJ031013: Interrupted attempting lock: org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@585a738b\n","stream":"stdout","time":"2023-02-01T02:50:47.802826047Z"}”
},
},
{
@timestamp”: “2023-02-01 02:50:47.809”,
@message”: {
“log”: “{"log":"\u001b[0m\u001b[33m02:50:47,803 WARN [org.keycloak.utils.ServicesUtils] (default task-6718) Execution with object [com.singtel.ml.keycloak.providers.telepin.TelepinProvider@6ea96e85] exceeded specified time limit 3000. \n","stream":"stdout","time":"2023-02-01T02:50:47.804688362Z"}”
},
},
{
@timestamp”: “2023-02-01 02:50:47.809”,
@message”: {
“log”: “{"log":"\u001b[0m\u001b[31m02:50:47,803 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-6718) Uncaught server error: org.hibernate.exception.GenericJDBCException: could not read next row of results\n","stream":"stdout","time":"2023-02-01T02:50:47.804724813Z"}”
}
},