Thread: Strange behaviour

Hi folks !

Where to start looking for cure ?

I have a database, simple one, about teams and team members, nothing fancy
about it, straight forward, add, mod and del teams and their members. Four
tables team_type_1, members_type_1, team_type_2 and members_type_2.

Whatever I do with this db, I have another postmaster and httpd process
started and running and these keep piling up until everything freezes and at
the same time I see this error on an other terminal window for every access,
be it even a simple select:

bash-2.04$ postmaster -D /usr/share/pgdata/
020425.18:57:20.546  [7218] DEBUG:  Data Base System is starting up at Thu
Apr 25 18:57:20 2002
020425.18:57:20.546  [7218] DEBUG:  Data Base System was shut down at Thu Apr
25 18:54:49 2002
020425.18:57:20.548  [7218] DEBUG:  Data Base System is in production state
at Thu Apr 25 18:57:20 2002
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection


I have default / install config on RH 7.1 and Pg is 7.1.3 which comes with RH
distribution. Nothing like this on any other db. I have scheduled vacuum for
all dbs every night. All runs on 800Mhz / 256 RAM machine. I (and others)
access the dbs via ColdFusion / web ( yes, some might have opinions about
this, but don't think it is the issue here )

What is the max or recommended max number of dbs for the system. I have now
just under 40 small ones, 'biggest' contains 11000 rows. The dump file of all
dbs is about 4.5 MB, which can't be nothing yet ?

I am a bit lost here, so please give a hint.

TIA,

aarni

Aarni =?iso-8859-1?q?Ruuhim=E4ki=20=2F=20Megative=20Tmi=20=2F=20KYMI=2Ecom?= <aarni.ruuhimaki@kymi.com> writes:
> bash-2.04$ postmaster -D /usr/share/pgdata/
> 020425.18:57:20.546  [7218] DEBUG:  Data Base System is starting up at Thu
> Apr 25 18:57:20 2002
> 020425.18:57:20.546  [7218] DEBUG:  Data Base System was shut down at Thu Apr
> 25 18:54:49 2002
> 020425.18:57:20.548  [7218] DEBUG:  Data Base System is in production state
> at Thu Apr 25 18:57:20 2002
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection
> pq_recvbuf: unexpected EOF on client connection

There's no reason here to think that Postgres has a problem: all you are
showing us is a bunch of clients disconnecting without bothering to send
a 'connection complete' message (which might be their normal behavior,
depending on the client software).

My guess is that you are mismanaging persistent connections somehow on
the client side (ie, keeping a connection open but failing to reuse it),
but you aren't going to find help for that here.  Try asking a
ColdFusion group.

            regards, tom lane