-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm using posgresql 8.2.4 on Gentoo Linux.

Is there anything that can be done about an infinite loop in plpython?
I tired stopping the query (with PG Admin), but the process kept going
on the server. I tried pg_cancel_backend but it kept running. I tried
kill -INT and it ignored that as well.

I found a response by Tom Lane from Oct. 3 2007, subject: Re: [GENERAL]
pg_cancel_backend() does not work with buzz queries

where he suggested the solution: "Short answer: don't write infinite
loops in plpython"


The query was a simple loop that was programmed by accident. It is using
100% of CPU. Is there a better way then restarting the server?
Is this fixed in a more current version?

Thanks
Sim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkl+53MACgkQjDX6szCBa+owmQCfWxyVBZdnMW3zSUqbatl83wrD
3vcAoJLrYJE8cjCkcWTJEgmkxL7U33sO
=qHrx
-----END PGP SIGNATURE-----

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to