{"action":"opened","issue":{"url":"https://api.github.com/repos/openzipkin/zipkin/issues/698","labels_url":"https://api.github.com/repos/openzipkin/zipkin/issues/698/labels{/name}","comments_url":"https://api.github.com/repos/openzipkin/zipkin/issues/698/comments","events_url":"https://api.github.com/repos/openzipkin/zipkin/issues/698/events","html_url":"https://github.com/openzipkin/zipkin/issues/698","id":105303185,"number":698,"title":"DB error when trying to display 1000 items in the UI","user":{"login":"jcarres-mdsol","id":1803073,"avatar_url":"https://avatars.githubusercontent.com/u/1803073?v=3","gravatar_id":"","url":"https://api.github.com/users/jcarres-mdsol","html_url":"https://github.com/jcarres-mdsol","followers_url":"https://api.github.com/users/jcarres-mdsol/followers","following_url":"https://api.github.com/users/jcarres-mdsol/following{/other_user}","gists_url":"https://api.github.com/users/jcarres-mdsol/gists{/gist_id}","starred_url":"https://api.github.com/users/jcarres-mdsol/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jcarres-mdsol/subscriptions","organizations_url":"https://api.github.com/users/jcarres-mdsol/orgs","repos_url":"https://api.github.com/users/jcarres-mdsol/repos","events_url":"https://api.github.com/users/jcarres-mdsol/events{/privacy}","received_events_url":"https://api.github.com/users/jcarres-mdsol/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-08T05:28:33Z","updated_at":"2015-09-08T05:28:33Z","closed_at":null,"body":"\r\nTo reproduce, in the UI choose Limit to be 1000  and click on Find traces\r\n\r\nI get this:\r\n```\r\ncom.datastax.driver.core.exceptions.InvalidQueryException: Cannot page queries with both ORDER BY and a IN restriction on the partition key; you must either remove the ORDER BY or the IN and sort client side, or disable paging for this query\r\n\r\n\r\ncom.twitter.zipkin.thriftscala.QueryException$.decode(QueryException.scala:104)\r\ncom.twitter.zipkin.thriftscala.ZipkinQuery$GetTraceIds$Result$.readQeValue(ZipkinQuery.scala:483)\r\ncom.twitter.zipkin.thriftscala.ZipkinQuery$GetTraceIds$Result$.decode(ZipkinQuery.scala:426)\r\ncom.twitter.zipkin.thriftscala.ZipkinQuery$GetTraceIds$Result$.decode(ZipkinQuery.scala:332)\r\ncom.twitter.zipkin.thriftscala.ZipkinQuery$FinagleClient.decodeResponse(ZipkinQuery$FinagleClient.scala:58)\r\ncom.twitter.zipkin.thriftscala.ZipkinQuery$FinagleClient$$anonfun$getTraceIds$1.apply(ZipkinQuery$FinagleClient.scala:96)\r\ncom.twitter.zipkin.thriftscala.ZipkinQuery$FinagleClient$$anonfun$getTraceIds$1.apply(ZipkinQuery$FinagleClient.scala:95)\r\ncom.twitter.util.Future$$anonfun$flatMap$1.apply(Future.scala:890)\r\ncom.twitter.util.Future$$anonfun$flatMap$1.apply(Future.scala:889)\r\ncom.twitter.util.Promise$Transformer.liftedTree1$1(Promise.scala:100)\r\ncom.twitter.util.Promise$Transformer.k(Promise.scala:100)\r\ncom.twitter.util.Promise$Transformer.apply(Promise.scala:110)\r\ncom.twitter.util.Promise$Transformer.apply(Promise.scala:91)\r\ncom.twitter.util.Promise$$anon$2.run(Promise.scala:358)\r\ncom.twitter.concurrent.LocalScheduler$Activation.run(Scheduler.scala:193)\r\ncom.twitter.concurrent.LocalScheduler$Activation.submit(Scheduler.scala:140)\r\ncom.twitter.concurrent.LocalScheduler.submit(Scheduler.scala:222)\r\ncom.twitter.concurrent.Scheduler$.submit(Scheduler.scala:84)\r\ncom.twitter.util.Promise.runq(Promise.scala:342)\r\ncom.twitter.util.Promise.updateIfEmpty(Promise.scala:713)\r\ncom.twitter.util.Promise.update(Promise.scala:686)\r\ncom.twitter.util.Promise.setValue(Promise.scala:662)\r\ncom.twitter.concurrent.AsyncQueue.offer(AsyncQueue.scala:88)\r\ncom.twitter.finagle.netty3.transport.ChannelTransport.handleUpstream(ChannelTransport.scala:51)\r\norg.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\norg.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)\r\norg.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)\r\norg.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:70)\r\norg.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\norg.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)\r\norg.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)\r\norg.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)\r\norg.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)\r\norg.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)\r\norg.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)\r\ncom.twitter.finagle.thrift.ThriftFrameCodec.handleUpstream(ThriftFrameCodec.scala:17)\r\norg.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\norg.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)\r\norg.jboss.netty.channel.SimpleChannelHandler.messageReceived(SimpleChannelHandler.java:142)\r\ncom.twitter.finagle.netty3.channel.ChannelStatsHandler.messageReceived(ChannelStatsHandler.scala:80)\r\norg.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88)\r\norg.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\norg.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)\r\norg.jboss.netty.channel.SimpleChannelHandler.messageReceived(SimpleChannelHandler.java:142)\r\ncom.twitter.finagle.netty3.channel.ChannelRequestStatsHandler.messageReceived(ChannelRequestStatsHandler.scala:35)\r\norg.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88)\r\norg.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)\r\norg.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)\r\norg.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)\r\norg.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)\r\norg.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)\r\norg.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)\r\norg.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:337)\r\norg.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)\r\norg.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)\r\norg.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)\r\norg.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)\r\njava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\njava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\njava.lang.Thread.run(Thread.java:745)\r\n```"}}