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

(ORA) errors with database upgrading from 1.7(.1) to 1.8(.2)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 1.7.1, 1.8.2
    • 1.8.3
    • None
    • Solaris 10,
      Oracle 10,
      Firefox 2.0.0.2,
      Developer messages on
    • Oracle
    • MOODLE_17_STABLE, MOODLE_18_STABLE
    • MOODLE_18_STABLE

    Description

      Hey Eloy,
      are you back to normal business?

      I would like to upgrade our moodle site from 1.7.1 to 1.8.2 and did a first quick test
      I encountered some issues with the upgrading of the database structures.
      Right on the first upgrade step seems to be a problem with some "context creations".
      There were many more errors like that, but with different levels and instances...

      Snippet no. 1:
      Processing context relations (125/127)
      Error: Invalid context creation request for level "80", instance "3".

      • line 3877 of lib/accesslib.php: call to debugging()
      • line 3918 of lib/accesslib.php: call to insert_context_rel()
      • line 527 of lib/db/upgrade.php: call to build_context_rel()
      • line 322 of admin/index.php: call to xmldb_main_upgrade()

      Error: Invalid context creation request for level "80", instance "4".

      • line 3877 of lib/accesslib.php: call to debugging()
      • line 3918 of lib/accesslib.php: call to insert_context_rel()
      • line 527 of lib/db/upgrade.php: call to build_context_rel()
      • line 322 of admin/index.php: call to xmldb_main_upgrade()

      ----------------------------------------------------------------------------------------------------------------------------------------------

      Then at a later step, I did get some ORA errors (ORA-01400: cannot insert NULL into...) apparently coming from some of our group stuff:

      Snippet No.2
      upgrading database
      group

      (oci8po): SELECT * FROM m_groups_members_temp

      stdClass Object
      (
      [courseid] => 2
      [name] => Gruppe A
      [description] =>
      [password] =>
      [lang] => de
      [theme] =>
      [picture] => 0
      [hidepicture] => 0
      [timecreated] => 1133178615
      [timemodified] => 1134986852
      [id] => 1
      )

      (oci8po): INSERT INTO m_groups (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified) VALUES ('1','Gruppe A','', '','de', '','0','0', '1133178615','1134986852')
      Warning: ociexecute() [function.ociexecute]: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich in /moodle/apache/2.2.4/htdocs/moodle182/lib/adodb/drivers/adodb-oci8.inc.php on line 1017
      1400: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich

      ADOConnection._Execute(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ..., false) % line 769, file: adodb-oci8.inc.php
      ADODB_oci8.Execute(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ...) % line 89, file: dmllib.php
      execute_sql(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ...) % line 331, file: dbbasicgrouplib.php
      groups_db_upgrade_group(2, Object:stdClass) % line 155, file: upgrade.php
      groups_transfer_db() % line 39, file: upgrade.php

      ErrorScroll to next warning

      stdClass Object
      (
      [courseid] => 2
      [name] => Gruppe E
      [description] =>
      [password] =>
      [lang] => de
      [theme] =>
      [picture] => 0
      [hidepicture] => 0
      [timecreated] => 1133718608
      [timemodified] => 1136324634
      [id] => 2
      )

      (oci8po): INSERT INTO m_groups (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified) VALUES ('2','Gruppe E','', '','de', '','0','0', '1133718608','1136324634')
      Warning: ociexecute() [function.ociexecute]: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich in /moodle/apache/2.2.4/htdocs/moodle182/lib/adodb/drivers/adodb-oci8.inc.php on line 1017
      1400: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich

      ADOConnection._Execute(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ..., false) % line 769, file: adodb-oci8.inc.php
      ADODB_oci8.Execute(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ...) % line 89, file: dmllib.php
      execute_sql(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ...) % line 331, file: dbbasicgrouplib.php
      groups_db_upgrade_group(2, Object:stdClass) % line 155, file: upgrade.php
      groups_transfer_db() % line 39, file: upgrade.php

      Scroll to previous warningErrorScroll to next warning

      stdClass Object
      (
      [courseid] => 2
      [name] => Gruppe B
      [description] =>
      [password] =>
      [lang] => de
      [theme] =>
      [picture] => 0
      [hidepicture] => 0
      [timecreated] => 1133718615
      [timemodified] => 1134564997
      [id] => 3
      )

      (oci8po): INSERT INTO m_groups (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified) VALUES ('3','Gruppe B','', '','de', '','0','0', '1133718615','1134564997')
      Warning: ociexecute() [function.ociexecute]: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich in /moodle/apache/2.2.4/htdocs/moodle182/lib/adodb/drivers/adodb-oci8.inc.php on line 1017
      1400: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich

      ADOConnection._Execute(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ..., false) % line 769, file: adodb-oci8.inc.php
      ADODB_oci8.Execute(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ...) % line 89, file: dmllib.php
      execute_sql(INSERT INTO m_groups
      (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
      ...) % line 331, file: dbbasicgrouplib.php
      groups_db_upgrade_group(2, Object:stdClass) % line 155, file: upgrade.php
      groups_transfer_db() % line 39, file: upgrade.php

      Scroll to previous warningErrorScroll to next warning

      stdClass Object
      (
      [courseid] => 2
      [name] => Gruppe C
      [description] =>
      [password] =>
      [lang] => de
      [theme] =>
      [picture] => 0
      [hidepicture] => 0
      [timecreated] => 1133718622
      [timemodified] => 1135953543
      [id] => 4
      )

      I will test the upgrading a bit more in the coming weeks with a bigger database

      Attachments

        Issue Links

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              protzek D P
              Nobody Nobody
              Amaia Anabitarte, Carlos Escobedo, Laurent David, Sabina Abellan, Sara Arjona (@sarjona), David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                11/Oct/07