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

Messaging upgrade breaks the moodle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.6.1
    • Fix Version/s: None
    • Component/s: Messages
    • Affected Branches:
      MOODLE_36_STABLE

      Description

      Upgrade savepoint 2018092800.00 throws an SQL error:

       

      -[ RECORD 1 ]-+------------------------------------------------------------------------------------------------------------------
      id            | 10415
      type          | 0
      plugin        | core
      version       | 2018092100.02
      targetversion | 2018120301
      info          | Upgrade savepoint reached
      details       | 
      backtrace     | 
      userid        | 0
      timemodified  | 1545218046
      -[ RECORD 2 ]-+------------------------------------------------------------------------------------------------------------------
      id            | 10416
      type          | 0
      plugin        | core
      version       | 2018092100.03
      targetversion | 2018120301
      info          | Upgrade savepoint reached
      details       | 
      backtrace     | 
      userid        | 0
      timemodified  | 1545218046
      -[ RECORD 3 ]-+------------------------------------------------------------------------------------------------------------------
      id            | 10417
      type          | 0
      plugin        | core
      version       | 2018092100.04
      targetversion | 2018120301
      info          | Upgrade savepoint reached
      details       | 
      backtrace     | 
      userid        | 0
      timemodified  | 1545218046
      -[ RECORD 4 ]-+------------------------------------------------------------------------------------------------------------------
      id            | 10418
      type          | 2
      plugin        | core
      version       | 2018092100.04
      targetversion | 2018120301
      info          | Exception: ddl_dependency_exception
      details       | column "message_contacts->userid" cannot be modified. Dependency found with index "m_messcont_use_ix (userid)"
      backtrace     | * line 732 of /lib/ddl/database_manager.php: ddl_dependency_exception thrown                                     +
                    | * line 652 of /lib/ddl/database_manager.php: call to database_manager->check_field_dependencies()                +
                    | * line 2399 of /lib/db/upgrade.php: call to database_manager->change_field_default()                             +
                    | * line 1798 of /lib/upgradelib.php: call to xmldb_main_upgrade()                                                 +
                    | * line 180 of /admin/cli/upgrade.php: call to upgrade_core()                                                     +
                    | 
      userid        | 0
      timemodified  | 1545218047 

       

       

      After checking the DB, i can see it gets all the way up to creating the 'timecreated' field, and the new table 'message_contact_requests' does not exist.

       

      After this upgrade failure /admin/cli/upgrade.php reports there are no more upgrades needed so we cannot try again however the web interface is stuck on an infinite loop to /admin/index.php because is_major_upgrade_required() is triggering

      No upgrade needed for the installed version 3.6.1 (Build: 20181205) (2018120301). Thanks for coming anyway! 

       

      $CFG->version is at 2018092100.04

      $CFG->allversionshash is at 79ff38d59f8eeffb88f78c00d4044308c8881b0d

       

       

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: