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:31:48 GMT
I was able to reproduce with CLI.  I'll send over the example as soon
as I can obfuscate it.

-brian

On Thu, Oct 4, 2012 at 3:19 PM, Jonathan Ellis <jbellis@gmail.com> wrote:
> Nothing jumps out at me, varchar should be pretty straightforward.
> Probably going to need a test case.  (Even better if you can repro w/
> cli instead of needing Astyanax.)
>
> On Thu, Oct 4, 2012 at 2: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
>
>
>
> --
> 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

Mime
View raw message