X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id C75EBD1B8C0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 29 Nov 2003 03:20:49 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 43393-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 28 Nov 2003 23:20:22 -0400 (AST)
Received: from web14919.mail.yahoo.com (web14919.mail.yahoo.com
	[216.136.225.224])
	by svr1.postgresql.org (Postfix) with SMTP id 9E668D1B450
	for <pgsql-sql@postgresql.org>; Fri, 28 Nov 2003 23:20:17 -0400 (AST)
Message-ID: <20031129032021.52222.qmail@web14919.mail.yahoo.com>
Received: from [202.9.168.62] by web14919.mail.yahoo.com via HTTP;
	Fri, 28 Nov 2003 19:20:21 PST
Date: Fri, 28 Nov 2003 19:20:21 -0800 (PST)
From: "George A.J" <jinujosein@yahoo.com>
Subject: Infinite loop crashes server
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-335921009-1070076021=:49691"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_30,
	HTML_10_20
X-Spam-Level: 
X-Archive-Number: 200311/337
X-Sequence-Number: 16152

--0-335921009-1070076021=:49691
Content-Type: text/plain; charset=us-ascii

hi all,
i am using PostgreSQL 7.3.2 on redhat linux 9.
there is problem when executing pl/pg sql functions.
if the function enter an infinite loop. the server is hanged.
cannot cancel the query.
the linux itself is hanged.i cannot kill postgres process.
i have to reboot the machine manually..
waited for a long time for completion. but no result .
when ever there is an infinite loop happened
the system have to be restarted. unfortunately it happened many time 
during development of the pl/pg sql function.
is it a bug in postgres. or is it configuration problem?
when the system is hanged disk access is 100%. the harddisk read indicator does not stop.
 
is there a solution for this problem..
pls help
regards
jinujose
 
 


---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
--0-335921009-1070076021=:49691
Content-Type: text/html; charset=us-ascii

<DIV>hi all,</DIV>
<DIV>i am using PostgreSQL 7.3.2 on redhat linux 9.</DIV>
<DIV>there is problem when executing pl/pg sql functions.</DIV>
<DIV>if the function enter an infinite loop. the server is hanged.</DIV>
<DIV>cannot cancel the query.</DIV>
<DIV>the linux itself is hanged.i cannot kill postgres process.</DIV>
<DIV>i have to reboot the machine manually..</DIV>
<DIV>waited for a long time for completion. but no result .</DIV>
<DIV>when ever there is an infinite loop happened</DIV>
<DIV>the system have to be restarted. unfortunately it happened many time </DIV>
<DIV>during development of the pl/pg sql function.</DIV>
<DIV>is it a bug in postgres. or is it configuration problem?</DIV>
<DIV>when the system is hanged disk access is 100%. the harddisk read indicator does not stop.</DIV>
<DIV>&nbsp;</DIV>
<DIV>is there a solution for this problem..</DIV>
<DIV>pls help</DIV>
<DIV>regards</DIV>
<DIV>jinujose</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://antispam.yahoo.com/whatsnewfree">Protect your identity with Yahoo! Mail AddressGuard</a>
--0-335921009-1070076021=:49691--