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