From: | Network Administrator <netadmin(at)vcsn(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Database Recovery Procedures |
Date: | 2003-09-17 15:08:45 |
Message-ID: | 1063811325.3f6878fd15329@webmail.vcsn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)sss(dot)pgh(dot)pa(dot)us>:
> Network Administrator <netadmin(at)vcsn(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-09-17 15:08:57 | Re: char o varchar |
Previous Message | Tom Lane | 2003-09-17 14:47:20 | Re: State of Beta 2 |