Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-61702

Can't install Moodle version > 3.1 with mariaDB version >= 10.3.1

    XMLWordPrintable

Details

    • MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE, MOODLE_36_STABLE
    • MOODLE_33_STABLE, MOODLE_34_STABLE, MOODLE_35_STABLE
    • m36_MDL-61702_MariaDB_InnoDB10d3d1_Params_Removed
    • Hide

      Functional Tests

      1. get latest moodle release version
      2. install mariadb version> 10.3.1 e.g. the first GA (2018-05-25), 10.3.7
      3. start installation process
      4. set the database configuration to mariadb
      5. verify that you pass the requirement check page

      Unit Tests

      • vendor/bin/phpunit core_ddl_testcase lib/ddl/tests/ddl_test.php
      • vendor/bin/phpunit core_dml_testcase lib/dml/tests/dml_test.php

      Regression Tests

      Repeat the tests above with the following MySQL and MariaDB versions:

      • MySQL 5.7.22
      • MySQL 8.0.3
      • MariaDB 10.2.15
      Show
      Functional Tests get latest moodle release version install mariadb version> 10.3.1 e.g. the first GA ( 2018-05-25 ), 10.3.7 start installation process set the database configuration to mariadb verify that you pass the requirement check page Unit Tests vendor/bin/phpunit core_ddl_testcase lib/ddl/tests/ddl_test.php vendor/bin/phpunit core_dml_testcase lib/dml/tests/dml_test.php Regression Tests Repeat the tests above with the following MySQL and MariaDB versions: MySQL 5.7.22 MySQL 8.0.3 MariaDB 10.2.15

    Description

      According to mariadb documentation (https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-103/#system-variables) in version 10.3.1 the global variables innodb_file_format, innodb_file_format_check, innodb_file_format_max and innodb_large_prefix was removed. See removal dates here

      .during installation of moodle > 3.1 installation innodb_file_format and innodb_large_prefix are required in mariadb/mysql installation and need to be set (see ----MDL-48228---- (https://tracker.moodle.org/browse/MDL-48228)), so the installation can't completed.

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-48228 MySQL drivers only use partial UTF-8

          • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-51080 upgrading on OS where mysql changed to mariadb does not give useful advice

          • Major - Major loss of function, incorrect output
          • Closed

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-59099 Row format options removed

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-59596 Unit test failure with MariaDB/MySQL8

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              matteo Matteo Scaramuccia
              avimoto Avi Levy
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Andrew Lyons Andrew Lyons
              Andrew Lyons Andrew Lyons
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              13 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/Jul/18