You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Caleb Rackliffe (Jira)" <ji...@apache.org> on 2025/02/03 17:14:00 UTC
[jira] [Updated] (CASSANDRA-20278) SAI range query returned duplicate results
[ https://issues.apache.org/jira/browse/CASSANDRA-20278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Caleb Rackliffe updated CASSANDRA-20278:
----------------------------------------
Epic Link: CASSANDRA-19224
> SAI range query returned duplicate results
> ------------------------------------------
>
> Key: CASSANDRA-20278
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20278
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/SAI
> Reporter: David Capwell
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x
>
>
> This was found by CASSANDRA-20156
> The query
> {code}
> SELECT * FROM ks1.tbl WHERE pk0 <= 899031163 -- pk0 int, indexed with SAI, on node1, fetch size 10
> {code}
> Returned duplicate rows, which was unexpected behavior. This test was first found on a multi node test, but it was rerun with a single node and reproduced there as well; the error and history are below
> Error
> {code}
> Caused by: java.lang.AssertionError: Unexpected results for query: SELECT * FROM ks1.tbl WHERE pk0 <= 899031163
> Caused by: java.lang.AssertionError: Duplicate row in response at row 17: [899031163, '166.83.96.184', '1976-01-10T17:24:38.783Z', false, 8201882284927653861, 00000000-0000-4400-b300-000000000000]
> Expected:
> pk0 | pk1 | ck0 | s0 | v0 | v1
> 39449600 | '81.198.103.152' | '2045-08-05T02:37:57.171Z' | true | -2476516224653398512 | 00000000-0000-4e00-b600-000000000000
> 39449600 | '81.198.103.152' | '2036-06-10T22:00:17.792Z' | true | -80747231541411067 | null
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2066-09-19T04:00:25.392Z' | null | 8590534382743815013 | 00000000-0000-4e00-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2061-11-20T03:37:53.545Z' | null | 1291125393530733493 | 00000000-0000-4400-8000-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2055-08-22T09:11:43.351Z' | null | 5849756315687015356 | 00000000-0000-4500-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2033-08-05T19:00:42.577Z' | null | null | 00000000-0000-4e00-b500-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2024-12-20T13:01:46.053Z' | null | -7968182913511381934 | 00000000-0000-4800-a300-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2017-02-18T11:21:43.841Z' | null | -9163063412452511790 | 00000000-0000-4e00-9500-000000000000
> -1588614995 | 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' | '2044-12-12T16:20:23.180Z' | false | -8119861318124410395 | 00000000-0000-4400-8a00-000000000000
> 899031163 | '166.83.96.184' | '2069-01-02T11:41:56.180Z' | false | -8679274544229216450 | null
> 899031163 | '166.83.96.184' | '2061-09-17T23:03:12.731Z' | false | 5137350797308537490 | 00000000-0000-4e00-9a00-000000000000
> 899031163 | '166.83.96.184' | '2060-12-05T18:37:09.359Z' | false | -5445897667865003538 | 00000000-0000-4f00-8e00-000000000000
> 899031163 | '166.83.96.184' | '2046-05-22T01:59:21.957Z' | false | 4069527879523850349 | 00000000-0000-4900-a600-000000000000
> 899031163 | '166.83.96.184' | '2041-05-26T01:48:18.393Z' | false | -1309942315708652688 | 00000000-0000-4e00-9000-000000000000
> 899031163 | '166.83.96.184' | '2023-11-28T14:35:29.979Z' | false | 1522521532393520102 | 00000000-0000-4e00-b500-000000000000
> 899031163 | '166.83.96.184' | '2018-05-27T13:34:49.688Z' | false | 4942506467166386576 | 00000000-0000-4000-af00-000000000000
> 899031163 | '166.83.96.184' | '1976-01-10T17:24:38.783Z' | false | 8201882284927653861 | 00000000-0000-4400-b300-000000000000
> -674540792 | '231.35.74.202' | '2015-01-16T13:44:30.399Z' | true | 8409782327800029767 | 00000000-0000-4300-8f00-000000000000
> -674540792 | '231.35.74.202' | '1990-02-17T08:46:41.775Z' | true | -3157133547435245197 | 00000000-0000-4e00-8400-000000000000
> -674540792 | '231.35.74.202' | '1973-01-10T03:07:46.590Z' | true | 7977795665840050417 | 00000000-0000-4300-af00-000000000000
> Actual:
> pk0 | pk1 | ck0 | s0 | v0 | v1
> 39449600 | '81.198.103.152' | '2045-08-05T02:37:57.171Z' | true | -2476516224653398512 | 00000000-0000-4e00-b600-000000000000
> 39449600 | '81.198.103.152' | '2036-06-10T22:00:17.792Z' | true | -80747231541411067 | null
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2066-09-19T04:00:25.392Z' | null | 8590534382743815013 | 00000000-0000-4e00-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2061-11-20T03:37:53.545Z' | null | 1291125393530733493 | 00000000-0000-4400-8000-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2055-08-22T09:11:43.351Z' | null | 5849756315687015356 | 00000000-0000-4500-9800-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2033-08-05T19:00:42.577Z' | null | null | 00000000-0000-4e00-b500-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2024-12-20T13:01:46.053Z' | null | -7968182913511381934 | 00000000-0000-4800-a300-000000000000
> -1604814500 | '2b38:8656:b4c3:662a:1129:ad75:c557:1959' | '2017-02-18T11:21:43.841Z' | null | -9163063412452511790 | 00000000-0000-4e00-9500-000000000000
> -1588614995 | 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' | '2044-12-12T16:20:23.180Z' | false | -8119861318124410395 | 00000000-0000-4400-8a00-000000000000
> 899031163 | '166.83.96.184' | '2069-01-02T11:41:56.180Z' | false | -8679274544229216450 | null
> 899031163 | '166.83.96.184' | '2061-09-17T23:03:12.731Z' | false | 5137350797308537490 | 00000000-0000-4e00-9a00-000000000000
> 899031163 | '166.83.96.184' | '2060-12-05T18:37:09.359Z' | false | -5445897667865003538 | 00000000-0000-4f00-8e00-000000000000
> 899031163 | '166.83.96.184' | '2046-05-22T01:59:21.957Z' | false | 4069527879523850349 | 00000000-0000-4900-a600-000000000000
> 899031163 | '166.83.96.184' | '2041-05-26T01:48:18.393Z' | false | -1309942315708652688 | 00000000-0000-4e00-9000-000000000000
> 899031163 | '166.83.96.184' | '2023-11-28T14:35:29.979Z' | false | 1522521532393520102 | 00000000-0000-4e00-b500-000000000000
> 899031163 | '166.83.96.184' | '2018-05-27T13:34:49.688Z' | false | 4942506467166386576 | 00000000-0000-4000-af00-000000000000
> 899031163 | '166.83.96.184' | '1976-01-10T17:24:38.783Z' | false | 8201882284927653861 | 00000000-0000-4400-b300-000000000000
> 899031163 | '166.83.96.184' | '1976-01-10T17:24:38.783Z' | false | 8201882284927653861 | 00000000-0000-4400-b300-000000000000
> -674540792 | '231.35.74.202' | '2015-01-16T13:44:30.399Z' | true | 8409782327800029767 | 00000000-0000-4300-8f00-000000000000
> -674540792 | '231.35.74.202' | '1990-02-17T08:46:41.775Z' | true | -3157133547435245197 | 00000000-0000-4e00-8400-000000000000
> -674540792 | '231.35.74.202' | '1973-01-10T03:07:46.590Z' | true | 7977795665840050417 | 00000000-0000-4300-af00-000000000000
> at org.apache.cassandra.harry.model.ASTSingleTableModel.validateNoDuplicates(ASTSingleTableModel.java:526)
> at org.apache.cassandra.harry.model.ASTSingleTableModel.validate(ASTSingleTableModel.java:458)
> {code}
> History
> {code}
> CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
> CREATE TABLE ks1.tbl (
> pk0 int,
> pk1 inet,
> ck0 timestamp,
> s0 boolean static,
> v0 bigint,
> v1 uuid,
> PRIMARY KEY ((pk0, pk1), ck0)
> ) WITH CLUSTERING ORDER BY (ck0 DESC)
> AND additional_write_policy = '99p'
> AND allow_auto_snapshot = true
> AND bloom_filter_fp_chance = 0.01
> AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
> AND cdc = false
> AND comment = ''
> AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
> AND compression = {'chunk_length_in_kb': '16', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
> AND memtable = 'default'
> AND crc_check_chance = 1.0
> AND default_time_to_live = 0
> AND extensions = {}
> AND gc_grace_seconds = 864000
> AND incremental_backups = true
> AND max_index_interval = 2048
> AND memtable_flush_period_in_ms = 0
> AND min_index_interval = 128
> AND read_repair = 'BLOCKING'
> AND speculative_retry = '99p';
> CREATE CUSTOM INDEX tbl_pk0 ON ks1.tbl(pk0) USING 'StorageAttachedIndex';
> CREATE INDEX tbl_pk1 ON ks1.tbl(pk1) USING 'SAI';
> CREATE CUSTOM INDEX tbl_ck0 ON ks1.tbl(ck0) USING 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_s0 ON ks1.tbl(s0) USING 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_v0 ON ks1.tbl(v0) USING 'StorageAttachedIndex';
> CREATE CUSTOM INDEX tbl_v1 ON ks1.tbl(v1) USING 'StorageAttachedIndex';: org.apache.cassandra.distributed.test.cql3.MultiNodeTableWalkTest.MultiNodeState
> History:
> 2: DELETE v1 FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 = 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 = '2055-10-08T04:23:08.001Z' -- on node1
> 3: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-674540792, '231.35.74.202', '1973-01-10T03:07:46.590Z', true, -1608632915548222072 + -8860315492321279127, 00000000-0000-4300-af00-000000000000) -- on node1
> 4: DELETE v0, v1, s0 FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 = 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 = '2036-05-27T15:59:40.725Z' -- on node1
> 6: DELETE FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 = 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 = '2016-05-14T07:50:09.449Z' -- on node1
> 9: UPDATE ks1.tbl SET s0=false, v0=1398032085572706939 * -2993723032305989674, v1=00000000-0000-4e00-9500-000000000000 WHERE pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND ck0 = '2017-02-18T11:21:43.841Z' -- on node1
> 10: UPDATE ks1.tbl SET v0=-3535561236849850017 * -8043433388328290760 WHERE pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 = '1971-10-27T07:57:08.066Z' -- on node1
> 13: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (942134495, '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3', '1978-08-29T04:29:27.730Z', true, -5389597202918249395 - -6026126177165020130, 00000000-0000-4f00-8200-000000000000) -- on node1
> 16: DELETE FROM ks1.tbl WHERE pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' -- on node1
> 23: UPDATE ks1.tbl SET v0=-1783520945422376140, v1=00000000-0000-4800-b000-000000000000 WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 = '2002-11-28T09:12:35.970Z' -- on node1
> 25: UPDATE ks1.tbl SET v0=1936354366539578581, v1=00000000-0000-4600-9f00-000000000000, s0=true WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 = '1988-10-09T01:31:28.554Z' -- on node1
> 26: INSERT INTO ks1.tbl (pk0, pk1, ck0, v0, v1) VALUES (39449600, '81.198.103.152', '1993-12-13T13:32:05.859Z', 1636375529996901105, 00000000-0000-4800-8f00-000000000000) -- on node1
> 27: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (899031163, '166.83.96.184', '1976-01-10T17:24:38.783Z', true, 8201882284927653861, 00000000-0000-4400-b300-000000000000) -- on node1
> 31: UPDATE ks1.tbl SET v0=7308869628918268475 - 2419563561742694375, v1=00000000-0000-4500-b800-000000000000, s0=false WHERE pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 = '2016-07-07T09:13:00.539Z' -- on node1
> 34: DELETE FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 = '2046-02-13T02:24:53.626Z' -- on node1
> 37: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-1604814500, '2b38:8656:b4c3:662a:1129:ad75:c557:1959', '2066-09-19T04:00:25.392Z', true, 8590534382743815013, 00000000-0000-4e00-9800-000000000000) -- on node1
> 42: UPDATE ks1.tbl SET v1=00000000-0000-4e00-b500-000000000000 WHERE pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND ck0 = '2033-08-05T19:00:42.577Z' -- on node1
> 48: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-1604814500, '2b38:8656:b4c3:662a:1129:ad75:c557:1959', '2061-11-20T03:37:53.545Z', true, 1291125393530733493, 00000000-0000-4400-8000-000000000000) -- on node1
> 50: UPDATE ks1.tbl SET v0=-6261429098999922749 - 7242808507543242291, v1=00000000-0000-4000-af00-000000000000 WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2018-05-27T13:34:49.688Z' -- on node1
> 51: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (39449600, '81.198.103.152', '2032-07-29T10:41:03.504Z', false, 4548936738637010119 * -4155195644767826103, 00000000-0000-4d00-8300-000000000000) -- on node1
> 52: UPDATE ks1.tbl SET v1=00000000-0000-4f00-ba00-000000000000, s0=false WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 = '1985-08-02T19:35:17.160Z' -- on node1
> 55: DELETE FROM ks1.tbl WHERE pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 = '2068-05-30T12:45:46.214Z' -- on node1
> 56: DELETE s0, s0 FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' -- on node1
> 57: DELETE FROM ks1.tbl WHERE pk0 = -674540792 AND pk1 = '231.35.74.202' AND ck0 = '2027-07-14T09:16:28.536Z' -- on node1
> 69: UPDATE ks1.tbl SET s0=true, v0=-2947636590983477748 - 8247102155612683121, v1=00000000-0000-4500-9b00-000000000000 WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 = '2011-10-30T23:31:12.495Z' -- on node1
> 78: UPDATE ks1.tbl SET s0=true, v0=2922387005817199167 * -7560409299577766895, v1=00000000-0000-4800-bd00-000000000000 WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 = '2032-09-30T05:32:09.786Z' -- on node1
> 81: UPDATE ks1.tbl SET v0=-3809815611870385136, v1=00000000-0000-4000-be00-000000000000 WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 = '1986-09-03T11:33:38.890Z' -- on node1
> 84: UPDATE ks1.tbl SET v0=4069527879523850349, v1=00000000-0000-4900-a600-000000000000 WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2046-05-22T01:59:21.957Z' -- on node1
> 85: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (899031163, '166.83.96.184', '2060-12-05T18:37:09.359Z', true, -5445897667865003538, 00000000-0000-4f00-8e00-000000000000) -- on node1
> 90: UPDATE ks1.tbl SET s0=false, v0=1522521532393520102, v1=00000000-0000-4e00-b500-000000000000 WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2023-11-28T14:35:29.979Z' -- on node1
> 96: DELETE s0 FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' -- on node1
> 98: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-674540792, '231.35.74.202', '2015-01-16T13:44:30.399Z', true, 8409782327800029767, 00000000-0000-4300-8f00-000000000000) -- on node1
> 101: UPDATE ks1.tbl SET v0=1597043131977600325 * 5466235106362256012, v1=00000000-0000-4500-9800-000000000000, s0=true WHERE pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND ck0 = '2055-08-22T09:11:43.351Z' -- on node1
> 104: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2026-09-10T09:05:17.045Z' -- on node1
> 106: UPDATE ks1.tbl SET s0=false, v0=7853943918757719482 * 8311442026616271709, v1=00000000-0000-4e00-9a00-000000000000 WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2061-09-17T23:03:12.731Z' -- on node1
> 107: UPDATE ks1.tbl SET s0=true, v0=9184601897606684178, v1=00000000-0000-4900-9500-000000000000 WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 = '2066-04-13T17:10:41.249Z' -- on node1
> 108: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-674540792, '231.35.74.202', '1990-02-17T08:46:41.775Z', true, -2068989779579395794 - 1088143767855849403, 00000000-0000-4e00-8400-000000000000) -- on node1
> 118: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-1588614995, 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe', '2044-12-12T16:20:23.180Z', false, -8119861318124410395, 00000000-0000-4400-8a00-000000000000) -- on node1
> 129: DELETE v0, v1 FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 = '2025-06-04T02:16:39.616Z' -- on node1
> 132: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (-1604814500, '2b38:8656:b4c3:662a:1129:ad75:c557:1959', '2024-12-20T13:01:46.053Z', false, -7968182913511381934, 00000000-0000-4800-a300-000000000000) -- on node1
> 139: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2021-02-16T03:32:23.585Z' -- on node1
> 140: DELETE s0, s0 FROM ks1.tbl WHERE pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' -- on node1
> 146: DELETE FROM ks1.tbl WHERE pk0 = 1725529242 AND pk1 = '117:867a:7a41:e846:36d5:1555:39c6:83f6' AND ck0 = '2005-04-29T06:16:39.217Z' -- on node1
> 149: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (1725529242, '117:867a:7a41:e846:36d5:1555:39c6:83f6', '1972-05-27T07:54:21.124Z', true, -5070627253851794547, 00000000-0000-4e00-b100-000000000000) -- on node1
> 150: DELETE FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 = 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 = '2019-09-09T03:26:32.918Z' -- on node1
> 165: DELETE FROM ks1.tbl WHERE pk0 = -1604814500 AND pk1 = '2b38:8656:b4c3:662a:1129:ad75:c557:1959' AND ck0 = '2068-02-02T09:30:37.941Z' -- on node1
> 170: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2044-10-25T22:52:54.949Z' -- on node1
> 184: DELETE FROM ks1.tbl WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' -- on node1
> 198: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (1725529242, '117:867a:7a41:e846:36d5:1555:39c6:83f6', '1992-10-25T01:43:46.783Z', true, 6351968542588291471 - 8198394538441004069, 00000000-0000-4800-8c00-000000000000) -- on node1
> 213: DELETE FROM ks1.tbl WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '1990-10-23T09:18:06.920Z' -- on node1
> 214: UPDATE ks1.tbl SET v0=-8299137650853321859 + -380136893375894591 WHERE pk0 = 899031163 AND pk1 = '166.83.96.184' AND ck0 = '2069-01-02T11:41:56.180Z' -- on node1
> 215: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (899031163, '166.83.96.184', '2041-05-26T01:48:18.393Z', false, -1309942315708652688, 00000000-0000-4e00-9000-000000000000) -- on node1
> 217: DELETE FROM ks1.tbl WHERE pk0 = -1588614995 AND pk1 = 'efb5:8821:b4df:cfa5:caa:789e:4972:ecfe' AND ck0 = '2042-05-11T02:00:40.702Z' -- on node1
> 224: UPDATE ks1.tbl SET v0=4244754967876539698 - 4325502199417950765, s0=true WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 = '2036-06-10T22:00:17.792Z' -- on node1
> 227: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v0, v1) VALUES (942134495, '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3', '2065-05-12T02:51:46.440Z', false, 8287983160203037938, 00000000-0000-4a00-9600-000000000000) -- on node1
> 228: nodetool flush ks1 tbl
> 229: UPDATE ks1.tbl SET v0=-6424812408535177370 * -4016939246762444862 WHERE pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' AND ck0 = '2041-08-28T15:34:53.914Z' -- on node1
> 232: UPDATE ks1.tbl SET v0=-2476516224653398512, v1=00000000-0000-4e00-b600-000000000000 WHERE pk0 = 39449600 AND pk1 = '81.198.103.152' AND ck0 = '2045-08-05T02:37:57.171Z' -- on node1
> 235: DELETE FROM ks1.tbl WHERE pk0 = 942134495 AND pk1 = '2d3d:d450:742d:5b39:5ad5:441e:9d02:44c3' -- on node1
> 242: SELECT * FROM ks1.tbl WHERE pk0 <= 899031163 -- pk0 int, indexed with SAI, on node1, fetch size 10
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org