Strange behaviour

From: Aarni Ruuhimäki / Megative Tmi / KYMI(dot)com <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Strange behaviour
Date: 2002-04-25 17:38:17
Message-ID: 20020425173932.SVOM7072.fep08.tmt.tele.fi@there
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Leandro Fanzone 2002-04-25 19:13:41 Index on wildcard text search
Previous Message Tom Lane 2002-04-25 17:14:27 Re: Shell Script Execution