API tools faq
paste
Advertisement
jmkumbo

Openmrs upgrade

jmkumbo
May 12th, 2017
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 67.66 KB | None | 0 0
raw download clone embed print report
  1. Using CATALINA_BASE:   /Library/tomcat
  2. Using CATALINA_HOME:   /Library/tomcat
  3. Using CATALINA_TMPDIR: /Library/tomcat/temp
  4. Using JRE_HOME:        /Library/Java/JavaVirtualMachines/jdk1.8.0_77.jdk/Contents/Home
  5. Using CLASSPATH:       /Library/tomcat/bin/bootstrap.jar:/Library/tomcat/bin/tomcat-juli.jar
  6. Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=64m; support was removed in 8.0
  7. Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
  8. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  9. INFO: Server version:        Apache Tomcat/7.0.77
  10. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  11. INFO: Server built:          Mar 28 2017 16:01:48 UTC
  12. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  13. INFO: Server number:         7.0.77.0
  14. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  15. INFO: OS Name:               Mac OS X
  16. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  17. INFO: OS Version:            10.11.6
  18. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  19. INFO: Architecture:          x86_64
  20. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  21. INFO: Java Home:             /Library/Java/JavaVirtualMachines/jdk1.8.0_77.jdk/Contents/Home/jre
  22. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  23. INFO: JVM Version:           1.8.0_77-b03
  24. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  25. INFO: JVM Vendor:            Oracle Corporation
  26. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  27. INFO: CATALINA_BASE:         /Library/tomcat
  28. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  29. INFO: CATALINA_HOME:         /Library/tomcat
  30. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  31. INFO: Command line argument: -Djava.util.logging.config.file=/Library/tomcat/conf/logging.properties
  32. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  33. INFO: Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
  34. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  35. INFO: Command line argument: -Dfile.encoding=UTF-8
  36. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  37. INFO: Command line argument: -Xms128m
  38. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  39. INFO: Command line argument: -Xmx1024m
  40. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  41. INFO: Command line argument: -XX:PermSize=64m
  42. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  43. INFO: Command line argument: -XX:MaxPermSize=256m
  44. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  45. INFO: Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
  46. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  47. INFO: Command line argument: -Djava.endorsed.dirs=/Library/tomcat/endorsed
  48. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  49. INFO: Command line argument: -Dcatalina.base=/Library/tomcat
  50. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  51. INFO: Command line argument: -Dcatalina.home=/Library/tomcat
  52. May 12, 2017 2:51:48 PM org.apache.catalina.startup.VersionLoggerListener log
  53. INFO: Command line argument: -Djava.io.tmpdir=/Library/tomcat/temp
  54. May 12, 2017 2:51:48 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
  55. INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /Users/martinmartin/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
  56. May 12, 2017 2:51:49 PM org.apache.coyote.AbstractProtocol init
  57. INFO: Initializing ProtocolHandler ["http-bio-8080"]
  58. May 12, 2017 2:51:49 PM org.apache.coyote.AbstractProtocol init
  59. INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
  60. May 12, 2017 2:51:49 PM org.apache.catalina.startup.Catalina load
  61. INFO: Initialization processed in 847 ms
  62. May 12, 2017 2:51:49 PM org.apache.catalina.core.StandardService startInternal
  63. INFO: Starting service Catalina
  64. May 12, 2017 2:51:49 PM org.apache.catalina.core.StandardEngine startInternal
  65. INFO: Starting Servlet Engine: Apache Tomcat/7.0.77
  66. May 12, 2017 2:51:49 PM org.apache.catalina.startup.HostConfig deployDescriptor
  67. INFO: Deploying configuration descriptor /Library/tomcat/conf/Catalina/localhost/context.xml
  68. May 12, 2017 2:51:49 PM org.apache.catalina.core.StandardContext resourcesStart
  69. SEVERE: Error starting static Resources
  70. java.lang.IllegalArgumentException: Document base /Library/tomcat/webapps/context does not exist or is not a readable directory
  71.     at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:136)
  72.     at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:5247)
  73.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5436)
  74.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
  75.     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
  76.     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
  77.     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
  78.     at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679)
  79.     at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966)
  80.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  81.     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  82.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  83.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  84.     at java.lang.Thread.run(Thread.java:745)
  85.  
  86. May 12, 2017 2:51:49 PM org.apache.catalina.core.ContainerBase addChildInternal
  87. SEVERE: ContainerBase.addChild: start:
  88. org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/context]]
  89.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:162)
  90.     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
  91.     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
  92.     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
  93.     at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679)
  94.     at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966)
  95.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  96.     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  97.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  98.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  99.     at java.lang.Thread.run(Thread.java:745)
  100. Caused by: org.apache.catalina.LifecycleException: Error in resourceStart()
  101.     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5437)
  102.     at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)
  103.     ... 10 more
  104.  
  105. May 12, 2017 2:51:49 PM org.apache.catalina.startup.HostConfig deployDescriptor
  106. SEVERE: Error deploying configuration descriptor /Library/tomcat/conf/Catalina/localhost/context.xml
  107. java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: Failed to start component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/context]]
  108.     at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:903)
  109.     at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
  110.     at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
  111.     at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:679)
  112.     at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1966)
  113.     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  114.     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  115.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  116.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  117.     at java.lang.Thread.run(Thread.java:745)
  118.  
  119. May 12, 2017 2:51:49 PM org.apache.catalina.startup.HostConfig deployDescriptor
  120. INFO: Deployment of configuration descriptor /Library/tomcat/conf/Catalina/localhost/context.xml has finished in 108 ms
  121. May 12, 2017 2:51:49 PM org.apache.catalina.startup.HostConfig deployDirectory
  122. INFO: Deploying web application directory /Library/tomcat/webapps/docs
  123. May 12, 2017 2:51:49 PM org.apache.catalina.startup.HostConfig deployDirectory
  124. INFO: Deployment of web application directory /Library/tomcat/webapps/docs has finished in 532 ms
  125. May 12, 2017 2:51:49 PM org.apache.catalina.startup.HostConfig deployDirectory
  126. INFO: Deploying web application directory /Library/tomcat/webapps/examples
  127. May 12, 2017 2:51:50 PM org.apache.catalina.startup.HostConfig deployDirectory
  128. INFO: Deployment of web application directory /Library/tomcat/webapps/examples has finished in 1,070 ms
  129. May 12, 2017 2:51:50 PM org.apache.catalina.startup.HostConfig deployDirectory
  130. INFO: Deploying web application directory /Library/tomcat/webapps/host-manager
  131. May 12, 2017 2:51:51 PM org.apache.catalina.startup.HostConfig deployDirectory
  132. INFO: Deployment of web application directory /Library/tomcat/webapps/host-manager has finished in 127 ms
  133. May 12, 2017 2:51:51 PM org.apache.catalina.startup.HostConfig deployDirectory
  134. INFO: Deploying web application directory /Library/tomcat/webapps/manager
  135. May 12, 2017 2:51:51 PM org.apache.catalina.startup.HostConfig deployDirectory
  136. INFO: Deployment of web application directory /Library/tomcat/webapps/manager has finished in 93 ms
  137. May 12, 2017 2:51:51 PM org.apache.catalina.startup.HostConfig deployDirectory
  138. INFO: Deploying web application directory /Library/tomcat/webapps/ROOT
  139. May 12, 2017 2:51:51 PM org.apache.catalina.startup.HostConfig deployDirectory
  140. INFO: Deployment of web application directory /Library/tomcat/webapps/ROOT has finished in 46 ms
  141. May 12, 2017 2:51:51 PM org.apache.coyote.AbstractProtocol start
  142. INFO: Starting ProtocolHandler ["http-bio-8080"]
  143. May 12, 2017 2:51:51 PM org.apache.coyote.AbstractProtocol start
  144. INFO: Starting ProtocolHandler ["ajp-bio-8009"]
  145. May 12, 2017 2:51:51 PM org.apache.catalina.startup.Catalina start
  146. INFO: Server startup in 2069 ms
  147. May 12, 2017 2:53:51 PM org.apache.catalina.startup.HostConfig undeploy
  148. INFO: Undeploying context [/context]
  149. May 12, 2017 2:54:25 PM org.apache.catalina.startup.HostConfig deployDescriptor
  150. INFO: Deploying configuration descriptor /Library/tomcat/conf/Catalina/localhost/context.xml
  151. May 12, 2017 2:54:37 PM org.apache.catalina.startup.TldConfig execute
  152. INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
  153. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2017-05-12 14:54:38,258| Unable to find a runtime properties file at /Library/tomcat/bin/context-runtime.properties
  154. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2141) |2017-05-12 14:54:38,310| Unable to find properties file: /Users/martinmartin/.OpenMRS/context/context-runtime.properties
  155. WARN - OpenmrsUtil.getRuntimeProperties(2075) |2017-05-12 14:54:38,311| Unable to find a runtime properties file. Initial setup is needed. View the webapp to run the setup wizard.
  156. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2017-05-12 14:54:38,612| Unable to find a runtime properties file at /Library/tomcat/bin/context-runtime.properties
  157. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2141) |2017-05-12 14:54:38,613| Unable to find properties file: /Users/martinmartin/.OpenMRS/context/context-runtime.properties
  158. WARN - OpenmrsUtil.getRuntimeProperties(2075) |2017-05-12 14:54:38,613| Unable to find a runtime properties file. Initial setup is needed. View the webapp to run the setup wizard.
  159. May 12, 2017 2:54:38 PM org.apache.catalina.startup.HostConfig deployDescriptor
  160. INFO: Deployment of configuration descriptor /Library/tomcat/conf/Catalina/localhost/context.xml has finished in 13,378 ms
  161. May 12, 2017 2:55:02 PM org.apache.catalina.startup.HostConfig deployWAR
  162. INFO: Deploying web application archive /Library/tomcat/webapps/openmrs.war
  163. May 12, 2017 2:55:11 PM org.apache.catalina.startup.TldConfig execute
  164. INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
  165. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2017-05-12 14:55:11,536| Unable to find a runtime properties file at /Library/tomcat/bin/openmrs-runtime.properties
  166. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2017-05-12 14:55:11,589| Unable to find a runtime properties file at /Library/tomcat/bin/openmrs-runtime.properties
  167. INFO - Listener.contextInitialized(174) |2017-05-12 14:55:11,589| Using runtime properties file: /Users/martinmartin/.OpenMRS/openmrs-runtime.properties
  168. INFO 5/12/17 2:55 PM:liquibase: Reading from `liquibasechangelog`
  169. WARNING 5/12/17 2:55 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  170. WARNING 5/12/17 2:55 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  171. WARNING 5/12/17 2:55 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  172. INFO 5/12/17 2:55 PM:liquibase: Reading from `liquibasechangelog`
  173. WARNING 5/12/17 2:55 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  174. WARNING 5/12/17 2:55 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  175. WARNING 5/12/17 2:55 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  176. WARN - OpenmrsUtil.getRuntimePropertiesFilePathName(2113) |2017-05-12 14:55:16,325| Unable to find a runtime properties file at /Library/tomcat/bin/openmrs-runtime.properties
  177. May 12, 2017 2:55:17 PM org.apache.catalina.startup.HostConfig deployWAR
  178. INFO: Deployment of web application archive /Library/tomcat/webapps/openmrs.war has finished in 15,338 ms
  179. INFO 5/12/17 2:56 PM:liquibase: Reading from `liquibasechangelog`
  180. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  181. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  182. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  183. INFO 5/12/17 2:56 PM:liquibase: Successfully acquired change log lock
  184. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  185. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  186. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  187. INFO 5/12/17 2:56 PM:liquibase: Reading from `liquibasechangelog`
  188. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::1-increase-privilege-col-size-privilege::dkayiwa ran successfully in 2206ms
  189. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::2-increase-privilege-col-size-rol-privilege::dkayiwa ran successfully in 846ms
  190. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::201205241728-1::mvorobey ran successfully in 916ms
  191. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::201205241728-2::mvorobey ran successfully in 809ms
  192. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::3-increase-privilege-col-size-person_attribute_type::dkayiwa ran successfully in 674ms
  193. INFO 5/12/17 2:56 PM:liquibase: Marking ChangeSet: liquibase-update-to-latest.xml::20101209-1353::wyclif::(Checksum: 3:9d30d1435a6c10a4b135609dc8e925ca) ran despite precondition failure due to onFail='MARK_RAN':
  194.           liquibase-update-to-latest.xml : Column '`as_needed`' does not exist
  195.  
  196. INFO 5/12/17 2:56 PM:liquibase: Marking ChangeSet: liquibase-update-to-latest.xml::20120503-djmod::dkayiwa and djazayeri::(Checksum: 3:d31ac18d3a40e45c0ebb399c5d116951) ran despite precondition failure due to onFail='MARK_RAN':
  197.           liquibase-update-to-latest.xml : Not precondition failed
  198.  
  199. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121007-orders_urgency::djazayeri ran successfully in 291ms
  200. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121007-test_order_laterality::djazayeri ran successfully in 172ms
  201. INFO 5/12/17 2:56 PM:liquibase: Marking ChangeSet: liquibase-update-to-latest.xml::20121008-order_specimen_source_fk::djazayeri::(Checksum: 3:99464e51d64e056a1e23b30c7aaaf47e) ran despite precondition failure due to onFail='MARK_RAN':
  202.           liquibase-update-to-latest.xml : Not precondition failed
  203.  
  204. INFO 5/12/17 2:56 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121016-1504::wyclif ran successfully in 502ms
  205. SEVERE 5/12/17 2:56 PM:liquibase: Change Set liquibase-update-to-latest.xml::20121020-TRUNK-3610::lluismf failed.  Error: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  206. liquibase.exception.DatabaseException: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  207.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  208.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  209.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  210.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  211.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  212.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  213.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  214.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  215.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  216.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  217.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  218.     at java.lang.Thread.run(Thread.java:745)
  219. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  220.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  221.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  222.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  223.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  224.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  225.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  226.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  227.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  228.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  229.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  230.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  231.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  232.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  233.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  234.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  235.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  236.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  237.     ... 11 more
  238. INFO 5/12/17 2:56 PM:liquibase: Successfully released change log lock
  239. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2017-05-12 14:56:29,099| Unable to update the database
  240. org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::20121020-TRUNK-3610::lluismf:
  241.      Reason: liquibase.exception.DatabaseException: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY':
  242.           Caused By: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY':
  243.           Caused By: Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  244.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  245.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  246.     at java.lang.Thread.run(Thread.java:745)
  247. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20121020-TRUNK-3610::lluismf:
  248.      Reason: liquibase.exception.DatabaseException: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY':
  249.           Caused By: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY':
  250.           Caused By: Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  251.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  252.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  253.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  254.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  255.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  256.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  257.     ... 2 more
  258. Caused by: liquibase.exception.DatabaseException: Error executing SQL UPDATE `global_property` SET `property` = 'visits.autoCloseVisitType' WHERE property='autoCloseVisits.visitType': Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  259.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  260.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  261.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  262.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  263.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  264.     ... 7 more
  265. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'visits.autoCloseVisitType' for key 'PRIMARY'
  266.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  267.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  268.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  269.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  270.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  271.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  272.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  273.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  274.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  275.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  276.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  277.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  278.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  279.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  280.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  281.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  282.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  283.     ... 11 more
  284. INFO 5/12/17 2:56 PM:liquibase: Reading from `liquibasechangelog`
  285. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  286. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  287. WARNING 5/12/17 2:56 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  288. INFO 5/12/17 3:12 PM:liquibase: Reading from `liquibasechangelog`
  289. WARNING 5/12/17 3:12 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  290. WARNING 5/12/17 3:12 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  291. WARNING 5/12/17 3:12 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  292. INFO 5/12/17 3:12 PM:liquibase: Successfully acquired change log lock
  293. WARNING 5/12/17 3:12 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  294. WARNING 5/12/17 3:12 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  295. WARNING 5/12/17 3:12 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  296. INFO 5/12/17 3:12 PM:liquibase: Reading from `liquibasechangelog`
  297. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121020-TRUNK-3610::lluismf ran successfully in 5ms
  298. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121025-TRUNK-213::lluismf ran successfully in 9731ms
  299. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121021-TRUNK-333::lluismf ran successfully in 86ms
  300. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121109-TRUNK-3474::patandre ran successfully in 542ms
  301. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121112-TRUNK-3474::patandre ran successfully in 398ms
  302. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121113-TRUNK-3474::patandre ran successfully in 557ms
  303. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121113-TRUNK-3474-person-attribute-type::patandre ran successfully in 668ms
  304. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121113-TRUNK-3474-privilege::patandre ran successfully in 148ms
  305. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121114-TRUNK-3474-role::patandre ran successfully in 311ms
  306. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121114-TRUNK-3474-relationship_type::patandre ran successfully in 543ms
  307. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121114-TRUNK-3474-encounter_type::patandre ran successfully in 73ms
  308. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20121212-TRUNK-2768::patandre ran successfully in 1465ms
  309. INFO 5/12/17 3:12 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20130626-TRUNK-439::jthoenes ran successfully in 31ms
  310. SEVERE 5/12/17 3:13 PM:liquibase: Change Set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan failed.  Error: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  311. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  312.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  313.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  314.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  315.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  316.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  317.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  318.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  319.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  320.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  321.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  322.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  323.     at java.lang.Thread.run(Thread.java:745)
  324. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  325.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  326.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  327.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  328.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  329.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  330.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  331.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  332.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  333.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  334.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  335.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  336.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  337.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  338.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  339.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  340.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  341.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  342.     ... 11 more
  343. INFO 5/12/17 3:13 PM:liquibase: Successfully released change log lock
  344. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2017-05-12 15:13:00,465| Unable to update the database
  345. org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  346.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  347.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  348.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  349.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  350.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  351.     at java.lang.Thread.run(Thread.java:745)
  352. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  353.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  354.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  355.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  356.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  357.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  358.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  359.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  360.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  361.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  362.     ... 2 more
  363. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  364.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  365.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  366.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  367.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  368.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  369.     ... 7 more
  370. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_15d`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  371.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  372.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  373.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  374.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  375.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  376.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  377.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  378.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  379.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  380.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  381.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  382.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  383.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  384.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  385.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  386.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  387.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  388.     ... 11 more
  389. INFO 5/12/17 3:13 PM:liquibase: Reading from `liquibasechangelog`
  390. WARNING 5/12/17 3:13 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  391. WARNING 5/12/17 3:13 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  392. WARNING 5/12/17 3:13 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  393. ^[[B^[[BINFO 5/12/17 3:48 PM:liquibase: Reading from `liquibasechangelog`
  394. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  395. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  396. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  397. INFO 5/12/17 3:48 PM:liquibase: Successfully acquired change log lock
  398. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  399. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  400. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  401. INFO 5/12/17 3:48 PM:liquibase: Reading from `liquibasechangelog`
  402. SEVERE 5/12/17 3:48 PM:liquibase: Change Set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan failed.  Error: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  403. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  404.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  405.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  406.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  407.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  408.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  409.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  410.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  411.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  412.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  413.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  414.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  415.     at java.lang.Thread.run(Thread.java:745)
  416. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  417.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  418.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  419.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  420.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  421.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  422.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  423.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  424.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  425.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  426.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  427.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  428.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  429.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  430.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  431.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  432.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  433.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  434.     ... 11 more
  435. INFO 5/12/17 3:48 PM:liquibase: Successfully released change log lock
  436. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2017-05-12 15:48:26,295| Unable to update the database
  437. org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  438.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  439.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  440.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  441.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  442.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  443.     at java.lang.Thread.run(Thread.java:745)
  444. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  445.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  446.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  447.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  448.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  449.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  450.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  451.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  452.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  453.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  454.     ... 2 more
  455. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  456.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  457.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  458.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  459.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  460.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  461.     ... 7 more
  462. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2b0`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  463.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  464.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  465.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  466.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  467.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  468.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  469.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  470.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  471.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  472.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  473.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  474.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  475.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  476.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  477.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  478.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  479.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  480.     ... 11 more
  481. INFO 5/12/17 3:48 PM:liquibase: Reading from `liquibasechangelog`
  482. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  483. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  484. WARNING 5/12/17 3:48 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  485. INFO 5/12/17 4:01 PM:liquibase: Reading from `liquibasechangelog`
  486. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  487. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  488. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  489. INFO 5/12/17 4:01 PM:liquibase: Successfully acquired change log lock
  490. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  491. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  492. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  493. INFO 5/12/17 4:01 PM:liquibase: Reading from `liquibasechangelog`
  494. SEVERE 5/12/17 4:01 PM:liquibase: Change Set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan failed.  Error: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  495. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  496.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  497.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  498.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  499.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  500.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  501.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  502.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  503.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  504.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  505.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  506.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  507.     at java.lang.Thread.run(Thread.java:745)
  508. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  509.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  510.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  511.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  512.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  513.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  514.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  515.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  516.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  517.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  518.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  519.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  520.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  521.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  522.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  523.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  524.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  525.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  526.     ... 11 more
  527. INFO 5/12/17 4:01 PM:liquibase: Successfully released change log lock
  528. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2017-05-12 16:01:42,086| Unable to update the database
  529. org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  530.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  531.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  532.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  533.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  534.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  535.     at java.lang.Thread.run(Thread.java:745)
  536. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  537.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  538.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  539.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  540.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  541.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  542.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  543.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  544.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  545.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  546.     ... 2 more
  547. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  548.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  549.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  550.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  551.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  552.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  553.     ... 7 more
  554. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_2fb`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  555.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  556.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  557.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  558.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  559.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  560.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  561.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  562.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  563.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  564.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  565.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  566.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  567.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  568.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  569.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  570.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  571.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  572.     ... 11 more
  573. INFO 5/12/17 4:01 PM:liquibase: Reading from `liquibasechangelog`
  574. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  575. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  576. WARNING 5/12/17 4:01 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  577. INFO 5/12/17 4:17 PM:liquibase: Reading from `liquibasechangelog`
  578. WARNING 5/12/17 4:17 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  579. WARNING 5/12/17 4:17 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  580. WARNING 5/12/17 4:17 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  581. INFO 5/12/17 4:17 PM:liquibase: Successfully acquired change log lock
  582. WARNING 5/12/17 4:17 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  583. WARNING 5/12/17 4:17 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  584. WARNING 5/12/17 4:17 PM:liquibase: modifyDataType will lose primary key/autoincrement/not null settings for mysql.  Use <sql> and re-specify all configuration if this is the case
  585. INFO 5/12/17 4:17 PM:liquibase: Reading from `liquibasechangelog`
  586. SEVERE 5/12/17 4:18 PM:liquibase: Change Set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan failed.  Error: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  587. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  588.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  589.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  590.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  591.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  592.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  593.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  594.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  595.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  596.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  597.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  598.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  599.     at java.lang.Thread.run(Thread.java:745)
  600. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  601.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  602.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  603.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  604.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  605.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  606.     at com.mysql.jdbc.Util.getInstance(Util.java:386)
  607.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  608.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  609.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  610.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  611.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  612.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  613.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  614.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  615.     at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  616.     at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  617.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  618.     ... 11 more
  619. INFO 5/12/17 4:18 PM:liquibase: Successfully released change log lock
  620. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2017-05-12 16:18:00,529| Unable to update the database
  621. org.openmrs.util.DatabaseUpdateException: There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  622.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  623.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  624.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  625.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  626.     at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  627.     at java.lang.Thread.run(Thread.java:745)
  628. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201306141103-TRUNK-3884::susantan:
  629.      Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  630.           Caused By: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`)):
  631.           Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  632.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  633.     at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  634.     at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  635.     at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  636.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  637.     at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  638.     ... 2 more
  639. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `encounter_provider` ADD CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`): Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  640.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  641.     at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  642.     at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  643.     at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  644.     at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  645.     ... 7 more
  646. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-8623_389`, CONSTRAINT `encounter_provider_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`))
  647.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!