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