Issue with transaction_isolation in MySQL on Metabase

1

I am experiencing an issue while connecting Metabase to my Hostinger-managed MySQL (MariaDB) database. The Metabase logs show the following error:

Unknown system variable 'transaction_isolation'

When trying to execute:
SET GLOBAL transaction_isolation = 'READ-COMMITTED';

I receive the error:

#1193 - Unknown system variable 'transaction_isolation'

After checking, I found that tx_isolation is set to READ-COMMITTED, but transaction_isolation is not recognized. It seems my hosting provider (Hostinger) does not allow modifying global system variables.

My Setup:

  • Metabase Version:0.53.7
  • Database Type: MariaDB (Managed by Hostinger)
  • Metabase Hosting: VPS (Linux)
  • Connection Method: Remote MySQL

Issues Faced:

  1. Metabase fails to execute queries due to the missing transaction_isolation variable.
  2. I cannot change the global isolation level on my Hostinger database.
  3. Metabase does not connect properly due to this limitation.

Questions:

  1. Is there a workaround to make Metabase work without modifying transaction_isolation?
  2. Can Metabase use tx_isolation instead of transaction_isolation?
  3. Is there a way to override or force an alternative transaction setting from Metabase?

I appreciate any guidance on this issue, as I need Metabase to work smoothly with my database.

2

This is deep into the mariadb driver and our query processor. Please use another MySQL or mariadb data warehouse that supports setting the transaction isolation