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

Oracle reports phpunit errors sometime after 95% (only when running the whole suite)

    XMLWordPrintable

    Details

      Description

      1) tool_uploadcourse_course_testcase::test_restore_course
      ddl_change_structure_exception: DDL sql execution error (ORA-00942: table or view does not exist
      TRUNCATE TABLE l00246ecd0001110)

      /server/workspace/moodle/lib/dml/moodle_database.php:442
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:271
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:905
      /server/workspace/moodle/lib/ddl/database_manager.php:88
      /server/workspace/moodle/lib/ddl/database_manager.php:77
      /server/workspace/moodle/lib/ddl/database_manager.php:331
      /server/workspace/moodle/lib/testing/classes/util.php:568
      /server/workspace/moodle/lib/phpunit/classes/util.php:119
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:86

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_course_testcase admin/tool/uploadcourse/tests/course_test.php

      2) tool_uploadcourse_course_testcase::test_restore_file
      ddl_change_structure_exception: DDL sql execution error (ORA-00942: table or view does not exist
      TRUNCATE TABLE l00246ecd0001111)

      /server/workspace/moodle/lib/dml/moodle_database.php:442
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:271
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:905
      /server/workspace/moodle/lib/ddl/database_manager.php:88
      /server/workspace/moodle/lib/ddl/database_manager.php:77
      /server/workspace/moodle/lib/ddl/database_manager.php:331
      /server/workspace/moodle/lib/testing/classes/util.php:568
      /server/workspace/moodle/lib/phpunit/classes/util.php:119
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:86

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_course_testcase admin/tool/uploadcourse/tests/course_test.php

      3) tool_uploadcourse_course_testcase::test_reset
      ddl_change_structure_exception: DDL sql execution error (ORA-00942: table or view does not exist
      TRUNCATE TABLE l00246ecd0001112)

      /server/workspace/moodle/lib/dml/moodle_database.php:442
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:271
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:905
      /server/workspace/moodle/lib/ddl/database_manager.php:88
      /server/workspace/moodle/lib/ddl/database_manager.php:77
      /server/workspace/moodle/lib/ddl/database_manager.php:331
      /server/workspace/moodle/lib/testing/classes/util.php:568
      /server/workspace/moodle/lib/phpunit/classes/util.php:119
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:86

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_course_testcase admin/tool/uploadcourse/tests/course_test.php

      4) tool_uploadcourse_course_testcase::test_create_bad_category
      Warning: max_execution_time was changed to 3600

      /server/workspace/moodle/lib/phpunit/classes/util.php:241
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:100

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_course_testcase admin/tool/uploadcourse/tests/course_test.php

      5) tool_uploadcourse_processor_testcase::test_restore_template_course
      ddl_change_structure_exception: DDL sql execution error (ORA-00942: table or view does not exist
      TRUNCATE TABLE l00246ecd0001118)

      /server/workspace/moodle/lib/dml/moodle_database.php:442
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:271
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:905
      /server/workspace/moodle/lib/ddl/database_manager.php:88
      /server/workspace/moodle/lib/ddl/database_manager.php:77
      /server/workspace/moodle/lib/ddl/database_manager.php:331
      /server/workspace/moodle/lib/testing/classes/util.php:568
      /server/workspace/moodle/lib/phpunit/classes/util.php:119
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:86

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_processor_testcase admin/tool/uploadcourse/tests/processor_test.php

      6) tool_uploadcourse_processor_testcase::test_restore_restore_file
      ddl_change_structure_exception: DDL sql execution error (ORA-00942: table or view does not exist
      TRUNCATE TABLE l00246ecd0001119)

      /server/workspace/moodle/lib/dml/moodle_database.php:442
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:271
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:905
      /server/workspace/moodle/lib/ddl/database_manager.php:88
      /server/workspace/moodle/lib/ddl/database_manager.php:77
      /server/workspace/moodle/lib/ddl/database_manager.php:331
      /server/workspace/moodle/lib/testing/classes/util.php:568
      /server/workspace/moodle/lib/phpunit/classes/util.php:119
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:86

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_processor_testcase admin/tool/uploadcourse/tests/processor_test.php

      7) tool_uploadcourse_processor_testcase::test_shortname_template
      ddl_change_structure_exception: DDL sql execution error (ORA-00942: table or view does not exist
      TRUNCATE TABLE l00246ecd0001120)

      /server/workspace/moodle/lib/dml/moodle_database.php:442
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:271
      /server/workspace/moodle/lib/dml/oci_native_moodle_database.php:905
      /server/workspace/moodle/lib/ddl/database_manager.php:88
      /server/workspace/moodle/lib/ddl/database_manager.php:77
      /server/workspace/moodle/lib/ddl/database_manager.php:331
      /server/workspace/moodle/lib/testing/classes/util.php:568
      /server/workspace/moodle/lib/phpunit/classes/util.php:119
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:100

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_processor_testcase admin/tool/uploadcourse/tests/processor_test.php

      8) tool_uploadcourse_processor_testcase::test_empty_csv
      Warning: max_execution_time was changed to 3600

      /server/workspace/moodle/lib/phpunit/classes/util.php:241
      /server/workspace/moodle/lib/phpunit/classes/advanced_testcase.php:100

      To re-run:
      /usr/bin/phpunit tool_uploadcourse_processor_testcase admin/tool/uploadcourse/tests/processor_test.php

      This is something to do with deleting temp tables.

        Attachments

        1. oracle_24.txt
          7 kB
        2. oracle_25.txt
          5 kB
        3. oracle_26.txt
          12 kB

          Issue Links

            Activity

              People

              Assignee:
              marina Marina Glancy
              Reporter:
              damyon Damyon Wiese
              Integrator:
              Dan Poltawski
              Tester:
              Dan Poltawski
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                18/Nov/13