Thread: Pltcl kills postmaster...
NetBSD 1.5 on i386 PostgreSQL 7.1.1 and 7.1.2 I downloaded source, compiled and installed Postgresql 7.1.1 and all was well. Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine. I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from script. Functions create just fine. However, any time I try to execute a pltcl function, I get /usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3) Server process (pid 11970) exited with status 256... What could this be? Ian A. Harding Programmer/Analyst II Tacoma-Pierce County Health Department (253) 798-3549 mailto: ianh@tpchd.org
It is there, and has reasonable permissions (755). Hmmmm.... Ian A. Harding Programmer/Analyst II Tacoma-Pierce County Health Department (253) 798-3549 mailto: ianh@tpchd.org >>> Doug McNaught <doug@wireboard.com> 06/01/01 12:18PM >>> "Ian Harding" <ianh@healthdept.co.pierce.wa.us> writes: > However, any time I try to execute a pltcl function, I get > > /usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3) > Server process (pid 11970) exited with status 256... Looks like the backend is not finding the libtcl shared library for some reason... -Doug -- The rain man gave me two cures; he said jump right in, The first was Texas medicine--the second was just railroad gin, And like a fool I mixed them, and it strangled up my mind, Now people just get uglier, and I got no sense of time... --Dylan
"Ian Harding" <ianh@healthdept.co.pierce.wa.us> writes: > However, any time I try to execute a pltcl function, I get > > /usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3) > Server process (pid 11970) exited with status 256... Looks like the backend is not finding the libtcl shared library for some reason... -Doug -- The rain man gave me two cures; he said jump right in, The first was Texas medicine--the second was just railroad gin, And like a fool I mixed them, and it strangled up my mind, Now people just get uglier, and I got no sense of time... --Dylan
tcl 8.3.
By the way, I found that libtcl83 is NOT there, but there is a libtcl83.a and some other extensions. It appears to be
appendingalphas and numbers as I have been thrashing around building and installing things. I wonder if this has
somethingto do with it...
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org
>>> Jan Wieck <JanWieck@Yahoo.com> 06/01/01 12:51PM >>>
Ian Harding wrote:
> NetBSD 1.5 on i386
> PostgreSQL 7.1.1 and 7.1.2
>
> I downloaded source, compiled and installed Postgresql 7.1.1 and all was well.
>
> Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain
PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine.
>
> I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from
script. Functions create just fine.
>
> However, any time I try to execute a pltcl function, I get
>
> /usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
> Server process (pid 11970) exited with status 256...
>
> What could this be?
What version of Tcl is that now?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Ian Harding wrote:
> NetBSD 1.5 on i386
> PostgreSQL 7.1.1 and 7.1.2
>
> I downloaded source, compiled and installed Postgresql 7.1.1 and all was well.
>
> Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain
PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine.
>
> I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from
script. Functions create just fine.
>
> However, any time I try to execute a pltcl function, I get
>
> /usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
> Server process (pid 11970) exited with status 256...
>
> What could this be?
What version of Tcl is that now?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
A better understanding of the packages collection might help me. I commented out the line in the Makefile that says
--without-tclthinking that was what I needed to do to get pltcl to work. All it did was break it.
I ran 'make update' in the tcl package directory, and noticed that it installed postgresql-pltcl as well as tcl and tk.
This fixed my problem.
I still don't know exactly why that broke it, but it's all better now.
Thanks!
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: ianh@tpchd.org
>>> Jan Wieck <JanWieck@Yahoo.com> 06/01/01 12:51PM >>>
Ian Harding wrote:
> NetBSD 1.5 on i386
> PostgreSQL 7.1.1 and 7.1.2
>
> I downloaded source, compiled and installed Postgresql 7.1.1 and all was well.
>
> Once the NetBSD pkgsrc packages caught up with the latest distribution, I decided to use it to install and maintain
PG. So, I deleted /usr/local/pgsql and installed using pgksrc. It seems to have worked fine.
>
> I added 'pltcl' language to template1 and created a database. I created my tables, views, functions, triggers from
script. Functions create just fine.
>
> However, any time I try to execute a pltcl function, I get
>
> /usr/pkg/lib/pltcl.so: Undefined PLT symbol "TclCreateInterp" (reloc type=7, synum=3)
> Server process (pid 11970) exited with status 256...
>
> What could this be?
What version of Tcl is that now?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com