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

Bug #1294216 reported by Timur Bakeyev on 2014-03-18
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.5
Undecided
Alexey Bychko
5.6
Undecided
Unassigned

Bug Description

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"

Tags: pkg Edit Tag help

Related branches

lp:~percona-core/percona-server/release-5.5.36-34.1
Merged into lp:percona-server/5.5 at revision 646
Laurynas Biveinis: Approve on 2014-03-27
Anders Carling (lowe-p) wrote :

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

Changed in percona-server:
status: New → Confirmed
assignee: nobody → Alexey Bychko (abychko)
tags: added: pkg
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers