Weird problem - possibly a bug. - Mailing list pgsql-general

From Glen Eustace
Subject Weird problem - possibly a bug.
Date
Msg-id 01120919571208.01550@agree-6
Whole thread Raw
Responses Re: Weird problem - possibly a bug.
Re: Weird problem - possibly a bug.
List pgsql-general
I have a single row table that I use to hold various data, this table is only
ever updated by my programs, none of them ever do an insert ( I set the
values initially using psql.  I have not had cause to look in the table until
today when a client notified me of a database error occuring in one of my
programs.

The table had 4 rows, all with the same OID. ( It is only supposed to have 1
!!)

admin=# select oid,* from control;
  oid  | next_client | next_dialin | next_domain | next_invnum | next_rctnum
| next_creditcard | open_period | rebuild_mail_config | rebuild_http_config
-------+-------------+-------------+-------------+-------------+-------------+-----------------+-----
--------+---------------------+---------------------
 37238 |       10285 |        1032 |       10288 |     1011804 |     2011237
|             141 | 200112      | f                   | f
 37238 |       10285 |        1032 |       10288 |     1011804 |     2011237
|             141 | 200112      | f                   | f
 37238 |       10285 |        1032 |       10288 |     1011804 |     2011251
|             141 | 200112      | f                   | f
 37238 |       10285 |        1032 |       10288 |     1011804 |     2011251
|             141 | 200112      | f                   | f
(4 rows)

It would appear that on a number of occassions, something has gone wrong. I
am using 7.1.3 on RH7.1

Finding these extra rows, with duplicate oids has destroyed my faith in the
integrity of the rest of this and other databases.

Comments appreciated.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015

pgsql-general by date:

Previous
From: S P Arif Sahari Wibowo
Date:
Subject: Querying and setting a particular bit in a varying bit value
Next
From: Tommi Mäkitalo
Date:
Subject: Re: Database permissions