| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Jeff Bohmer <bohmer(at)visionlink(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Duplicate oid and primary key values |
| Date: | 2004-02-10 21:12:31 |
| Message-ID: | Pine.LNX.4.33.0402101412000.29472-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 10 Feb 2004, Jeff Bohmer wrote:
>
> I have a table in a PG 7.4.1 database with 380 duplicate rows,
> including duplicate oid and primary key values. Looking through our
> backups, the duplicates did not exist before Friday, 02/06/2004. I'm
> assuming neither pg_dumpall nor restoring from a pg_dumpall file will
> eliminate such duplicates. We upgraded from 7.3.4 to 7.4.1 on
> 02/02/2004.
>
> What can cause these duplicates?
>
> The server has had several system crashes over the past few days and weeks.
Check your hardware. bad memory, bad cpu, or bad hard drives can cause
these problems. Postgresql, like most databases, expects the hardware to
operate without errors.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Lebedev | 2004-02-10 21:17:02 | Re: Upgrade function problem - c language |
| Previous Message | Richard Huxton | 2004-02-10 21:07:17 | Re: Join query on 1M row table slow |