service-api icon indicating copy to clipboard operation
service-api copied to clipboard

service-api gets unhealthy state after postgresSQL deadlock

Open qasamppa opened this issue 1 year ago • 0 comments

I am not sure, if this is correct place for this issue... Suddenly service-api noticed postgreSQL deadlock while updating test-results. What might cause this? We have docker solution in use and latest docker-compose.yml without modifications Only change we made was this elastic search data folder group and rights change based on ReportPortal documentation. This was mandatory. Known issue 1

Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected Detail: Process 7473 waits for ShareLock on transaction 6373; blocked by process 7359. Process 7359 waits for ShareLock on transaction 7083; blocked by process 7473. Hint: See server log for query details. Where: while updating tuple (3,192) in relation "test_item_results" reportportal.zip

qasamppa avatar Jun 29 '23 05:06 qasamppa