Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Bug in oracle 8.1.7 on Win2000server

Re: Bug in oracle 8.1.7 on Win2000server

From: s.kapitza <skapitza_at_volcanomail.com>
Date: 20 Feb 2003 23:59:56 -0800
Message-ID: <26703915.0302202359.1f36972d@posting.google.com>


What about a little Update Trigger
to proof that not any other Process
is updating the table ?  

regards

stefan

Adrion-Weber <Adrion-Weber_at_t-online.de> wrote in message news:<3E55356B.3E77349B_at_t-online.de>...
> Hi all,
>
> yesterday I had a really "funny" adventure.
> there is a server Win2000 with oracle 8.1.7 SE 2 instances with about 1
> G virtual memory on each.
> RAM is 2 GB.
> in one instance I had a failure found by a check routine in the
> application.
> so I detected, that a column in a row was not updated.
>
> So I tried to do it manually.
>
> following sequence of SQL-statements (in SQLPlus):
> 1.SELECT amount FROM DELIVERY WHERE DeliveryNo = 123456 ;
> AMOUNT
> ========
> 585.12
>
> 2.UPDATE DELIVERY SET amount = 653.88 WHERE DeliveryNo = 123456 ;
> Row updated
>
> 3.SELECT amount FROM DELIVERY WHERE DeliveryNo = 123456 ;
> AMOUNT
> ========
> 653.88
>
> 4. commit;
> Transaction comitted.
>
> 5.SELECT amount FROM DELIVERY WHERE DeliveryNo = 123456 ;
> AMOUNT
> ========
> 653.88
>
> 6.SELECT amount FROM DELIVERY WHERE DeliveryNo = 123456 ;
> AMOUNT
> ========
> 653.88
>
> 1.SELECT amount FROM DELIVERY WHERE DeliveryNo = 123456 ;
> AMOUNT
> ========
> 585.12 <=== the old value reappears after a few seconds (about 5-10)
>
> together we are three persons who saw this bug on a production database.
>
> we could reproduce this several times.
> after database shut down and startup again the bug disappeared.
>
> How can I trust a "bank", even a "datenbank"(=database ?)
>
> regards Berni
Received on Fri Feb 21 2003 - 01:59:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US