Skip site navigation (1) Skip section navigation (2)

Encounter shared memory error when running createlang command!

From: "Yaming Gu" <yaming(dot)gu(at)w-oasis(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Encounter shared memory error when running createlang command!
Date: 2009-09-24 03:44:06
Message-ID: 4C13DA21211F445AA94D1C1A4887313B@SH.WOASIS.COM (view raw or flat)
Thread:
Lists: pgsql-bugs
 

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

 

Responses

pgsql-bugs by date

Next:From: John R PierceDate: 2009-09-24 04:48:02
Subject: Re: Encounter shared memory error when running createlang command!
Previous:From: KaeltenDate: 2009-09-24 03:11:33
Subject: Re: BUG #5077: Corrupted Table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group