Re: backend stalls

Any chance you're running out of disk space somewhere?

Have you looked in the log file for clues?

(/var/log/postgres.log on debian - not sure if the location is the same on
other OSs.)

-Nick

---------------------------------------------------------------------
Nick Fankhauser

Business:
nickf@doxpop.com  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop  - Court records at your fingertips - http://www.doxpop.com/

Personal:
nick@fankhausers.com   http://www.fankhausers.com


> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Shane Wright
> Sent: Saturday, September 22, 2001 12:59 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] backend stalls
>
>
> Hi
>
> I'm tearing my hair out here, the backend seems to randomly
> decide to stall
> and not serve any more queries (processes are listed as waiting).
>
> It happens on all sorts of queries (including CREATE TABLE and
> CREATE INDEX).
>
> I have completely uninstalled and deleted the whole installation and
> reinstalled - only to have it do it again mid way through
> entering the SQL to
> rebuild my database (not a big one ~25 tables, and no rows to speak of -
> havent got that far yet).
>
> I was thinking corrupted tables - or corrupt system catalog, but even
> vacuumdb stalls as well...
>
> Any help would be appreciated, I have so much work to do and I cant do
> anything without the database working :(
>
> My install is Postgres 7.0.3-8 from the RedHat RPMs runing on RH7.1
>
> I know I havent given much specific information, I dont really
> know where to
> start.  What its doing at this very minute is hanging on an insert into a
> freshly created table on an installation thats only existed for
> 30 minutes
> and only just had all the tables created.
>
> Thanks
>
> Shane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>