-----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: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
