I've been using mariadb for a while on Ubuntu 12.04 with an ODBC DSN that I could use in R.
Today it stopped working and I've been checking things like reinstalling packages, moving to mariadb 10 (as an issue which prevented ODBC connections has been fixed), and generally looking around.
I am unfortunately still getting the following error
slocke@host:~$ isql -v myDB Floating point exception (core dumped)
Can folks advise on a) how to debug further and /or b) what the likely issue is?
UPDATE 1 Further to @Rinzwind's suggestion and this SO question I was able to locate a crash report / core dump. Using apport-retrace I have tried to open both isql .crash files present in the /var/crash directory however both get the following error
sudo apport-retrace -g -R /var/crash/_usr_bin_isql.0.crash Program terminated with signal 8, Arithmetic exception. #0 0x00007ff459929366 in sqlchar_as_sqlwchar () from /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
UPDATE 2 Based on the error message, it looks like a known bug with the MySQL ODBC connector. It has subsequently been fixed, however, the version it has been fixed in is not available in the Ubuntu repository. I've attempted to download and install a later version but installing it seems very difficult (to me!) with dependencies that can't be met by the repository and a complete lack of installation instructions for Ubuntu in the INSTALL file.
[MySQL] Description = ODBC Driver for MySQL Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so FileUsage = 1
[myDB] Description = Database linked to application Driver = MySQL SERVER = localhost USER = abc PASSWORD = mypwd PORT = 3306 DATABASE = mydb
Installed mariadb packages
dpkg --list ii mariadb-client 10.0.10+maria- MariaDB database client binaries ii mariadb-client 10.0.10+maria- MariaDB database core client binaries ii mariadb-common 10.0.10+maria- MariaDB database common files (e.g. /etc/mys ii mariadb-server 10.0.10+maria- MariaDB database server (metapackage dependi ii mariadb-server 10.0.10+maria- MariaDB database server binaries ii mariadb-server 10.0.10+maria- MariaDB database core server files
ii libmyodbc 5.1.10-1 the MySQL ODBC driver ii libmysqlclient 10.0.10+maria- Virtual package to satisfy external depends external depends ii unixodbc 2.2.14p2-5ubun Basic ODBC tools ii unixodbc-dev 2.2.14p2-5ubun ODBC libraries for UNIX (development files)