On 6/15/23 12:14, Eric Wallis wrote:
My guacamole install has been working great for months until now. Any help would be very appreciated! I'm getting this in my docker log:

Attaching to guacd, guacamole
...
guacamole    | 19:03:39.399 [http-nio-8080-exec-9] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: guacamole    | ### Error querying database.  Cause: java.sql.SQLException: Unknown system variable 'transaction_isolation'
...

This is due to an incompatibility between the MySQL/MariaDB JDBC driver ("Connector/J") bundled with the "guacamole/guacamole" image and the latest version of MariaDB. See:

https://issues.apache.org/jira/browse/GUACAMOLE-1808

It seems the Docker's official MariaDB image was recently updated from 10 to 11, hence the error appearing now. I'd recommend taking a database backup and (carefully) rolling back to MariaDB 10.x.

- Mike

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to