[BUGS] 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 �CU 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 * <>
[BUGS] Encounter shared memory error when running createlang command!
Hi, List, Because my previous mail contains some Chinese character, now I modified it, the whole problem is described as below: I need to create language Pl/Perl. I have checked all dependencies of plperl.dll and all is ok. Next: D:\Program Files\Postgresql\bin>createlang -U postgres -e plperl example (example is my dbname) Password: SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plperl'; CREATE LANGUAGE "plperl"; createlang: language installation failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. And pg_log is : 2009-09-24 10:50:55 HKT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2009-09-24 10:50:59 HKT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" Substitution pattern not terminated at line 1. 2009-09-24 10:51:01 HKT LOG: Server process (PID 1640) exited, exit code 255 2009-09-24 10:51:01 HKT LOG: terminating any other active server processes 2009-09-24 10:51:01 HKT LOG: all server processes terminated; reinitializing 2009-09-24 10:51:02 HKT FATAL: pre-existing shared memory block is still in use 2009-09-24 10:51:02 HKT HINT: Check if there are any old server processes still running, and terminate them. Then unsurprised, I found pgsql-8.3 service has stopped. But then I can start up it successfully. Thank you for any advice in advance. I have been kept on it for two days.. BR Lucy Gu
[BUGS] 答复: [BUGS] Encounter shared memory err or when running createlang command!
Thank you for your reminding. Before running createlang script, ActivePerl 5.8.9 has been installed because of the dependency of plperl.dll on perl58.dll. -邮件原件- 发件人: John R Pierce [mailto:pie...@hogranch.com] 发送时间: 2009年9月24日 12:48 收件人: Yaming Gu 抄送: pgsql-bugs@postgresql.org 主题: Re: [BUGS] Encounter shared memory error when running createlang command! Yaming Gu wrote: > > > > Hi, List, > > Because my previous mail contains some Chinese character, now I > modified it, the whole problem is described as below: > > I need to create language Pl/Perl. I have checked all dependencies of > plperl.dll and all is ok. > have you installed perl? I believe the plperl in postgres on Windows is dependent on activeperl. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] 答复: [BUGS] Encounter shared memo ry error when running createlang command!
Thank you so much for your kind reply. Your analysis sounds very reasonable. I checked my Perl version, it is "Perl 5.8.9 Build 826" which is the latest version in the series of 5.8.*. The whole process of installation of Perl goes well without any something wrong. And I can run Perl command out of Postgresql very well. So is this Perl version not compatible with Postgresql 8.3.7? And may I configure Perl somewhere or something? When Perl is loaded, what will be executed by it? "Substitution pattern not terminated at line 1." Souds like one regular expression. But I can not determine what will be executed by Perl. BR Lucy -邮件原件- 发件人: Robert Haas [mailto:robertmh...@gmail.com] 发送时间: 2009年9月28日 10:19 收件人: Yaming Gu 抄送: pgsql-bugs@postgresql.org 主题: Re: [BUGS] Encounter shared memory error when running createlang command! On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu wrote: > 2009-09-24 10:50:55 HKT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > > 2009-09-24 10:50:59 HKT LOG: loaded library > "$libdir/plugins/plugin_debugger.dll" > > Substitution pattern not terminated at line 1. I'm very suspicious of this error message. "Substitution pattern not terminated at line 1" sounds like an error message that is being generated *by Perl*. I don't see that phrase anywhere in the PostgreSQL sources. If that's true, that means that Perl is getting loaded, but then immediately dying when it tries to compile something-or-other that has a bad regular expression in there. Could there be something wrong with your Perl installation? Can you launch Perl from outside PostgreSQL OK? Another possibility is that some of the Perl code that PL/perl tries to execute during the load of Perl is not working for some reason. What version of Perl do you have on your system? What happens if you try to load plperlu? ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
