percona-server-server-5.5_5.5.36-rel34.0-632.wheezy_amd64 misses UDF functions(and handlersocket)

[Timur Bakeyev]

Hi!

With the recent upgrade from percona-server-server-5.5_5.5.35-rel33.0-611.wheezy_amd64 to percona-server-server-5.5_5.5.36-rel34.0-632.wheezy_amd64 I've noticed in the logs:

Mar 18 04:24:43 mysql05 mysqld[6396]: 140318 4:24:43 Percona XtraDB (http://www.percona.com) 5.5.36-34.0-34.0 started; log sequence number 12786538600075
Mar 18 04:24:43 mysql05 mysqld[6396]: 140318 4:24:43 [ERROR] Can't open shared library 'libfnv1a_udf.so' (errno: 0 /usr/lib/mysql/plugin/libfnv1a_udf.so: cannot open shared object file: No such file or directory)
Mar 18 04:24:43 mysql05 mysqld[6396]: 140318 4:24:43 [ERROR] Can't open shared library 'libfnv_udf.so' (errno: 0 /usr/lib/mysql/plugin/libfnv_udf.so: cannot open shared object file: No such file or directory)
Mar 18 04:24:43 mysql05 mysqld[6396]: 140318 4:24:43 [ERROR] Can't open shared library 'libmurmur_udf.so' (errno: 0 /usr/lib/mysql/plugin/libmurmur_udf.so: cannot open shared object file: No such file or directory)

Indeed, comparing content of both deb files I see, that later one misses:

-rw-r--r-- 1 root root 3855458 Dec 18 14:08 handlersocket.a
-rw-r--r-- 1 root root 984 Dec 18 14:08 handlersocket.la
lrwxrwxrwx 1 root root 22 Mar 18 17:48 handlersocket.so -> handlersocket.so.0.0.0
lrwxrwxrwx 1 root root 22 Mar 18 17:48 handlersocket.so.0 -> handlersocket.so.0.0.0
-rw-r--r-- 1 root root 148792 Dec 18 14:08 handlersocket.so.0.0.0
-rw-r--r-- 1 root root 2170 Dec 18 14:08 libfnv1a_udf.a
-rw-r--r-- 1 root root 976 Dec 18 14:08 libfnv1a_udf.la
lrwxrwxrwx 1 root root 21 Mar 18 17:48 libfnv1a_udf.so -> libfnv1a_udf.so.0.0.0
lrwxrwxrwx 1 root root 21 Mar 18 17:48 libfnv1a_udf.so.0 -> libfnv1a_udf.so.0.0.0
-rw-r--r-- 1 root root 5048 Dec 18 14:08 libfnv1a_udf.so.0.0.0
-rw-r--r-- 1 root root 2168 Dec 18 14:08 libfnv_udf.a
-rw-r--r-- 1 root root 962 Dec 18 14:08 libfnv_udf.la
lrwxrwxrwx 1 root root 19 Mar 18 17:48 libfnv_udf.so -> libfnv_udf.so.0.0.0
lrwxrwxrwx 1 root root 19 Mar 18 17:48 libfnv_udf.so.0 -> libfnv_udf.so.0.0.0
-rw-r--r-- 1 root root 5040 Dec 18 14:08 libfnv_udf.so.0.0.0
-rw-r--r-- 1 root root 2494 Dec 18 14:08 libmurmur_udf.a
-rw-r--r-- 1 root root 983 Dec 18 14:08 libmurmur_udf.la
lrwxrwxrwx 1 root root 22 Mar 18 17:48 libmurmur_udf.so -> libmurmur_udf.so.0.0.0
lrwxrwxrwx 1 root root 22 Mar 18 17:48 libmurmur_udf.so.0 -> libmurmur_udf.so.0.0.0
-rw-r--r-- 1 root root 5296 Dec 18 14:08 libmurmur_udf.so.0.0.0

Not sure about handler socket, maybe it was removed for some other reasons, but UDF functions seems, missing by mistake.

Or, at least, they should be suggested to be removed from UDF functions in 'postinst':

#Some postinstall info about UDF
#
echo -e "\n\n * Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit."
echo -e " * Run the following commands to create these functions:\n"
echo -e "\tmysql -e \"CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'\""
echo -e "\tmysql -e \"CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'\""
echo -e "\tmysql -e \"CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'\""
echo -e "\n * See http://www.percona.com/doc/percona-server/5.5/management/udf_percona_toolkit.html for more details\n\n"

[Anders Carling (lowe-p)]

They're also missing in 5.5.36-rel34.1-642.precise

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3110