You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Joaquin Casares (JIRA)" <ji...@apache.org> on 2011/07/13 19:10:59 UTC

[jira] [Created] (CASSANDRA-2896) Del command doesn't work in cli

Del command doesn't work in cli
-------------------------------

                 Key: CASSANDRA-2896
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
             Project: Cassandra
          Issue Type: Bug
    Affects Versions: 0.8.0
            Reporter: Joaquin Casares
             Fix For: 0.8.2


[default@unknown] connect localhost/9160;
Connected to: "Test Cluster" on localhost/9160
[default@unknown] use test;
Authenticated to keyspace: test
[default@test] get test[123][123];    
=> (column=0123, value=31, timestamp=1310576784324000)
[default@test] del test[123][123];    
column removed.
[default@test] get test[123][123];
=> (column=0123, value=31, timestamp=1310576784324000)

Does the same in 0.8.1 still.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Joaquin Casares (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joaquin Casares updated CASSANDRA-2896:
---------------------------------------

    Description: 
[default@unknown] connect localhost/9160;
Connected to: "Test Cluster" on localhost/9160
[default@unknown] use test;
Authenticated to keyspace: test
[default@test] get test[123][123];    
=> (column=0123, value=31, timestamp=1310576784324000)
[default@test] del test[123][123];    
column removed.
[default@test] get test[123][123];
=> (column=0123, value=31, timestamp=1310576784324000)

Does the same in 0.8.1 still both times in a single node.

  was:
[default@unknown] connect localhost/9160;
Connected to: "Test Cluster" on localhost/9160
[default@unknown] use test;
Authenticated to keyspace: test
[default@test] get test[123][123];    
=> (column=0123, value=31, timestamp=1310576784324000)
[default@test] del test[123][123];    
column removed.
[default@test] get test[123][123];
=> (column=0123, value=31, timestamp=1310576784324000)

Does the same in 0.8.1 still.


> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Assigned] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis reassigned CASSANDRA-2896:
-----------------------------------------

    Assignee: Pavel Yaskevich

> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Brandon Williams (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams resolved CASSANDRA-2896.
-----------------------------------------

    Resolution: Duplicate

Fixed by CASSANDRA-2821

> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13066088#comment-13066088 ] 

Pavel Yaskevich commented on CASSANDRA-2896:
--------------------------------------------

We assume that column was removed if thrift call returned without an error that is why it returns "column removed".

Running cassandra-0.8 branch does not have such an error and tests pass:

{noformat}
[default@unknown] connect localhost/9160;
Connected to: "Test Cluster" on localhost/9160
[default@unknown] create keyspace test;
c9ec9fe0-af05-11e0-0000-242d50cf1f9f
Waiting for schema agreement...
... schemas agree across the cluster
[default@unknown] use test;
Authenticated to keyspace: test
[default@test] create column family test;
d0999be0-af05-11e0-0000-242d50cf1f9f
Waiting for schema agreement...
... schemas agree across the cluster
[default@test] set test[123][123] = 1;
Value inserted.
[default@test] list test;
Using default limit of 100
-------------------
RowKey: 0123
=> (column=0123, value=31, timestamp=1310750040745000)

1 Row Returned.
[default@test] del test[123][123];
column removed.
[default@test] list test;
Using default limit of 100
-------------------
RowKey: 0123

1 Row Returned.
[default@test] get test[123][123];
Value was not found
[default@test]
{noformat}

I assume that we should close this one with Not a problem.

> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13065890#comment-13065890 ] 

Pavel Yaskevich commented on CASSANDRA-2896:
--------------------------------------------

Seems like you have a problem with comparator/validator on our CF, that's is why CLI can't delete row. Can you please post your CF schema?

Tested on latest cassandra-0.8 branch.

{noformat}
Connected to: "Test Cluster" on localhost/9160
eWelcome to the Cassandra CLI.

Type 'help;' or '?' for help.
Type 'quit;' or 'exit;' to quit.

[default@unknown] create keyspace ks;
3f54f520-aede-11e0-0000-242d50cf1ffc
Waiting for schema agreement...
... schemas agree across the cluster
[default@unknown] use ks;
Authenticated to keyspace: ks
[default@ks] CREATE COLUMN FAMILY test WITH comparator = UTF8Type AND default_validation_class = UTF8Type AND key_validation_class = UTF8Type;
482df8e0-aede-11e0-0000-242d50cf1ffc
Waiting for schema agreement...
... schemas agree across the cluster
[default@ks] set test[123][123] = 31;
Value inserted.
[default@ks] list test;
Using default limit of 100
-------------------
RowKey: 123
=> (column=123, value=31, timestamp=1310733064224000)

1 Row Returned.
[default@ks] del test[123][123];
column removed.
[default@ks] list test;
Using default limit of 100
-------------------
RowKey: 123

1 Row Returned.
[default@ks]
{noformat}

> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Joaquin Casares (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13066095#comment-13066095 ] 

Joaquin Casares commented on CASSANDRA-2896:
--------------------------------------------

Weird, this is what I get:


[default@unknown] connect localhost/9160;
Connected to: "Test Cluster" on localhost/9160
[default@unknown] create keyspace test;
920cb3a0-af08-11e0-0000-242d50cf1fff
Waiting for schema agreement...
... schemas agree across the cluster
[default@unknown] use test;          
Authenticated to keyspace: test
[default@test] create column family test;
9a2fd4e0-af08-11e0-0000-242d50cf1fff
Waiting for schema agreement...
... schemas agree across the cluster
[default@test] set test[123][123]=1;
Value inserted.
[default@test] get test[123][123]=1;
Syntax error at position 18: missing EOF at '='
[default@test] get test[123][123];  
=> (column=0123, value=31, timestamp=1310751238633000)
[default@test] del test[123][123];
column removed.
[default@test] get test[123][123];
=> (column=0123, value=31, timestamp=1310751238633000)
[default@test] list test;
Using default limit of 100
-------------------
RowKey: 313233
-------------------
RowKey: 0123
=> (column=0123, value=31, timestamp=1310751238633000)

2 Rows Returned.
[default@test] del test[123][123];
column removed.
[default@test] list test;         
Using default limit of 100
-------------------
RowKey: 313233
-------------------
RowKey: 0123
=> (column=0123, value=31, timestamp=1310751238633000)

2 Rows Returned.
[default@test] 


After removing /var/lib/cassandra and running ant clean && ant after:

Joaquin-Casaress-MacBook-Pro:git-cassandra joaquin$ git checkout cassandra-0.8
Previous HEAD position was 4cdffba... Create 0.8.1 tag
Switched to branch 'cassandra-0.8'
Your branch is behind 'origin/cassandra-0.8' by 75 commits, and can be fast-forwarded.
Joaquin-Casaress-MacBook-Pro:git-cassandra joaquin$ git pull


> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-2896) Del command doesn't work in cli

Posted by "Joaquin Casares (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13066081#comment-13066081 ] 

Joaquin Casares commented on CASSANDRA-2896:
--------------------------------------------

I ran this on the 0.8.0 and 0.8.1 tags.

I created the column family by running:
create column family test;

So if it's a problem with the comparator/validator, then perhaps we should throw a related error instead of the message "column removed" when it wasn't removed.

> Del command doesn't work in cli
> -------------------------------
>
>                 Key: CASSANDRA-2896
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2896
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.0
>            Reporter: Joaquin Casares
>            Assignee: Pavel Yaskevich
>             Fix For: 0.8.2
>
>
> [default@unknown] connect localhost/9160;
> Connected to: "Test Cluster" on localhost/9160
> [default@unknown] use test;
> Authenticated to keyspace: test
> [default@test] get test[123][123];    
> => (column=0123, value=31, timestamp=1310576784324000)
> [default@test] del test[123][123];    
> column removed.
> [default@test] get test[123][123];
> => (column=0123, value=31, timestamp=1310576784324000)
> Does the same in 0.8.1 still both times in a single node.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira