{"action":"created","issue":{"url":"https://api.github.com/repos/raintank/raintank-metric/issues/86","labels_url":"https://api.github.com/repos/raintank/raintank-metric/issues/86/labels{/name}","comments_url":"https://api.github.com/repos/raintank/raintank-metric/issues/86/comments","events_url":"https://api.github.com/repos/raintank/raintank-metric/issues/86/events","html_url":"https://github.com/raintank/raintank-metric/issues/86","id":123498043,"number":86,"title":"no data returned when requesting large time ranges on prod.","user":{"login":"woodsaj","id":8415072,"avatar_url":"https://avatars.githubusercontent.com/u/8415072?v=3","gravatar_id":"","url":"https://api.github.com/users/woodsaj","html_url":"https://github.com/woodsaj","followers_url":"https://api.github.com/users/woodsaj/followers","following_url":"https://api.github.com/users/woodsaj/following{/other_user}","gists_url":"https://api.github.com/users/woodsaj/gists{/gist_id}","starred_url":"https://api.github.com/users/woodsaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/woodsaj/subscriptions","organizations_url":"https://api.github.com/users/woodsaj/orgs","repos_url":"https://api.github.com/users/woodsaj/repos","events_url":"https://api.github.com/users/woodsaj/events{/privacy}","received_events_url":"https://api.github.com/users/woodsaj/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-22T15:10:45Z","updated_at":"2015-12-22T15:57:41Z","closed_at":null,"body":"cassandra is reporting this error.\r\n\r\n2015/12/22 14:55:31 [cassandra.go:222 searchCassandra()] [E] cassandra query error. java.lang.ClassCastException: org.apache.cassandra.db.composites.Composites$EmptyComposite cannot be cast to org.apache.cassandra.db.composites.CellName\r\n"},"comment":{"url":"https://api.github.com/repos/raintank/raintank-metric/issues/comments/166655792","html_url":"https://github.com/raintank/raintank-metric/issues/86#issuecomment-166655792","issue_url":"https://api.github.com/repos/raintank/raintank-metric/issues/86","id":166655792,"user":{"login":"woodsaj","id":8415072,"avatar_url":"https://avatars.githubusercontent.com/u/8415072?v=3","gravatar_id":"","url":"https://api.github.com/users/woodsaj","html_url":"https://github.com/woodsaj","followers_url":"https://api.github.com/users/woodsaj/followers","following_url":"https://api.github.com/users/woodsaj/following{/other_user}","gists_url":"https://api.github.com/users/woodsaj/gists{/gist_id}","starred_url":"https://api.github.com/users/woodsaj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/woodsaj/subscriptions","organizations_url":"https://api.github.com/users/woodsaj/orgs","repos_url":"https://api.github.com/users/woodsaj/repos","events_url":"https://api.github.com/users/woodsaj/events{/privacy}","received_events_url":"https://api.github.com/users/woodsaj/received_events","type":"User","site_admin":false},"created_at":"2015-12-22T15:57:41Z","updated_at":"2015-12-22T15:57:41Z","body":"This definitely looks like a bug in Cassandra.  Though i can't find any bug reports matching it.\r\n\r\nThis problem occurs when performing an open ended range '>' or '<' request.  ie, `ts < X` or `ts > X`.  If the range requests provides both an upper and lower bound, or uses '<=' or '>=' then the query works.\r\n\r\n```\r\ncqlsh:raintank> SELECT ts FROM metric WHERE key='1.9ba599efc9c4747d9e9729416de0b5e0_599' AND ts < 1450797001 limit 1;\r\nServerError: <ErrorMessage code=0000 [Server error] message=\"java.lang.ClassCastException: org.apache.cassandra.db.composites.Composites$EmptyComposite cannot be cast to org.apac\r\nhe.cassandra.db.composites.CellName\">\r\ncqlsh:raintank> SELECT ts FROM metric WHERE key='1.9ba599efc9c4747d9e9729416de0b5e0_599' AND ts <= 1450797099 limit 1;\r\n ts\r\n------------\r\n 1450797000\r\n(1 rows)\r\ncqlsh:raintank>\r\n```\r\n"}}