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
[Fixed in 2.4.2] switched to mariadb / transaction_isolation
-
- Posts: 5
- Joined: Wed Sep 14, 2022 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
TLDR; use MariaDB 10 not 11 easy enough in docker but do not know your infrastructure
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.
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.