Infinite loop crashes server

From: "George A(dot)J" <jinujosein(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Infinite loop crashes server
Date: 2003-11-29 03:20:21
Message-ID: 20031129032021.52222.qmail@web14919.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2003-11-29 06:38:22 Re: OFFSET and subselects
Previous Message Stephan Szabo 2003-11-29 03:09:47 Re: Stored procedures and relations