From: | Pete Leonard <pete(at)hero(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: sick DB - ?? |
Date: | 2001-07-18 16:36:38 |
Message-ID: | Pine.LNX.4.10.10107180929440.636-100000@hero.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Followup ^2 -
The reason this happened was that for whatever reason (we're still
investigating), /tmp was writeable only by root.
I only noticed this when using initdb to create a new data directory.
postmaster offered no suggestion that there was a problem here, even when
running at -d5.
chmod 777 /tmp fixed everything.
my best guess (I don't know how postmaster is operating, I didn't run any
of the system-level diagnostic tools to check) is that if postmaster fails
on opening a pipe/tmpfile, rather than check the error properly, it
changes the filename and tries again ad infinitum? Perhaps printing some
error code (especially at debug level 5) would help?
thanks,
--pete
On Wed, 18 Jul 2001, Pete Leonard wrote:
>
> As a followup - the line from top:
>
> 1641 postgres 105 0 2684K 1384K CPU1 0 8:26 99.02% 99.02%
> postgres
>
> As you can see, it's barely taking up any RAM - the process is going nuts
> right off the bat..
>
> On Wed, 18 Jul 2001, Pete Leonard wrote:
>
> >
> > Postgres 7.1.2, FreeBSD 3.4
> >
> > Box got sick, had to bounce it. Postgres wasn't brought down in a
> > graceful fashion..
> >
> > restart didn't bring the DB back properly, so as the postgres user, did
> > the following:
> >
> > /usr/local/pgsql/bin/postmaster -d5 start
> >
> > it dumps the initial environment variables, and then returns nothing. CPU
> > is pegged at 100%. No reporting, no information as to what's happening.
> >
> > Solutions? It the DB corrupted badly? Where do I go from here?
> >
> > thanks,
> >
> > --pete
> >
> >
> >
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Hansen | 2001-07-18 16:43:10 | getting logging going on the rpms |
Previous Message | Richard Huxton | 2001-07-18 16:35:02 | Re: restore single table |