Re: Runaway backend at 100% CPU PostgreSQL v8.3.5 - Mailing list pgsql-hackers

From Stephen R. van den Berg
Subject Re: Runaway backend at 100% CPU PostgreSQL v8.3.5
Date
Msg-id 20090107003327.GD13379@cuci.nl
Whole thread Raw
In response to Re: Runaway backend at 100% CPU PostgreSQL v8.3.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
>"Stephen R. van den Berg" <srb@cuci.nl> writes:
>> BEGIN
>>  vcsid:=vfrom;
>>  LOOP

>>   EXIT WHEN vsid IS NOT NULL OR vcsid=vold;
>>  END LOOP;
>>  RETURN vsid;
>> END;

>And are you certain that's never an infinite loop?  The query string
>gives a starting point that one suspects doesn't terminate.

Indeed, you're right.  It starts at a deleted item due to a race condition.
Thanks, sorry for the noise.
-- 
Sincerely,          Stephen R. van den Berg.

"Very funny, Mr. Scott. Now beam down my clothes!"


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Re: [COMMITTERS] pgsql: This makes all the \dX commands (most importantly to most: \df)
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Warning about the 8.4 release