pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddb recovery (FATAL 2)
2+ messages / 2 participants
[nested] [flat]
* db recovery (FATAL 2)
@ 2002-05-07 14:22 Bojan Belovic <bbelovic@usa.net>
2002-05-08 05:59 ` Re: db recovery (FATAL 2) Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Bojan Belovic @ 2002-05-07 14:22 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
My database apparently crashed - don't know how or why. It happend in the
middle of the night so I wasn't around to troubleshoot it at the time. It
looks like it died during the scheduled vacuum.
Here's the log that gets generated when I attempt to bring it back up:
postmaster successfully started
DEBUG: database system shutdown was interrupted at 2002-05-07 09:35:35 EDT
DEBUG: CheckPoint record at (10, 1531023244)
DEBUG: Redo record at (10, 1531023244); Undo record at (10, 1531022908);
Shutdown FALSE
DEBUG: NextTransactionId: 29939385; NextOid: 9729307
DEBUG: database system was not properly shut down; automatic recovery in
progress...
DEBUG: redo starts at (10, 1531023308)
DEBUG: ReadRecord: record with zero len at (10, 1575756128)
DEBUG: redo done at (10, 1575756064)
FATAL 2: write(logfile 10 seg 93 off 15474688) failed: Success
/usr/bin/postmaster: Startup proc 1339 exited with status 512 - abort
Any suggestions? What are my options, other than doing a complete restore of
the DB from a dump (which is not really an option as the backup is not as
recent as it should be).
Thanks!
Bojan
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: db recovery (FATAL 2)
2002-05-07 14:22 db recovery (FATAL 2) Bojan Belovic <bbelovic@usa.net>
@ 2002-05-08 05:59 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2002-05-08 05:59 UTC (permalink / raw)
To: Bojan Belovic <bbelovic@usa.net>; +Cc: pgsql-admin@postgresql.org
Bojan Belovic <bbelovic@usa.net> writes:
> FATAL 2: write(logfile 10 seg 93 off 15474688) failed: Success
This would be what PG version?
Broad-jumping to conclusions, I'm going to guess (a) 7.1.0-7.1.2
and (b) you are out of disk space for the WAL logs.
If so, you'll need to free up 16MB or so to restart the postmaster,
and you'd be well advised to update to 7.1.3 before trying another
VACUUM.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-05-08 05:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-05-07 14:22 db recovery (FATAL 2) Bojan Belovic <bbelovic@usa.net>
2002-05-08 05:59 ` Tom Lane <tgl@sss.pgh.pa.us>
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