[
https://issues.apache.org/jira/browse/CASSANDRA-14940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wings updated CASSANDRA-14940:
------------------------------
Attachment: session.txt
> 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
> Priority: Critical
> Attachments: Screenshot from 2018-12-18 19-03-19.png, Screenshot from
> 2018-12-18 19-04-49.png, demo.tar.gz, event.txt, event.txt, session.txt,
> session.txt, test.txt, test.txt
>
>
> *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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
