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'
      

        Gliffy Diagrams

          Attachments

            Attachments-Category-Modification

              Activity

                People

                • Assignee:
                  raff Rafal Korytkowski
                  Reporter:
                  dkayiwa Daniel Kayiwa
                  Watchers:
                  Ben Wolfe, Daniel Kayiwa, Darius Jazayeri, Jeremy Keiper, Nyoman Ribeka, Rafal Korytkowski, Wyclif Luyima
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: