CODEWITHSUNDEEP
postgresqlpostgresql-9.1
Scott Klarenbach
Scott Klarenbach

Reputation: 38731

Postgresql An I/O error occurred while sending to the backend

I have postgresql 9.1.19 deployed on a Windows Server 2008 R2.

For some reason, it started throwing exceptions with no other information other than "an I/O error occurred while sending to the backend".

It only happens with certain tables.

If I use a clean database, the error disappears, which leads me to believe I am running out of memory or some other allocated resource which is causing the error??

I'm connecting via JDBC.

Any insights would be greatly appreciated.

Thanks.

Scott.

Upvotes: 4

Views: 15692

Answers (2)

Scott Klarenbach
Scott Klarenbach

Reputation: 38731

The problem was that I was performing an IN query with too many parameters...due to an ORM generated query.

But very unhelpful message that could've been much more specific.

For example, Postgres will throw a more helpful message if you select too many columns, or use too many characters, etc. Maybe this is a jdbc issue too, not sure.

Upvotes: 1

barbarity
barbarity

Reputation: 2488

The error means you're timing out while connecting to the database.

Check you have the connection configured correctly. If it is, see if you have access to the database or there's some firewall forbidding the access.

Upvotes: 1

Related Questions