BASE crashes with "Assertion `to - buff < sizeof(buff)' failed" on queries

I am using BASE to connect CALC documents to MySQL via ODBC. This worked fine, until I was forced to upgrade from an older version.
Now, isql command line works, MySQL server works, but CALC and BASE crashe when trying to run certain queries or open tables.

Queries that only return simple results, such as count(1) work, but trying to open tables or running more complex queries immediately crashes the program. This is true both when editing the .odb file as well as the .ods file using the conneection.

Full crash report on command line:
/export/home2/tmp/cteam/bs/connector-odbc-5.1-64bit/src/mysql-connector-odbc-5.1.11-src/driver/catalog.c:219: mysql_table_status_i_s: Assertion `to - buff < sizeof(buff)’ failed.

Hi @cyberbunny, Please file a bug about this problem. The QA team will be happy to help you track down this issue! Thanks!

I actually just figured it out… Using driver 5.1.8 worked for me(unsure about .9 or .10)

I am getting the same error but for a different close-source application.

XXXXXXXXXX: /export/home2/tmp/cteam/bs/connector-odbc-5.1-32bit/src/mysql-connector-odbc-5.1.11-src/BUILD/mysql-connector-odbc-5.1.11-src/driver/catalog.c:219: mysql_table_status_i_s: Assertion `to - buff < sizeof(buff)’ failed.

MySQL: 5.1.61
Connector: 5.1.11

I can confirm the same error, opening an .odb file, connecting via myodbc 5.1.11 only selecting a table in Base table list makes Base crash with:

soffice.bin: /build/src/mysql-connector-odbc-5.1.11-src/driver/catalog.c:219: mysql_table_status_i_s: asserzione "to - buff < sizeof(buff)" non riuscita.

Downgrading to myodbc 5.1.10 seems to fix this problem.

Hi @cyberbunny,

Based on the Answers above, it sounds like there’s an issue in the 5.1.11 version of the connector.

  1. As a workaround, downgrade to 5.1.10 (or lower)
  2. Please file a bug about this problem, and provide a list of steps that can reproduce it. The QA team will be happy to help you track down this issue!

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!