From: | Glen Eustace <geustace(at)godzone(dot)net(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Weird problem - possibly a bug. |
Date: | 2001-12-09 06:57:12 |
Message-ID: | 01120919571208.01550@agree-6 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tommi Mäkitalo | 2001-12-09 09:32:11 | Re: Database permissions |
Previous Message | S P Arif Sahari Wibowo | 2001-12-09 06:15:38 | Querying and setting a particular bit in a varying bit value |