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. sqlsrv-upgrade-ok.png
          sqlsrv-upgrade-ok.png
          62 kB
        2. oracle upgrade.png
          oracle upgrade.png
          74 kB
        3. oracle frontend.png
          oracle frontend.png
          40 kB
        4. mssql upgrade.png
          mssql upgrade.png
          41 kB
        5. mssql frontend.png
          mssql frontend.png
          28 kB
        6. get_indexes_coverage.png
          get_indexes_coverage.png
          217 kB

        Issue Links

          blocks

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-73808 Moodle 4.0 question bank upgrade uses a lot of memory and is slow

          • 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-74138 Incorrectly defined unique key in auth/lti/upgrade.php

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          has a non-specific relationship to

          Sub-task - Issues are sometimes broken into multiple sub-tasks. MDL-19701 In PHP code generation, detect field dependencies (XMLDB-based) and provide needed code

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-74376 Unable to upgrade from 3.11 to 4.0 for Oracle db

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is a regression caused by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-63020 Work-around MS SQL and Oracle incorrect handling of unique indexes on nullable columns

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

          New Feature - A new Moodle feature which has yet to be developed. MDL-71696 Add question versions

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

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-74287 Early (web) installation steps lead to table does not exist errors

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

          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, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, Tim Hunt, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, 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