Re: pq_recvbuf: unexpected EOF

On Fri, 25 Apr 2003, David Link wrote:

> Hi
>
> We went live a months back with very low volumn (so far) on
> subscription based website. And we are very happy. App built on 100%
> open source toolstack, with PostgreSQL (of course) at it's heart. I
> Can't tell you how pleased I am with Pg (coming from 5 year experience
> with Oracle).
>
> I'm writing to discuss some scaling issues. After bombarding the
> system using HTTPD::Bench::ApacheBench (from CPAN), she starts to fail
> some where around 30-50 concurrent requests, depending on the query.
> See error messages below.
>
> Any advice would be helpful.
> Thanks. David Link, White Plains, NY
>
> Specs:
> h/w: Dual AMD Athalon
> Red Hat 8.0 / Linux 2.4.7
> Apache 1.3.27 (w/ mod_perl)
> PostgreSQL 7.3.1
> perl 5.8
>
> DB Specs:
> Size: 10 GB
> tables: 280 / largest: 550,000 tuples / 25,000 relpages (8K)
> indexes: 650
>
> ERROR:
>
> [4] LOG: pq_recvbuf: unexpected EOF on client connection
> [4] LOG: server process (pid 28353) was terminated by signal 11

Sig 11 usually means flakey hardware. Check out www.memtest86.com and do
a couple dozen kernel or postgresql compiles to see if they get sig 11s
while running.

It's not uncommon for an error to be in a relatively unused spot of
memory, and only show up under heavy load as causing problems.