Re: backend stalls - Mailing list pgsql-general

From Mitch Vincent
Subject Re: backend stalls
Date
Msg-id 005a01c1478a$5b6e2a90$1e51000a@mitch
Whole thread Raw
In response to backend stalls  (Shane Wright <me@shanewright.co.uk>)
Responses Re: backend stalls
List pgsql-general
You should upgrade to the latest version (7.1.3) and see if you're still
experiencing the same problems..I'm sure you're interested in finding out
why it's happening but upgrading is still a good idea.... I'm almost
positive that the RPMs are available for 7.1.3..


-Mitch

----- Original Message -----
From: "Shane Wright" <me@shanewright.co.uk>
To: <pgsql-general@postgresql.org>
Sent: Saturday, September 22, 2001 1:58 PM
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)
>


pgsql-general by date:

Previous
From: "Dave VanAuken"
Date:
Subject: pgsql and SSL
Next
From: vitthal
Date:
Subject: Reading the database in RAM