Pacticipant version cannot be deleted when webhook has been triggered

[bartschotten]

Pre issue-raising checklist

I have already (please mark the applicable with an x):

• Upgraded to the latest Pact Broker OR
• Checked the CHANGELOG to see if the issue I am about to raise has been fixed
• Created an executable example that demonstrates the issue using either a:
  • Dockerfile
  • Git repository with a Travis or Appveyor (or similar) build

Software versions

• pact-broker docker version: eg 2.31.0-1

Expected behaviour

Calling DELETE on a pacticipant version resource should delete it.

Actual behaviour

500 internal server error is returned.

Steps to reproduce

Trigger webhook related to the version, then try to delete it.

Relevent log files

ERROR -- : PG::ForeignKeyViolation: ERROR: update or delete on table "pact_publications" violates foreign key constraint "triggered_webhooks_pact_publication_id_fkey" on table "triggered_webhooks"

[bethesque]

Please update to the latest version of the Pact Broker.

[bethesque]

PS I still recommend using the SQL script to clean up the data - it will be much faster than iterating over the API.

[bartschotten]

We upgraded to the latest version and the issue has indeed been fixed. Thanks a lot. I'll look into the sql script as well.