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

Error during upgrade 3.9 to 4.0 on Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 4.0
    • 3.11.7
    • Questions, Quiz
    • MOODLE_400_STABLE
    • MOODLE_311_STABLE
    • MDL-74143_311
    • Hide

      Test Oracle upgrade (master and 311)

      1. Install a 39_STABLE with Oracle.
      2. Check out the branch you're testing (e.g. for master, "git checkout master")
      3. Run the upgrade. (Better to do in the CLI as upgrading Oracle is so slow on the browser. "php admin/cli/upgrade.php")
      4. Verify that the process ends without error.

      Test SQL*Server upgrade (optional, master only)

      1. Requirement: This test requires MDL-74138 to be integrated or another error (in auth_lti) will happen.
      2. Install a 39_STABLE with SQL*Server (e.g. if using MDK, "mdk create -n isqlsrv_39 -i -t -v 39 -r users -e sqlsrv")
      3. Upgrade it to master
      4. Verify that the process ends without error.
      Show
      Test Oracle upgrade (master and 311) Install a 39_STABLE with Oracle. Check out the branch you're testing (e.g. for master, " git checkout master ") Run the upgrade. (Better to do in the CLI as upgrading Oracle is so slow on the browser. " php admin/cli/upgrade.php ") Verify that the process ends without error. Test SQL*Server upgrade (optional, master only) Requirement: This test requires MDL-74138 to be integrated or another error (in auth_lti) will happen. Install a 39_STABLE with SQL*Server (e.g. if using MDK, " mdk create -n isqlsrv_39 -i -t -v 39 -r users -e sqlsrv ") Upgrade it to master Verify that the process ends without error.

    Description

      To replicate:

      1. Install an oracle site using MOODLE_39_STABLE (integration, weekly, whatever)
      2. Now checkout integration master (4.0 beta) and try to run the upgrade
        Expected: Upgrade completes without errors
        Actual: We see the following error:

        column "question->idnumber" cannot be modified. Dependency found with index "m_ques_catidn_uix (sys_nc00019$, idnumber)"
         
        More information about this error
         
        ×Debug info:
        Error code: ddldependencyerror
        ×Stack trace:
        line 734 of /lib/ddl/database_manager.php: ddl_dependency_exception thrown
        line 566 of /lib/ddl/database_manager.php: call to database_manager->check_field_dependencies()
        line 3969 of /lib/db/upgrade.php: call to database_manager->drop_field()
        line 1875 of /lib/upgradelib.php: call to xmldb_main_upgrade()
        line 519 of /admin/index.php: call to upgrade_core()
        

      Thanks to ilyatregubov for also confirming this one.

      Attachments

        1. get_indexes_coverage.png
          217 kB
          Eloy Lafuente (stronk7)
        2. mssql frontend.png
          28 kB
          Angelia Dela Cruz
        3. mssql upgrade.png
          41 kB
          Angelia Dela Cruz
        4. oracle frontend.png
          40 kB
          Angelia Dela Cruz
        5. oracle upgrade.png
          74 kB
          Angelia Dela Cruz
        6. sqlsrv-upgrade-ok.png
          62 kB
          Eloy Lafuente (stronk7)

        Issue Links

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              jaked Jake Dallimore
              Tim Hunt Tim Hunt
              Jun Pataleta Jun Pataleta
              Angelia Dela Cruz Angelia Dela Cruz
              Safat Shahin, Tim Hunt, Amaia Anabitarte, Bas Brands, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Kevin Percy, Laurent David, Mathew May, Mihail Geshoski, Raquel Ortega, Sabina Abellan, Sander Bangma, Sara Arjona (@sarjona), Shamim Rezaie, Tim Hunt, Amaia Anabitarte, Bas Brands, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Kevin Percy, Laurent David, Mathew May, Mihail Geshoski, Raquel Ortega, Sabina Abellan, Sander Bangma, Sara Arjona (@sarjona), Shamim Rezaie
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9/May/22

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours, 45 minutes
                  4h 45m