How to use MariaDB with Redmine 5.1.2

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 3 months 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 3 months 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 2 months 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 2 months 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 2 months 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 2 months ago

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

(1-6/6)

Project

General

Profile

Redmine