Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-3234

Failed to run sql dump file with testing installation method

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Must
    • Resolution: Won't Fix
    • Affects Version/s: OpenMRS 1.9.0
    • Fix Version/s: OpenMRS 1.9.0
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Medium

      Description

      After using the Testing installation method together with the release testing helper module on a big database, i got an sql dump file of size 771.3MB which failed to import in the new server with the error message below:

      ERROR - TestInstallUtil.addTestData(109) |2012-03-30 17:34:28,769| 
      ERROR 2006 (HY000) at line 64867 in file: '/docs/testDataSet.dump': MySQL server has gone away
      ERROR - TestInstallUtil.addTestData(117) |2012-03-30 17:34:29,887| The process terminated abnormally while adding test data
      

      After trying to manually running the mysql dump file, i get these error messages:

      Query OK, 0 rows affected, 1 warning (0.00 sec)
      
      ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`xforms_xform`, CONSTRAINT `user_who_created_xform` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
      Query OK, 0 rows affected, 1 warning (0.00 sec)
      
      Query OK, 0 rows affected (0.00 sec)
      
      ERROR 1231 (42000): Variable 'time_zone' can't be set to the value of 'NULL'
      ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
      ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
      ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
      ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
      Query OK, 0 rows affected (0.00 sec)
      
      ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of 'NULL'
      ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'
      

        Attachments

          Activity

            People

            • Assignee:
              raff Rafal Korytkowski
              Reporter:
              dkayiwa Daniel Kayiwa
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: