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

Oracle, Identifier is too long when importing/backup&restore courses

    XMLWordPrintable

    Details

    • Database:
      Oracle
    • Affected Branches:
      MOODLE_20_STABLE, MOODLE_24_STABLE, MOODLE_25_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE, MOODLE_25_STABLE
    • Sprint:
      BACKEND Sprint 7

      Description

      Today, I was trying to backup and restore a course (about 174M), I ran into the following error message. When I imported the course, the same thing happened.

      This is pretty urgent, so, I am wondering if I can just block the "CREATE INDEX" statement, so that I can continue the restore process. Thanks.

      [Tue Aug 23 11:10:39 2011] [error] [client 128.119.103.2] Default exception handler:
      DDL sql execution error Debug: ORA-00972: identifier is too long\n
      CREATE INDEX m_backfiletemp_bacconcomfi10_ix ON m_01aa45cf00012 (backupid, contextid, component, filearea, itemid)\n*
      line 397 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown\n*
      line 268 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()\n*
      line 855 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()\n*
      line 88 of /lib/ddl/database_manager.php: call to oci_native_moodle_database->change_database_structure()\n*
      line 75 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()\n*
      line 499 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()\n*
      line 141 of /backup/util/dbops/backup_controller_dbops.class.php: call to database_manager->create_temp_table()\n*
      line 97 of /backup/util/dbops/restore_controller_dbops.class.php: call to backup_controller_dbops::create_temptable_from_real_table()\n*
      line 72 of /backup/util/helper/restore_prechecks_helper.class.php: call to restore_controller_dbops::create_restore_temp_tables()\n*
      line 322 of /backup/controller/restore_controller.class.php: call to restore_prechecks_helper::execute_prechecks()\n*
      line 603 of /backup/util/ui/restore_ui_stage.class.php: call to restore_controller->execute_precheck()\n*
      line 251 of /backup/util/ui/restore_ui.class.php: call to restore_ui_stage_process->process()\n*
      line 38 of /backup/restore.php: call to restore_ui->requires_substage()\n
      , referer: https://moodle.umass.edu/backup/restore.php

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                13/Jan/14