❯ gc deploy
Deploying service `example-airbnb` to stage `dev` on cluster `local`... 131ms
Changes:
Location (Type)
- Deleted field `address`
Applying changes... ⣟
The local container contains this log message:
encountered exception while applying migration. will roll back.
java.sql.SQLSyntaxErrorException: (conn=13) Unknown table 'example-airbnb@dev.ReceivedMessages'
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:163)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:235)
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:224)
at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at slick.jdbc.StatementInvoker.results(StatementInvoker.scala:39)
at slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
at slick.jdbc.Invoker.first(Invoker.scala:31)
at slick.jdbc.Invoker.first$(Invoker.scala:30)
at slick.jdbc.StatementInvoker.first(StatementInvoker.scala:16)
at slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:52)
at slick.jdbc.StreamingInvokerAction$HeadAction.run(StreamingInvokerAction.scala:51)
at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Unknown table 'example-airbnb@dev.ReceivedMessages'
Query is: DROP TABLE `example-airbnb@dev`.`ReceivedMessages`
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:146)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:217)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mariadb.jdbc.internal.failover.AbstractMastersListener.invoke(AbstractMastersListener.java:376)
at org.mariadb.jdbc.internal.failover.FailoverProxy.executeInvocation(FailoverProxy.java:220)
at org.mariadb.jdbc.internal.failover.FailoverProxy.invoke(FailoverProxy.java:213)
at com.sun.proxy.$Proxy4.executeQuery(Unknown Source)
at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:218)
The Migration table contains the following unapplied migration:
Steps to reproduce:
1: large example
2: small change
remove
Location.address
3: observe error:
This results in the deploy spinning forever:
The local container contains this log message:
The Migration table contains the following unapplied migration:
Deleting the migration and running
gc deploy
again succeeds and the resulting migration is:Adding the field again causes a similar issue. Again, deleting the migration and running it again works.