API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 21st, 2018
140
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.02 KB | None | 0 0
raw download clone embed print report
  1. sbt:root> compile
  2. [info] Database: jdbc:postgresql://localhost:5432/nfldb (PostgreSQL 10.5)
  3. [info] Database: jdbc:postgresql://localhost:5432/exchangesdb (PostgreSQL 10.5)
  4. [warn] Unable to resolve location classpath:db/migration
  5. [info] Successfully validated 1 migration (execution time 00:00.015s)
  6. [warn] Unable to resolve location classpath:db/migration
  7. [warn] Unable to resolve location classpath:db/migration
  8. [warn] Unable to resolve location classpath:db/migration
  9. [info] Current version of schema "public": << Empty Schema >>
  10. [info] Successfully validated 2 migrations (execution time 00:00.012s)
  11. [info] Current version of schema "public": 2
  12. [warn] Schema "public" has version 2, but no migration could be resolved in the configured locations !
  13. [info] Schema "public" is up to date. No migration necessary.
  14. [info] Migrating schema "public" to version 1 - Create all
  15. [error] Migration of schema "public" to version 1 - Create all failed! Changes successfully rolled back.
  16. [error] org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException:
  17. [error] Migration V1__Create_all.sql failed
  18. [error] -----------------------------------
  19. [error] SQL State : 42501
  20. [error] Error Code : 0
  21. [error] Message : ERROR: must be owner of extension fuzzystrmatch
  22. [error] Location : db/migration/V1__Create_all.sql (/home/chris/dev/suredbits-api/nfldb-api/target/scala-2.11/classes/db/migration/V1__Create_all.sql)
  23. [error] Line : 41
  24. [error] Statement : COMMENT ON EXTENSION fuzzystrmatch IS 'determine similarities and distance between strings'
  25. [error]
  26. [error] at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:345)
  27. [error] at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:53)
  28. [error] at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:276)
  29. [error] at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75)
  30. [error] at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:273)
  31. [error] at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53)
  32. [error] at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:210)
  33. [error] at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:146)
  34. [error] at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:68)
  35. [error] at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLDbSupport.lock(PostgreSQLDbSupport.java:162)
  36. [error] at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174)
  37. [error] at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:146)
  38. [error] at org.flywaydb.core.Flyway$1.execute(Flyway.java:1010)
  39. [error] at org.flywaydb.core.Flyway$1.execute(Flyway.java:971)
  40. [error] at org.flywaydb.core.Flyway.execute(Flyway.java:1464)
  41. [error] at org.flywaydb.core.Flyway.migrate(Flyway.java:971)
  42. [error] at org.flywaydb.sbt.FlywayPlugin$.$anonfun$flywayBaseSettings$44(FlywayPlugin.scala:178)
  43. [error] at scala.runtime.java8.JFunction0$mcI$sp.apply(JFunction0$mcI$sp.java:12)
  44. [error] at org.flywaydb.sbt.FlywayPlugin$.withContextClassLoader(FlywayPlugin.scala:210)
  45. [error] at org.flywaydb.sbt.FlywayPlugin$.withPrepared(FlywayPlugin.scala:193)
  46. [error] at org.flywaydb.sbt.FlywayPlugin$.$anonfun$flywayBaseSettings$43(FlywayPlugin.scala:178)
  47. [error] at org.flywaydb.sbt.FlywayPlugin$.$anonfun$flywayBaseSettings$43$adapted(FlywayPlugin.scala:178)
  48. [error] at scala.Function1.$anonfun$compose$1(Function1.scala:44)
  49. [error] at sbt.internal.util.$tilde$greater.$anonfun$$u2219$1(TypeFunctions.scala:39)
  50. [error] at sbt.std.Transform$$anon$4.work(System.scala:66)
  51. [error] at sbt.Execute.$anonfun$submit$2(Execute.scala:263)
  52. [error] at sbt.internal.util.ErrorHandling$.wideConvert(ErrorHandling.scala:16)
  53. [error] at sbt.Execute.work(Execute.scala:272)
  54. [error] at sbt.Execute.$anonfun$submit$1(Execute.scala:263)
  55. [error] at sbt.ConcurrentRestrictions$$anon$4.$anonfun$submitValid$1(ConcurrentRestrictions.scala:174)
  56. [error] at sbt.CompletionService$$anon$2.call(CompletionService.scala:37)
  57. [error] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  58. [error] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  59. [error] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  60. [error] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  61. [error] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  62. [error] at java.lang.Thread.run(Thread.java:748)
  63. [error] Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of extension fuzzystrmatch
  64. [error] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453)
  65. [error] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2153)
  66. [error] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:286)
  67. [error] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432)
  68. [error] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358)
  69. [error] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305)
  70. [error] at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291)
  71. [error] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269)
  72. [error] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:265)
  73. [error] at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(JdbcTemplate.java:267)
  74. [error] at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java:142)
  75. [error] at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:76)
  76. [error] at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:343)
  77. [error] at org.flywaydb.core.internal.command.DbMigrate.access$900(DbMigrate.java:53)
  78. [error] at org.flywaydb.core.internal.command.DbMigrate$4.call(DbMigrate.java:276)
  79. [error] at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:75)
  80. [error] at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:273)
  81. [error] at org.flywaydb.core.internal.command.DbMigrate.access$800(DbMigrate.java:53)
  82. [error] at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:210)
  83. [error] at org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:146)
  84. [error] at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:68)
  85. [error] at org.flywaydb.core.internal.dbsupport.postgresql.PostgreSQLDbSupport.lock(PostgreSQLDbSupport.java:162)
  86. [error] at org.flywaydb.core.internal.metadatatable.MetaDataTableImpl.lock(MetaDataTableImpl.java:174)
  87. [error] at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:146)
  88. [error] at org.flywaydb.core.Flyway$1.execute(Flyway.java:1010)
  89. [error] at org.flywaydb.core.Flyway$1.execute(Flyway.java:971)
  90. [error] at org.flywaydb.core.Flyway.execute(Flyway.java:1464)
  91. [error] at org.flywaydb.core.Flyway.migrate(Flyway.java:971)
  92. [error] at org.flywaydb.sbt.FlywayPlugin$.$anonfun$flywayBaseSettings$44(FlywayPlugin.scala:178)
  93. [error] at scala.runtime.java8.JFunction0$mcI$sp.apply(JFunction0$mcI$sp.java:12)
  94. [error] at org.flywaydb.sbt.FlywayPlugin$.withContextClassLoader(FlywayPlugin.scala:210)
  95. [error] at org.flywaydb.sbt.FlywayPlugin$.withPrepared(FlywayPlugin.scala:193)
  96. [error] at org.flywaydb.sbt.FlywayPlugin$.$anonfun$flywayBaseSettings$43(FlywayPlugin.scala:178)
  97. [error] at org.flywaydb.sbt.FlywayPlugin$.$anonfun$flywayBaseSettings$43$adapted(FlywayPlugin.scala:178)
  98. [error] at scala.Function1.$anonfun$compose$1(Function1.scala:44)
  99. [error] at sbt.internal.util.$tilde$greater.$anonfun$$u2219$1(TypeFunctions.scala:39)
  100. [error] at sbt.std.Transform$$anon$4.work(System.scala:66)
  101. [error] at sbt.Execute.$anonfun$submit$2(Execute.scala:263)
  102. [error] at sbt.internal.util.ErrorHandling$.wideConvert(ErrorHandling.scala:16)
  103. [error] at sbt.Execute.work(Execute.scala:272)
  104. [error] at sbt.Execute.$anonfun$submit$1(Execute.scala:263)
  105. [error] at sbt.ConcurrentRestrictions$$anon$4.$anonfun$submitValid$1(ConcurrentRestrictions.scala:174)
  106. [error] at sbt.CompletionService$$anon$2.call(CompletionService.scala:37)
  107. [error] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  108. [error] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  109. [error] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  110. [error] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  111. [error] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  112. [error] at java.lang.Thread.run(Thread.java:748)
  113. [error] (nfldbapi / flywayMigrate) org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateSqlException:
  114. [error] Migration V1__Create_all.sql failed
  115. [error] -----------------------------------
  116. [error] SQL State : 42501
  117. [error] Error Code : 0
  118. [error] Message : ERROR: must be owner of extension fuzzystrmatch
  119. [error] Location : db/migration/V1__Create_all.sql (/home/chris/dev/suredbits-api/nfldb-api/target/scala-2.11/classes/db/migration/V1__Create_all.sql)
  120. [error] Line : 41
  121. [error] Statement : COMMENT ON EXTENSION fuzzystrmatch IS 'determine similarities and distance between strings'
  122. [error] Total time: 1 s, completed Aug 21, 2018 11:47:53 AM
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!