[jira] [Commented] (CASSANDRA-7293) Not able to delete a cell with timeuuid as part of clustering key

["Ananthkumar K S (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-7293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14008061#comment-14008061 ] 

Ananthkumar K S commented on CASSANDRA-7293:
--------------------------------------------

This started happening post a simple batch delete I tried in a loop .

Here is the scenario.

I have a table with 280 entries. All are in same partition.

I am running a batched delete(10 queries in a batch in a synchronised manner). At the end, I try to check if there is any entry left out to try and delete that. But found none of 280 got deleted.

When I stop the process and execute the cql command in cqlsh in server, I get the same problem(Entry doesn't get deleted). Is it a range scan death problem?

I have found 2.0.3 a bit stable after sometime of usage. Any specific bug similar to this is being solved in 2.0.7 or any other big bug solved?

> Not able to delete a cell with timeuuid as part of clustering key
> -----------------------------------------------------------------
>
>                 Key: CASSANDRA-7293
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7293
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: Java
>            Reporter: Ananthkumar K S
>            Priority: Minor
>             Fix For: 2.0.3
>
>
> **My keyspace definition**
> aa
> {
>  classname text,
>   jobid timeuuid,
>   jobdata text,
> }
> **Values in it now:**
> classname                                  | jobid                                | jobdata
> --------------------------------------------+--------------------------------------+--------
>  VVVVVVVV | 047a6130-e25a-11e3-83a5-8d12971ccb90 | {}
>  vvvvv | 3d176010-e250-11e3-83a5-8d12971ccb91 | {}
>  vvvvv | 3d176010-e250-11e3-83a5-8d12971ccb92 | {}
> Now when i delete this with following query
> **delete from aa where classname='VVVVVVVV' and jobid = 047a6130-e25a-11e3-83a5-8d12971ccb90;**
> **Result is :**
> classname | jobid | jobdata
> ------------------------------------------------------
>  VVVVVVVV | 047a6130-e25a-11e3-83a5-8d12971ccb90 | {}
>  vvvvv | 3d176010-e250-11e3-83a5-8d12971ccb91 | {}
>  vvvvv | 3d176010-e250-11e3-83a5-8d12971ccb92 | {}
> The portion never got deleted. When i use a long value instead of timeuuid, it works.
> Any problem with respect to timeuuid in deletion
> **Cassandra version : 2.0.3**



--
This message was sent by Atlassian JIRA
(v6.2#6252)