Issue with Unimus and MariaDB/MySQL

General discussion of anything Unimus
Post Reply
jpsimmonds
Posts: 5
Joined: Wed Sep 14, 2022 10:54 pm

Tue Jul 11, 2023 10:53 pm

Not putting this under support, as well its a resolution, not a support request. I have logged this as a support ticket for direct correspondence with the team but this is what has been discovered

When connecting to a MariaDB 11 (not sure of the equivalent MySQL version), the java connector cannot connect and returns the following error.

2023-07-12 08:34:03.110 ERROR 12 --- [cTaskExecutor-1] .s.b.b.s.DatabaseConnectionCheckBootStep : Database 'MysqlConfig{host='MariaDB', port='3306', database
ed exception is java.sql.SQLException: Unknown system variable 'transaction_isolation''

on the MariaDB side, it shows as

2023-07-11 22:34:03 3 [Warning] Aborted connection 3 to db: 'unimus' user: 'unimus_user' host: '172.23.0.3' (Got an error reading communication packets)

This is utilising docker, so I have been able to confirm that changing the docker container for MariaDB from latest (or untagged) to 10 the connection works fine, but forcing it to 11 or latest which is now 11, breaks the connection. reverting back to 10 fixes it again
dominik.c
Posts: 33
Joined: Fri Jun 09, 2023 6:47 pm

Mon Jul 17, 2023 2:45 pm

Hello,
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.
irrwitzer
Posts: 1
Joined: Thu Jul 20, 2023 4:02 pm

Thu Jul 20, 2023 4:05 pm

jpsimmonds wrote:
Tue Jul 11, 2023 10:53 pm
Not putting this under support, as well its a resolution, not a support request. I have logged this as a support ticket for direct correspondence with the team but this is what has been discovered
[...]This is utilising docker, so I have been able to confirm that changing the docker container for MariaDB from latest (or untagged) to 10 the connection works fine, but forcing it to 11 or latest which is now 11, breaks the connection. reverting back to 10 fixes it again
Thank you so much @jpsimmonds for sharing this solution. Saved me a lot of time....
Thanks!
Post Reply