Re: Data Recovery

Ok - I found the log messages:

ERROR: duplicate key violates unique constraint "features_pkey"
STATEMENT: insert into features
(propid,dtmodified,proptype,groupid,featid,group_desc,feat_desc)
values (449356005,'3/9/2005 12:03:59 AM',1,26,1,'Water','PublicWater')
PANIC: right sibling's left-link doesn't match
STATEMENT: insert into features
(propid,dtmodified,proptype,groupid,featid,group_desc,feat_desc)
values (449356005,'3/9/2005 12:04:00 AM',1,27,1,'Sewer','PublicSewer')
LOG: server process (PID 13129) was terminated by signal 6
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
STATEMENT: update features set dtmodified='9/16/2004 7:28:42
AM',proptype=3,group_desc='Primary Heating',feat_desc='GasHeat' where
propid=442448204 and groupid=15 and featid=2
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
STATEMENT: select count(C.agentcode) from propmain A,areacodes
B,members C,office D,type_xref E,prop_extra F where A.listprice<350000
and A.listprice>100000 and A.approx_age<300 and A.approx_age>0 and
A.areacode=B.areacode and A.listagent=C.agentcode and
C.officecode=D.officecode and A.type_of_prop=E.type_of_prop and
A.propid=F.propid and lower(B.group_name) in ('bucks') and
A.school_dist in ('quakertown comm','u perkiomen') and A.type_of_prop
in ('SNG')
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process
exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2005-03-12 01:36:41 EST
LOG: checkpoint record is at 2B/553CED30
LOG: redo record is at 2B/553CED30; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 118419066; next OID: 50155349
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 2B/553CED78
FATAL: the database system is starting up
FATAL: the database system is starting up

On Wed, 16 Mar 2005 16:02:58 -0500, Alex Turner <armtuk(at)gmail(dot)com> wrote:
> Fsync was off - we are using XFS and the Microcontroller on the RAID
> card Crashed and took two filesystems offline at about 2 a.m.
>
> There were some error messages in the postgres log, something like
> Update failed - right part of branch is wrong (I'm guessing - I'm
> trying to find the exact error - but we do 10 hits/second and there
> are alot of logs).
>
> The pg_dumpall would get to a certain table and crap out - it would
> just not read anymore data.
>
> Thanks,
>
> Alex Turner
> netEconomist
>
> On Wed, 16 Mar 2005 12:51:21 -0800, Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> > On Wed, 16 Mar 2005 15:46:16 -0500, Alex Turner <armtuk(at)gmail(dot)com> wrote:
> > > It's postgresl 8.01 on AMD 64 Suse 9.2. The database didn't dump
> > > succesfully for several days in a row so the backup is corrupted also.
> > >
> > > The controller card crashed and we think caused data corruption. I
> > > rebooted the system the following day, and it came back up, but all
> > > was not well, pg_dump all failed that day, and the following day.
> >
> > Failed how? What options are you using and what kind of output are
> > you seeing?
> >
> > What makes you think you had data corruption? What kind of filesystem
> > are you using?
> >
> >
> > --
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > L. Friedman netllama(at)gmail(dot)com
> > LlamaLand http://netllama.linux-sxs.org
> >
>