| Summary: | mysql cli broken after upgrade: symbol lookup error | ||
|---|---|---|---|
| Product: | Gentoo Linux | Reporter: | John Barton <jbarton> |
| Component: | Current packages | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | ||
| Priority: | High | ||
| Version: | unspecified | ||
| Hardware: | x86 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Package list: | Runtime testing required: | --- | |
|
Description
John Barton
2004-12-03 16:05:18 UTC
sounds like your mysql client is from a much older mysql, or your libmysqlclient.so is misssing. please put up the output from 'ldd `which mysql`'. in your description you note that an already established connection to mysql still works, but how was this connection made, given that you restarted mysqld. Here is the ldd output:
server1 root # ldd `which mysql`
libreadline.so.4 => /lib/libreadline.so.4 (0x4001b000)
libncurses.so.5 => /lib/libncurses.so.5 (0x40049000)
libstdc++.so.5 => /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.4/libstdc++.so.5 (0x4008e000)
libgcc_s.so.1 => /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.4/libgcc_s.so.1 (0x40157000)
libmysqlclient.so.12 => /usr/lib/mysql/libmysqlclient.so.12 (0x40160000)
libz.so.1 => /lib/libz.so.1 (0x40184000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40195000)
libnsl.so.1 => /lib/libnsl.so.1 (0x401c3000)
libssl.so.0.9.7 => /usr/lib/libssl.so.0.9.7 (0x401d8000)
libcrypto.so.0.9.7 => /usr/lib/libcrypto.so.0.9.7 (0x40208000)
libm.so.6 => /lib/libm.so.6 (0x40304000)
libc.so.6 => /lib/libc.so.6 (0x40326000)
libdl.so.2 => /lib/libdl.so.2 (0x4043a000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
The mysql connection had to reconnect to the daemon, but the client had been running for some time. Here is what I did:
mysql> show databases;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 7818
Current database: vpopmail
+----------------------------+
| Database |
+----------------------------+
+----------------------------+
9 rows in set (0.00 sec)
mysql>
Also, looking at the mysql binary, it is dated the day I did the installation:
-rwxr-xr-x 1 root root 65268 Dec 1 23:28 /usr/bin/mysql
This appears to be an issue of old libraries on my system causing confusion. I had mysql libraries in /usr/lib and /usr/lib/mysql. The copy of libmysqlclient.so.12.0.0 in /usr/lib/mysql was much older than the copy in /usr/lib. After renaming this file and then creating a symbolic link from /usr/lib/mysql/libmysqlclient.so.12.0.0 to point to /usr/lib/libmysqlclient.so.12, everything seems to be working again. |
