pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpltlc and pltlcu problems
27+ messages / 5 participants
[nested] [flat]
* pltlc and pltlcu problems
@ 2002-01-18 13:37 Murray Prior Hobbs <murray@efone.com>
0 siblings, 1 reply; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-18 13:37 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
I try this code
CREATE FUNCTION pltclu_call_handler() RETURNS OPAQUE AS
'/usr/lib/postgresql/pltcl.so' LANGUAGE 'C';
and get this error
ERROR: Load of file /usr/lib/postgresql/pltcl.so failed:
/usr/lib/postgresql/pltcl.so: undefined symbol: pg_get_enconv_by_encoding
anyone help me with this?
murray hobbs
ps here's my .configure command
./configure --enable-multibyte=UNICODE --enable-unicode-conversion --enable-locale --bindir=/usr/local/bin --libdir=/usr/lib --includedir=/usr/include --mandir=/usr/local/man --with-tcl --enable-odbc --with-unixodbc --enable-syslog
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-18 15:04 Tom Lane <tgl@sss.pgh.pa.us>
parent: Murray Prior Hobbs <murray@efone.com>
0 siblings, 2 replies; 27+ messages in thread
From: Tom Lane @ 2002-01-18 15:04 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-18 20:17 Murray Prior Hobbs <murray@efone.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-18 20:17 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
you are so right
bugga, and i thought i was being both so clever and so careful
m
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
>
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 04:09 Murray Prior Hobbs <murray@efone.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-19 04:09 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 04:12 Tom Lane <tgl@sss.pgh.pa.us>
parent: Murray Prior Hobbs <murray@efone.com>
0 siblings, 1 reply; 27+ messages in thread
From: Tom Lane @ 2002-01-19 04:12 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: pgsql-sql
Murray Prior Hobbs <murray@efone.com> writes:
> 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
Kinda looks like your dynamic loader doesn't know where to find
libtcl.so (and thinks that the appropriate way to fail is a hard exit(),
which is not my idea of friendly).
> so what do i do now?
> log it as a bug?
It's not a Postgres bug; you need to twiddle your shlib configuration.
But since you didn't mention your platform, I can't offer any pointers
beyond
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/install-post.html#AEN11747
(note that this is talking about finding Postgres' libraries; alter
to suit wherever libtcl lives).
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 07:58 Murray Prior Hobbs <murray@efone.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-19 07:58 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Thanks tom but i think there's more to it
error while loading shared libraries: /usr/lib/postgresql/pltcl.so: undefined symbol: Tcl_CreateInterp
as you can see it knows where the library is - what i think it's
complaining about is the undefined symbol
so i do a grep through the sources and find the call - the only call -
but there's no function declaration in the sources
i did follow your link and i had read the page before - i'm on RedHat
7.2 so should not have needed to do that - but i did anyway - it made no
difference
is there meant to be Tcl_CreateInterp anywhere in the sources?
murray
Tom Lane wrote:
>Murray Prior Hobbs <murray@efone.com> writes:
>
>>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
>>
>
>Kinda looks like your dynamic loader doesn't know where to find
>libtcl.so (and thinks that the appropriate way to fail is a hard exit(),
>which is not my idea of friendly).
>
>>so what do i do now?
>>
>
>>log it as a bug?
>>
>
>It's not a Postgres bug; you need to twiddle your shlib configuration.
>But since you didn't mention your platform, I can't offer any pointers
>beyond
>http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/install-post.html#AEN11747
>(note that this is talking about finding Postgres' libraries; alter
>to suit wherever libtcl lives).
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 08:19 Brent Verner <brent@rcfile.org>
parent: Murray Prior Hobbs <murray@efone.com>
0 siblings, 2 replies; 27+ messages in thread
From: Brent Verner @ 2002-01-19 08:19 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: pgsql-sql
[2002-01-19 18:58] Murray Prior Hobbs said:
|
| Thanks tom but i think there's more to it
|
| error while loading shared libraries: /usr/lib/postgresql/pltcl.so:
| undefined symbol: Tcl_CreateInterp
|
| as you can see it knows where the library is - what i think it's
| complaining about is the undefined symbol
|
| so i do a grep through the sources and find the call - the only call -
| but there's no function declaration in the sources
|
| i did follow your link and i had read the page before - i'm on RedHat
| 7.2 so should not have needed to do that - but i did anyway - it made no
| difference
|
| is there meant to be Tcl_CreateInterp anywhere in the sources?
No. This is provided by the tcl library:
bash$ grep Tcl_CreateInter /usr/include/tcl8.3/tclDecls.h
EXTERN Tcl_Interp * Tcl_CreateInterp _ANSI_ARGS_((void));
The problem is, as Tom said, that your tcl library is not being
found by the system's linker. Try this:
bash$ ldd /usr/lib/postgresql/pltcl.so
I suspect you'll see a line containing "not found".
brent
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 08:40 Murray Prior Hobbs <murray@efone.com>
parent: Brent Verner <brent@rcfile.org>
1 sibling, 1 reply; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-19 08:40 UTC (permalink / raw)
To: Brent Verner <brent@rcfile.org>; +Cc: pgsql-sql
i have had no trouble loading and using the pgpgsql language - and it
lives in exactly the same place
i've done as you suggested though - here is the output
[murray@localhost dbSources]$ ldd /usr/lib/postgresql/pltcl.so
libdl.so.2 => /lib/libdl.so.2 (0x40020000)
libm.so.6 => /lib/i686/libm.so.6 (0x40024000)
libc.so.6 => /lib/i686/libc.so.6 (0x40047000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
murray
Brent Verner wrote:
>
>No. This is provided by the tcl library:
>
> bash$ grep Tcl_CreateInter /usr/include/tcl8.3/tclDecls.h
> EXTERN Tcl_Interp * Tcl_CreateInterp _ANSI_ARGS_((void));
>
>The problem is, as Tom said, that your tcl library is not being
>found by the system's linker. Try this:
>
> bash$ ldd /usr/lib/postgresql/pltcl.so
>
>I suspect you'll see a line containing "not found".
>
> brent
>
[2002-01-19 18:58] Murray Prior Hobbs said:
|
| Thanks tom but i think there's more to it
|
| error while loading shared libraries: /usr/lib/postgresql/pltcl.so:
| undefined symbol: Tcl_CreateInterp
|
| as you can see it knows where the library is - what i think it's
| complaining about is the undefined symbol
|
| so i do a grep through the sources and find the call - the only call -
| but there's no function declaration in the sources
|
| i did follow your link and i had read the page before - i'm on RedHat
| 7.2 so should not have needed to do that - but i did anyway - it made no
| difference
|
| is there meant to be Tcl_CreateInterp anywhere in the sources?
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 09:09 Murray Prior Hobbs <murray@efone.com>
parent: Brent Verner <brent@rcfile.org>
1 sibling, 1 reply; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-19 09:09 UTC (permalink / raw)
To: Brent Verner <brent@rcfile.org>; +Cc: pgsql-sql
maybe this is a dumb question
but are not all the tcl sources part of the source distribution?
like - am i to assume then that there are binaries in the distribution
for which there is no code?
like - if i go looking for somethng in the code should not i find it?
murray
Brent Verner wrote:
>
>No. This is provided by the tcl library:
>
> bash$ grep Tcl_CreateInter /usr/include/tcl8.3/tclDecls.h
> EXTERN Tcl_Interp * Tcl_CreateInterp _ANSI_ARGS_((void));
>
>The problem is, as Tom said, that your tcl library is not being
>found by the system's linker. Try this:
>
> bash$ ldd /usr/lib/postgresql/pltcl.so
>
>I suspect you'll see a line containing "not found".
>
> brent
>
[2002-01-19 18:58] Murray Prior Hobbs said:
|
| Thanks tom but i think there's more to it
|
| error while loading shared libraries: /usr/lib/postgresql/pltcl.so:
| undefined symbol: Tcl_CreateInterp
|
| as you can see it knows where the library is - what i think it's
| complaining about is the undefined symbol
|
| so i do a grep through the sources and find the call - the only call -
| but there's no function declaration in the sources
|
| i did follow your link and i had read the page before - i'm on RedHat
| 7.2 so should not have needed to do that - but i did anyway - it made no
| difference
|
| is there meant to be Tcl_CreateInterp anywhere in the sources?
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-19 17:36 Tom Lane <tgl@sss.pgh.pa.us>
parent: Murray Prior Hobbs <murray@efone.com>
0 siblings, 1 reply; 27+ messages in thread
From: Tom Lane @ 2002-01-19 17:36 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: Brent Verner <brent@rcfile.org>; pgsql-sql
Murray Prior Hobbs <murray@efone.com> writes:
> maybe this is a dumb question
> but are not all the tcl sources part of the source distribution?
I'm only going to say this one more time: Tcl is not part of Postgres.
pltcl depends on libtcl (note difference), and the loader is evidently
not finding libtcl.so. Which will absolutely NOT be in
/usr/lib/postgresql. The question for you is where it actually lives
(if it's installed at all), and next why the dynamic loader search path
isn't finding it.
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 07:57 Murray Prior Hobbs <murray@efone.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 27+ messages in thread
From: Murray Prior Hobbs @ 2002-01-20 07:57 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Brent Verner <brent@rcfile.org>; pgsql-sql
ok ok - so i went off and read a LOT about Tcl - cool what a nice tool
and then i downloaded the tcl/tk sources and built with appropriate
configure options and installed it - in approprate places (in /usr/bin -
over the old copies that were already there) and ran the tests and
dowloaded some TCl samples and played with the apps
as i had been using the postgres 7.2 beta i reinstalled 7.13 over the
top - right from the start, reconfigured, recompiled, reinstalled,
reinitialised
and tried to call a tcl function yet again - but now i get this error
ERROR: pltcl: internal error - cannot create 'normal' interpreter
but hmm, that's further than i got before and at least the database does
not restart itself in the process
and in the code i have got one step further
any clues?
murray
if ((pltcl_hold_interp = Tcl_CreateInterp()) == NULL)
{
elog(ERROR, "pltcl: internal error - cannot create 'hold' "
"interpreter");
}
/************************************************************
* Create the two interpreters
************************************************************/
if ((pltcl_norm_interp =
Tcl_CreateSlave(pltcl_hold_interp, "norm", 0)) == NULL)
{
elog(ERROR,
"*pltcl: internal error - cannot create 'normal' interpreter*");
}
murray
Tom Lane wrote:
>Murray Prior Hobbs <murray@efone.com> writes:
>
>>maybe this is a dumb question
>>but are not all the tcl sources part of the source distribution?
>>
>
>I'm only going to say this one more time: Tcl is not part of Postgres.
>
>pltcl depends on libtcl (note difference), and the loader is evidently
>not finding libtcl.so. Which will absolutely NOT be in
>/usr/lib/postgresql. The question for you is where it actually lives
>(if it's installed at all), and next why the dynamic loader search path
>isn't finding it.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 11:59 Brent Verner <brent@rcfile.org>
parent: Murray Prior Hobbs <murray@efone.com>
0 siblings, 2 replies; 27+ messages in thread
From: Brent Verner @ 2002-01-20 11:59 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
[2002-01-19 19:40] Murray Prior Hobbs said:
|
| i have had no trouble loading and using the pgpgsql language - and it
| lives in exactly the same place
|
| i've done as you suggested though - here is the output
Indeed. I just got finished installing a chroot image of
redhat-7.2 to test this. I am seeing the same Tcl_CreateInterp
problem you mentioned earlier. The pltcl language does not work
even from the 7.2b3 rpms. Can someone verify that pltcl works on
their stock redhat 7.2 system?
Are there a known bugs in the stock 7.2 binutils or any other part
of the toolchain that might be causing this problem? Most notably
is the absence of pltcl.so being linked to libtcl.so. Could this
be a problem with redhat's tcl package?
Monty, are you by chance running in a chroot?
confounded,
brent
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 12:36 Brent Verner <brent@rcfile.org>
parent: Brent Verner <brent@rcfile.org>
1 sibling, 1 reply; 27+ messages in thread
From: Brent Verner @ 2002-01-20 12:36 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
[2002-01-20 23:24] Murray Prior Hobbs said:
| Brent Verner wrote:
|
| >[2002-01-19 19:40] Murray Prior Hobbs said:
| >|
| >| i have had no trouble loading and using the pgpgsql language - and it
| >| lives in exactly the same place
| >|
| >| i've done as you suggested though - here is the output
| >
| >Indeed. I just got finished installing a chroot image of
| >redhat-7.2 to test this. I am seeing the same Tcl_CreateInterp
| >problem you mentioned earlier. The pltcl language does not work
| >even from the 7.2b3 rpms. Can someone verify that pltcl works on
| >their stock redhat 7.2 system?
| >
| >Are there a known bugs in the stock 7.2 binutils or any other part
| >of the toolchain that might be causing this problem? Most notably
| >is the absence of pltcl.so being linked to libtcl.so. Could this
| >be a problem with redhat's tcl package?
| >
| >Monty, are you by chance running in a chroot?
| >
| if you mean me (Murray) nope - it's a bog standard RedHat 7.2 install
sorry! I know a guy named "Monty Hobbs"... I'm really too tired ;-)
| but i have installed Tcl from the sources from scratch - 8.3.4
Indeed I've tracked the problem down to the line that links
the pltcl.so library:
make[3]: Entering directory `/usr/local/cvs/pgsql/src/pl/tcl'
/bin/sh mkMakefile.tcldefs.sh '/usr/lib/tclConfig.sh' 'Makefile.tcldefs'
make[3]: Leaving directory `/usr/local/cvs/pgsql/src/pl/tcl'
make[3]: Entering directory `/usr/local/cvs/pgsql/src/pl/tcl'
gcc -pipe -O -D__NO_STRING_INLINES -D__NO_MATH_INLINES -fPIC -I../../../src/include -DHAVE_UNISTD_H=1 -DHAVE_LIMITS_H=1 -DHAVE_GETCWD=1 -DHAVE_OPENDIR=1 -DHAVE_STRSTR=1 -DHAVE_STRTOL=1 -DHAVE_TMPNAM=1 -DHAVE_WAITPID=1 -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DUSE_TERMIOS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SYS_TIME=1 -DHAVE_TM_ZONE=1 -DHAVE_TM_GMTOFF=1 -DHAVE_TIMEZONE_VAR=1 -DHAVE_ST_BLKSIZE=1 -DSTDC_HEADERS=1 -DNEED_MATHERR=1 -DHAVE_SIGNED_CHAR=1 -DHAVE_SYS_IOCTL_H=1 -c -o pltcl.o pltcl.c
gcc -pipe -shared -Wl,-soname,libtcl.so.0 -o pltcl.so pltcl.o -L/usr/lib -ltcl -ldl -lieee -lm -lc
^^^^^^^^^^^
IIRC, this was changed to workaround another problem with the
tcl client library having name conflicts. This value (TCL_SHLIB_LD)
comes directly from the /usr/lib/tclConfig.sh file supplied by the
rpm. You can add the following line to src/pl/tcl/Makefile
below "-include Makefile.tcldefs"
TCL_SHLIB_LD = gcc -shared
to override the erronious value supplied by the system's tclConfig.sh.
| but just because i'm ignorant of many things - how would i check if i
| was running in chroot environment?
not sure. I always know when I am, because I setup the chroot.
Some web hosts will give you a chroot as well, but if you are
developing on your own workstation, there is little chance of
you being in a chroot and not knowing it.
hth.
b
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 17:35 Tom Lane <tgl@sss.pgh.pa.us>
parent: Brent Verner <brent@rcfile.org>
1 sibling, 0 replies; 27+ messages in thread
From: Tom Lane @ 2002-01-20 17:35 UTC (permalink / raw)
To: Brent Verner <brent@rcfile.org>; +Cc: Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Brent Verner <brent@rcfile.org> writes:
> I am seeing the same Tcl_CreateInterp
> problem you mentioned earlier. The pltcl language does not work
> even from the 7.2b3 rpms. Can someone verify that pltcl works on
> their stock redhat 7.2 system?
Hmm, what Tcl version are you using? pltcl does not appear broken
on my system, but I think what I've got installed is Tcl 8.0.5.
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 19:14 Tom Lane <tgl@sss.pgh.pa.us>
parent: Brent Verner <brent@rcfile.org>
0 siblings, 2 replies; 27+ messages in thread
From: Tom Lane @ 2002-01-20 19:14 UTC (permalink / raw)
To: Brent Verner <brent@rcfile.org>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Brent Verner <brent@rcfile.org> writes:
> Indeed I've tracked the problem down to the line that links
> the pltcl.so library:
> gcc -pipe -shared -Wl,-soname,libtcl.so.0 -o pltcl.so pltcl.o -L/usr/lib -ltcl -ldl -lieee -lm -lc
> ^^^^^^^^^^^
Yeah, removing the "-Wl,-soname,libtcl.so.0" switch produces a correctly
functioning pltcl.
> IIRC, this was changed to workaround another problem with the
> tcl client library having name conflicts. This value (TCL_SHLIB_LD)
> comes directly from the /usr/lib/tclConfig.sh file supplied by the
> rpm.
I seem to recall that this same problem was being debated a few weeks
back, but apparently we didn't actually do anything about it. Looks
like we have to.
Peter, didn't you have a proposal on the table to fix this?
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 20:58 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 27+ messages in thread
From: Tom Lane @ 2002-01-20 20:58 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: Brent Verner <brent@rcfile.org>; Peter Eisentraut <peter_e@gmx.net>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Murray Prior Hobbs <murray@efone.com> writes:
> Brent sent me a fix
> ----start Bent's fix ----
> rpm. You can add the following line to src/pl/tcl/Makefile
> below "-include Makefile.tcldefs"
> TCL_SHLIB_LD = gcc -shared
> ---- end Brent's fix -----
> which i tried but did not work
Works for me. Did you remove the pltcl.so file so it would be rebuilt?
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 21:12 Peter Eisentraut <peter_e@gmx.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 27+ messages in thread
From: Peter Eisentraut @ 2002-01-20 21:12 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Brent Verner <brent@rcfile.org>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Tom Lane writes:
> Peter, didn't you have a proposal on the table to fix this?
Yeah, complain loudly to whoever dared to package a broken Tcl like
that... Or we'll work with Andreas Zeugwetter's patches and eliminate the
use of tclConfig.sh mostly.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 21:33 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 27+ messages in thread
From: Tom Lane @ 2002-01-20 21:33 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Brent Verner <brent@rcfile.org>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Peter Eisentraut <peter_e@gmx.net> writes:
>> Peter, didn't you have a proposal on the table to fix this?
> Yeah, complain loudly to whoever dared to package a broken Tcl like
> that... Or we'll work with Andreas Zeugwetter's patches and eliminate the
> use of tclConfig.sh mostly.
Yeah, I was taking a second look at Andreas' patch myself. At the time,
the report was that we were only seeing a failure in RPM-packaged
Postgres and so I thought that the root problem was somewhere in our RPM
script. However, I have now tried it for myself and can confirm that
we fail in a Postgres source build too. The bogus soname switch might
be blamable on the Tcl RPM package and not on Tcl sources, but that
doesn't make a lot of difference to us either way.
I'm still quite nervous about making these changes so late in the cycle.
OTOH I suspect Andreas was right: we haven't been getting any pltcl
portability testing from our beta testers. If it's broken now, we
can hardly make it worse.
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 22:17 Peter Eisentraut <peter_e@gmx.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 3 replies; 27+ messages in thread
From: Peter Eisentraut @ 2002-01-20 22:17 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Brent Verner <brent@rcfile.org>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Tom Lane writes:
> I'm still quite nervous about making these changes so late in the cycle.
> OTOH I suspect Andreas was right: we haven't been getting any pltcl
> portability testing from our beta testers.
This logic can also be reversed: We haven't been getting any beta testing
from users of Red Hat 7.1.
> If it's broken now, we can hardly make it worse.
You can surely make things a lot worse for those that are using other
operating systems. I certainly don't agree with making changes just
because Red Hat blew it.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-20 22:52 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
2 siblings, 1 reply; 27+ messages in thread
From: Tom Lane @ 2002-01-20 22:52 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Brent Verner <brent@rcfile.org>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Peter Eisentraut <peter_e@gmx.net> writes:
> You can surely make things a lot worse for those that are using other
> operating systems. I certainly don't agree with making changes just
> because Red Hat blew it.
It does appear that the problem can be blamed entirely on the RPM
packaging of Tcl. I tried configuring from source on RHL 7.2, and
neither tcl 8.3.2 nor 8.3.4 produce a "soname" switch in TCL_SHLIB_LD.
In fact, grep can't find any occurrence of "soname" anywhere in the
Tcl source distribution.
Nonetheless, I'm not sure that "do nothing" is an acceptable response
on our part.
I tried setting up pltcl's makefile to dike out the offending switch:
override TCL_SHLIB_LD := $(patsubst %soname%, , $(TCL_SHLIB_LD))
but could not get it to work --- gmake's pattern matching logic seems
to be too brain-dead to cope with more than one % in a pattern. And
override TCL_SHLIB_LD := $(patsubst -Wl,-soname%, , $(TCL_SHLIB_LD))
doesn't work either; apparently there's no way to escape the comma.
Anyone know a cute hack to get gmake to do this?
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 00:02 Brent Verner <brent@rcfile.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 27+ messages in thread
From: Brent Verner @ 2002-01-21 00:02 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
[2002-01-20 17:52] Tom Lane said:
| Peter Eisentraut <peter_e@gmx.net> writes:
| > You can surely make things a lot worse for those that are using other
| > operating systems. I certainly don't agree with making changes just
| > because Red Hat blew it.
|
| It does appear that the problem can be blamed entirely on the RPM
| packaging of Tcl. I tried configuring from source on RHL 7.2, and
| neither tcl 8.3.2 nor 8.3.4 produce a "soname" switch in TCL_SHLIB_LD.
| In fact, grep can't find any occurrence of "soname" anywhere in the
| Tcl source distribution.
|
| Nonetheless, I'm not sure that "do nothing" is an acceptable response
| on our part.
Agreed. I think working around this borkenness in the Makefile is
the best solution; I don't think switching from RTLD_LAZY is good
right now.
| I tried setting up pltcl's makefile to dike out the offending switch:
|
| override TCL_SHLIB_LD := $(patsubst %soname%, , $(TCL_SHLIB_LD))
|
| but could not get it to work --- gmake's pattern matching logic seems
| to be too brain-dead to cope with more than one % in a pattern. And
|
| override TCL_SHLIB_LD := $(patsubst -Wl,-soname%, , $(TCL_SHLIB_LD))
|
| doesn't work either; apparently there's no way to escape the comma.
| Anyone know a cute hack to get gmake to do this?
It seems that substvar operates on each " " separated token in the
string. The following works for me.
override TCL_SHLIB_LD := $(shell echo $(TCL_SHLIB_LD) | sed 's/-Wl,-soname.*//')
cheers.
brent
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 00:16 Tom Lane <tgl@sss.pgh.pa.us>
parent: Brent Verner <brent@rcfile.org>
0 siblings, 1 reply; 27+ messages in thread
From: Tom Lane @ 2002-01-21 00:16 UTC (permalink / raw)
To: Brent Verner <brent@rcfile.org>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Brent Verner <brent@rcfile.org> writes:
> It seems that substvar operates on each " " separated token in the
> string. The following works for me.
> override TCL_SHLIB_LD := $(shell echo $(TCL_SHLIB_LD) | sed 's/-Wl,-soname.*//')
I suspect that the above works only because -Wl,-soname is the last
switch in TCL_SHLIB_LD; any following switches would be removed too.
Perhaps better
override TCL_SHLIB_LD := $(shell echo $(TCL_SHLIB_LD) | sed 's/-Wl,-soname[^ ]*//'
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 00:31 Brent Verner <brent@rcfile.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 27+ messages in thread
From: Brent Verner @ 2002-01-21 00:31 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
[2002-01-20 19:16] Tom Lane said:
| Brent Verner <brent@rcfile.org> writes:
| > It seems that substvar operates on each " " separated token in the
| > string. The following works for me.
|
| > override TCL_SHLIB_LD := $(shell echo $(TCL_SHLIB_LD) | sed 's/-Wl,-soname.*//')
|
| I suspect that the above works only because -Wl,-soname is the last
| switch in TCL_SHLIB_LD; any following switches would be removed too.
| Perhaps better
|
| override TCL_SHLIB_LD := $(shell echo $(TCL_SHLIB_LD) | sed 's/-Wl,-soname[^ ]*//'
Yes, much better.
cheers.
brent
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 03:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
2 siblings, 1 reply; 27+ messages in thread
From: Tom Lane @ 2002-01-21 03:03 UTC (permalink / raw)
To: Murray Prior Hobbs <murray@efone.com>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Brent Verner <brent@rcfile.org>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Murray Prior Hobbs <murray@efone.com> writes:
> tell me oh mighty guru's
> what linux distribution could i use to make me a happy happy man
Just apply this patch and RHL should work.
inline patch 1: src/pl/tcl/Makefile (+4/-0 lines) download inline-1.patch
*** src/pl/tcl/Makefile.orig Sat Oct 13 00:23:50 2001
--- src/pl/tcl/Makefile Sun Jan 20 21:57:45 2002
***************
*** 49,54 ****
--- 49,58 ----
endif
endif
+ # Suppress bogus soname switch that RedHat RPMs put into tclConfig.sh
+ override TCL_SHLIB_LD := $(shell echo "$(TCL_SHLIB_LD)" | sed 's/-Wl,-soname[^ ]*//')
+
+
%$(TCL_SHLIB_SUFFIX): %.o
$(TCL_SHLIB_LD) -o $@ $< $(TCL_LIB_SPEC) $(SHLIB_EXTRA_LIBS)
regards, tom lane
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 03:27 Peter Eisentraut <peter_e@gmx.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 27+ messages in thread
From: Peter Eisentraut @ 2002-01-21 03:27 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Murray Prior Hobbs <murray@efone.com>; Brent Verner <brent@rcfile.org>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Tom Lane writes:
> Just apply this patch and RHL should work.
I'm OK with this patch. (Although you don't need the override.)
We should file a bug report with Red Hat, methinks.
> *** src/pl/tcl/Makefile.orig Sat Oct 13 00:23:50 2001
> --- src/pl/tcl/Makefile Sun Jan 20 21:57:45 2002
> ***************
> *** 49,54 ****
> --- 49,58 ----
> endif
> endif
>
> + # Suppress bogus soname switch that RedHat RPMs put into tclConfig.sh
> + override TCL_SHLIB_LD := $(shell echo "$(TCL_SHLIB_LD)" | sed 's/-Wl,-soname[^ ]*//')
> +
> +
> %$(TCL_SHLIB_SUFFIX): %.o
> $(TCL_SHLIB_LD) -o $@ $< $(TCL_LIB_SPEC) $(SHLIB_EXTRA_LIBS)
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 17:28 Trond Eivind Glomsrød <teg@redhat.com>
parent: Peter Eisentraut <peter_e@gmx.net>
2 siblings, 0 replies; 27+ messages in thread
From: teg@redhat.com @ 2002-01-21 17:28 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Brent Verner <brent@rcfile.org>; Murray Prior Hobbs <murray@efone.com>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane writes:
>
> > I'm still quite nervous about making these changes so late in the cycle.
> > OTOH I suspect Andreas was right: we haven't been getting any pltcl
> > portability testing from our beta testers.
>
> This logic can also be reversed: We haven't been getting any beta testing
> from users of Red Hat 7.1.
I don't think the tcl there had a proper so-name (from memory, I don't
use tcl)
--
Trond Eivind Glomsrød
Red Hat, Inc.
^ permalink raw reply [nested|flat] 27+ messages in thread
* Re: pltlc and pltlcu problems
@ 2002-01-21 17:36 Trond Eivind Glomsrød <teg@redhat.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 27+ messages in thread
From: teg@redhat.com @ 2002-01-21 17:36 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Murray Prior Hobbs <murray@efone.com>; Brent Verner <brent@rcfile.org>; Lamar Owen <lamar.owen@wgcr.org>; pgsql-hackers@postgresql.org; havill@redhat.com
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > I'm OK with this patch. (Although you don't need the override.)
>
> Okay, committed. (I left in the override; it can't hurt can it?)
>
> > We should file a bug report with Red Hat, methinks.
>
> Trond, I think this is your turf ... is it a bug?
(Note, I don't do tcl.)
At least part of it is intentional - adding the so name to the tcl
library. That said, it looks like a bug to me too... at the minimum,
the soname should be removed from the tclConfig.sh script after use in
generating the tcl libraries. Adrian?
--
Trond Eivind Glomsrød
Red Hat, Inc.
^ permalink raw reply [nested|flat] 27+ messages in thread
end of thread, other threads:[~2002-01-21 17:36 UTC | newest]
Thread overview: 27+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-18 13:37 pltlc and pltlcu problems Murray Prior Hobbs <murray@efone.com>
2002-01-18 15:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-18 20:17 ` Murray Prior Hobbs <murray@efone.com>
2002-01-19 04:09 ` Murray Prior Hobbs <murray@efone.com>
2002-01-19 04:12 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-19 07:58 ` Murray Prior Hobbs <murray@efone.com>
2002-01-19 08:19 ` Brent Verner <brent@rcfile.org>
2002-01-19 08:40 ` Murray Prior Hobbs <murray@efone.com>
2002-01-20 11:59 ` Brent Verner <brent@rcfile.org>
2002-01-20 12:36 ` Brent Verner <brent@rcfile.org>
2002-01-20 19:14 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-20 20:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-20 21:12 ` Peter Eisentraut <peter_e@gmx.net>
2002-01-20 21:33 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-20 22:17 ` Peter Eisentraut <peter_e@gmx.net>
2002-01-20 22:52 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-21 00:02 ` Brent Verner <brent@rcfile.org>
2002-01-21 00:16 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-21 00:31 ` Brent Verner <brent@rcfile.org>
2002-01-21 03:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-21 03:27 ` Peter Eisentraut <peter_e@gmx.net>
2002-01-21 17:36 ` Trond Eivind Glomsrød <teg@redhat.com>
2002-01-21 17:28 ` Trond Eivind Glomsrød <teg@redhat.com>
2002-01-20 17:35 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-19 09:09 ` Murray Prior Hobbs <murray@efone.com>
2002-01-19 17:36 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-01-20 07:57 ` Murray Prior Hobbs <murray@efone.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox