aborting startup due to startup process failure

From: "George Wilk" <gwilk(at)ellacoya(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: aborting startup due to startup process failure
Date: 2007-06-28 19:55:29
Message-ID: 006101c7b9be$479dfed0$0d7ba8c0@ellacoya.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I posted to this group before with the same topic but nobody replied.
Please, provide some feedback if you can.

I am running a warm standby server, which executes the following command in
a recovery mode:

triggered=false

while (test ! -f /var/ipsc/WAL/$1 && ! $triggered)

do

echo waiting for file: $1

sleep 30

if test -f /var/ipsc/pgsql/trigger

then

echo --- trigger found ---

echo --- exiting recovery mode ---

triggered=true

fi

done

if ( ! $triggered)

then

cp /var/ipsc/WAL/$1 $2

else

exit 133

fi

Recovery command works just fine restoring data from the WAL files scp'd
from the primary server. While in the recovery mode, when I create the
trigger file breaking the while loop in recovery command, postgres does not
go gently into the active database mode. Here is output:

waiting for file: 00000001000000000000003A

--- trigger found ---

--- exiting recovery mode ---

FATAL: could not restore file "00000001000000000000003A" from archive:
return code 34048

LOG: startup process (PID 13994) exited with exit code 1

LOG: aborting startup due to startup process failure

After finding the trigger file my recovery_cmd returns non-zero code. Why
am I still getting FATAL: could not restore file ?

Both my primary and standby servers run on Solaris 10 under SMF. When the
standby server is attempting to change mode from recovery to regular
database mode, there might be a race condition there between SMF trying to
restart the server and the server trying to restart itself. or am I just
hallucinating.

Thanks in advance for your comments.

Cheers,

~george

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2007-06-28 21:16:48 Re: aborting startup due to startup process failure
Previous Message Raymond O'Donnell 2007-06-28 18:43:23 Re: [GENERAL] i need a rad/ide open source for work with postgresql