ERROR: Failed to connect to the compute node

Support
1

I’m getting this error when I try to connect.

org.postgresql.util.PSQLException: ERROR: Failed to connect to the compute node
	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:646) ~[postgresql-42.3.5.jar:42.3.5]
	at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:180) ~[postgresql-42.3.5.jar:42.3.5]
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235) ~[postgresql-42.3.5.jar:42.3.5]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.3.5.jar:42.3.5]
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:223) ~[postgresql-42.3.5.jar:42.3.5]
	at org.postgresql.Driver.makeConnection(Driver.java:402) ~[postgresql-42.3.5.jar:42.3.5]
	at org.postgresql.Driver.connect(Driver.java:261) ~[postgresql-42.3.5.jar:42.3.5]

The dashboard shows this:
image

2

Hi! Can you please check again? We’ve had a few issues with service and rolled back the latest release. Your project should work now.

1 Like
3

Seems to connect again.
Is this typical?

org.postgresql.util.PSQLException: ERROR: index "idx_record_version" contains unexpected zero page at block 1737
  Hint: Please REINDEX it.

going to try to reindex it.

4

Looks a lot like this bug: Index corruption after compute crash and restart · Issue #1915 · neondatabase/neon · GitHub. Yeah, reindexing should fix it for now.

PR Init wal redo buffer for fpi by knizhnik · Pull Request #194 · neondatabase/postgres · GitHub to fix the underlying bug was just merged into main. Once that’s deployed to production, it should prevent the error from happening again.

Thanks!

1 Like
5

I also get “error: Failed to connect to the compute node” after some period of inactivity in my node based pg client.

Are we supposed to re-connect on every request? Or is it ok to hold a persistent but inactive connection?