API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 13th, 2016
167
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.21 KB | None | 0 0
raw download clone embed print report
  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
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!