You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Rodion (JIRA)" <ji...@apache.org> on 2014/05/03 17:20:14 UTC
[jira] [Updated] (CASSANDRA-7146) Cassandra returns to life deleted
entries
[ https://issues.apache.org/jira/browse/CASSANDRA-7146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rodion updated CASSANDRA-7146:
------------------------------
Fix Version/s: (was: 2.0.7)
> Cassandra returns to life deleted entries
> -----------------------------------------
>
> Key: CASSANDRA-7146
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7146
> Project: Cassandra
> Issue Type: Bug
> Reporter: Rodion
> Fix For: 2.0.7
>
>
> I'm testing Cassandra Version: 2.1.0~beta1 and getting into a very strange thing.
> This is my schema:
> CREATE TABLE userlines (
> username text,
> time timeuuid,
> msg_id uuid,
> PRIMARY KEY (username, time)
> ) WITH CLUSTERING ORDER BY (time DESC)
> First, I'm trying to INSERT something into this empty Columns Family:
> cqlsh:cequel> select * from userlines;
>
> (0 rows)
>
> cqlsh:cequel> INSERT INTO userlines (username, msg_id, time) VALUES ('admin', ad18dbf8-d2bc-11e3-9bc1-47ba2f5b0f02, c9553f3c-d2bc-11e3-b650-255df2f099c5);
> cqlsh:cequel> select * from userlines;
>
> username | time | msg_id
> ----------+--------------------------------------+--------------------------------------
> admin | c9553f3c-d2bc-11e3-b650-255df2f099c5 | ad18dbf8-d2bc-11e3-9bc1-47ba2f5b0f02
>
> (1 rows)
> Then DELETE this entry:
>
> cqlsh:cequel> DELETE FROM userlines WHERE username = 'admin' and time = c9553f3c-d2bc-11e3-b650-255df2f099c5;
> cqlsh:cequel> select * from userlines;
>
> (0 rows)
> And then INSERT same entry, but increment the last digit of Time column:
>
> cqlsh:cequel> INSERT INTO userlines (username, msg_id, time) VALUES ('admin', ad18dbf8-d2bc-11e3-9bc1-47ba2f5b0f02, c9553f3c-d2bc-11e3-b650-255df2f099c6);
> cqlsh:cequel> select * from userlines;
>
> username | time | msg_id
> ----------+--------------------------------------+--------------------------------------
> admin | c9553f3c-d2bc-11e3-b650-255df2f099c6 | ad18dbf8-d2bc-11e3-9bc1-47ba2f5b0f02
> admin | c9553f3c-d2bc-11e3-b650-255df2f099c5 | ad18dbf8-d2bc-11e3-9bc1-47ba2f5b0f02
>
> (2 rows)
> Now, after inserting just a one entry, I get two.
> So, an old entry returns after another INSERT operation.
> In Version 2.0.7 All is fine.
--
This message was sent by Atlassian JIRA
(v6.2#6252)