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
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 |