Received: from wombat.efone.com.au ([203.89.233.66]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0J405V25872 for ; Fri, 18 Jan 2002 23:00:14 -0500 (EST) (envelope-from murray@efone.com) Received: from efone.com ([202.138.193.106]) by wombat.efone.com.au (8.11.6/8.11.6) with ESMTP id g0J3wOQ32701; Sat, 19 Jan 2002 14:58:24 +1100 Message-ID: <3C48F172.60302@efone.com> Date: Sat, 19 Jan 2002 15:09:22 +1100 From: Murray Prior Hobbs Organization: eFone International Pty Ltd User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2.1) Gecko/20010901 X-Accept-Language: en-us MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: pltlc and pltlcu problems References: <3C482537.9040005@efone.com> <6420.1011366281@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------010203050400050102050707" X-Archive-Number: 200201/228 X-Sequence-Number: 6312 --------------010203050400050102050707 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit after i have succesfully used createlan script to load both the trusted and untrusted tlc languages i try some tests i create a test function (right out of the docs) CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS ' if {$1 > $2} {return $1} return $2 ' LANGUAGE 'pltclu'; and i try to run this stest select tcl_max(4,6); but i get ERROR: fmgr_info: function 17020: cache lookup failed so i create trusted version CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS ' if {$1 > $2} {return $1} return $2 ' LANGUAGE 'pltcl'; and i again try to run this stest select tcl_max(4,6); but i get instead server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost and if i look at the log postgres: murray kale [local] SELECT: error while loading shared libraries: /usr/lib/postgresql/pltcl.so: undefined symbol: Tcl_CreateInterp DEBUG: server process (pid 18415) exited with exit code 127 DEBUG: terminating any other active server processes DEBUG: all server processes terminated; reinitializing shared memory and semaphores DEBUG: database system was interrupted at 2002-01-19 15:01:29 EST DEBUG: checkpoint record is at 0/4BAD10 DEBUG: redo record is at 0/4BAD10; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 2120; next oid: 49324 DEBUG: database system was not properly shut down; automatic recovery in progress DEBUG: redo starts at 0/4BAD50 DEBUG: ReadRecord: record with zero length at 0/4C0FB4 DEBUG: redo done at 0/4C0F90 DEBUG: database system is ready so what do i do now? log it as a bug? murray so ok i go to the sources looking for test of pl/tlc or pl/tlcu (untrusted) Tom Lane wrote: >Murray Prior Hobbs writes: > >>ERROR: Load of file /usr/lib/postgresql/pltcl.so failed: >>/usr/lib/postgresql/pltcl.so: undefined symbol: pg_get_enconv_by_encoding >> > >Looks like a multibyte-enabled pltcl and a non-multibyte-enabled >backend. Given that they were clearly built at different times and >with different configurations, one might also wonder if they're even >the same Postgres version. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster > --------------010203050400050102050707 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

after i have succesfully used createlan script to load both the trusted and untrusted tlc languages i try some tests


i create a test function (right out of the docs)


CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS ' if {$1 > $2} {return $1} return $2 ' LANGUAGE 'pltclu';

and i try to run this stest

select tcl_max(4,6);
but i get


ERROR: fmgr_info: function 17020: cache lookup failed

so i create trusted version


CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS ' if {$1 > $2} {return $1} return $2 ' LANGUAGE 'pltcl';

and i again try to run this stest

select tcl_max(4,6);
but i get instead

server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost
and if i look at the log

postgres: murray kale [local] SELECT: error while loading shared libraries: /usr/lib/postgresql/pltcl.so: undefined symbol: Tcl_CreateInterp
DEBUG: server process (pid 18415) exited with exit code 127 DEBUG: terminating any other active server processes DEBUG: all server processes terminated; reinitializing shared memory and semaphores DEBUG: database system was interrupted at 2002-01-19 15:01:29 EST DEBUG: checkpoint record is at 0/4BAD10 DEBUG: redo record is at 0/4BAD10; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 2120; next oid: 49324 DEBUG: database system was not properly shut down; automatic recovery in progress DEBUG: redo starts at 0/4BAD50 DEBUG: ReadRecord: record with zero length at 0/4C0FB4 DEBUG: redo done at 0/4C0F90 DEBUG: database system is ready


so what do i do now?

log it as a bug?


murray



so ok i go to the sources looking for test of pl/tlc or pl/tlcu (untrusted)





Tom Lane wrote:
Murray Prior Hobbs <murray@efone.com> writes:
ERROR:  Load of file /usr/lib/postgresql/pltcl.so failed: 
/usr/lib/postgresql/pltcl.so: undefined symbol: pg_get_enconv_by_encoding

Looks like a multibyte-enabled pltcl and a non-multibyte-enabled
backend. Given that they were clearly built at different times and
with different configurations, one might also wonder if they're even
the same Postgres version.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



--------------010203050400050102050707--