| 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: | Whole Thread | Raw Message | 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 |