Re: Encounter shared memory error when running createlang command!

Hi, List

Because I need to use pl/perl language, then I decided to run
“createlang” to create PL/Perl language. I have checked all dependencies
and all is ok.

Next I run: D:\Program Files\Postgresql\bin>createlang U postgres plperl
example (example is my dbname)

Then it failed telling me:

createlang: language installation failed: 服务器意外地关闭了联接

这种现象通常意味着服务器在处理请求之前

或者正在处理请求的时候意外中止

I checked my log and show it below:

****************************************************************************
**********************************************************************

2009-09-23 13:39:55 HKT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"

2009-09-23 13:39:58 HKT LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"

Substitution pattern not terminated at line 1.

2009-09-23 13:39:59 HKT 日志: 服务器进程 (PID 5588) 已退出, 退出代码 255

2009-09-23 13:39:59 HKT 日志: 中断任何其它已激活的服务器进程

2009-09-23 13:39:59 HKT 日志: 所有的服务器进程被中止; 重新初始化

2009-09-23 13:40:00 HKT 致命错误: pre-existing shared memory block is still
in use

2009-09-23 13:40:00 HKT 提示: Check if there are any old server processes
still running, and terminate them.

****************************************************************************
**************************************************************************

Can you give me some advice about this problem?

Best Regards,
Yaming Gu (谷亚明)
****************************************************************************
************

WOASiS Telecommunications Ltd.
Tel: +86-021-54276611-819
Fax: +86-021-54260599
Add: 15F, Software Building, 461 Hongcao
Road, Xuhui District,Shanghai,China
P.C: 200233

****************************************************************************
*************

2009/9/23 Yaming Gu <yaming(dot)gu(at)w-oasis(dot)com>

>
>
> Hi, List
>
> Because I need to use pl/perl language, then I decided to run “createlang”
> to create PL/Perl language. I have checked all dependencies and all is ok.
>
> Next I run: D:\Program Files\Postgresql\bin>createlang U postgres plperl
> example (example is my dbname)
>
> Then it failed telling me:
>
> createlang: language installation failed: 服务器意外地关闭了联接
>
> 这种现象通常意味着服务器在处理请求之前
>
> 或者正在处理请求的时候意外中止
>
>
>
> I checked my log and show it below:
>
>
> **************************************************************************************************************************************************
>
> 2009-09-23 13:39:55 HKT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> 2009-09-23 13:39:58 HKT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
>
> Substitution pattern not terminated at line 1.
>
> 2009-09-23 13:39:59 HKT 日志: 服务器进程 (PID 5588) 已退出, 退出代码 255
>
> 2009-09-23 13:39:59 HKT 日志: 中断任何其它已激活的服务器进程
>
> 2009-09-23 13:39:59 HKT 日志: 所有的服务器进程被中止; 重新初始化
>
> 2009-09-23 13:40:00 HKT 致命错误: pre-existing shared memory block is still
> in use
>
> 2009-09-23 13:40:00 HKT 提示: Check if there are any old server processes
> still running, and terminate them.
>
>
> ******************************************************************************************************************************************************
>
>
>
> Can you give me some advice about this problem?
>

Hmm... I confess I'd have an easier time if this were all in English.

...Robert