From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | <me(at)shanewright(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: backend stalls |
Date: | 2001-09-27 19:54:13 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGMEHKDLAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)doxpop(dot)com Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
nick(at)fankhausers(dot)com http://www.fankhausers.com
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Shane Wright
> Sent: Saturday, September 22, 2001 12:59 PM
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Keary Suska | 2001-09-27 20:15:13 | Re: Quoting '?' placeholder in Perl's DBD::Pg? |
Previous Message | Steve Wolfe | 2001-09-27 19:46:53 | Re: Reading the database in RAM |