Loading...

XML

Word

Printable

Type: Bug
Resolution: Fixed
Priority: Critical
Fix Version/s: 5.0.2, 4.5.6, 4.4.10, 4.1.20
Affects Version/s: 5.0, 4.5.6, 4.4.10, 4.1.20
Component/s: Database SQL/XMLDB
Labels:

Database:

MySQL
Affected Branches:
MOODLE_401_STABLE, MOODLE_404_STABLE, MOODLE_405_STABLE, MOODLE_500_STABLE
Fixed Branches:
MOODLE_401_STABLE, MOODLE_404_STABLE, MOODLE_405_STABLE, MOODLE_500_STABLE
Pull from Repository:
https://github.com/meirzamoodle/moodle.git
Pull 4.1 Branch:
~~MDL-85316~~-401-mysql-version
Pull 4.1 Diff URL:
https://github.com/meirzamoodle/moodle/compare/a0a0458154...MDL-85316-401-mysql-version
Pull 4.4 Branch:
~~MDL-85316~~-404-mysql-version
Pull 4.4 Diff URL:
https://github.com/meirzamoodle/moodle/compare/662befa64e...MDL-85316-404-mysql-version
Pull 4.5 Branch:
~~MDL-85316~~-405-mysql-version
Pull 4.5 Diff URL:
https://github.com/meirzamoodle/moodle/compare/812ef23c00...MDL-85316-405-mysql-version
Pull 5.0 Branch:
~~MDL-85316~~-500-mysql-version
Pull 5.0 Diff URL:
https://github.com/meirzamoodle/moodle/compare/ffb6475f6a...MDL-85316-500-mysql-version
Pull Main Branch:
~~MDL-85316~~-main-mysql-version
Pull Main Diff URL:
https://github.com/meirzamoodle/moodle/compare/9223e346c3...MDL-85316-main-mysql-version
Workaround:

Hide

Hack environment.xml

Just use Postgres

Show
Hack environment.xml Just use Postgres
Documentation link:
https://github.com/moodle/devdocs/pull/1368
Testing Instructions:
Hide

1. Setup

Create an Aurora (MySQL compatible) database engine in AWS, ensuring compatibility with version 8.0.39. Ping Huong for the testing credentials.

Test 1

Create previous weekly release of 4.1, 4.4, 4.5, 5.0 instances (Do not install them).

Create an Aurora (MySQL compatible) database engine in AWS, ensuring compatibility with version 8.0.39

Install Moodle instance with auroramysql along with the necessary credentials from the Setup.

Checkout to the latest integration.git code.

Login as admin with username/password is admin/test.

Navigate to Site administration / Server / Environment.

Select 5.0 in the Moodle version select box.

Verify that you will see Aurora compatibility in the Other checks section.

Verify that the Status column value is Check.

Repeat steps 8 and 9 with 5.1 in the Moodle version select box.

Test 2

Create previous weekly release 4.1, 4.4, 4.5, 5.0 (Do not install them).

Create an Aurora (MySQL compatible) database engine in AWS, ensuring compatibility with version 8.0.39

Install Moodle instance with auroramysql along with the necessary credentials from the Setup.

Check out to 5.0 branch. (Except for 5.0 instance)

Run the upgrade

VERIFY that the upgrade runs well and there is no error.

Repeat the steps from 1 to 6, but change to main branch in step 4.
Show
1. Setup Create an Aurora (MySQL compatible) database engine in AWS, ensuring compatibility with version 8.0.39. Ping Huong for the testing credentials. Test 1 Create previous weekly release of 4.1, 4.4, 4.5, 5.0 instances (Do not install them). Create an Aurora (MySQL compatible) database engine in AWS, ensuring compatibility with version 8.0.39 Install Moodle instance with auroramysql along with the necessary credentials from the Setup. Checkout to the latest integration.git code. Login as admin with username/password is admin/test. Navigate to Site administration / Server / Environment. Select 5.0 in the Moodle version select box. Verify that you will see Aurora compatibility in the Other checks section. Verify that the Status column value is Check . Repeat steps 8 and 9 with 5.1 in the Moodle version select box. Test 2 Create previous weekly release 4.1, 4.4, 4.5, 5.0 (Do not install them). Create an Aurora (MySQL compatible) database engine in AWS, ensuring compatibility with version 8.0.39 Install Moodle instance with auroramysql along with the necessary credentials from the Setup. Check out to 5.0 branch. (Except for 5.0 instance) Run the upgrade VERIFY that the upgrade runs well and there is no error. Repeat the steps from 1 to 6, but change to main branch in step 4.
Pre-check results:
Hide

Code verified against automated checks.

Checked ~~MDL-85316~~ using repository: https://github.com/meirzamoodle/moodle.git

MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-85316-405-mysql-version | CI Job]

MOODLE_500_STABLE (0 errors / 0 warnings) [branch: MDL-85316-500-mysql-version | CI Job]

main (0 errors / 0 warnings) [branch: MDL-85316-main-mysql-version | CI Job]

_{More information about this report}

Built on: Thu Jun 5 05:48:16 UTC 2025
Show
Code verified against automated checks. Checked MDL-85316 using repository: https://github.com/meirzamoodle/moodle.git MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-85316-405-mysql-version | CI Job ] MOODLE_500_STABLE (0 errors / 0 warnings) [branch: MDL-85316-500-mysql-version | CI Job ] main (0 errors / 0 warnings) [branch: MDL-85316-main-mysql-version | CI Job ] More information about this report Built on: Thu Jun 5 05:48:16 UTC 2025
Automated test results:
Hide

Launching automatic jobs for branch ~~MDL-85316~~-405-mysql-version

https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/19601/ PHPUnit (sqlsrv)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67027/ Behat (NonJS - boost and classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67028/ Behat (Firefox - boost)

Launching automatic jobs for branch ~~MDL-85316~~-500-mysql-version

https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/19602/ PHPUnit (sqlsrv)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67029/ Behat (NonJS - boost and classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67030/ Behat (Firefox - boost)

Launching automatic jobs for branch ~~MDL-85316~~-main-mysql-version

https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/19603/ PHPUnit (sqlsrv)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67031/ Behat (NonJS - boost and classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67032/ Behat (Firefox - boost)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67033/ Behat (Firefox - classic)

https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67034/ App tests (stable app version)

Built on: Thu Jun 5 06:25:21 UTC 2025
Show
Launching automatic jobs for branch MDL-85316 -405-mysql-version https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/19601/ PHPUnit (sqlsrv) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67027/ Behat (NonJS - boost and classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67028/ Behat (Firefox - boost) Launching automatic jobs for branch MDL-85316 -500-mysql-version https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/19602/ PHPUnit (sqlsrv) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67029/ Behat (NonJS - boost and classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67030/ Behat (Firefox - boost) Launching automatic jobs for branch MDL-85316 -main-mysql-version https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/19603/ PHPUnit (sqlsrv) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67031/ Behat (NonJS - boost and classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67032/ Behat (Firefox - boost) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67033/ Behat (Firefox - classic) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/67034/ App tests (stable app version) Built on: Thu Jun 5 06:25:21 UTC 2025

Story Points:
6
Sprint:
Team Hedgehogs 2025 Sprint 2.1, Team Hedgehogs 2025 Sprint 2.2

Background

AWS Aurora is Amazon's highly scalable and highly available SQL DB service. It used by mainly organisations to host their Moodle LMS instances. Essentially it is a fork of the community versions of MySQL and Postgres (both engines are available). AWS then essentially adds their own patches (security etc).

For the most part Aurora is feature compatible with the community version of the database engine (either MySQL or Postgres).

In LMS 3.10 (~~MDL-58931~~) explicit support was added for Aurora MySQL. This is essentially a thin wrapper around the existing MySQL drivers. This allowed auroramysql to by set as the dbtype in config.php and fixed some compatibility issues that were present at the time. The code has not changed much since then.

Historically, AWS have been slow to update the major version of MySQL used by Aurora, instead they have tended to backport patches. They do upgrade the major version eventually.

Problem

In LMS 5.0 the minimum version of MySQL required was upped from 8.0 to 8.4 (see ~~MDL-83470~~), this was due to the impending EOL for MySQL 8.0 (as part of the LMS lifecycle) and that 8.4 has been released for more than 12 months.

However, AWS Aurora only supports at a maximum MySQL 8.0.39.
See: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.release-calendars.html

This means that anyone using AWS Aurora MySQL cannot install or upgrade currently to LMS 5.0, without hacking the environment.xml file or changing to Postgres.

Proposed Solution

Update the support introduced ~~MDL-58931~~ to allow AWS Aurora with a minimum version of 3 for LMS 5.0

This will also require including this in the LMS requirements policy going forward.

Update documentation etc. that for organisations using AWS Aurora MySQL to explicitly set the dbtype in config.php to auroramysql

More info:

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List
  - Download All

MDL-85316_engine_version.png
27/May/25 5:23 AM
86 kB
Meirza
MDL-85316_new_checks.png
03/Jun/25 5:57 PM
586 kB
Meirza
MDL-85316_401_test1_step10.png
13/Jun/25 4:08 AM
428 kB
Raquel Ortega
MDL-85316_401_test1_step8-9.png
13/Jun/25 4:08 AM
420 kB
Raquel Ortega
MDL-85316_401_test2_step6.png
13/Jun/25 4:08 AM
400 kB
Raquel Ortega
MDL-85316_401_test2_step7.png
13/Jun/25 4:08 AM
404 kB
Raquel Ortega
MDL-85316_404_test1_step10.png
13/Jun/25 4:08 AM
378 kB
Raquel Ortega
MDL-85316_404_test1_step8-9.png
13/Jun/25 4:08 AM
364 kB
Raquel Ortega
MDL-85316_404_test2_step6.png
13/Jun/25 4:08 AM
369 kB
Raquel Ortega
MDL-85316_404_test2_step7.png
13/Jun/25 4:08 AM
373 kB
Raquel Ortega
MDL-85316_405_test1_step10.png
13/Jun/25 4:08 AM
378 kB
Raquel Ortega
MDL-85316_405_test1_step8-9.png
13/Jun/25 4:08 AM
365 kB
Raquel Ortega
MDL-85316_405_test2_step6.png
13/Jun/25 4:08 AM
369 kB
Raquel Ortega
MDL-85316_405_test2_step7.png
13/Jun/25 4:08 AM
373 kB
Raquel Ortega
MDL-85316_500_test1_step10.png
13/Jun/25 4:08 AM
372 kB
Raquel Ortega
MDL-85316_500_test2_step7.png
13/Jun/25 4:08 AM
364 kB
Raquel Ortega
MDL-85316_main_Installation.png
13/Jun/25 4:08 AM
393 kB
Raquel Ortega

has a non-specific relationship to

MDL-58931 AWS Aurora MySQL support for Moodle

Closed

is a regression caused by

MDL-83470 Decide Moodle 5.0 requirements and push them to environment.xml (due date: 15 Nov 2024)

Closed

Assignee:: Meirza

Reporter:: Matt Porritt

Peer reviewer:: Stevani Andolo

Integrator:: Huong Nguyen

Tester:: Raquel Ortega

Participants:: CiBoT, Huong Nguyen, Matt Porritt, Meirza, Michael Hawkins, Raquel Ortega, Stevani Andolo

Votes:: 6 Vote for this issue

Watchers:: 11 Start watching this issue

Created:: 30/Apr/25 8:30 AM

Updated:: 13/Jun/25 6:15 PM

Resolved:: 13/Jun/25 4:00 PM

Estimated:

Remaining:

Logged:

4d 4h 46m

Details

1. Setup

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Time Tracking

Clockify