Project

General

Profile

Actions

Feature #35014

closed

Review and update supported database engines and versions

Added by Marius BĂLTEANU almost 3 years ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Category:
Database
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed

Description

Supported database engines and versions were not been updated for a while and we should do it in Redmine 6.0.0.

Redmine version Supported Ruby versions Rails version used Recommended Databases
PostgreSQL MySQL MSSQL SQLite
trunk (>= r22053) 2.7, 3.0, 3.1, 3.2 Rails 6.1 14 8.0 - 8.1 >2012 3
5.1 2.7, 3.0, 3.1, 3.2 Rails 6.1 >9.2 5.7 - 8.1 >2012 3
5.0 Ruby 2.51, 2.61, 2.7, 3.0, 3.1 Rails 6.1 >9.2 5.7 - 5.7 >2012 3
4.2 Ruby 2.41, 2.51, 2.6, 2.72 Rails 5.2 >9.2 5.5 - 5.7 >2012 3

Related issues

Related to Redmine - Defect #39437: MySQL / MariaDB issue nested set deadlocks and consistencyClosedMarius BĂLTEANU

Actions
Actions #1

Updated by Marius BĂLTEANU almost 3 years ago

Tests pass on MySQL 8, but issue_nested_set_concurrency_test still fails:

➜  redmine git:(feature/postgresql-13) ✗ ruby test/unit/issue_nested_set_concurrency_test.rb
Run options: --seed 4055

# Running:

.F

Failure:
IssueNestedSetConcurrencyTest#test_concurrency [test/unit/issue_nested_set_concurrency_test.rb:48]:
Expected "Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction" to be nil.

rails test test/unit/issue_nested_set_concurrency_test.rb:41

Anyway, considering that MySQL 5.7 is used on CI, my proposal regarding to MySQL is to update the documentation and mention that we test Redmine against MySQL 5.7 (#17460) and 8 and drop MySQL 5.5 (#30419) and MySQL 5.6.

What do you think?

Actions #2

Updated by Marius BĂLTEANU almost 2 years ago

  • Target version changed from 5.0.0 to Candidate for next major release
Actions #3

Updated by Go MAEDA 5 months ago

  • Related to Defect #39437: MySQL / MariaDB issue nested set deadlocks and consistency added
Actions #4

Updated by Marius BĂLTEANU 4 months ago

  • Target version changed from Candidate for next major release to 6.0.0
Actions #5

Updated by Marius BĂLTEANU 4 months ago

  • Description updated (diff)
Actions #6

Updated by Marius BĂLTEANU 4 months ago

  • Description updated (diff)

I propose to merge the Ruby interpreter and Supported database back-ends from RedmineInstall in a table like the one from the description and have all the importance notices under it, including footnotes.

Also, I think we should a column with end of support for each Redmine version.

What do you think?

P.S. The table is update based on the changes made by Jean-Philippe on Continuous_integration matrix.

Actions #7

Updated by Marius BĂLTEANU 4 months ago

  • Description updated (diff)
Actions #8

Updated by Marius BĂLTEANU 3 months ago

  • Status changed from New to Closed
  • Resolution set to Fixed

All the changes have been made in RedmineInstall as part of #39437#note-16.

Actions

Also available in: Atom PDF