Weird problem - possibly a bug.

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

Responses

Browse pgsql-general by date

  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