From: Curt W. Zirzow
Date: March 29 1999 9:02pm
Subject: Re: error while loading UDF
List-Archive: http://lists.mysql.com/mysql/1163
Message-Id: <19990329210207.3427.qmail@modgud.nordicdms.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7BIT

On 29 Mar 1999 05:34:20 -0800, 
   Michael Widenius <monty@stripped> wrote:
>
>Did you upgrade FreeBSD version between 3.22.16 gamma and 
3.22.19b ?

Yes, 3.22.16 gamma is running on FreeBSD 3.0-RELEASE.
        3.22.19b is running on FreeBSD 3.1-RELEASE

Also, the new version we have has been compiled --with-mit-
threads=yes; while the 3.22.16 gamma was not, if this makes any 
difference.

A way I found to fix this problem is to compile my .so as so...
c++ -shared -DMYSQL_SERVER <snip> udf_relevant.cc ../mit-
pthreads/obj/libpthread.a -o udf_relevant.so

Would this be a reasonable aproach to fixing my problem?

Thanks much...
Curt Zirzow


>>>>> "Curt" == Curt W Zirzow <curt@stripped> writes:

Curt> I've got a udf which I've got compiled as a share library.  And 
then I 
Curt> go into mysql and type:

mysql> create function relevant returns real soname 
Curt> 'udf_relevant.so';
Curt> Query OK, 0 rows affected (0.00 sec)

mysql> select relevant('string 1', 'string 2');
Curt> +----------------------------------+
Curt> | relevant('string 1', 'string 2') |
Curt> +----------------------------------+
Curt> |                           0.5000 |
Curt> +----------------------------------+
Curt> 1 row in set (0.00 sec)

Curt> So far everything is working ok, BUT...

Curt> If I start and stop mysqld I get in my error log:

Curt> 990328 18:32:10  Can't open shared library: 'udf_relevant.so', 
Curt> errno:0 (/usr/local/lib/mysql/udf_relevant.so: Undefined 
symbol 
Curt> "pthread_initial")

Curt> Whats going on? why wouldn't it load when mysqld is restarted?

Curt> I had this running ok on 3.22.16gamma but it isn't working for 
Curt> 3.22.19b.

Curt> Here is some info about this computer. 

>> Environment:
Curt>         <machine, os, target, libraries (multiple lines)>
Curt> System: FreeBSD frigg.nordicdms.com 3.1-RELEASE FreeBSD 
Curt> 3.1-RELEASE #0: Thu Mar
Curt> 25 21:08:13 PST 1999     
Curt> walton@stripped:/usr/src/sys/compile/FRIGG
Curt> i386


Curt> Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake 
Curt> /usr/bin/gcc /usr/
Curt> bin/cc
Curt> GCC: gcc version 2.7.2.1
Curt> Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  
CXXFLAGS='' 
Curt> LDFLAGS=''
Curt> Configure command: ./configure --with-unix-socket-
Curt> path=/var/tmp/mysql.sock --with-low-memory --with-mit-
threads=yes
Curt> Perl: This is perl, version 5.005_02 built for i386-freebsd

Curt Zirzow
Nordic Entertainment 
http://www.nordicdms.com