switched to mariadb / transaction_isolation

Unimus support forum
Post Reply
Posts: 1
Joined: Sat Jul 08, 2023 10:09 am

Sat Jul 08, 2023 10:11 am


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?

Posts: 30
Joined: Fri Jun 09, 2023 6:47 pm

Mon Jul 10, 2023 10:45 am


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
Posts: 5
Joined: Wed Sep 14, 2022 10:54 pm

Tue Jul 11, 2023 10:54 pm

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
Posts: 30
Joined: Fri Jun 09, 2023 6:47 pm

Mon Jul 17, 2023 2:47 pm


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.
Post Reply