Skip site navigation (1) Skip section navigation (2)

Re: Perl 5.10 vs. PG 8.4 on Win32

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Perl 5.10 vs. PG 8.4 on Win32
Date: 2009-05-15 14:23:39
Message-ID: 2950.1242397419@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Dave Page <dpage(at)pgadmin(dot)org> writes:
> CREATE LANGUAGE plperl; causes a backend crash on 8.4 with ActivePerl
> 5.10.0 (running on XP Pro). I'm testing this on beta 2 which I just
> rolled, however I believe this is probably the same issue that Kevin
> Field was reporting here:
> http://archives.postgresql.org/message-id/200904171407.n3HE7uri070869@wwwmaster.postgresql.org.
> For info, 0xC0000005 is a pretty general access violation error.

> I couldn't get much out of the server in the way of logs:

> 2009-05-15 11:40:29 BST DEBUG:  shmem_exit(-1)
> 2009-05-15 11:40:29 BST STATEMENT:  create language plperl;
> 2009-05-15 11:40:29 BST DEBUG:  proc_exit(-1)
> 2009-05-15 11:40:29 BST STATEMENT:  create language plperl;
> 2009-05-15 11:40:29 BST DEBUG:  reaping dead processes
> 2009-05-15 11:40:29 BST DEBUG:  server process (PID 3432) was
> terminated by exception 0xC0000005

Ho, that's pretty curious.  The first two messages are the trace of the
atexit hook I recently installed, which means something called exit()
or the moral equivalent thereof.  I wouldn't really expect that to
happen in a crash situation ... is Windows dumb enough to try to run
the atexit hooks of a crashed process?

> 2009-05-15 11:40:29 BST DEBUG:  sending SIGQUIT to process 2920
> 2009-05-15 11:40:29 BST DEBUG:  shmem_exit(-1)
> 2009-05-15 11:40:29 BST DEBUG:  proc_exit(-1)

... and this proves I broke something :-( ... quickdie() is deliberately
not supposed to run through the proc_exit stuff.  Will fix.  That's not
related to your Perl problem though.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Simon RiggsDate: 2009-05-15 14:32:52
Subject: Re: [HACKERS] Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file
Previous:From: Heikki LinnakangasDate: 2009-05-15 14:19:04
Subject: Re: [HACKERS] Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group