incubator-cassandra-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian O'Neill" <b...@alumni.brown.edu>
Subject Re: TSocket read 0 bytes from cqlsh
Date Thu, 04 Oct 2012 19:18:06 GMT
>From this, I assume I inserted the wrong number of values into the
compound key from Astyanax.  It would be nice to carry this error
across to the CQL client.

-brian

On Thu, Oct 4, 2012 at 3:17 PM, Brian O'Neill <bone@alumni.brown.edu> wrote:
> 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 <bone@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 <jbellis@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 <bone@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



-- 
Brian ONeill
Lead Architect, Health Market Science (http://healthmarketscience.com)

mobile:215.588.6024
blog: http://brianoneill.blogspot.com/
twitter: @boneill42

Mime
View raw message