jobs: failed to retrieve access token for plaid link: pg: no rows in result set

[sentry-io]

Sentry Issue: REST-API-1A

internal.Error: pg: no rows in result set
*errors.withMessage: failed to retrieve access token for plaid link: pg: no rows in result set
*errors.withStack: failed to retrieve access token for plaid link: pg: no rows in result set
  File "/build/pkg/secrets/postgres.go", line 61, in (*postgresPlaidSecretProvider).GetAccessTokenForPlaidLinkId
  File "/build/pkg/jobs/pull_latest_transactions.go", line 141, in (*jobManagerBase).pullLatestTransactions.func2
  File "/build/pkg/jobs/jobs.go", line 205, in (*jobManagerBase).getRepositoryForJob.func1
  File "/go/pkg/mod/github.com/go-pg/pg/v10@v10.10.2/tx.go", line 95, in (*Tx).RunInTransaction
  File "/go/pkg/mod/github.com/go-pg/pg/v10@v10.10.2/tx.go", line 74, in (*baseDB).RunInTransaction
...
(8 additional frame(s) were not displayed)

This is failing poorly due to some links not having access tokens. As to why they do not have access tokens I do not know. But graceful handling of this error should be added, as well as a way to potentially mark links that do not have access tokens as "orphaned" to prevent the error from occurring forever.

[elliotcourant]

This is now handled a bit better, but maybe some improvements should be made around this to help track it if it starts happening again.