Disconnect PayPal gives "Looks like you've found a bug! Sorry for the inconvenience, we'll get it fixed ASAP!"

[toy]

Account toy, I have only one verified email, when clicking Disconnect button on PayPal page, I get the error.

[chadwhitacre]

Sorry, @toy. :-/

Don't have time now, but I will look into this when I get a chance if someone else doesn't get to it first ...

[toy]

It is not really urgent. I already saw this bug, but assumed that you are getting notifications, but as the bug was not fixed, I've created an issue.

[rohitpaulk]

Copying the error from Sentry:

IntegrityError: update or delete on table "exchange_routes" violates foreign key constraint "exchanges_route_fkey" on table "exchanges"
DETAIL:  Key (id)=(10189) is still referenced from table "exchanges".

Looks like we're trying to delete the exchange route, but the foreign key constraint between exchanges -> exchange_routes prevents us from doing so.

Hmm, maybe we should be soft deleting exchange routes?

[chadwhitacre]

assumed that you are getting notifications

We are getting notifications, but we're not staying on top of them. Sorry. 😞

[rohitpaulk]

Aha!

[rohitpaulk]

The DELETE statement was added by me in 0500105, and @whit537 added the comment above that in e27a228.

I think the best way out here is to update the error to 'invalidated' irrespective of the network - and when user tries to add the route again for paypal, we revive the previous exchange_route.

[rohitpaulk]

Moving implementation details to a PR so that we don't pollute this issue

[toy]

Still not possible to disconnect

[chadwhitacre]

Mind giving this another shot, @toy? We just deployed #4170 in an attempt to fix this.

[toy]

@whit537 Thanks! It seems to work, as I was able to disconnect the paypal account.

[chadwhitacre]

Woo-hoo! Thanks for your patience. :-)