Hello,
While deleting a pacticipant, I am getting ...
# pact-brokers
Sushant Soni
03/14/2023, 2:03 PMHello,
While deleting a pacticipant, I am getting this error in the Pact Broker logs. Can you please guide me what could be wrong?
Copy code
Cause: PG::QueryCanceled: ERROR: canceling statement due to statement timeout
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."webhook_executions" x WHERE $1 OPERATOR(pg_catalog.=) "pact_publication_id" FOR KEY SHARE OF x"m
Matt (pactflow.io / pact-js / pact-go)
03/14/2023, 8:21 PM
You might need to enable automatic data cleaning, my guess is it's timing out deleting associated data (i.e. the delete is cascading in a transaction and that is exceeding the statement timeout)
b
Beth (pactflow.io/Pact Broker/pact-ruby)
03/15/2023, 6:44 AM
We might need an index on the pact publication id
👍 1
Beth (pactflow.io/Pact Broker/pact-ruby)
03/15/2023, 6:49 AM
Yeah, looks like there isn't one.
👍 1
5 Views