Hi all,
My bloomreach application is hosted on gcp kubernetes, we are facing unstability issue frequently. services are running fine on keubernetes but cms says :
We checked in logs, found below logs but still not sure it is causing the issue.
"
INFO 2023-09-26T13:08:18.189408496Z [resource.labels.containerName: hep-bloomreach-cms] SELECT * FROM REPOSITORY_HIPPO_LOCK WHERE status=‘ABORT’ AND lockOwner=? [57014-200]
INFO 2023-09-26T13:08:18.189400723Z [resource.labels.containerName: hep-bloomreach-cms] org.h2.jdbc.JdbcSQLTimeoutException: Statement was canceled or the session timed out; SQL statement:
INFO 2023-09-26T13:08:18.189358101Z [resource.labels.containerName: hep-bloomreach-cms] 26.09.2023 13:08:18 ERROR pool-4-thread-1 [LockThreadInterrupter.run:100] Exception in org.onehippo.repository.lock.db.LockThreadInterrupter happened:
{
“textPayload”: “26.09.2023 13:08:18 ERROR pool-4-thread-1 [LockThreadInterrupter.run:100] Exception in org.onehippo.repository.lock.db.LockThreadInterrupter happened:”,
“insertId”: “deaq9pev5df26uze”,
“resource”: {
“type”: “k8s_container”,
“labels”: {
“pod_name”: “hep-bloomreach-cms-5555479b6b-m65xh”,
“namespace_name”: “default”,
“project_id”: “projpoc”,
“cluster_name”: “dev”,
“location”: “us-central1-a”,
“container_name”: “hep-bloomreach-cms”
}
},
“timestamp”: “2023-09-26T13:08:18.189358101Z”,
“severity”: “INFO”,
“labels”: {
“k8s-pod/pod-template-hash”: “5555479b6b”,
“k8s-pod/app”: “hep-bloomreach-cms”,
“compute.googleapis.com/resource_name”: “gke-dev-nodes-85016ce1-5rls”
},
“logName”: “projects/projpoc/logs/stdout”,
“receiveTimestamp”: “2023-09-26T13:08:22.703837365Z”
}
"
Please help me on above issue.!
Thanks,