Re: 答复: 答复: [BUGS] Encounter shared memory error when running createlang command!

2009/9/29 Yaming Gu <yaming.gu@w-oasis.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