We have installed
the PostgreSQL 7.1.3 database on a HPUX 11.00 system and was running fine until
now. The database has stopped and when running the '/sbin/init.d/postgres
start' command, it will only run for a few seconds before quitting. We
know this because we can grep on the 'postmaster' process but only exists for
the first 10-15 seconds or so.
We have turned on
debugging with the following results:
Appliedview pg_log invoking
IpcMemorycreate(size=1245184)
FindExec:
found "joptjpgsql-7.1.3jbinjpostmaster" using argv[O]
DEBUG:
database system shutdown was interrupted at 2002-10-0110:59:26 EDT
DEBUG:
checkpoint record at (2,
900015984)
DEBUG: Redo
record at (2, 899933184); undo record at (0, 0); Shutdown FALSE DEBUG:
NextTransactionld: 40178986; NextOid: 127439
DEBUG:
database system was not properly shut down; automatic recovery in progress. ..
DEBUG: redo
starts at (2, 899933184)
DEBUG:
ReadRecord: record with zero len at (2, 923216960) DEBUG: redo done at (2,
923216920)
FATAL 2:
XLogFlush: request is not satisfied
IDEBUG:
proc_exit(2)
DEBUG:
shmem_exit(2)
:
DEBUG: exit(2)
joptjpgsql-7.1.3jbinjpostmaster: reaping dead processes...
joptjpgsql-7.1.3jbinjpostmaster:
Startup proc 8056
exited
with status 512 -
abort
$
Is the database
corrupt? Can it be saved?
Thanks for
assistance,
Steve Wahl
Applications Engineer
<AppliedView/OpenView/HPUX>
[EMAIL PROTECTED]
5800 Innovation Drive
Dublin, OH 43016
(800)246-7852 <Tech. Support Hot Line>
(614)798-8133 <Fax>
<AppliedView/OpenView/HPUX>
[EMAIL PROTECTED]
5800 Innovation Drive
Dublin, OH 43016
(800)246-7852 <Tech. Support Hot Line>
(614)798-8133 <Fax>
