A248

Flyway 7.0.4->7.5.0 results in 'unable to decrease block depth below 0'

Jan 14th, 2021 (edited)
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.89 KB | None | 0 0
  1. [main] INFO space.arim.libertybans.core.AbstractBaseFoundation - Conducting START...
  2. [main] TRACE space.arim.libertybans.core.database.DatabaseSettings - Using connection properties {sql.syntax_mys=true, sql.enforce_refs=true, hsqldb.tx_interrupt_rollback=true, sql.enforce_types=true, sql.ignore_case=true, sql.restrict_exec=true, sql.enforce_names=true}
  3. [main] INFO com.zaxxer.hikari.HikariDataSource - LibertyBans-HikariCP-HyperSQL - Starting...
  4. Jan 14, 2021 9:36:10 PM org.hsqldb.persist.Logger logInfoEvent
  5. INFO: Checkpoint start
  6. Jan 14, 2021 9:36:10 PM org.hsqldb.persist.Logger logInfoEvent
  7. INFO: checkpointClose start
  8. Jan 14, 2021 9:36:10 PM org.hsqldb.persist.Logger logInfoEvent
  9. INFO: checkpointClose synched
  10. Jan 14, 2021 9:36:10 PM org.hsqldb.persist.Logger logInfoEvent
  11. INFO: checkpointClose script done
  12. Jan 14, 2021 9:36:10 PM org.hsqldb.persist.Logger logInfoEvent
  13. INFO: checkpointClose end
  14. Jan 14, 2021 9:36:10 PM org.hsqldb.persist.Logger logInfoEvent
  15. INFO: Checkpoint end - txts: 1
  16. [main] INFO com.zaxxer.hikari.pool.PoolBase - LibertyBans-HikariCP-HyperSQL - Driver does not support get/set network timeout for connections. (feature not supported)
  17. [main] INFO com.zaxxer.hikari.HikariDataSource - LibertyBans-HikariCP-HyperSQL - Start completed.
  18. [main] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Community Edition 7.5.0 by Redgate
  19. [main] INFO org.flywaydb.core.internal.database.base.DatabaseType - Database: jdbc:hsqldb:file:/var/folders/35/x5nnljfd0vq8d96k1593n1bc0000gn/T/libertybans-test-dir1009230769267107913/hypersql/punishments-database;sql.syntax_mys=true;sql.enforce_refs=true;hsqldb.tx_interrupt_rollback=true;sql.enforce_types=true;sql.ignore_case=true;sql.restrict_exec=true;sql.enforce_names=true (HSQL Database Engine 2.5)
  20. [main] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 3 migrations (execution time 00:00.004s)
  21. [main] INFO org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory - Creating Schema History table "PUBLIC"."libertybans_flyway" ...
  22. [main] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema "PUBLIC": << Empty Schema >>
  23. [main] ERROR space.arim.libertybans.core.database.DatabaseSettings - Unable to migrate your database. Please create a backup of your database and promptly report this issue.
  24. org.flywaydb.core.api.FlywayException: Unable to parse statement in sql-migrations/common/V3__Create_views.sql at line 30 col 1. See https://flywaydb.org/documentation/knownparserlimitations for more information: Flyway parsing bug: unable to decrease block depth below 0
  25. at org.flywaydb.core.internal.parser.Parser.getNextStatement(Parser.java:303)
  26. at org.flywaydb.core.internal.parser.Parser$ParserSqlStatementIterator.<init>(Parser.java:696)
  27. at org.flywaydb.core.internal.parser.Parser.parse(Parser.java:123)
  28. at org.flywaydb.core.internal.sqlscript.ParserSqlScript.parse(ParserSqlScript.java:74)
  29. at org.flywaydb.core.internal.sqlscript.ParserSqlScript.validate(ParserSqlScript.java:122)
  30. at org.flywaydb.core.internal.sqlscript.ParserSqlScript.executeInTransaction(ParserSqlScript.java:191)
  31. at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.canExecuteInTransaction(SqlMigrationExecutor.java:83)
  32. at org.flywaydb.core.internal.command.DbMigrate.isExecuteGroupInTransaction(DbMigrate.java:358)
  33. at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:321)
  34. at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:290)
  35. at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:189)
  36. at org.flywaydb.core.internal.command.DbMigrate.access$000(DbMigrate.java:56)
  37. at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:148)
  38. at org.flywaydb.core.internal.command.DbMigrate$1.call(DbMigrate.java:145)
  39. at org.flywaydb.core.internal.jdbc.TableLockingExecutionTemplate$1.call(TableLockingExecutionTemplate.java:38)
  40. at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66)
  41. at org.flywaydb.core.internal.jdbc.TableLockingExecutionTemplate.execute(TableLockingExecutionTemplate.java:33)
  42. at org.flywaydb.core.internal.database.base.Connection.lock(Connection.java:129)
  43. at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:140)
  44. at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:145)
  45. at org.flywaydb.core.Flyway$1.execute(Flyway.java:216)
  46. at org.flywaydb.core.Flyway$1.execute(Flyway.java:165)
  47. at org.flywaydb.core.Flyway.execute(Flyway.java:570)
  48. at org.flywaydb.core.Flyway.migrate(Flyway.java:165)
  49. at space.arim.libertybans.core.database.DatabaseSettings.create(DatabaseSettings.java:101)
  50. at space.arim.libertybans.core.database.DatabaseSettings.create(DatabaseSettings.java:77)
  51. at space.arim.libertybans.core.database.DatabaseManager.startup(DatabaseManager.java:88)
  52. at space.arim.libertybans.core.LifecycleGodfather.startup0(LifecycleGodfather.java:59)
  53. at space.arim.libertybans.core.AbstractBaseFoundation.timedEvent(AbstractBaseFoundation.java:125)
  54. at space.arim.libertybans.core.AbstractBaseFoundation.startup(AbstractBaseFoundation.java:62)
  55. at space.arim.libertybans.it.ResourceCreator.lambda$create$0(ResourceCreator.java:82)
  56. at org.junit.jupiter.engine.execution.ExtensionValuesStore.lambda$getOrComputeIfAbsent$4(ExtensionValuesStore.java:86)
  57. at org.junit.jupiter.engine.execution.ExtensionValuesStore$MemoizingSupplier.get(ExtensionValuesStore.java:205)
  58. at org.junit.jupiter.engine.execution.ExtensionValuesStore$StoredValue.evaluate(ExtensionValuesStore.java:182)
  59. at org.junit.jupiter.engine.execution.ExtensionValuesStore$StoredValue.access$100(ExtensionValuesStore.java:171)
  60. at org.junit.jupiter.engine.execution.ExtensionValuesStore.getOrComputeIfAbsent(ExtensionValuesStore.java:89)
  61. at org.junit.jupiter.engine.execution.ExtensionValuesStore.getOrComputeIfAbsent(ExtensionValuesStore.java:93)
  62. at org.junit.jupiter.engine.execution.NamespaceAwareStore.getOrComputeIfAbsent(NamespaceAwareStore.java:61)
  63. at space.arim.libertybans.it.ResourceCreator.create(ResourceCreator.java:61)
  64. at space.arim.libertybans.it.InjectionInvocationContextProvider.lambda$provideTestTemplateInvocationContexts$0(InjectionInvocationContextProvider.java:48)
  65. at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
  66. at java.base/java.util.HashMap$KeySpliterator.forEachRemaining(HashMap.java:1603)
  67. at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
  68. at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
  69. at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
  70. at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
  71. at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
  72. at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
  73. at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
  74. at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
  75. at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
  76. at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
  77. at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
  78. at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
  79. at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
  80. at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
  81. at org.junit.jupiter.engine.descriptor.TestTemplateTestDescriptor.execute(TestTemplateTestDescriptor.java:107)
  82. at org.junit.jupiter.engine.descriptor.TestTemplateTestDescriptor.execute(TestTemplateTestDescriptor.java:42)
  83. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
  84. at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
  85. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
  86. at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
  87. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
  88. at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
  89. at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
  90. at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
  91. at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
  92. at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
  93. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
  94. at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
  95. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
  96. at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
  97. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
  98. at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
  99. at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
  100. at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
  101. at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
  102. at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
  103. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
  104. at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
  105. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
  106. at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
  107. at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
  108. at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
  109. at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
  110. at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
  111. at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
  112. at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
  113. at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
  114. at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:108)
  115. at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:88)
  116. at org.junit.platform.launcher.core.EngineExecutionOrchestrator.lambda$execute$0(EngineExecutionOrchestrator.java:54)
  117. at org.junit.platform.launcher.core.EngineExecutionOrchestrator.withInterceptedStreams(EngineExecutionOrchestrator.java:67)
  118. at org.junit.platform.launcher.core.EngineExecutionOrchestrator.execute(EngineExecutionOrchestrator.java:52)
  119. at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:96)
  120. at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:75)
  121. at org.apache.maven.surefire.junitplatform.JUnitPlatformProvider.execute(JUnitPlatformProvider.java:188)
  122. at org.apache.maven.surefire.junitplatform.JUnitPlatformProvider.invokeAllTests(JUnitPlatformProvider.java:154)
  123. at org.apache.maven.surefire.junitplatform.JUnitPlatformProvider.invoke(JUnitPlatformProvider.java:128)
  124. at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:428)
  125. at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:162)
  126. at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:562)
  127. at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:548)
  128. Caused by: org.flywaydb.core.api.FlywayException: Flyway parsing bug: unable to decrease block depth below 0
  129. at org.flywaydb.core.internal.parser.ParserContext.decreaseBlockDepth(ParserContext.java:61)
  130. at org.flywaydb.core.internal.database.hsqldb.HSQLDBParser.adjustBlockDepth(HSQLDBParser.java:91)
  131. at org.flywaydb.core.internal.parser.Parser.getNextStatement(Parser.java:217)
  132. ... 102 more
Add Comment
Please, Sign In to add comment