Re: Data integrity problem !!!

Tom Lane wrote:
> 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.

The user reported they were running 7.2.  I assume they got bitten by
the sequence counter bug we fixed in 7.2.1.  They just upgraded to 7.2.1
so I assume the problem will not happen again.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026