Re: Weird problem - possibly a bug.

Aha,

    so  I  wasn't halluzinating at all, and Tom was right that it
    probably doesn't have to do with the lazy vacuum by itself.

    But anyway, "HAL, we have a  problem".  Seems  we  have  some
    longer standing bug here, causing a row to survive an UPDATE.


Jan

Glen Eustace wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com