Re: cqlsh doesn't make response in LCS setting

2016-07-21 Thread Yuji Ito
Thanks Alain I tried to make index before starting tests. The problem hasn't occurred for now. What happen if you run it on a screen and come back later to see if this > query completed successfully? The index was made after I forced the hanging cqlsh to stop. Which problem, cqlsh hanging or to

Re: cqlsh doesn't make response in LCS setting

2016-07-20 Thread Alain RODRIGUEZ
Hi Yuji Ito, I don't know Cassandra 2.2 that much and I try to avoid using indexes, but I imagine that what happened there is that creating the index took some time, and all the newly created data went to L0 and compaction was intensive as this node suddenly had a lot of pending compactions. From

cqlsh doesn't make response in LCS setting

2016-07-18 Thread Yuji Ito
Hi all, I have a question. I use Cassandra 2.2.6. Why does cqlsh sometimes make no response in LCS setting for compaction? I requested as below: cqlsh -e "create index new_index on keyspace.table (sub_column);" When this problem happened, Cassandra process used 100% CPU and debug.log was fill