no, this one seems to be fine now.
i have no idea what went wrong.
the code cored at some very "unlikely" place.
somehow rebooting helped ... - this was very strange.
fortunately it works nicely now ...
many thanks a best regards,
hans
Michael Fuhr wrote:
On Fri, Jul 29, 2005 at 10:46:35PM -0400, Bruce Momjian wrote:
Has this been fixed?
---------------------------------------------------------------------------
Hans-Jürgen Schönig wrote:
we have found a bug in CVS head using PL/Perl:
[EMAIL PROTECTED] hs]$ psql test < /tmp/core.sql
DROP FUNCTION
CREATE FUNCTION
NOTICE: sql: SELECT 10, 10 FROM pg_locks WHERE transaction IS NOT NULL
AND pid = pg_backend_pid()
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
I don't think anybody was able to reproduce the problem, and
Hans-Jürgen said that it started working after he rebooted
the box:
http://archives.postgresql.org/pgsql-bugs/2005-07/msg00062.php
There was reportedly no core dump and apparently the reboot destroyed
whatever conditions were causing the problem, so it might be difficult
to find out what was happening :-(
Hans-Jürgen, did this problem ever reappear?
Somebody else recently reported a backend crash when calling PL/Perl
in 8.0.3, but again we've been given no core dump info and thus far
nobody has been able to duplicate the problem:
http://archives.postgresql.org/pgsql-novice/2005-07/msg00181.php
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
