Lists: | pgsql-bugs |
---|
From: | "pasman" <pasman(dot)p(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6204: Using plperl functions generate crash |
Date: | 2011-09-14 09:15:54 |
Message-ID: | 201109140915.p8E9Fs0w075076@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6204
Logged by: pasman
Email address: pasman(dot)p(at)gmail(dot)com
PostgreSQL version: 9.1.0
Operating system: WinXP sp3
Description: Using plperl functions generate crash
Details:
After install postgresql 9.1.0 and Activestate perl 5.14.1 execute:
create function perl_test() returns void as
$$
$$
language plperl
This generates server crash. Log contain:
2011-09-14 11:08:22 CEST STATEMENT: create function perl_test() returns
void as $$ $$ language plperl
2011-09-14 11:08:47 CEST LOG: server process (PID 560) was terminated by
exception 0xC0000005
2011-09-14 11:08:47 CEST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2011-09-14 11:08:47 CEST LOG: terminating any other active server
processes
2011-09-14 11:08:47 CEST WARNING: terminating connection because of crash
of another server process
2011-09-14 11:08:47 CEST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2011-09-14 11:08:47 CEST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2011-09-14 11:08:47 CEST WARNING: terminating connection because of crash
of another server process
2011-09-14 11:08:47 CEST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2011-09-14 11:08:47 CEST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2011-09-14 11:08:47 CEST WARNING: terminating connection because of crash
of another server process
2011-09-14 11:08:47 CEST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2011-09-14 11:08:47 CEST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2011-09-14 11:08:47 CEST LOG: all server processes terminated;
reinitializing
2011-09-14 11:08:57 CEST FATAL: pre-existing shared memory block is still
in use
2011-09-14 11:08:57 CEST HINT: Check if there are any old server processes
still running, and terminate them.
From: | Alex Hunsaker <badalex(at)gmail(dot)com> |
---|---|
To: | pasman <pasman(dot)p(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6204: Using plperl functions generate crash |
Date: | 2011-09-14 22:17:53 |
Message-ID: | CAFaPBrRbEfH6xU=9WMvHPZ23bPbJRk2wsUBzSqnD+_86nPKzGw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On Wed, Sep 14, 2011 at 03:15, pasman <pasman(dot)p(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6204
> Logged by: pasman
> Email address: pasman(dot)p(at)gmail(dot)com
> PostgreSQL version: 9.1.0
> Operating system: WinXP sp3
> Description: Using plperl functions generate crash
> Details:
>
> After install postgresql 9.1.0 and Activestate perl 5.14.1 execute:
>
> create function perl_test() returns void as
> $$
> $$
> language plperl
My hunch is the binary distribution of postgres you are using was
compiled with a different version (or brand, maybe strawberry?) of
perl in mind.
I don't know what installer you used, I'd guess the one from
enterprisedb. I looked around for a bit on their website but didn't
see what flavor of perl for windows it wants... :-(
From: | Sachin Srivastava <sachin(dot)srivastava(at)enterprisedb(dot)com> |
---|---|
To: | Alex Hunsaker <badalex(at)gmail(dot)com> |
Cc: | pasman <pasman(dot)p(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #6204: Using plperl functions generate crash |
Date: | 2011-09-15 07:11:10 |
Message-ID: | B1D86254-EFD7-4568-B42E-41FF57540832@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
On Sep 15, 2011, at 3:47 AM, Alex Hunsaker wrote:
> On Wed, Sep 14, 2011 at 03:15, pasman <pasman(dot)p(at)gmail(dot)com> wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference: 6204
>> Logged by: pasman
>> Email address: pasman(dot)p(at)gmail(dot)com
>> PostgreSQL version: 9.1.0
>> Operating system: WinXP sp3
>> Description: Using plperl functions generate crash
>> Details:
>>
>> After install postgresql 9.1.0 and Activestate perl 5.14.1 execute:
>>
>> create function perl_test() returns void as
>> $$
>> $$
>> language plperl
>
> My hunch is the binary distribution of postgres you are using was
> compiled with a different version (or brand, maybe strawberry?) of
> perl in mind.
>
> I don't know what installer you used, I'd guess the one from
> enterprisedb. I looked around for a bit on their website but didn't
> see what flavor of perl for windows it wants... :-(
One-Click Installers uses ActiveState Perl 5.14 only.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
--
Regards,
Sachin Srivastava
EnterpriseDB, the Enterprise PostgreSQL company.