Re: Data Recovery - Mailing list pgsql-general

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@gmail.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@gmail.com> wrote:
> > On Wed, 16 Mar 2005 15:46:16 -0500, Alex Turner <armtuk@gmail.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@gmail.com
> > LlamaLand                       http://netllama.linux-sxs.org
> >
>