Another database recovery problem

From: "Chris White (cjwhite)" <cjwhite(at)cisco(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Another database recovery problem
Date: 2003-10-30 23:59:43
Message-ID: 002501c39f41$e3d87410$0400a8c0@amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

My 7.2.1 database was in the middle of inserting a large object when the
power went down. When I restart the database I getting the following
messages:

postgres: startup subprocess : DEBUG sql sql sql DEBUG: database
system was interrupted at 2003-10-08 09:29:12 PDT
postgres: startup subprocess : DEBUG sql sql sql DEBUG: checkpoint
postgres: startup subprocess : DEBUG sql sql sql DEBUG: redo record
is at 0/115A3C; undo record is at 0/0; shutdown TRUE
postgres: startup subprocess : DEBUG sql sql sql DEBUG: next
transaction id: 95; next oid: 16557
postgres: startup subprocess : DEBUG sql sql sql DEBUG: database
system was not properly shut down; automatic recovery in progress
postgres: startup subprocess : DEBUG sql sql sql DEBUG: redo starts
at 0/115A7C
postgres: startup subprocess : DEBUG sql sql sql DEBUG: ReadRecord:
record with zero length at 0/157F4C
postgres: startup subprocess : DEBUG sql sql sql DEBUG: redo done
at 0/157F28
postgres: startup subprocess : DEBUG sql sql sql DEBUG: database
system is ready


When I vacuum the database to remove used entries and to compact the db,
I get the following errors:

postgres: voicemail aesop 127.0.0.1 VACUUM: DEBUG sql sql sql DEBUG
--Relation pg_largeobject--
postgres: voicemail aesop 127.0.0.1 VACUUM: INFO sql sql sql NOTICE:
Rel pg_largeobject: TID 1/1: InsertTransactionInProgress 0 - can't
shrink relation
postgres: voicemail aesop 127.0.0.1 VACUUM: INFO sql sql sql NOTICE:
Rel pg_largeobject: TID 1/2: InsertTransactionInProgress 0 - can't
shrink relation
postgres: voicemail aesop 127.0.0.1 VACUUM: INFO sql sql sql NOTICE:
Rel pg_largeobject: TID 1/4: InsertTransactionInProgress 0 - can't
shrink relation
postgres: voicemail aesop 127.0.0.1 VACUUM: CRASH sql sql sql FATAL2:
open of /data/sql/pg_clog/09C6 failed: No such file or directory
postmaster: DEBUG sql sql sql DEBUG: server process (pid 1393) exited
with exit code 2
postmaster: DEBUG sql sql sql DEBUG: terminating any other active
server processes
postmaster: ERROR sql sql sql FATAL 1: The database system is in
recovery mode

and from then on any time we try to connect we get a message saying
database is in recovery mode and it never comes out. How can I recover
this database or do I have to restore a prior backup?

Chris White

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-10-31 00:38:57 Re: Another database recovery problem
Previous Message Tom Lane 2003-10-30 22:31:53 Re: help from Portugal