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:
<machine, os, target, libraries (multiple lines)>
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
