solana-accountsdb-plugin-postgres
solana-accountsdb-plugin-postgres copied to clipboard
No reconnect logic
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.