[
https://issues.apache.org/jira/browse/CASSANDRA-14940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Claude Warren updated CASSANDRA-14940:
--------------------------------------
Description:
*dInserting 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
was:
*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
> 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: Urgent
> 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
>
>
> *dInserting 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
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
