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

Question upgrade failure in Oracle and SQL Server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.5.2
    • Fix Version/s: 3.5.3
    • Component/s: Questions
    • Labels:
    • Database:
      Microsoft SQL, Oracle
    • Testing Instructions:
      Hide

      Note: Test on PostgreSQL, SQL Server and Oracle.

      1. Open your terminal and go to your Moodle instance's root folder.
      2. Checkout Moodle 3.4.5:

        git checkout  v3.4.5
        

      3. Install your Moodle instance.
        • For other databases, if you have MDK,

          mdk install -e [DBENGINE]
          

          Where "[DBENGINE]" can be either "pgsql" (for PostgreSQL) or "sqlsrv" for (SQL Server)

        • For Oracle, since MDK doesn't support Oracle yet, you'll have to install manually, probably better to do this on the web browser.
      4. Checkout the latest Moodle codebase with this patch applied:
        • For master

          git checkout master
          

        • For 3.5

          git checkout MOODLE_35_STABLE
          

      5. Run an upgrade:

         php admin/cli/upgrade.php --non-interactive --allow-unstable
        

      6. Confirm that the upgrade process completes successfully and that you don't get any error messages.
      Show
      Note: Test on PostgreSQL, SQL Server and Oracle. Open your terminal and go to your Moodle instance's root folder. Checkout Moodle 3.4.5: git checkout v3.4.5 Install your Moodle instance. For other databases, if you have MDK, mdk install -e [DBENGINE] Where " [DBENGINE] " can be either " pgsql " (for PostgreSQL) or " sqlsrv " for (SQL Server) For Oracle, since MDK doesn't support Oracle yet, you'll have to install manually, probably better to do this on the web browser. Checkout the latest Moodle codebase with this patch applied: For master git checkout master For 3.5 git checkout MOODLE_35_STABLE Run an upgrade: php admin/cli/upgrade.php --non-interactive --allow-unstable Confirm that the upgrade process completes successfully and that you don't get any error messages.
    • Affected Branches:
      MOODLE_35_STABLE
    • Fixed Branches:
      MOODLE_35_STABLE
    • Pull 3.5 Branch:
    • Pull Master Branch:
      MDL-63493-master

      Description

      To reproduce:

      1. Have a Moodle installation before the patch in MDL-62708 landed.
      2. Upgrade to the latest Moodle version.
      3. Expected: Upgrade will continue successfully.
      4. Actual: Upgrade fails with the error below.

      Weird, I didn't encounter this on PostgreSQL. I encountered this on Oracle.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  12/Nov/18