1 strange issue with 1.1.5 .
It works with CQL3:
**************************************************************************************************************************************************8
CREATE TABLE altercations (
... instigator text,
... started_at timestamp,
... ships_destroyed int,
... energy_used float,
... alliance_involvement boolean,
... PRIMARY KEY (instigator,started_at)
... );
cqlsh:testcomp> drop columnfamily altercations;
cqlsh:testcomp> CREATE TABLE altercations (
... instigator text,
... started_at timestamp,
... ships_destroyed int,
... energy_used float,
... alliance_involvement boolean,
... PRIMARY KEY (instigator,started_at,ships_destroyed)
... );
cqlsh:testcomp> INSERT INTO altercations (instigator, started_at,
ships_destroyed,
... energy_used,
alliance_involvement)
... VALUES ('Jayne Cobb', '2012-07-23', 2,
4.6, 'false');
cqlsh:testcomp> select * from altercations;
instigator | started_at | ships_destroyed |
alliance_involvement | energy_used
------------+--------------------------+-----------------+----------------------+-------------
Jayne Cobb | 2012-07-23 00:00:00+0000 | 2 |
False | 4.6
**************************************************************************************************************************************************8
But after this when i try with cassandra-cli (to fetch this record):
[default@testcomp] list altercations;
Using default limit of 100
Using default column limit of 100
-------------------
RowKey: Jayne Cobb
=> (column=2012-07-23 00:00:00+0530:2:alliance_involvement, value=,
timestamp=1349772570037000)
invalid UTF8 bytes 40933333
gives me {invalid UTF8 bytes 40933333}
Not sure, whether it will behave in same way if i go with thrift java
client? Is this a problem CQL or thrift API?
-Vivek
On Tue, Oct 9, 2012 at 2:14 PM, Vivek Mishra <mishra.v...@gmail.com> wrote:
> Works fine with 1.1.5
>
> Thanks,
> -Vivek
>
>
> On Tue, Oct 9, 2012 at 1:59 PM, Vivek Mishra <mishra.v...@gmail.com>wrote:
>
>> I am going to try it on 1.1.5
>>
>> In case if you can point me to changes made in between since 1.1.2 to
>> 1.1.5 . It will be great.
>>
>> -Vivek
>>
>>
>> On Tue, Oct 9, 2012 at 1:51 PM, Sylvain Lebresne <sylv...@datastax.com>wrote:
>>
>>> On Tue, Oct 9, 2012 at 9:50 AM, Vivek Mishra <mishra.v...@gmail.com>
>>> wrote:
>>> > Unfortunately nothing in server logs leads me to any error.
>>>
>>> Ok. Would you mind checking if you can reproduce against 1.1.5 if you
>>> haven't already. If it does, do you mind opening a JIRA ticket with
>>> the steps to reproduce?
>>>
>>> Thanks,
>>> Sylvain
>>>
>>> >
>>> > -Vivek
>>> >
>>> >
>>> > On Tue, Oct 9, 2012 at 1:16 PM, Sylvain Lebresne <sylv...@datastax.com
>>> >
>>> > wrote:
>>> >>
>>> >> On Tue, Oct 9, 2012 at 8:57 AM, Vivek Mishra <mishra.v...@gmail.com>
>>> >> wrote:
>>> >> > Ok. I am able to understand the problem now. Issue is:
>>> >> >
>>> >> > If i create a column family altercations as:
>>> >> >
>>> >> >
>>> >> >
>>> **********************************************************************************************************8
>>> >> > CREATE TABLE altercations (
>>> >> > instigator text,
>>> >> > started_at timestamp,
>>> >> > ships_destroyed int,
>>> >> > energy_used float,
>>> >> > alliance_involvement boolean,
>>> >> > PRIMARY KEY (instigator,started_at,ships_destroyed)
>>> >> > );
>>> >> > /
>>> >> > INSERT INTO altercations (instigator, started_at,
>>> ships_destroyed,
>>> >> > energy_used, alliance_involvement)
>>> >> > VALUES ('Jayne Cobb', '2012-07-23', 2, 4.6,
>>> >> > 'false');
>>> >> >
>>> >> >
>>> *********************************************************************************************************************
>>> >> >
>>> >> > it works!
>>> >> >
>>> >> > But if i create a column family with compound primary key with 2
>>> >> > composite
>>> >> > column as:
>>> >> >
>>> >> > CREATE TABLE altercations (
>>> >> > instigator text,
>>> >> > started_at timestamp,
>>> >> > ships_destroyed int,
>>> >> > energy_used float,
>>> >> > alliance_involvement boolean,
>>> >> > PRIMARY KEY (instigator,started_at)
>>> >> > );
>>> >> >
>>> >> >
>>> >> >
>>> *********************************************************************************************************************
>>> >> > and Then drop this column family:
>>> >> >
>>> >> > drop columnfamily altercations;
>>> >> >
>>> >> > and then try to create same one with primary compound key with 3
>>> >> > composite
>>> >> > column:
>>> >> >
>>> >> > CREATE TABLE altercations (
>>> >> > instigator text,
>>> >> > started_at timestamp,
>>> >> > ships_destroyed int,
>>> >> > energy_used float,
>>> >> > alliance_involvement boolean,
>>> >> > PRIMARY KEY (instigator,started_at,ships_destroyed)
>>> >> > );
>>> >> >
>>> >> > it gives me error: "TSocket read 0 bytes"
>>> >> >
>>> >> > Rest, as no column family is created, so nothing onwards will work.
>>> >> >
>>> >> > Is this an issue?
>>> >>
>>> >> Sounds like it yes (I mean the theory is, you shouldn't ever get such
>>> >> an error by creating and dropping tables. Even if you do something
>>> >> wrong, you should get a meaningful error).
>>> >>
>>> >> Is there an exception in the log server side? (it's often the case
>>> >> with a "TSocket read 0 bytes").
>>> >>
>>> >> --
>>> >> Sylvain
>>> >
>>> >
>>>
>>
>>
>
