[MDEV-5763] libmyodbc.so: undefined symbol: int2str - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5.36, 10.0.9
Fix Version/s: 5.5.37, 10.0.10
Component/s: None
Labels:
None
Environment:
Ubuntu 12.04.4 LTS
libmyodbc-5.1.10-1

Description

Since I upgraded to 5.5.36 I can't use libmyodbc to connect to the database:

jorgeml@london:~$ isql -v MySQL-asterisk-cdr

isql: symbol lookup error: /usr/lib/i386-linux-gnu/odbc/libmyodbc.so: undefined symbol: int2str

jorgeml@london:~$ ldd /usr/lib/i386-linux-gnu/odbc/libmyodbc.so

	linux-gate.so.1 =>  (0xb777c000)

	libmysqlclient.so.18 => /usr/lib/libmysqlclient.so.18 (0xb7448000)

	libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb742d000)

	libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7428000)

	libodbcinst.so.1 => /usr/lib/i386-linux-gnu/libodbcinst.so.1 (0xb7414000)

	libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb726a000)

	libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb7254000)

	libssl.so.1.0.0 => /lib/i386-linux-gnu/libssl.so.1.0.0 (0xb71fc000)

	libcrypto.so.1.0.0 => /lib/i386-linux-gnu/libcrypto.so.1.0.0 (0xb7051000)

	librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb7047000)

	/lib/ld-linux.so.2 (0xb777d000)

	libltdl.so.7 => /usr/lib/i386-linux-gnu/libltdl.so.7 (0xb703d000)

jorgeml@london:~$ ldd /usr/lib/libmysqlclient.so.18

	linux-gate.so.1 =>  (0xb773e000)

	libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb743a000)

	libssl.so.1.0.0 => /lib/i386-linux-gnu/libssl.so.1.0.0 (0xb73e2000)

	libcrypto.so.1.0.0 => /lib/i386-linux-gnu/libcrypto.so.1.0.0 (0xb7237000)

	libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7231000)

	librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb7228000)

	libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb720d000)

	libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7063000)

	/lib/ld-linux.so.2 (0xb773f000)

Could it be a regression introduced by ~~MDEV-5613~~ ?

Attachments

Issue Links

relates to

MDEV-5529 Sync libmysqlclient.so symbol versioning across distributions

Closed

Activity

Ascending order - Click to sort in descending order

Jorge Martínez López created issue - 2014-02-27 21:26

Sergei Golubchik made changes - 2014-02-27 22:09

Field	Original Value	New Value
Description	Since I upgraded to 5.5.36 I can't use libmyodbc to connect to the database: jorgeml@london:~$ isql -v MySQL-asterisk-cdr isql: symbol lookup error: /usr/lib/i386-linux-gnu/odbc/libmyodbc.so: undefined symbol: int2str jorgeml@london:~$ ldd /usr/lib/i386-linux-gnu/odbc/libmyodbc.so linux-gate.so.1 => (0xb777c000) libmysqlclient.so.18 => /usr/lib/libmysqlclient.so.18 (0xb7448000) libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb742d000) libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7428000) libodbcinst.so.1 => /usr/lib/i386-linux-gnu/libodbcinst.so.1 (0xb7414000) libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb726a000) libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb7254000) libssl.so.1.0.0 => /lib/i386-linux-gnu/libssl.so.1.0.0 (0xb71fc000) libcrypto.so.1.0.0 => /lib/i386-linux-gnu/libcrypto.so.1.0.0 (0xb7051000) librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb7047000) /lib/ld-linux.so.2 (0xb777d000) libltdl.so.7 => /usr/lib/i386-linux-gnu/libltdl.so.7 (0xb703d000) jorgeml@london:~$ ldd /usr/lib/libmysqlclient.so.18 linux-gate.so.1 => (0xb773e000) libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb743a000) libssl.so.1.0.0 => /lib/i386-linux-gnu/libssl.so.1.0.0 (0xb73e2000) libcrypto.so.1.0.0 => /lib/i386-linux-gnu/libcrypto.so.1.0.0 (0xb7237000) libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7231000) librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb7228000) libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb720d000) libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7063000) /lib/ld-linux.so.2 (0xb773f000) Could it be a regression introduced by ~~MDEV-5613~~ ?	Since I upgraded to 5.5.36 I can't use libmyodbc to connect to the database: {noformat} jorgeml@london:~$ isql -v MySQL-asterisk-cdr isql: symbol lookup error: /usr/lib/i386-linux-gnu/odbc/libmyodbc.so: undefined symbol: int2str jorgeml@london:~$ ldd /usr/lib/i386-linux-gnu/odbc/libmyodbc.so linux-gate.so.1 => (0xb777c000) libmysqlclient.so.18 => /usr/lib/libmysqlclient.so.18 (0xb7448000) libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb742d000) libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7428000) libodbcinst.so.1 => /usr/lib/i386-linux-gnu/libodbcinst.so.1 (0xb7414000) libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb726a000) libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb7254000) libssl.so.1.0.0 => /lib/i386-linux-gnu/libssl.so.1.0.0 (0xb71fc000) libcrypto.so.1.0.0 => /lib/i386-linux-gnu/libcrypto.so.1.0.0 (0xb7051000) librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb7047000) /lib/ld-linux.so.2 (0xb777d000) libltdl.so.7 => /usr/lib/i386-linux-gnu/libltdl.so.7 (0xb703d000) jorgeml@london:~$ ldd /usr/lib/libmysqlclient.so.18 linux-gate.so.1 => (0xb773e000) libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb743a000) libssl.so.1.0.0 => /lib/i386-linux-gnu/libssl.so.1.0.0 (0xb73e2000) libcrypto.so.1.0.0 => /lib/i386-linux-gnu/libcrypto.so.1.0.0 (0xb7237000) libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xb7231000) librt.so.1 => /lib/i386-linux-gnu/librt.so.1 (0xb7228000) libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb720d000) libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7063000) /lib/ld-linux.so.2 (0xb773f000) {noformat} Could it be a regression introduced by ~~MDEV-5613~~ ?

Sergei Golubchik added a comment - 2014-02-27 22:11 - edited

Not quite, it's a regression introduced by ~~MDEV-5529~~. Thanks for reporting it, it'll be fixed in 5.5.37

Sergei Golubchik added a comment - 2014-02-27 22:11 - edited Not quite, it's a regression introduced by MDEV-5529 . Thanks for reporting it, it'll be fixed in 5.5.37

Sergei Golubchik made changes - 2014-02-27 22:11

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2014-02-27 22:11

Fix Version/s

5.5.37 [ 15000 ]

Jorge Martínez López added a comment - 2014-02-27 22:15

Fantastic job Sergei, thanks for your swift response.

Is there a workaround while 5.5.37 goes out?

Jorge Martínez López added a comment - 2014-02-27 22:15 Fantastic job Sergei, thanks for your swift response. Is there a workaround while 5.5.37 goes out?

Elena Stepanova added a comment - 2014-02-27 22:56

As a workaround, you can install libmysqlclient18 from 5.5.35 repository.
You need to add the 5.5.35 repo to your /etc/apt/sources file, e.g.

deb http://ftp.osuosl.org/pub/mariadb/mariadb-5.5.35/repo/ubuntu precise main

(if you prefer a different mirror, you can tweak the path in the similar fashion and see if the 5.5.35 repo is there, at least some mirrors have it).
Then run

apt-get update

apt-get install libmysqlclient18=5.5.35+maria-1~precise libmariadbclient18=5.5.35+maria-1~precise

Then you can remove 5.5.35 repo from the sources.list.

Elena Stepanova added a comment - 2014-02-27 22:56 As a workaround, you can install libmysqlclient18 from 5.5.35 repository. You need to add the 5.5.35 repo to your /etc/apt/sources file, e.g. deb http://ftp.osuosl.org/pub/mariadb/mariadb-5.5.35/repo/ubuntu precise main (if you prefer a different mirror, you can tweak the path in the similar fashion and see if the 5.5.35 repo is there, at least some mirrors have it). Then run apt-get update apt-get install libmysqlclient18=5.5.35+maria-1~precise libmariadbclient18=5.5.35+maria-1~precise Then you can remove 5.5.35 repo from the sources.list.

Jorge Martínez López added a comment - 2014-02-27 23:18

Thanks Elena, I'm afraid that didn't work as downgrading libmysqlclient18 and libmariadbclient18 triggers the removal of mariadb-client and mariadb-server (and a few other packages).

Jorge Martínez López added a comment - 2014-02-27 23:18 Thanks Elena, I'm afraid that didn't work as downgrading libmysqlclient18 and libmariadbclient18 triggers the removal of mariadb-client and mariadb-server (and a few other packages).

Elena Stepanova added a comment - 2014-02-27 23:22

Sorry, I didn't know you had the server on the same machine. Then you can just downgrade the whole set, whichever mariadb-5.5.36 packages you have, to 5.5.35, in the same way, and maybe pin the version to prevent automatic upgrades until 5.5.37 is released.

Alternatively, I suppose you can just pull the 5.5.35 library, put it somewhere and upgrade the LD_LIBRARY_PATH for the client, will it work for you?

Elena Stepanova added a comment - 2014-02-27 23:22 Sorry, I didn't know you had the server on the same machine. Then you can just downgrade the whole set, whichever mariadb-5.5.36 packages you have, to 5.5.35, in the same way, and maybe pin the version to prevent automatic upgrades until 5.5.37 is released. Alternatively, I suppose you can just pull the 5.5.35 library, put it somewhere and upgrade the LD_LIBRARY_PATH for the client, will it work for you?

Jorge Martínez López added a comment - 2014-02-28 00:12 - edited

Downgraded by running

# apt-get install libmysqlclient18=5.5.35+maria-1~precise libmariadbclient18=5.5.35+maria-1~precise mariadb-client=5.5.35+maria-1~precise mariadb-server=5.5.35+maria-1~precise mariadb-client-5.5=5.5.35+maria-1~precise mariadb-server-5.5=5.5.35+maria-1~precise mariadb-client-core-5.5=5.5.35+maria-1~precise mariadb-server-core-5.5=5.5.35+maria-1~precise

Then I added a hold to the packages

apt-mark hold libmariadbclient18 libmysqlclient18 mariadb-client mariadb-client-5.5 mariadb-client-core-5.5 mariadb-server mariadb-server-5.5 mariadb-server-core-5.5

libmyodbc works again:

jorgeml@london:~$ isql -v MySQL-asterisk-cdr

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL>

Thanks Elena and Sergei!

Jorge Martínez López added a comment - 2014-02-28 00:12 - edited Downgraded by running # apt-get install libmysqlclient18=5.5.35+maria-1~precise libmariadbclient18=5.5.35+maria-1~precise mariadb-client=5.5.35+maria-1~precise mariadb-server=5.5.35+maria-1~precise mariadb-client-5.5=5.5.35+maria-1~precise mariadb-server-5.5=5.5.35+maria-1~precise mariadb-client-core-5.5=5.5.35+maria-1~precise mariadb-server-core-5.5=5.5.35+maria-1~precise Then I added a hold to the packages apt-mark hold libmariadbclient18 libmysqlclient18 mariadb-client mariadb-client-5.5 mariadb-client-core-5.5 mariadb-server mariadb-server-5.5 mariadb-server-core-5.5 libmyodbc works again: jorgeml@london:~$ isql -v MySQL-asterisk-cdr +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> Thanks Elena and Sergei!

Sergei Golubchik made changes - 2014-03-03 15:06

Link

This issue relates to ~~MDEV-5529~~ [ ~~MDEV-5529~~ ]

Sergei Golubchik made changes - 2014-03-12 18:37

Affects Version/s

10.0.9 [ 14400 ]

Sergei Golubchik made changes - 2014-03-12 18:37

Fix Version/s

10.0.10 [ 14500 ]

Steph Locke added a comment - 2014-03-18 17:56 - edited

I got this issue and was having trouble downgrading with the code provided by Jorge, turns out you have to also remove the var/lib/mysql files

sudo apt-get purge mysql* mariadb*

sudo rm /etc/mysql -R

sudo rm /var/lib/mysql -R

 sudo apt-get install libmysqlclient18=5.5.35+maria-1~precise libmariadbclient18=5.5.35+maria-1~precise mariadb-client=5.5.35+maria-1~precise mariadb-server=5.5.35+maria-1~precise mariadb-client-5.5=5.5.35+maria-1~precise mariadb-server-5.5=5.5.35+maria-1~precise mariadb-client-core-5.5=5.5.35+maria-1~precise mariadb-server-core-5.5=5.5.35+maria-1~precise mariadb-common=5.5.35+maria-1~precise mysql-common=5.5.35+maria-1~precise

Steph Locke added a comment - 2014-03-18 17:56 - edited I got this issue and was having trouble downgrading with the code provided by Jorge, turns out you have to also remove the var/lib/mysql files sudo apt-get purge mysql* mariadb* sudo rm /etc/mysql -R sudo rm /var/lib/mysql -R sudo apt-get install libmysqlclient18=5.5.35+maria-1~precise libmariadbclient18=5.5.35+maria-1~precise mariadb-client=5.5.35+maria-1~precise mariadb-server=5.5.35+maria-1~precise mariadb-client-5.5=5.5.35+maria-1~precise mariadb-server-5.5=5.5.35+maria-1~precise mariadb-client-core-5.5=5.5.35+maria-1~precise mariadb-server-core-5.5=5.5.35+maria-1~precise mariadb-common=5.5.35+maria-1~precise mysql-common=5.5.35+maria-1~precise

Sergei Golubchik made changes - 2014-03-18 22:10

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2014-03-26 23:48

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 35411 ]

MariaDB v2 [ 43003 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 43003 ]

MariaDB v3 [ 62720 ]

Sergei Golubchik made changes - 2021-12-06 21:39

Workflow

MariaDB v3 [ 62720 ]

MariaDB v4 [ 147569 ]

People

Assignee:: Sergei Golubchik

Reporter:: Jorge Martínez López

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2014-02-27 21:26

Updated:: 2014-03-26 23:48

Resolved:: 2014-03-26 23:48

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration