[Fixed in 2.4.2] switched to mariadb / transaction_isolation

[j.koopmann]

Hi,

I switched my backend database from mysql to mariadb which in most cases is not a problem. With unimus however I get

2023-07-08 12:02:53.671 ERROR 12 --- [cTaskExecutor-1] .s.b.b.s.DatabaseConnectionCheckBootStep : Database 'MysqlConfig{host='x.x.x.x', port='3306', databaseName='xx', user='xx'}' connection test failed. Reason = 'org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Unknown system variable 'transaction_isolation''

This seems to be unimus not recognizing mariadb and trying an option that does not exist with mariadb. Any idea?

Regards
JP

[dominik.c]

Hi,

Could you please create a Support Ticket on our Portal? It would also be very helpful if you could attach the Unimus logs.

Thank you
Unimus support

[jpsimmonds]

I have found the issue, found the fix and posted my findings here viewtopic.php?f=7&t=1653.

TLDR; use MariaDB 10 not 11 easy enough in docker but do not know your infrastructure

[dominik.c]

Hello,

Unfortunately the problem is that MariaDB 11 is not supported by Unimus yet. We have it in our scope, but unfortunately we don't have an ETA yet. I will inform you when we will have news about ETA.

[dominik.c]

Greetings,

We have a new Unimus version 2.4.2 live now, where we add a support for MariaDB 11.
More info here: viewtopic.php?f=3&t=1748

If you get a chance, give it a try and let us know if it works as expected.

Thank you and have a nice day.