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 error when running createlang command! |
Date: | 2009-10-22 16:24:47 |
Message-ID: | 603c8f070910220924u68518458i543a65ea53ca0f6c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-10-22 16:29:39 | Re: BUG #5021: ts_parse doesn't recognize email addresses with underscores |
Previous Message | Tom Lane | 2009-10-22 15:59:30 | Re: BUG #5126: convert_to preventing index scan |