solana-accountsdb-plugin-postgres icon indicating copy to clipboard operation
solana-accountsdb-plugin-postgres copied to clipboard

No reconnect logic

Open skynetcap opened this issue 2 years ago • 0 comments

I had this plugin feeding into a Postgres, and then overnight it stopped working, and my log was filled with:

[2022-09-13T15:27:51.193907033Z ERROR solana_geyser_plugin_postgres::postgres_client] Failed to update account: (Error updating account. Error message: (Failed to persist the update of account to the PostgreSQL database. Error: Error { kind: Closed, cause: None }))

So either Postgres killed the connection, or this did. Either way, it failed to reconnect. Postgres was up and running, and I am forced to restart the entire validator process to reconnect.

Solution: Add auto-reconnect logic if a connection gets closed.

skynetcap avatar Sep 13 '22 15:09 skynetcap