Re: Database Recovery Procedures

Ok, upgrade done and the system is up but when try hit database through the app
(browser front end just does selects) on the debug screen (level 3) I get this...

DEBUG:  child process (pid 21248) was terminated by signal 6
LOG:  server process (pid 21248) was terminated by signal 6
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing shared memory and semaphores
DEBUG:  shmem_exit(0)
DEBUG:  invoking IpcMemoryCreate(size=1466368)
LOG:  database system was interrupted at 2003-09-17 10:52:16 EDT
LOG:  checkpoint record is at 5/2D498110
LOG:  redo record is at 5/2D498110; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 5287090; next oid: 26471
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  ReadRecord: record with zero length at 5/2D498150
LOG:  redo is not required
LOG:  database system is ready
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)

..if I using the psql client, and issue a "select * from <corrupt table name>
limit 5" if get this...


PANIC:  read of clog file 5, offset 16384 failed: Success
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

..I've never seen the prompt got to "!#"


So back to my original question.  What are the recover procedures (if any) that
should be tried before I grab my PGDATA path from tape?


Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> Network Administrator <netadmin@vcsn.com> writes:
> > PANIC:  XLogWrite: write request 5/2D498000 is past end of log 5/2D498000
>
> I'll bet you are running 7.3.3.  You need to update to 7.3.4 to escape
> this startup bug.
>
>             regards, tom lane
>


--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com