Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Duplicate values found when reindexing unique index





Something else interesting about that: the apparent interloper page
contains just a single WAL record, which appears to be a shutdown
checkpoint bearing the timestamp "Thu Dec 27 2007, 16:55:01 EST".
Not sure if Mason can correlate that with any recent activity...

Nothing jumps to mind, but I'll crawl through the logs looking for anything interesting.

I'm starting to think that Occam's razor says you've got hardware
problems.  Or maybe a kernel-level bug that is causing writes to get
discarded.

For what its worth, we do closely monitor the server for RAID and kernel errors and haven't seen either variety reported in quite some time.

If it is some mysterious hardware or kernel error -- any suggestions for how I should go about narrowing that down?

Finally, if it would help to see the full wal segment files, let me know and I will email individually. (I assume the list doesn't want 32MB of attachments).

Mason




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group