Unfortunately I'm using 2.1.2. Is it possible that I downgrade to 2.0.13
without wiping out the data? I'm worrying about if there is a bug in 2.1.2.


On Tue, Mar 31, 2015 at 4:37 AM, Paulo Ricardo Motta Gomes <
paulo.mo...@chaordicsystems.com> wrote:

>  What version of Cassandra are you running? Are you by any chance running
> repairs on your data?
>
> On Mon, Mar 30, 2015 at 5:39 PM, Benyi Wang <bewang.t...@gmail.com> wrote:
>
>> Thanks for replying.
>>
>> In cqlsh, if I change to Quorum (Consistency quorum), sometime the select
>> return the deleted row, sometime not.
>>
>> I have two virtual data centers: service (3 nodes) and analytics(4 nodes
>> collocate with Hadoop data nodes).The table has 3 replicas in service and 2
>> in analytics. When I wrote, I wrote into analytics using local_one. So I
>> guest the data may not replicated to all nodes yet.
>>
>> I will try to use strong consistency for write.
>>
>>
>>
>> On Mon, Mar 30, 2015 at 11:59 AM, Prem Yadav <ipremya...@gmail.com>
>> wrote:
>>
>>> Increase the read CL to quorum and you should get correct results.
>>> How many nodes do you have in the cluster and what is the replication
>>> factor for the keyspace?
>>>
>>> On Mon, Mar 30, 2015 at 7:41 PM, Benyi Wang <bewang.t...@gmail.com>
>>> wrote:
>>>
>>>> Create table tomb_test (
>>>>    guid text,
>>>>    content text,
>>>>    range text,
>>>>    rank int,
>>>>    id text,
>>>>    cnt int
>>>>    primary key (guid, content, range, rank)
>>>> )
>>>>
>>>> Sometime I delete the rows using cassandra java driver using this query
>>>>
>>>> DELETE FROM tomb_test WHERE guid=? and content=? and range=?
>>>>
>>>> in Batch statement with UNLOGGED. CONSISTENCE_LEVEL is local_one.
>>>>
>>>> But if I run
>>>>
>>>> SELECT * FROM tomb_test WHERE guid='guid-1' and content='content-1' and
>>>> range='week'
>>>> or
>>>> SELECT * FROM tomb_test WHERE guid='guid-1' and content='content-1' and
>>>> range='week' and rank = 1
>>>>
>>>> The result shows the deleted rows.
>>>>
>>>> If I run this select, the deleted rows are not shown
>>>>
>>>> SELECT * FROM tomb_test WHERE guid='guid-1' and content='content-1'
>>>>
>>>> If I run delete statement in cqlsh, the deleted rows won't show up.
>>>>
>>>> How can I fix this?
>>>>
>>>>
>>>
>>
>
>
> --
> *Paulo Motta*
>
> Chaordic | *Platform*
> *www.chaordic.com.br <http://www.chaordic.com.br/>*
> +55 48 3232.3200
>

Reply via email to