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: StartTransactionCommand
2009-05-15 11:40:29 BST STATEMENT: create language plperl;
2009-05-15 11:40:29 BST DEBUG: StartTransaction
2009-05-15 11:40:29 BST STATEMENT: create language plperl;
2009-05-15 11:40:29 BST DEBUG: name: unnamed; blockState:
DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2009-05-15 11:40:29 BST STATEMENT: create language plperl;
2009-05-15 11:40:29 BST LOG: statement: create language plperl;
2009-05-15 11:40:29 BST DEBUG: ProcessUtility
2009-05-15 11:40:29 BST STATEMENT: create language plperl;
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
2009-05-15 11:40:29 BST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2009-05-15 11:40:29 BST LOG: server process (PID 3432) was terminated
by exception 0xC0000005
2009-05-15 11:40:29 BST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2009-05-15 11:40:29 BST LOG: terminating any other active server processes
2009-05-15 11:40:29 BST DEBUG: sending SIGQUIT to process 3016
2009-05-15 11:40:29 BST DEBUG: sending SIGQUIT to process 2336
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)
2009-05-15 11:40:29 BST DEBUG: sending SIGQUIT to process 3012
2009-05-15 11:40:29 BST DEBUG: shmem_exit(-1)
2009-05-15 11:40:29 BST DEBUG: proc_exit(-1)
2009-05-15 11:40:29 BST DEBUG: shmem_exit(-1)
2009-05-15 11:40:29 BST DEBUG: proc_exit(-1)
2009-05-15 11:40:29 BST DEBUG: reaping dead processes
2009-05-15 11:40:29 BST DEBUG: reaping dead processes
2009-05-15 11:40:29 BST LOG: all server processes terminated; reinitializing
2009-05-15 11:40:29 BST DEBUG: shmem_exit(1)
2009-05-15 11:40:29 BST DEBUG: invoking IpcMemoryCreate(size=37052416)
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com