Project

General

Profile

How to use MariaDB with Redmine 5.1.2

Added by Michael Ashley 16 days ago

I am trying to install Redmine 5.1.2 on Ubuntu 24.04. The installation instructions on the wiki fail at this line:

RAILS_ENV=production bundle exec rake db:migrate

since MariaDB doesn't support the "transaction_isolation" variable:

Mysql2::Error: Unknown system variable 'transaction_isolation' (Mysql2::Error)

The "Installing Redmine" page on the wiki says that:

On Redmine < 5.1.1 MySQL 5.6 or higher and MariaDB have known issues

which implies that 5.1.1 and 5.1.2 should support MariaDB.

Any help gratefully received!
Regards,
Michael


Replies (6)

RE: How to use MariaDB with Redmine 5.1.2 - Added by Marius BĂLTEANU 15 days ago

If I'm not wrong, Ubuntu 22.04 ships MariaDB version 10.5.12 and according to the docs, the variable name in versions before 11.1.1 is tx_isolation. Can you try with this?

To determine the global and session transaction isolation levels at runtime, check the value of the tx_isolation system variable (note that the variable has been renamed transaction_isolation from MariaDB 11.1.1, to match the option, and the old name deprecated).

RE: How to use MariaDB with Redmine 5.1.2 - Added by Michael Ashley 15 days ago

Thanks for the suggestion. I'm using Ubuntu 24.04, not 22.04. MariaDB is "Ver 15.1 Distrib 10.11.7-MariaDB".

I have searched, but can't find where "transaction_isolation" appears in the part of the installation of Redmine that fails, so I don't know how to replace it with tx_isolation.

RE: How to use MariaDB with Redmine 5.1.2 - Added by Michael Ashley 14 days ago

I fixed the 'transaction_isolation' problem by upgrading to MariaDB 11.3.2 using the binary tarballs from mariadb.com.

RE: How to use MariaDB with Redmine 5.1.2 - Added by Philippe Liège 12 days ago

'tx_isolation: "READ-COMMITTED"' in database.yml does the job when using MariaDB 10.11.6 (Debian Bookworm).
I also also had to insert 'transaction-isolation=READ-COMMITTED' below [mariadb] in /etc/mysql/mariadb.conf.d/50-server.cnf. 'transaction-isolation' was renamed 'transaction_isolation' as from MariaDB 11.x.

RE: How to use MariaDB with Redmine 5.1.2 - Added by Philippe Liège 12 days ago

Philippe Liège wrote in RE: How to use MariaDB with Redmine 5.1.2:

'tx_isolation: "READ-COMMITTED"' in database.yml does the job when using MariaDB 10.11.6 (Debian Bookworm).
I also also had to insert 'transaction-isolation=READ-COMMITTED' below [mariadb] in /etc/mysql/mariadb.conf.d/50-server.cnf. 'transaction-isolation' was renamed 'transaction_isolation' as from MariaDB 11.x. No need to put READ-COMMITTED inside double quotes according to the MariaDB's help page.

RE: How to use MariaDB with Redmine 5.1.2 - Added by Leora Kreiger 3 days ago

Thank you for the suggestion, I hope my problem will also solved.

    (1-6/6)