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

Oracle phpunit tests stopping after exception

    XMLWordPrintable

Details

    Description

      Oracle phpunit tests are stopping after an exception. This is happening since MDL-45945 introduced additional tests to test_temp_tables() from lib/ddl/tests/ddl_test.php.

      Here is the output.

      D:\xampp\htdocs\27_integration>vendor\bin\phpunit
      		 
      Moodle 2.7.1+ (Build: 20140724), oci, 0fbda60bb3d78c5d2587b8d33dba9d0c7231cd94
      		 
      PHPUnit 3.7.37 by Sebastian Bergmann.
      		 
       
      		 
      Configuration read from D:\xampp\htdocs\27_integration\phpunit.xml
      		 
       
      		 
      ............................................................
      		 
      Fatal error: Uncaught exception 'ddl_change_structure_exception' with message 'DDL sql execution error (ORA-14452: attempt to create, alter or drop an index on temporary table already in use
      		 
      DROP TABLE m_006270ab00014)' in D:\xampp\htdocs\27_integration\lib\dml\moodle_database.php:449
      		 
      Stack trace:
      		 
      #0 D:\xampp\htdocs\27_integration\lib\dml\oci_native_moodle_database.php(271): moodle_database->query_end(false)
      		 
      #1 D:\xampp\htdocs\27_integration\lib\dml\oci_native_moodle_database.php(904): oci_native_moodle_database->query_end(false, Resource id #96554)
      		 
      #2 D:\xampp\htdocs\27_integration\lib\ddl\database_manager.php(76): oci_native_moodle_database->change_database_structure(Array)
      		 
      #3 D:\xampp\htdocs\27_integration\lib\ddl\database_manager.php(326): database_manager->execute_sql_arr(Array)
      		 
      #4 D:\xampp\htdocs\27_integration\lib\testing\classes\util.php(671): database_manager->drop_table(Object(xmldb_table))
      		 
      #5 D:\xampp\htdocs\27_integration\lib\phpunit\classes\util.php(264): testing_util::reset_database()
      		 
      #6 D:\xampp\htdocs\27_i in D:\xampp\htdocs\27_integration\lib\dml\moodle_database.php on line 449

      More details can be found in MDL-46193

      Attachments

        Issue Links

          Discovered while testing

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-45594 Fix use of ORDER BY id in the messaging system

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has a non-specific relationship to

          Improvement - An enhancement to an existing Moodle feature. MDL-46872 Temp tables should be deleted between the unit test

          • 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-45945 MS-SQL Collation in Temp Tables (as seen in LDAP Auth Import)

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

          Improvement - An enhancement to an existing Moodle feature. MDL-46193 For unit testing, use random starting sequence

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

          Activity

            People

              rajeshtaneja Rajesh Taneja
              rajeshtaneja Rajesh Taneja
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Marina Glancy Marina Glancy
              Michael de Raadt Michael de Raadt
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                8/Sep/14