Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

service-api gets unhealthy state after postgresSQL deadlock #1720

Open
qasamppa opened this issue Jun 29, 2023 · 0 comments
Open

service-api gets unhealthy state after postgresSQL deadlock #1720

qasamppa opened this issue Jun 29, 2023 · 0 comments

Comments

@qasamppa
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant