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

Missing Env check for InnoDB table format Barracuda

XMLWordPrintable

    • MySQL
    • MOODLE_28_STABLE
    • MOODLE_27_STABLE, MOODLE_28_STABLE
    • MDL-46963-master
    • Hide
      1. Set-up a moodle instance to use MySQL as database.
      2. Run the CLI script on the terminal to list tables that need fixing: 

        php admin/cli/mysql_compressed_rows.php -l

        By default, I've run the conversion script and it found 6 tables to be fixed.
        If it doesn't return anything, change the Row Format to Compact of a table (mdl_enrol_paypal) for example.

      3. In your moodle instance using MySQL, go to: Site Administration > Server > Environment.
      4. Look on Other checks section and make sure you get the message:

        Your database has tables using Antelope as file format. You are recommended to convert the tables to Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda.

      5. Return to the terminal, run the command: 

        php admin/cli/mysql_compressed_rows.php -f

      6. Reload the environment check page, and make sure the warning is no longer displayed.
      Show
      Set-up a moodle instance to use MySQL as database. Run the CLI script on the terminal to list tables that need fixing: php admin/cli/mysql_compressed_rows.php -l By default, I've run the conversion script and it found 6 tables to be fixed. If it doesn't return anything, change the Row Format to Compact of a table (mdl_enrol_paypal) for example. In your moodle instance using MySQL, go to: Site Administration > Server > Environment. Look on Other checks section and make sure you get the message: Your database has tables using Antelope as file format. You are recommended to convert the tables to Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda. Return to the terminal, run the command: php admin/cli/mysql_compressed_rows.php -f Reload the environment check page, and make sure the warning is no longer displayed.
    • Team '; drop tables Sprint 5, Team '; drop tables Sprint 6
    • Small

      See MDL-46235 for details, but the default InnoDB table format (Antelope) has bugs and should be changed to Barracuda to avoid random moodle bugs. We added a cli script to do the conversions, but we need to add an environment check to force admins to alter their default table formats. Otherwise newly created tables will be created with the wrong format even after they have run the cli script (after a DB reboot).

            lameze Simey Lameze
            damyon Damyon Wiese
            Mark Nelson Mark Nelson
            David Monllaó David Monllaó
            Rajesh Taneja Rajesh Taneja
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.