mydumper compression output vs. Percona 5.1

[Istvan Kovacs]

Hi,

I am facing the following error when I try to use the latest mydumper (9.1, trunk has been checked out at 27th Sept 2015) I try it on Centos 6.7 running Percona 5.1.

[user@replica4 mydumper]# /root/mydumper/mydumper -B db2 -o /var/lib/mysql/dump/ -c -e -E -R -L /home/user/mydumper.log -v 3 -t 16
/root/mydumper/mydumper: relocation error: /root/mydumper/mydumper: symbol gzopen, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference

Below you can find more details about compile and installed packages. Please advice or let me know if I can help with any information the troubleshooting.

[user@replica4 mydumper]# cmake .
-- Using mysql-config: /usr/bin/mysql_config
-- Found MySQL: /usr/include/mysql, /usr/lib64/mysql/libmysqlclient_r.so;/usr/lib64/mysql/libz.a;/usr/lib64/librt.so;/usr/lib64/libpthread.so;/usr/lib64/libcrypt.so;/usr/lib64/libnsl.so;/usr/lib64/libm.so;/usr/lib64/libpthread.so;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;/usr/lib64/mysql/libmygcc.a
0
CMake Warning at docs/CMakeLists.txt:14 (message):
  Sphinx is older than v1.0, not building docs

-- ------------------------------------------------
-- MYSQL_CONFIG = /usr/bin/mysql_config
-- CMAKE_INSTALL_PREFIX = /usr/local
-- BUILD_DOCS = ON
-- WITH_BINLOG = OFF
-- RUN_CPPCHECK = OFF
-- Change a values with: cmake -D<Variable>=<Value>
-- ------------------------------------------------
--
-- Configuring done
-- Generating done
-- Build files have been written to: /root/mydumper

[user@replica4 mydumper]# make
[ 25%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o
[ 50%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o
[ 75%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o
Linking C executable mydumper
[ 75%] Built target mydumper
[100%] Building C object CMakeFiles/myloader.dir/myloader.c.o
Linking C executable myloader
[100%] Built target myloader

[user@replica4 mydumper]# rpm -qa| grep -i Percona-Ser
Percona-Server-server-51-5.1.73-rel14.12.624.rhel6.x86_64
Percona-Server-client-51-5.1.73-rel14.12.624.rhel6.x86_64
Percona-Server-devel-51-5.1.73-rel14.12.624.rhel6.x86_64
Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64

[user@replica4 mydumper]# cat /etc/redhat-release
CentOS release 6.7 (Final)

[Max Bubenick (max-bubenick)]

Hi could you please also send me these commands output?

/usr/bin/mysql_config

rpm -qa | egrep -i "mysql|percona|maria"

[Istvan Kovacs (frescho)]

[user@replica4 ~]$ /usr/bin/mysql_config
Usage: /usr/bin/mysql_config [OPTIONS]
Options:
        --cflags [-I/usr/include/mysql -fPIC -g -static-libgcc -fno-omit-frame-pointer -DPERCONA_INNODB_VERSION=14.12 -DUNIV_LINUX -DUNIV_LINUX]
        --include [-I/usr/include/mysql]
        --libs [-rdynamic -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib64/ -lssl -lcrypto -lmygcc]
        --libs_r [-rdynamic -L/usr/lib64/mysql -lmysqlclient_r -lz -lrt -lpthread -lcrypt -lnsl -lm -lpthread -L/usr/lib64/ -lssl -lcrypto -lmygcc]
        --plugindir [/usr/lib64/mysql/plugin]
        --socket [/var/lib/mysql/mysql.sock]
        --port [0]
        --version [5.1.73]
        --libmysqld-libs [-rdynamic -L/usr/lib64/mysql -lmysqld -ldl -lz -lrt -lpthread -lcrypt -lnsl -lm -lpthread -lrt -L/usr/lib64/ -lssl -lcrypto -lmygcc]
[user@replica4 ~]$ rpm -qa | egrep -i "mysql|percona|maria"
percona-nagios-plugins-1.1.4-1.noarch
Percona-Server-server-51-5.1.73-rel14.12.624.rhel6.x86_64
perl-DBD-MySQL-4.013-3.el6.x86_64
percona-toolkit-2.2.11-1.noarch
collectd-mysql-5.5.0-1.el6.x86_64
Percona-Server-client-51-5.1.73-rel14.12.624.rhel6.x86_64
Percona-Server-devel-51-5.1.73-rel14.12.624.rhel6.x86_64
percona-xtrabackup-2.2.12-1.el6.x86_64
Percona-XtraDB-Cluster-shared-55-5.5.41-25.11.853.el6.x86_64
Percona-Server-shared-51-5.1.73-rel14.12.624.rhel6.x86_64

[Max Bubenick (max-bubenick)]

Ok try this.

* Remove CMakeCahe.txt if exists
* Edit CMakeLists.txt in this way:

-target_link_libraries(mydumper ${MYSQL_LIBRARIES} ${GLIB2_LIBRARIES} ${GTHREAD2_LIBRARIES} ${PCRE_PCRE_LIBRARY} ${ZLIB_LIBRARIES})
+target_link_libraries(mydumper ${MYSQL_LIBRARIES} ${GLIB2_LIBRARIES} ${GTHREAD2_LIBRARIES} ${PCRE_PCRE_LIBRARY} ${ZLIB_LIBRARIES} m ssl)

-target_link_libraries(myloader ${MYSQL_LIBRARIES} ${GLIB2_LIBRARIES} ${GTHREAD2_LIBRARIES} ${PCRE_PCRE_LIBRARY} ${ZLIB_LIBRARIES})
+target_link_libraries(myloader ${MYSQL_LIBRARIES} ${GLIB2_LIBRARIES} ${GTHREAD2_LIBRARIES} ${PCRE_PCRE_LIBRARY} ${ZLIB_LIBRARIES} m ssl)

* Then run cmake with:

cmake . -DMYSQL_LIBRARIES:FILEPATH=/usr/lib64/mysql/libmysqlclient_r.a

* make

That should work.

[Istvan Kovacs (frescho)]

Hi,

It works very well. Dump finished successfully, I am running myloader right now.

Thanks a lot for support

Istvan