From: George A.J <jinujosein@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Infinite loop crashes server
Date: Fri, 28 Nov 2003 19:20:21 -0800 (PST)
Message-ID: <20031129032021.52222.qmail@web14919.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jinujosein@yahoo.com
Subject: Re: Infinite loop crashes server
In-Reply-To: <20031129032021.52222.qmail@web14919.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox