Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2018
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.30 KB | None | 0 0
  1. INFO 8/3/18 4:17 PM:liquibase: Reading from `liquibasechangelog`
  2. INFO 8/3/18 4:17 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20150108-TRUNK-3849::rpuzdrowski ran successfully in 98ms
  3. INFO 8/3/18 4:17 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20150108-TRUNK-14::rpuzdrowski ran successfully in 25ms
  4. INFO 8/3/18 4:17 PM:liquibase: ChangeSet liquibase-update-to-latest.xml::20150211-TRUNK-3709::jkondrat ran successfully in 6ms
  5. SEVERE 8/3/18 4:17 PM:liquibase: Change Set liquibase-update-to-latest.xml::201411101055-TRUNK-3386::pmuchowski failed. Error: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  6. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  7. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  8. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  9. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  10. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  11. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  12. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  13. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  14. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  15. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  16. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  17. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  18. at java.lang.Thread.run(Thread.java:748)
  19. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'date_created'
  20. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  21. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  22. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  23. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  24. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  25. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  26. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  27. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  28. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  29. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  30. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  31. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  32. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  33. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  34. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  35. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  36. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  37. ... 11 more
  38. INFO 8/3/18 4:17 PM:liquibase: Successfully released change log lock
  39. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2018-08-03 16:17:16,339| Unable to update the database
  40. 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::201411101055-TRUNK-3386::pmuchowski:
  41. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  42. Caused By: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  43. Caused By: Invalid default value for 'date_created'
  44. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  45. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  46. at java.lang.Thread.run(Thread.java:748)
  47. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201411101055-TRUNK-3386::pmuchowski:
  48. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  49. Caused By: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  50. Caused By: Invalid default value for 'date_created'
  51. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  52. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  53. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  54. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  55. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  56. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  57. ... 2 more
  58. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  59. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  60. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  61. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  62. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  63. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  64. ... 7 more
  65. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'date_created'
  66. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  67. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  68. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  69. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  70. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  71. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  72. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  73. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  74. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  75. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  76. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  77. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  78. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  79. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  80. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  81. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  82. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  83. ... 11 more
  84. INFO 8/3/18 4:17 PM:liquibase: Reading from `liquibasechangelog`
  85. WARNING 8/3/18 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
  86. WARNING 8/3/18 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
  87. WARNING 8/3/18 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
  88. INFO 8/3/18 4:18 PM:liquibase: Reading from `liquibasechangelog`
  89. WARNING 8/3/18 4:18 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
  90. WARNING 8/3/18 4:18 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
  91. WARNING 8/3/18 4:18 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
  92. INFO 8/3/18 4:18 PM:liquibase: Successfully acquired change log lock
  93. WARNING 8/3/18 4:18 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
  94. WARNING 8/3/18 4:18 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
  95. WARNING 8/3/18 4:18 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
  96. INFO 8/3/18 4:18 PM:liquibase: Reading from `liquibasechangelog`
  97. SEVERE 8/3/18 4:18 PM:liquibase: Change Set liquibase-update-to-latest.xml::201411101055-TRUNK-3386::pmuchowski failed. Error: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  98. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  99. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  100. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  101. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  102. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  103. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  104. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  105. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  106. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  107. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  108. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  109. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  110. at java.lang.Thread.run(Thread.java:748)
  111. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'date_created'
  112. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  113. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  114. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  115. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  116. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  117. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  118. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  119. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  120. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  121. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  122. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  123. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  124. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  125. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  126. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  127. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  128. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  129. ... 11 more
  130. INFO 8/3/18 4:18 PM:liquibase: Successfully released change log lock
  131. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2018-08-03 16:18:57,808| Unable to update the database
  132. 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::201411101055-TRUNK-3386::pmuchowski:
  133. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  134. Caused By: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  135. Caused By: Invalid default value for 'date_created'
  136. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  137. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  138. at java.lang.Thread.run(Thread.java:748)
  139. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201411101055-TRUNK-3386::pmuchowski:
  140. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  141. Caused By: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  142. Caused By: Invalid default value for 'date_created'
  143. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  144. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  145. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  146. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  147. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  148. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  149. ... 2 more
  150. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  151. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  152. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  153. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  154. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  155. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  156. ... 7 more
  157. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'date_created'
  158. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  159. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  160. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  161. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  162. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  163. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  164. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  165. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  166. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  167. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  168. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  169. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  170. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  171. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  172. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  173. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  174. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  175. ... 11 more
  176. INFO 8/3/18 4:18 PM:liquibase: Reading from `liquibasechangelog`
  177. WARNING 8/3/18 4:18 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
  178. WARNING 8/3/18 4:18 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
  179. WARNING 8/3/18 4:18 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
  180. INFO 8/3/18 4:21 PM:liquibase: Reading from `liquibasechangelog`
  181. WARNING 8/3/18 4:21 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 8/3/18 4:21 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. WARNING 8/3/18 4:21 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
  184. INFO 8/3/18 4:21 PM:liquibase: Successfully acquired change log lock
  185. WARNING 8/3/18 4:21 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 8/3/18 4:21 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. WARNING 8/3/18 4:21 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
  188. INFO 8/3/18 4:21 PM:liquibase: Reading from `liquibasechangelog`
  189. SEVERE 8/3/18 4:21 PM:liquibase: Change Set liquibase-update-to-latest.xml::201411101055-TRUNK-3386::pmuchowski failed. Error: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  190. liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  191. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  192. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  193. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  194. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  195. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  196. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  197. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  198. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  199. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  200. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  201. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  202. at java.lang.Thread.run(Thread.java:748)
  203. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'date_created'
  204. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  205. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  206. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  207. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  208. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  209. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  210. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  211. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  212. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  213. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  214. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  215. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  216. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  217. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  218. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  219. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  220. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  221. ... 11 more
  222. INFO 8/3/18 4:21 PM:liquibase: Successfully released change log lock
  223. ERROR - UpdateFilter$UpdateFilterCompletion$1.run(753) |2018-08-03 16:21:39,721| Unable to update the database
  224. 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::201411101055-TRUNK-3386::pmuchowski:
  225. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  226. Caused By: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  227. Caused By: Invalid default value for 'date_created'
  228. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:152)
  229. at org.openmrs.web.filter.update.UpdateFilter$UpdateFilterCompletion$1.run(UpdateFilter.java:736)
  230. at java.lang.Thread.run(Thread.java:748)
  231. Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase-update-to-latest.xml::201411101055-TRUNK-3386::pmuchowski:
  232. Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  233. Caused By: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created':
  234. Caused By: Invalid default value for 'date_created'
  235. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
  236. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
  237. at org.openmrs.util.DatabaseUpdater$1OpenmrsUpdateVisitor.visit(DatabaseUpdater.java:189)
  238. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
  239. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:218)
  240. at org.openmrs.util.DatabaseUpdater.executeChangelog(DatabaseUpdater.java:148)
  241. ... 2 more
  242. Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE `person_attribute_type` DROP FOREIGN KEY `privilege_which_can_edit`: Invalid default value for 'date_created'
  243. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
  244. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
  245. at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
  246. at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
  247. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
  248. ... 7 more
  249. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'date_created'
  250. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  251. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  252. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  253. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  254. at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  255. at com.mysql.jdbc.Util.getInstance(Util.java:386)
  256. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
  257. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  258. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  259. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  260. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  261. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
  262. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
  263. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:949)
  264. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:795)
  265. at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
  266. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  267. ... 11 more
  268. INFO 8/3/18 4:21 PM:liquibase: Reading from `liquibasechangelog`
  269. WARNING 8/3/18 4:21 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
  270. WARNING 8/3/18 4:21 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
  271. WARNING 8/3/18 4:21 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement