cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Williams (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-7146) Cassandra returns to life deleted entries
Date Sat, 03 May 2014 16:58:16 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-7146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brandon Williams resolved CASSANDRA-7146.
-----------------------------------------

    Resolution: Cannot Reproduce

Doesn't reproduce against 2.1 head.  I recommend trying beta2 when it's released on Monday
and reopening if it happens there.

> 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
>
> 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)

Mime
View raw message