Unstable build

[gustavoamigo]

We need investigate why the build is unstable. Please, add some logs here.

[gustavoamigo]

Build failed log.

It seems DELETE FROM Couple and INSERT INTO Couple were running at the same time, is it possible?

[info] PeopleFinagleMysqlSpec:
06:03:19.729 [pool-1-thread-1] INFO  i.g.s.jdbc.mysql.package$$anon$1 - DELETE FROM Couple
06:03:19.749 [pool-1-thread-1] INFO  i.g.s.jdbc.mysql.package$$anon$1 - DELETE FROM Person WHERE age > 0
06:03:19.756 [pool-1-thread-1] INFO  i.g.s.jdbc.mysql.package$$anon$1 - INSERT INTO Person (name,age) VALUES (?, ?)
06:03:19.775 [pool-1-thread-1] INFO  i.g.s.jdbc.mysql.package$$anon$1 - INSERT INTO Couple (her,him) VALUES (?, ?)
Feb 24, 2016 6:03:19 AM com.twitter.util.RootMonitor$ handle
SEVERE: Exception propagated to the root monitor!
com.twitter.finagle.exp.mysql.ServerError: Deadlock found when trying to get lock; try restarting transaction
    at com.twitter.finagle.exp.mysql.ClientDispatcher$$anonfun$com$twitter$finagle$exp$mysql$ClientDispatcher$$decodePacket$3.apply(ClientDispatcher.scala:200)
    at com.twitter.finagle.exp.mysql.ClientDispatcher$$anonfun$com$twitter$finagle$exp$mysql$ClientDispatcher$$decodePacket$3.apply(ClientDispatcher.scala:198)
    at com.twitter.util.Future$$anonfun$flatMap$1.apply(Future.scala:894)
    at com.twitter.util.Future$$anonfun$flatMap$1.apply(Future.scala:893)
    at com.twitter.util.ConstFuture$$anon$6.run(Future.scala:1281)
    at com.twitter.concurrent.LocalScheduler$Activation.run(Scheduler.scala:178)
    at com.twitter.concurrent.LocalScheduler$Activation.submit(Scheduler.scala:136)
    at com.twitter.concurrent.LocalScheduler.submit(Scheduler.scala:207)
    at com.twitter.concurrent.Scheduler$.submit(Scheduler.scala:92)
    at com.twitter.util.Promise.runq(Promise.scala:350)
    at com.twitter.util.Promise.updateIfEmpty(Promise.scala:721)
    at com.twitter.util.Promise.update(Promise.scala:694)
    at com.twitter.util.Promise.setValue(Promise.scala:670)
    at com.twitter.concurrent.AsyncQueue.offer(AsyncQueue.scala:111)
    at com.twitter.finagle.netty3.transport.ChannelTransport.handleUpstream(ChannelTransport.scala:55)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
    at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
    at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)
    at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)
    at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)
    at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
    at org.jboss.netty.channel.SimpleChannelHandler.messageReceived(SimpleChannelHandler.java:142)
    at com.twitter.finagle.netty3.channel.ChannelStatsHandler.messageReceived(ChannelStatsHandler.scala:78)
    at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
    at org.jboss.netty.channel.SimpleChannelHandler.messageReceived(SimpleChannelHandler.java:142)
    at com.twitter.finagle.netty3.channel.ChannelRequestStatsHandler.messageReceived(ChannelRequestStatsHandler.scala:35)
    at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
    at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
    at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)
    at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)
    at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)
    at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)
    at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:337)
    at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)
    at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)
    at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
    at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
[info] Exception encountered when attempting to run a suite with class name: io.getquill.sources.finagle.mysql.PeopleFinagleMysqlSpec *** ABORTED ***
[info]   com.twitter.finagle.exp.mysql.ServerError: Deadlock found when trying to get lock; try restarting transaction
[info]   at com.twitter.finagle.exp.mysql.ClientDispatcher$$anonfun$com$twitter$finagle$exp$mysql$ClientDispatcher$$decodePacket$3.apply(ClientDispatcher.scala:200)
[info]   at com.twitter.finagle.exp.mysql.ClientDispatcher$$anonfun$com$twitter$finagle$exp$mysql$ClientDispatcher$$decodePacket$3.apply(ClientDispatcher.scala:198)
[info]   at com.twitter.util.Future$$anonfun$flatMap$1.apply(Future.scala:894)
[info]   at com.twitter.util.Future$$anonfun$flatMap$1.apply(Future.scala:893)
[info]   at com.twitter.util.ConstFuture$$anon$6.run(Future.scala:1281)
[info]   at com.twitter.concurrent.LocalScheduler$Activation.run(Scheduler.scala:178)
[info]   at com.twitter.concurrent.LocalScheduler$Activation.submit(Scheduler.scala:136)
[info]   at com.twitter.concurrent.LocalScheduler.submit(Scheduler.scala:207)
[info]   at com.twitter.concurrent.Scheduler$.submit(Scheduler.scala:92)
[info]   at com.twitter.util.Promise.runq(Promise.scala:350)

[fwbrasil]

Another error:

Please ignore

[fwbrasil]

@gustavoamigo does docker-compose run setup guarantee that the databases are running and the schema is already created?

[jilen]

@fwbrasil That is caused by insert data into cassandra without primary key. I will fix the test case

[fwbrasil]

@jilen I was certain it was just some flakiness, thanks for let me know!

[gustavoamigo]

@fwbrasil That's one of the fixes I need to add. Right now there's just a a sleep 30 at the beginning of the script.

[gustavoamigo]

I need to add somthing like this in order to wait databases.

[fwbrasil]

fixed by #213