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 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 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 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> 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