From: Curt W. Zirzow Date: March 29 1999 2:49am Subject: error while loading UDF List-Archive: http://lists.mysql.com/mysql/1115 Message-Id: <19990329024946.21820.qmail@modgud.nordicdms.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7BIT I've got a udf which I've got compiled as a share library. And then I go into mysql and type: mysql> create function relevant returns real soname 'udf_relevant.so'; Query OK, 0 rows affected (0.00 sec) mysql> select relevant('string 1', 'string 2'); +----------------------------------+ | relevant('string 1', 'string 2') | +----------------------------------+ | 0.5000 | +----------------------------------+ 1 row in set (0.00 sec) So far everything is working ok, BUT... If I start and stop mysqld I get in my error log: 990328 18:32:10 Can't open shared library: 'udf_relevant.so', errno:0 (/usr/local/lib/mysql/udf_relevant.so: Undefined symbol "pthread_initial") Whats going on? why wouldn't it load when mysqld is restarted? I had this running ok on 3.22.16gamma but it isn't working for 3.22.19b. Here is some info about this computer. >Environment: System: FreeBSD frigg.nordicdms.com 3.1-RELEASE FreeBSD 3.1-RELEASE #0: Thu Mar 25 21:08:13 PST 1999 walton@stripped:/usr/src/sys/compile/FRIGG i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/ bin/cc GCC: gcc version 2.7.2.1 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket- path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes Perl: This is perl, version 5.005_02 built for i386-freebsd Any Ideas? Curt