Here you go... ERROR 14:57:37,270 Error occurred during processing of message. java.lang.ArrayIndexOutOfBoundsException: 4 at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:773) at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137) at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108) at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121) at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1237) at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542) at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34) at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680)
On Thu, Oct 4, 2012 at 3:15 PM, Brian O'Neill <b...@alumni.brown.edu> wrote: > Obfuscated slightly.... > > The table is something simliar to: > > CREATE TABLE data ( > uid varchar, > t timestamp, > foo varchar, > bar varchar, > PRIMARY KEY (uid, t, foo, bar) > ); > > Then I can insert just fine via Astyanax and I can see the row via > cli, but the select statement fails in cqlsh. > > The table is fine, when I only interact with it through CQL. I can > insert and select fine, until I insert a row from Asytanax. > > If needed, I can probably create a small test for this that I can share. > > -brian > > > > On Thu, Oct 4, 2012 at 3:08 PM, Jonathan Ellis <jbel...@gmail.com> wrote: >> What kind of data did you insert, and what was expected? Expected >> behavior would be to reject nonconforming data at insert time. >> >> On Thu, Oct 4, 2012 at 2:04 PM, Brian O'Neill <b...@alumni.brown.edu> wrote: >>> This is probably already on your radar, but we could use a better >>> error message from cqlsh when the column key doesn't conform to the >>> expected schema... >>> >>> I accidentally inserted data using Astyanax that didn't conform to the >>> schema. After that, selects from that table via cqlsh return no >>> useful information. >>> (CLI shows the data just fine) >>> >>> >>> bone@boneill-macbook-wired:~/tools/cassandra-> bin/cassandra-cli >>> Connected to: "Test Cluster" on 127.0.0.1/9160 >>> Welcome to Cassandra CLI version 1.1.5 >>> >>> Type 'help;' or '?' for help. >>> Type 'quit;' or 'exit;' to quit. >>> >>> [default@unknown] use cirrus; >>> Authenticated to keyspace: cirrus >>> [default@cirrus] list data; >>> Using default limit of 100 >>> Using default column limit of 100 >>> ------------------- >>> RowKey: PI7JC8 >>> => (column=*****, value=2014-07-31, timestamp=1349376866686000) >>> ------------------- >>> RowKey: PI1234 >>> => (column=*****, value=Y, timestamp=1349372660453000) >>> >>> 2 Rows Returned. >>> Elapsed time: 212 msec(s). >>> [default@cirrus] quit; >>> bone@boneill-macbook-wired:~/tools/cassandra-> bin/cqlsh -3 >>> Connected to Test Cluster at localhost:9160. >>> [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 3.0.0 | Thrift protocol 19.32.0] >>> Use HELP for help. >>> cqlsh> use cirrus; >>> cqlsh:cirrus> select * from data; >>> TSocket read 0 bytes >>> cqlsh:cirrus> >>> >>> -- >>> Brian ONeill >>> Lead Architect, Health Market Science (http://healthmarketscience.com) >>> mobile:215.588.6024 >>> blog: http://brianoneill.blogspot.com/ >>> twitter: @boneill42 >> >> >> >> -- >> Jonathan Ellis >> Project Chair, Apache Cassandra >> co-founder of DataStax, the source for professional Cassandra support >> http://www.datastax.com > > > > -- > Brian ONeill > Lead Architect, Health Market Science (http://healthmarketscience.com) > > mobile:215.588.6024 > blog: http://brianoneill.blogspot.com/ > twitter: @boneill42 -- Brian ONeill Lead Architect, Health Market Science (http://healthmarketscience.com) mobile:215.588.6024 blog: http://brianoneill.blogspot.com/ twitter: @boneill42