Encounter shared memory error when running createlang command!

Started by Yaming Guover 16 years ago2 messagesbugs
Jump to latest
#1Yaming Gu
yaming.gu@w-oasis.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?

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

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

Attachments:

image001.jpgimage/jpeg; name=image001.jpgDownload
#2Robert Haas
robertmhaas@gmail.com
In reply to: Yaming Gu (#1)
Re: Encounter shared memory error when running createlang command!

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