Reset can fail after removing dependent streams

[thomas-gerber]

Applies to Faros Community Edition

How to reproduce:

• on a GitHub connection, sync with the canned streams
• delete reviews and review_comments streams, trigger the reset

the reset fails with the following error 2022-04-06 17:04:22 ERROR i.a.c.i.LineGobbler(voidCall):82 - Failed to reset vcs_PullRequest data for origin mygithubsrc: [{"extensions":{"path":"$","code":"constraint-violation"},"message":"Foreign key violation. update or delete on table \"vcs_PullRequest\" violates foreign key constraint \"vcs_PullRequestComment_pullRequest_fkey\" on table \"vcs_PullRequestComment\""}] which is likely because the reset does not delete the data from the removed streams.

Workaround once in that situation: update source schema, reset, delete unwanted streams.

[huongtn]

@thomas-gerber I don't see GitHub connection is airbyte-connectors project