API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 27th, 2016
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.02 KB | None | 0 0
raw download clone embed print report
  1. mvn liquibase:clearCheckSums
  2. [INFO] Scanning for projects...
  3. [INFO]
  4. [INFO] ------------------------------------------------------------------------
  5. [INFO] Building evm-changeset 2.0
  6. [INFO] ------------------------------------------------------------------------
  7. [INFO]
  8. [INFO] --- liquibase-maven-plugin:3.4.2:clearCheckSums (default-cli) @ evm-changes
  9. et ---
  10. [INFO] ------------------------------------------------------------------------
  11. [INFO] Parsing Liquibase Properties File
  12. [INFO] File: src/main/resources/liquibase.properties
  13. [INFO] 'changeLogFile' in properties file is not being used by this task.
  14. [INFO] ------------------------------------------------------------------------
  15. [INFO] Executing on Database: jdbc:mysql://localhost:3306/forte
  16. INFO 27.07.16 15:24: liquibase: Clearing database change log checksums
  17. INFO 27.07.16 15:24: liquibase: Successfully acquired change log lock
  18. INFO 27.07.16 15:24: liquibase: Successfully released change log lock
  19. [INFO] ------------------------------------------------------------------------
  20. [INFO]
  21. [INFO] ------------------------------------------------------------------------
  22. [INFO] BUILD SUCCESS
  23. [INFO] ------------------------------------------------------------------------
  24. [INFO] Total time: 2.591s
  25. [INFO] Finished at: Wed Jul 27 15:24:26 MSK 2016
  26. [INFO] Final Memory: 13M/212M
  27. [INFO] ------------------------------------------------------------------------
  28.  
  29. mvn liquibase:update
  30. [INFO] Scanning for projects...
  31. [INFO]
  32. [INFO] ------------------------------------------------------------------------
  33. [INFO] Building evm-changeset 2.0
  34. [INFO] ------------------------------------------------------------------------
  35. [INFO]
  36. [INFO] --- liquibase-maven-plugin:3.4.2:update (default-cli) @ evm-changeset ---
  37. [INFO] ------------------------------------------------------------------------
  38. [INFO] Parsing Liquibase Properties File
  39. [INFO] File: src/main/resources/liquibase.properties
  40. [INFO] ------------------------------------------------------------------------
  41. [INFO] Executing on Database: jdbc:mysql://localhost:3306/forte
  42. INFO 27.07.16 15:24: liquibase: Successfully acquired change log lock
  43. INFO 27.07.16 15:24: liquibase: Reading from DATABASECHANGELOG
  44. INFO 27.07.16 15:24: liquibase: Reading from DATABASECHANGELOG
  45. WARNING 27.07.16 15:24: liquibase: modifyDataType will lose primary key/autoincrem
  46. ent/not null settings for mysql. Use <sql> and re-specify all configuration if th
  47. is is the case
  48. WARNING 27.07.16 15:24: liquibase: modifyDataType will lose primary key/autoincrem
  49. ent/not null settings for mysql. Use <sql> and re-specify all configuration if th
  50. is is the case
  51. WARNING 27.07.16 15:24: liquibase: modifyDataType will lose primary key/autoincrem
  52. ent/not null settings for mysql. Use <sql> and re-specify all configuration if th
  53. is is the case
  54. WARNING 27.07.16 15:24: liquibase: modifyDataType will lose primary key/autoincrem
  55. ent/not null settings for mysql. Use <sql> and re-specify all configuration if th
  56. is is the case
  57. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  58. sources/liquibase/001-stage-5.xml::20160603-FTT-623-01::alexandr.zaharchuk: SQL in
  59. file src/main/resources/sql/FTT-623/update_company_docs.sql executed
  60. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  61. sources/liquibase/001-stage-5.xml::20160603-FTT-623-01::alexandr.zaharchuk: Change
  62. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-623-01::alexandr.za
  63. harchuk ran successfully in 57ms
  64. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  65. sources/liquibase/001-stage-5.xml::20160603-FTT-616-01::alexandr.zaharchuk: SQL in
  66. file src/main/resources/sql/FTT-616/update_races.sql executed
  67. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  68. sources/liquibase/001-stage-5.xml::20160603-FTT-616-01::alexandr.zaharchuk: Change
  69. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-616-01::alexandr.za
  70. harchuk ran successfully in 8ms
  71. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  72. sources/liquibase/001-stage-5.xml::20160603-FTT-595-01::alexandr.zaharchuk: users.
  73. Salary datatype was changed to INT
  74. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  75. sources/liquibase/001-stage-5.xml::20160603-FTT-595-01::alexandr.zaharchuk: Change
  76. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-595-01::alexandr.za
  77. harchuk ran successfully in 64ms
  78. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  79. sources/liquibase/001-stage-5.xml::20160603-FTT-595-02::alexandr.zaharchuk: salary
  80. historyrecords.Salary datatype was changed to INT
  81. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  82. sources/liquibase/001-stage-5.xml::20160603-FTT-595-02::alexandr.zaharchuk: Column
  83. s CreationDate(TIMESTAMP) added to salaryhistoryrecords
  84. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  85. sources/liquibase/001-stage-5.xml::20160603-FTT-595-02::alexandr.zaharchuk: Change
  86. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-595-02::alexandr.za
  87. harchuk ran successfully in 45ms
  88. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  89. sources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.zaharchuk: SQL in
  90. file src/main/resources/sql/FTT-595/migrate_exists_legalstatuses.sql executed
  91. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  92. sources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.zaharchuk: Foreig
  93. n key fk_CurrentLegalStatusID dropped
  94. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  95. sources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.zaharchuk: Column
  96. users.CurrentLegalStatusID dropped
  97. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  98. sources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.zaharchuk: Table
  99. legalstatuseshistoryrecords renamed to legalstatuseshistory
  100. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  101. sources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.zaharchuk: Column
  102. legalstatuseshistory.Date renamed to ExpirationDate
  103. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  104. sources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.zaharchuk: Change
  105. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-595-03::alexandr.za
  106. harchuk ran successfully in 107ms
  107. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  108. sources/liquibase/001-stage-5.xml::20160603-FTT-595-04::alexandr.zaharchuk: Null c
  109. onstraint has been added to legalstatuseshistory.UserID
  110. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  111. sources/liquibase/001-stage-5.xml::20160603-FTT-595-04::alexandr.zaharchuk: Null c
  112. onstraint has been added to legalstatuseshistory.LegalStatusID
  113. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  114. sources/liquibase/001-stage-5.xml::20160603-FTT-595-04::alexandr.zaharchuk: Change
  115. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-595-04::alexandr.za
  116. harchuk ran successfully in 49ms
  117. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  118. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: SQL in
  119. file src/main/resources/sql/FTT-595/migrate_users_salary.sql executed
  120. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  121. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: Table
  122. salaryhistoryrecords renamed to salaryhistory
  123. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  124. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: Column
  125. salaryhistory.CreationDate dropped
  126. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  127. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: Column
  128. users.SalaryType dropped
  129. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  130. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: Column
  131. users.Salary dropped
  132. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  133. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: Column
  134. users.SalaryEffectiveDate dropped
  135. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  136. sources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.zaharchuk: Change
  137. Set src/main/resources/liquibase/001-stage-5.xml::20160603-FTT-595-05::alexandr.za
  138. harchuk ran successfully in 170ms
  139. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  140. sources/liquibase/001-stage-5.xml::20160701-001::yauheni.suvitau: users.TokenExpir
  141. ation datatype was changed to date
  142. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  143. sources/liquibase/001-stage-5.xml::20160701-001::yauheni.suvitau: ChangeSet src/ma
  144. in/resources/liquibase/001-stage-5.xml::20160701-001::yauheni.suvitau ran successf
  145. ully in 36ms
  146. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  147. sources/liquibase/001-stage-5.xml::20160706-FFT-507::alexander.kohonovsky: users.S
  148. SN datatype was changed to CHAR(24)
  149. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  150. sources/liquibase/001-stage-5.xml::20160706-FFT-507::alexander.kohonovsky: ChangeS
  151. et src/main/resources/liquibase/001-stage-5.xml::20160706-FFT-507::alexander.kohon
  152. ovsky ran successfully in 23ms
  153. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  154. sources/liquibase/001-stage-5.xml::20160725-FTT-694::yauheni.suvitau: Null constra
  155. int dropped from billablecodes.code
  156. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  157. sources/liquibase/001-stage-5.xml::20160725-FTT-694::yauheni.suvitau: ChangeSet sr
  158. c/main/resources/liquibase/001-stage-5.xml::20160725-FTT-694::yauheni.suvitau ran
  159. successfully in 29ms
  160. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  161. sources/liquibase/001-stage-5.xml::20160726-FTT-692::yauheni.suvitau: Column posit
  162. ionhistory.Date renamed to StartDate
  163. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  164. sources/liquibase/001-stage-5.xml::20160726-FTT-692::yauheni.suvitau: Columns EndD
  165. ate(date) added to positionhistory
  166. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/re
  167. sources/liquibase/001-stage-5.xml::20160726-FTT-692::yauheni.suvitau: ChangeSet sr
  168. c/main/resources/liquibase/001-stage-5.xml::20160726-FTT-692::yauheni.suvitau ran
  169. successfully in 39ms
  170. SEVERE 27.07.16 15:24: liquibase: src/main/resources/liquibase/main.xml: src/main/
  171. resources/liquibase/001-stage-6.xml::20160531-FTT-551-4::anton.nadezhkin: Change S
  172. et src/main/resources/liquibase/001-stage-6.xml::20160531-FTT-551-4::anton.nadezhk
  173. in failed. Error: Key column 'UserID' doesn't exist in table [Failed SQL: ALTER T
  174. ABLE email_schedule ADD CONSTRAINT user_id_schedule_fk FOREIGN KEY (UserID) REFERE
  175. NCES users (ID) ON UPDATE NO ACTION ON DELETE NO ACTION]
  176. liquibase.exception.DatabaseException: Key column 'UserID' doesn't exist in table
  177. [Failed SQL: ALTER TABLE email_schedule ADD CONSTRAINT user_id_schedule_fk FOREIGN
  178. KEY (UserID) REFERENCES users (ID) ON UPDATE NO ACTION ON DELETE NO ACTION]
  179. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatem
  180. ent(JdbcExecutor.java:301)
  181. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
  182. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
  183. at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.ja
  184. va:1251)
  185. at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcD
  186. atabase.java:1234)
  187. at liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)
  188. at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
  189. at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
  190. at liquibase.Liquibase.update(Liquibase.java:212)
  191. at liquibase.Liquibase.update(Liquibase.java:192)
  192. at liquibase.Liquibase.update(Liquibase.java:327)
  193. at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.ja
  194. va:33)
  195. at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibas
  196. eTask(AbstractLiquibaseUpdateMojo.java:30)
  197. at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiqui
  198. baseMojo.java:394)
  199. at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBu
  200. ildPluginManager.java:101)
  201. at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.j
  202. ava:209)
  203. at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.j
  204. ava:153)
  205. at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.j
  206. ava:145)
  207. at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject
  208. (LifecycleModuleBuilder.java:84)
  209. at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject
  210. (LifecycleModuleBuilder.java:59)
  211. at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuil
  212. d(LifecycleStarter.java:183)
  213. at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleS
  214. tarter.java:161)
  215. at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)
  216. at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
  217. at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)
  218. at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
  219. at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
  220. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  221. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
  222. va:62)
  223. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
  224. rImpl.java:43)
  225. at java.lang.reflect.Method.invoke(Method.java:498)
  226. at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launch
  227. er.java:289)
  228. at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:
  229. 229)
  230. at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Laun
  231. cher.java:415)
  232. at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:35
  233. 6)
  234. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column '
  235. UserID' doesn't exist in table
  236. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  237. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor
  238. AccessorImpl.java:62)
  239. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon
  240. structorAccessorImpl.java:45)
  241. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  242. at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
  243. at com.mysql.jdbc.Util.getInstance(Util.java:381)
  244. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
  245. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  246. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
  247. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
  248. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
  249. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
  250. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
  251. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
  252. at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
  253. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
  254. ... 34 more
  255. INFO 27.07.16 15:24: liquibase: src/main/resources/liquibase/001-stage-6.xml::20160531-FTT-551-4::anton.nadezhkin: Successfully released change log lock
  256. [INFO] ------------------------------------------------------------------------
  257. [INFO] BUILD FAILURE
  258. [INFO] ------------------------------------------------------------------------
  259. [INFO] Total time: 7.135s
  260. [INFO] Finished at: Wed Jul 27 15:24:39 MSK 2016
  261. [INFO] Final Memory: 15M/267M
  262. [INFO] ------------------------------------------------------------------------
  263. [ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.4.2:update (default-cli) on project evm-changeset: Error setting up or running Liquibase: Migration failed for change set src/main/resources/liquibase/001-stage-6.xml::20160531-FTT-551-4::anton.nadezhkin:
  264. [ERROR] Reason: liquibase.exception.DatabaseException: Key column 'UserID' doesn't exist in table [Failed SQL: ALTER TABLE email_schedule ADD CONSTRAINT user_id_schedule_fk FOREIGN KEY (UserID) REFERENCES users (ID) ON UPDATE NO ACTION ON DELETE NO ACTION]
  265. [ERROR] -> [Help 1]
  266. [ERROR]
  267. [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
  268. [ERROR] Re-run Maven using the -X switch to enable full debug logging.
  269. [ERROR]
  270. [ERROR] For more information about the errors and possible solutions, please read the following articles:
  271. [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
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!