From: Andrew Janian <ajanian@scottrade.com>
To: Anjan Dave <adave@vantage.com>
To: pgsql-admin@postgresql.org
Subject: Re: startup subprocess hangs
Date: Fri, 17 Jun 2005 17:46:41 -0400
Message-ID: <80AD4CD06F9D904EAB15D6A1792268D50F2E04@EXCHSTL2.scottrade.com> (raw)
It seems that I have made things significantly worse. I am in the
process of restoring from last night's backup. Then I should be able to
get the data that I missed today back in.
Thanks for the help,
Andrew
_____
From: Anjan Dave [mailto:adave@vantage.com]
Sent: Friday, June 17, 2005 4:45 PM
To: Andrew Janian; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] startup subprocess hangs
Without any actual messages, not sure what to say in regards to whether
it is still recovering, or finished recovering successfully (from the
logs).
There are a few ways to check if the postmaster is up. A simple check is
to try a psql <dbname> and see if you're up.
Thanks,
Anjan
_____
From: Andrew Janian [mailto:ajanian@scottrade.com]
Sent: Friday, June 17, 2005 4:37 PM
To: Anjan Dave; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] startup subprocess hangs
Do you want me to stop the recovery to get the console messages? After
issuing the start command I did not capture the logs because I did not
notice a problem right away. Now I cannot see them anymore.
Is there anything I can do?
The database is 99GB with almost all the data in one table.
How long should the recovery process take?
Thanks,
Andrew
_____
From: Anjan Dave [mailto:adave@vantage.com]
Sent: Friday, June 17, 2005 3:32 PM
To: Andrew Janian; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] startup subprocess hangs
Probably some kind of a hardware issue (you lost a path to the array for
e.g.), or someone may have issued a kill -9 to postmaster?
Open another terminal and check the system log (/var/log/messages) if
you are not redirecting logs anywhere.
Can you paste the console messages on the list so people can see what
exactly might be going on?
Thanks,
Anjan
_____
From: Andrew Janian [mailto:ajanian@scottrade.com]
Sent: Friday, June 17, 2005 4:21 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] startup subprocess hangs
I am running Postgres 7.4.5 and I have recently run into a problem. My
database was running fine for days and then today in the middle of the
day it seems that the startup subprocess kicked in and started
recovering. I am not sure from what, and I am not sure how it started,
but nothing was allowed to connect and it has been running for quite
some time (30 minutes). The process said it was starting to recover,
but how long am I to wait?
Is there a way to get the status?
Can I just skip the recovery and get it going?
The environment is RH EL 3 2.4.21-4.ELsmp, with and EMC SAN for storage
and QLogix cards for fibre access.
Thanks,
Andrew
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ajanian@scottrade.com, adave@vantage.com
Subject: Re: startup subprocess hangs
In-Reply-To: <80AD4CD06F9D904EAB15D6A1792268D50F2E04@EXCHSTL2.scottrade.com>
References: <80AD4CD06F9D904EAB15D6A1792268D50F2E04@EXCHSTL2.scottrade.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox