API tools faq
paste
Guest User

Untitled

a guest
May 23rd, 2013
66
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.17 KB | None | 0 0
raw download clone embed print report
  1. INFO 23/05/13 10:34:liquibase: Reading from `liquibasechangelog`
  2. WARNING 23/05/13 10:34:liquibase: modifyDataType will lose primary key/autoincre
  3. ment/not null settings for mysql. Use <sql> and re-specify all configuration if
  4. this is the case
  5. INFO 23/05/13 10:34:liquibase: Successfully acquired change log lock
  6. WARNING 23/05/13 10:34:liquibase: modifyDataType will lose primary key/autoincre
  7. ment/not null settings for mysql. Use <sql> and re-specify all configuration if
  8. this is the case
  9. INFO 23/05/13 10:34:liquibase: Reading from `liquibasechangelog`
  10. SEVERE 23/05/13 10:34:liquibase: Change Set liquibase-update-to-latest.xml::1-in
  11. crease-privilege-col-size-privilege::dkayiwa failed. Error: Error executing SQL
  12. ALTER TABLE `privilege` MODIFY `privilege` VARCHAR(255) NOT NULL: Cannot change
  13. column 'privilege': used in a foreign key constraint 'privilege_which_can_edit'
  14. of table 'openmrs.person_attribute_type'
  15. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `privileg
  16. e` MODIFY `privilege` VARCHAR(255) NOT NULL: Cannot change column 'privilege': u
  17. sed in a foreign key constraint 'privilege_which_can_edit' of table 'openmrs.per
  18. son_attribute_type'
  19. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  20. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  21. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:109
  22. 1)
  23. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
  24. e.java:1075)
  25. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  26. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
  27. )
  28. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(Database
  29. Updater.java:202)
  30. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  31. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  32. a:230)
  33. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  34. a:167)
  35. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  36. a:152)
  37. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.r
  38. un(UpdateFilter.java:680)
  39. at java.lang.Thread.run(Unknown Source)
  40. Caused by: java.sql.SQLException: Cannot change column 'privilege': used in a fo
  41. reign key constraint 'privilege_which_can_edit' of table 'openmrs.person_attribu
  42. te_type'
  43. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  44. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  45. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
  46. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
  47. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
  48. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
  49. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
  50. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
  51. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:769)
  52. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:612)
  53. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
  54. tement(JdbcExecutor.java:92)
  55. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  56. ... 12 more
  57. INFO 23/05/13 10:34:liquibase: Successfully released change log lock
  58. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(697) |2013-05-23 10:34:10,199|
  59. Unable to update the database
  60. org.openmrs.util.DatabaseUpdateException: There was an error while updating the
  61. database to the latest. file: liquibase-update-to-latest.xml. Error: Migration f
  62. ailed for change set liquibase-update-to-latest.xml::1-increase-privilege-col-si
  63. ze-privilege::dkayiwa:
  64. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TA
  65. BLE `privilege` MODIFY `privilege` VARCHAR(255) NOT NULL: Cannot change column '
  66. privilege': used in a foreign key constraint 'privilege_which_can_edit' of table
  67. 'openmrs.person_attribute_type':
  68. Caused By: Error executing SQL ALTER TABLE `privilege` MODIFY `privile
  69. ge` VARCHAR(255) NOT NULL: Cannot change column 'privilege': used in a foreign k
  70. ey constraint 'privilege_which_can_edit' of table 'openmrs.person_attribute_type
  71. ':
  72. Caused By: Cannot change column 'privilege': used in a foreign key con
  73. straint 'privilege_which_can_edit' of table 'openmrs.person_attribute_type'
  74. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  75. a:155)
  76. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.r
  77. un(UpdateFilter.java:680)
  78. at java.lang.Thread.run(Unknown Source)
  79. Caused by: liquibase.exception.MigrationFailedException: Migration failed for ch
  80. ange set liquibase-update-to-latest.xml::1-increase-privilege-col-size-privilege
  81. ::dkayiwa:
  82. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TA
  83. BLE `privilege` MODIFY `privilege` VARCHAR(255) NOT NULL: Cannot change column '
  84. privilege': used in a foreign key constraint 'privilege_which_can_edit' of table
  85. 'openmrs.person_attribute_type':
  86. Caused By: Error executing SQL ALTER TABLE `privilege` MODIFY `privile
  87. ge` VARCHAR(255) NOT NULL: Cannot change column 'privilege': used in a foreign k
  88. ey constraint 'privilege_which_can_edit' of table 'openmrs.person_attribute_type
  89. ':
  90. Caused By: Cannot change column 'privilege': used in a foreign key con
  91. straint 'privilege_which_can_edit' of table 'openmrs.person_attribute_type'
  92. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  93. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
  94. )
  95. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(Database
  96. Updater.java:202)
  97. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  98. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  99. a:230)
  100. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  101. a:167)
  102. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.jav
  103. a:152)
  104. ... 2 more
  105. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABL
  106. E `privilege` MODIFY `privilege` VARCHAR(255) NOT NULL: Cannot change column 'pr
  107. ivilege': used in a foreign key constraint 'privilege_which_can_edit' of table '
  108. openmrs.person_attribute_type'
  109. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  110. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  111. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:109
  112. 1)
  113. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
  114. e.java:1075)
  115. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  116. ... 8 more
  117. Caused by: java.sql.SQLException: Cannot change column 'privilege': used in a fo
  118. reign key constraint 'privilege_which_can_edit' of table 'openmrs.person_attribu
  119. te_type'
  120. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  121. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  122. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
  123. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
  124. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
  125. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
  126. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
  127. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
  128. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:769)
  129. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:612)
  130. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
  131. tement(JdbcExecutor.java:92)
  132. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  133. ... 12 more
  134. INFO 23/05/13 10:34:liquibase: Reading from `liquibasechangelog`
  135. WARNING 23/05/13 10:34:liquibase: modifyDataType will lose primary key/autoincre
  136. ment/not null settings for mysql. Use <sql> and re-specify all configuration if
  137. this is the case
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!