Advertisement
Guest User

Untitled

a guest
Apr 13th, 2016
101
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.21 KB | None
  1. INFO 4/13/16 1:12 AM:liquibase: ChangeSet liquibase-update-to-latest.xml::20110825-1000-creating-providers-for-persons-from-encounter::raff ran successfully in 8ms
  2. SEVERE 4/13/16 1:12 AM:liquibase: Change Set liquibase-update-to-latest.xml::20110825-1000-migrating-providers-to-encounter-provider::raff failed. Error: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  3. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  4. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  5. from encounter as encounter
  6. inner join encounter_role as encounter_role
  7. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  8. inner join provider as provider on encounter.provider_id = provider.person_id
  9. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  10. liquibase.exception.DatabaseException: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  11. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  12. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  13. from encounter as encounter
  14. inner join encounter_role as encounter_role
  15. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  16. inner join provider as provider on encounter.provider_id = provider.person_id
  17. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  18. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  19. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  20. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  21. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  22. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  23. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  24. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:200)
  25. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  26. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:229)
  27. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:164)
  28. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:149)
  29. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:681)
  30. at java.lang.Thread.run(Thread.java:745)
  31. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  32. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  33. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  34. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  35. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  36. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  37. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  38. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  39. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  40. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  41. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  42. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  43. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  44. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  45. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  46. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  47. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  48. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  49. ... 12 more
  50. INFO 4/13/16 1:12 AM:liquibase: Successfully released change log lock
  51. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(698) |2016-04-13 01:12:06,868| Unable to update the database
  52. 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::20110825-1000-migrating-providers-to-encounter-provider::raff:
  53. Reason: liquibase.exception.DatabaseException: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  54. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  55. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  56. from encounter as encounter
  57. inner join encounter_role as encounter_role
  58. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  59. inner join provider as provider on encounter.provider_id = provider.person_id
  60. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid':
  61. Caused By: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  62. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  63. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  64. from encounter as encounter
  65. inner join encounter_role as encounter_role
  66. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  67. inner join provider as provider on encounter.provider_id = provider.person_id
  68. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid':
  69. Caused By: Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  70. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  71. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:681)
  72. at java.lang.Thread.run(Thread.java:745)
  73. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::20110825-1000-migrating-providers-to-encounter-provider::raff:
  74. Reason: liquibase.exception.DatabaseException: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  75. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  76. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  77. from encounter as encounter
  78. inner join encounter_role as encounter_role
  79. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  80. inner join provider as provider on encounter.provider_id = provider.person_id
  81. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid':
  82. Caused By: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  83. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  84. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  85. from encounter as encounter
  86. inner join encounter_role as encounter_role
  87. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  88. inner join provider as provider on encounter.provider_id = provider.person_id
  89. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid':
  90. Caused By: Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  91. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  92. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  93. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:200)
  94. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  95. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:229)
  96. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:164)
  97. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:149)
  98. ... 2 more
  99. Caused by: liquibase.exception.DatabaseException: Error executing SQL insert into encounter_provider(provider_id, encounter_id, encounter_role_id, creator, date_created, voided, uuid)
  100. select distinct provider.provider_id, encounter.encounter_id, encounter_role.encounter_role_id,
  101. encounter.creator, encounter.date_created, encounter.voided, encounter.uuid
  102. from encounter as encounter
  103. inner join encounter_role as encounter_role
  104. on encounter_role.uuid = "a0b03050-c99b-11e0-9572-0800200c9a66"
  105. inner join provider as provider on encounter.provider_id = provider.person_id
  106. where encounter.encounter_id not in (select encounter_id from encounter_provider): Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  107. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  108. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  109. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  110. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  111. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  112. ... 8 more
  113. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '332f5fe0-4713-4bc1-af25-152257fedc72' for key 'uuid'
  114. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  115. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
  116. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  117. at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
  118. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  119. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  120. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  121. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  122. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  123. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  124. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  125. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  126. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  127. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  128. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  129. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  130. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  131. ... 12 more
  132. INFO 4/13/16 1:12 AM:liquibase: Reading from `liquibasechangelog`
Advertisement
RAW Paste Data Copied
Advertisement