pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

database corruption help needed
3+ messages / 3 participants
[nested] [flat]

* database corruption help needed
@ 2009-02-22 20:53 Ken.Colson@sage.com
  2009-02-22 23:12 ` Re: database corruption help needed Tom Lane <tgl@sss.pgh.pa.us>
  2009-02-24 05:24 ` Re: database corruption help needed Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Ken.Colson@sage.com @ 2009-02-22 20:53 UTC (permalink / raw)
  To: pgsql-admin

Greetings,

 

I had a hardware problem this morning, which I believe is now resolved, but
I seem to have a little database corruption issue.  This is what I am seeing
when I restart postgres:

 

PANIC: right sibling's left-link doesn't match

 

So I attempted to reindex the database and now I get this error:

 

ERROR:  could not create unique index

DETAIL:  Table contains duplicated values.

 

But it does not mention which index it is trying to build, so I am at a
little bit of a stand still.  I am currently vaccuming the database to see
if that helps, but...I don't know what else to do from here.

 

Any suggestions?  I am running 8.2.5 on 64bit Linux.

 

Thanks in advance,

Ken

 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: database corruption help needed
  2009-02-22 20:53 database corruption help needed Ken.Colson@sage.com
@ 2009-02-22 23:12 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2009-02-22 23:12 UTC (permalink / raw)
  To: Ken.Colson@sage.com; +Cc: pgsql-admin

Ken.Colson@sage.com writes:
> I had a hardware problem this morning, which I believe is now resolved, but
> I seem to have a little database corruption issue.  This is what I am seeing
> when I restart postgres:
> PANIC: right sibling's left-link doesn't match

8.2.6 and later provide a little more detail in that message --- try
updating.  (Be sure the update is built with same options as your
existing 8.2.5 installation.)

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: database corruption help needed
  2009-02-22 20:53 database corruption help needed Ken.Colson@sage.com
@ 2009-02-24 05:24 ` Scott Marlowe <scott.marlowe@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2009-02-24 05:24 UTC (permalink / raw)
  To: Ken.Colson@sage.com; +Cc: pgsql-admin

On Sun, Feb 22, 2009 at 1:53 PM,  <Ken.Colson@sage.com> wrote:
> Greetings,
>
>
>
> I had a hardware problem this morning, which I believe is now resolved, but
> I seem to have a little database corruption issue.  This is what I am seeing
> when I restart postgres:
>
> PANIC: right sibling's left-link doesn't match
>

Know that if you do get the database mostly or all the way back up, it
is not to be trusted, and you should make a backup, reinitdb and then
restore to a fresh database cluster.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2009-02-24 05:24 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-22 20:53 database corruption help needed Ken.Colson@sage.com
2009-02-22 23:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-02-24 05:24 ` Scott Marlowe <scott.marlowe@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox