[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] Data integrity problem !!!
From: Tom Lane <tgl () sss ! pgh ! pa ! us>
Date: 2002-04-30 14:53:07
[Download RAW message or body]
Vaclav Kulakovsky <vaclav.kulakovsky@definity.cz> writes:
> I've started investigate a cause and I've found that there are really
> duplicated PK in table and some data in the same rows are corrupted. I
> I've checked all log files and database backups and found that this
> problem arose probably after run VACUUM ANALYZE command which is executed
> every night. Everning DB backup was ok and morning backup contained these
> errors. There were no user activity between these 2 backups except VACUUM
> ANALYZE command.
Hmm. Can you reproduce the problem from a standing start? (Ie, initdb,
load your evening backup, vacuum analyze, look for duplicates.) This
is a worrisome report but I really see nothing we can do without more
information. A test case would be great.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic