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

Re: 答复: 答复: [BUGS] Encounter shared memory e?==?GB2312?Q?rror when running createlang command!

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Yaming Gu <yaming(dot)gu(at)w-oasis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 答复: 答复: [BUGS] Encounter shared memory e?==?GB2312?Q?rror when running createlang command!
Date: 2009-10-22 16:24:47
Message-ID: 603c8f070910220924u68518458i543a65ea53ca0f6c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
2009/9/29 Yaming Gu <yaming(dot)gu(at)w-oasis(dot)com>:
> Hi, Robert,
>
>  According to your recommendations, I tried to load plperu, almost the same
> error messages have shown:
>
> D:\Program Files\Postgresql\8.3\bin>createlang -U postgres plperlu example
>
> Password:
>
> createlang: language installation failed: server closed the connection
> unexpectedly
>
>         This probably means the server terminated abnormally
>
>         before or while processing the request.
>
> The following is pg_log message:
>
> 2009-09-29 14:28:07 HKT LOG:  loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> 2009-09-29 14:28:44 HKT LOG:  loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> 2009-09-29 14:28:50 HKT LOG:  loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> 2009-09-29 14:28:53 HKT LOG:  loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> Substitution pattern not terminated at line 1.
>
> 2009-09-29 14:28:55 HKT LOG:  Server process (PID 3596) exited, exit code
> 255
>
> 2009-09-29 14:28:55 HKT LOG:  terminating any other active server processes
>
> 2009-09-29 14:28:55 HKT WARNING:  terminating connection because of crash of
> another server process
>
> 2009-09-29 14:28:55 HKT 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.
>
> 2009-09-29 14:28:55 HKT HINT:  In a moment you should be able to reconnect
> to the database and repeat your command.
>
> 2009-09-29 14:28:55 HKT WARNING:  terminating connection because of crash of
> another server process
>
> 2009-09-29 14:28:55 HKT 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.
>
> 2009-09-29 14:28:55 HKT HINT:  In a moment you should be able to reconnect
> to the database and repeat your command.
>
> 2009-09-29 14:28:55 HKT LOG:  all server processes terminated;
> reinitializing
>
> 2009-09-29 14:28:56 HKT FATAL:  pre-existing shared memory block is still in
> use
>
> 2009-09-29 14:28:56 HKT HINT:  Check if there are any old server processes
> still running, and terminate them.
>
>
>
> I wonder about the line of “terminating connection because of crash of
> another server process”. I have done nothing else except starting up
> postgresql service.

Well, that's a normal message when something crashes. The question is
what's making it crash.  Have you tried removing plugin_debugger.dll
from the equation?  Have you tried a fresh PostgreSQL install?
Something's obviously different in your installation than elsewhere.

...Robert

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2009-10-22 16:29:39
Subject: Re: BUG #5021: ts_parse doesn't recognize email addresses with underscores
Previous:From: Tom LaneDate: 2009-10-22 15:59:30
Subject: Re: BUG #5126: convert_to preventing index scan

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