[jira] [Created] (CASSANDRA-14940) Cassandra update operation failed silently

["wings (JIRA)" <ji...@apache.org>]

wings created CASSANDRA-14940:
---------------------------------

             Summary: Cassandra update operation failed silently
                 Key: CASSANDRA-14940
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14940
             Project: Cassandra
          Issue Type: Bug
         Environment: ENV：

    {color:#FF0000}Single Cassandra node{color}
    Ubuntu 16.04 LTS
    Memory: 7.8 GiB
    Processor: Intel® Core™ i7-7700K CPU @ 4.20GHz × 8
    go: v1.9.2
    github.com/gocql/gocql : 70385f88b28b43805bd83d212169ab2d38810b15
    github.com/scylladb/gocqlx: dcec9d031fb594a4bc470473d1c98d33656f93e6
    docker image: cassandra:lastest(8ea89760ce2b)
            Reporter: wings
         Attachments: demo.tar.gz

*Inserting a piece of data into Cassandra and then updating this data may fail silently.*
  
 
 
Operation record： # 
sudo docker run -d -v /home/xxx/Desktop/demo/:/demo cassandra
 # 
sudo docker ps
{color:#FF0000}CONTAINER ID{color}  IMAGE
df35191c6957     cassandra
 
 # 
sudo docker exec -it df35191c6957 bash
-----------------------------------------------------------
{color:#FF0000}root@df35191c6957{color}:/# cd /demo/cassandra/
{color:#FF0000}root@df35191c6957{color}:/demo/cassandra# ./cassandra -order init
Create KeySpace: wqg
Init Cassandra Env Sucess
{color:#FF0000}root@df35191c6957{color}:/demo/cassandra# ./cassandra -l 50 -s 0
Clean Done
Insert Success: 0
Update Success: 0
.........
Insert Success: 23
Update Success: 23
.........
Insert Success: 49
Update Success: 49
{color:#FF0000}*[Abnormal]: 23*{color}
 
{color:#FF0000}root@df35191c6957{color}:/demo/cassandra# cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.3 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
cqlsh> select * from wqg.info where id=23;
id | deleted | name | time
----+---------+-------------+---------------------------------
23 | {color:#FF0000}False{color} | wqg-test-23 | 2018-12-18 09:58:11.777000+0000

(1 rows)

 
Fake code:
{code:java}
for i := 0; i < 50; i ++ {
    // sql: INSERT INTO info (id,name,time,deleted) VALUES (?,?,?,?)
    // NOTICE: The delete field will be set to "false"
    insert()

    // sql: UPDATE %s SET deleted = ? WHERE id = ? IF deleted=False
    // NOTICE: The delete field will be set to "true"
    update()
}
 
{code}


 
If you can't reproduce, increase the number of loops, for example "./cassandra -l 100 -s 0"
 
Thanks
 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org