| From: | Bojan Belovic <bbelovic(at)usa(dot)net> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | db recovery (FATAL 2) |
| Date: | 2002-05-07 14:22:03 |
| Message-ID: | 20020507142203.4114.qmail@uwdvg001.cms.usa.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pam Wampler | 2002-05-07 15:32:22 | Upgrade from 7.2 -> 7.2.1 |
| Previous Message | Marin Dimitrov | 2002-05-07 13:49:42 | Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean McCorkle | 2002-05-07 15:03:50 | blanking out repeated columns in rows |
| Previous Message | Marin Dimitrov | 2002-05-07 13:49:42 | Re: [ADMIN] [DOCS] Migrating Oracle to PostgreSQL |