Unimus forum

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

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

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

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.

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.