backend error after upgrading to 3.6.0

[Erik Wienhold]

On 2025-09-15 19:16 +0200, Ярослав Минин via postgis-users wrote:
> 
> Hello! We have stumbled upon a strange issue after upgrading from
> PostGIS 3.3.0 to 3.6.0.
> A simple query like  select * from foo.bar where ST_IsValid(geometry)
> executed in DBeaver returns the following error:
> SQL Error [08006]: An I/O error occurred while sending to the backend
> if the size of this table is like 6 Mb or more. While executing
> DBeaver shows something like connection attempts and finally
> invalidates/reconnects with this error message.

That error message originates from pgJDBC [1].  Do you have to the full
stack trace?  Without that info it's impossible for us to track down the
cause.  But I doubt that it has anything to do with PostGIS or even the
Postgres backend judging by the implementation at [1] which may fail
when it cannot copy the InputStream.  Better raise that issue with
DBeaver or pgJDBC itself.

Nevertheless, can you reproduce this error with psql to rule out any
interference from DBeaver/JDBC?  Perhaps also the server log?

[1] https://github.com/pgjdbc/pgjdbc/blob/a3be9d5ec7efe18e88e44f1637c459eb2bb4cc15/pgjdbc/src/main/java/org/postgresql/util/StreamWrapper.java#L86

-- 
Erik Wienhold