I guess 'partition' is a reserved word for mariadb, but db_unixodbc is not quoting the column names.

Is there any reason not to use db_mysql, afaik, it should work fine for mariadb and it does proper quotation of column names.

As for db_unixodbc, it may need a mod param to set the quotation character, because it is not the same for database servers.