Also, it results in "Broken pipe" error on cqlsh. Not sure why socket
connection got broken as well.
-Vivek
On Tue, Oct 9, 2012 at 1:20 PM, Vivek Mishra <mishra.v...@gmail.com> wrote:
> Unfortunately nothing in server logs leads me to any error.
>
> -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
>>
>
>
