[
https://issues.apache.org/jira/browse/CASSANDRA-20338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939034#comment-17939034
]
David Capwell commented on CASSANDRA-20338:
-------------------------------------------
Here is another seed, but slightly different (using this one JIRA to triage
rather than have many JIRAs with slightly different shapes)
https://github.com/apache/cassandra/pull/4006
SHA: 57755ffe8c7954dbfc0ef4a50a2182c5cbbcff99
JDK: 11
Test: org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest
{code}
accord.utils.Property$PropertyError: Property error detected:
Seed = 1746205502103206170
Examples = 1
Pure = true
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
CREATE TYPE IF NOT EXISTS
ks1."Q0ddEgd4faJoB_A1w29KhEF7bar5FJzc4RBD9bdsVPcP8Hgb" (
f0 varint,
f1 int
);;
CREATE TABLE ks1.tbl (
pk0 tinyint,
pk1 text,
ck0 timestamp,
s0 boolean static,
s1
vector<frozen<"Q0ddEgd4faJoB_A1w29KhEF7bar5FJzc4RBD9bdsVPcP8Hgb">, 1> static,
v0 boolean,
v1 frozen<tuple<frozen<list<varint>>,
frozen<tuple<double>>, frozen<set<time>>>>,
v2 date,
v3 bigint,
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.UnifiedCompactionStrategy',
'only_purge_repaired_tombstones': 'false'}
AND compression = {'chunk_length_in_kb': '16', 'class':
'org.apache.cassandra.io.compress.ZstdCompressor'}
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 INDEX tbl_pk0 ON ks1.tbl(pk0) USING 'SAI';
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';
CREATE CUSTOM INDEX tbl_v2 ON ks1.tbl(v2) USING
'StorageAttachedIndex';
CREATE INDEX tbl_v3 ON ks1.tbl(v3) USING 'SAI';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
3: DELETE FROM ks1.tbl USING TIMESTAMP 2 WHERE pk0 = 107 AND
pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '1977-09-07T03:25:55.066Z' -- on node1
4: INSERT INTO ks1.tbl (pk0, pk1, ck0, v2) VALUES (107,
'ꣵ灗큨猃灹⏦㜁쑼憠', '2022-08-02T13:04:29.502Z', '-1213322-04-04') USING TIMESTAMP 3 --
on node1
29: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2, v3)
VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2057-08-09T08:20:36.163Z', true, [{f0: 0, f1:
384813393}], true, ([-1439831], (-2.8199785995473652E-226),
{'03:43:51.678894048', '15:36:33.314253972', '23:35:45.707393476'}),
'-4608610-11-18', -5975796022684081762) USING TIMESTAMP 6 -- on node1
34: UPDATE ks1.tbl USING TIMESTAMP 7 SET s0=false, s1=[{f0:
-251439, f1: -696923442}], v0=true, v1=([-12156417], (-1.6276025144344375E-26),
{'04:09:49.993428854', '18:33:52.213764689'}), v2='-2995783-12-25',
v3=6055326556237378688 WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 =
'2011-11-10T23:51:30.608Z' -- on node1
49: INSERT INTO ks1.tbl (pk0, pk1, ck0, v1) VALUES (107,
'ꣵ灗큨猃灹⏦㜁쑼憠', '2014-02-26T04:02:09.073Z', ([0, 12415], (-3.117435977224081E-48),
{'01:00:25.161793934', '08:02:28.505521754', '08:27:16.195326420'})) USING
TIMESTAMP 11 -- on node1
71: UPDATE ks1.tbl USING TIMESTAMP 17 SET s0=true, s1=[{f0:
19119138, f1: 1929880772}], v0=true, v1=([0], (3.2087149600532263E75),
{'15:26:18.912551252'}), v2='-2708113-11-07', v3=-5407144195768047242 WHERE
pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2020-06-18T21:27:59.421Z' -- on
node1
75: INSERT INTO ks1.tbl (pk0, pk1, ck0, v0, v1, v2, s0, v3)
VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2064-01-08T00:16:45.786Z', true, ([241186599],
(-3.575672122286255E-49), {'13:03:45.492808507'}), '-605168-07-22', true,
-6673233651437294232) USING TIMESTAMP 19 -- on node1
89: INSERT INTO ks1.tbl (pk0, pk1, ck0, v2) VALUES (107,
'ꣵ灗큨猃灹⏦㜁쑼憠', '1984-12-16T13:15:35.288Z', '-4887293-07-17') USING TIMESTAMP 21
-- on node1
95: DELETE FROM ks1.tbl USING TIMESTAMP 23 WHERE pk0 = 107 AND
pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2000-06-29T18:51:58.042Z' -- on node1
99: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2, v3)
VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2032-02-19T07:23:33.224Z', false, [{f0: -25311, f1:
-1512986568}], true, ([0], (1.0312920706246176E-274), {'03:13:21.706723041'}),
'-5469621-11-09', null) USING TIMESTAMP 24 -- on node1
115: UPDATE ks1.tbl USING TIMESTAMP 26 SET v0=false WHERE pk0
= 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2050-03-07T20:19:36.309Z' -- on node1
120: DELETE FROM ks1.tbl USING TIMESTAMP 27 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2052-04-10T15:35:53.577Z' -- on node1
123: UPDATE ks1.tbl USING TIMESTAMP 29 SET s0=true, s1=[{f0:
3486422, f1: 191348080}], v0=false, v1=([-1339316516],
(-7.023605048038695E-127), {'21:25:12.357957524'}), v2='-2978829-09-15',
v3=1135416572354541674 WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 =
'1999-09-09T23:50:13.116Z' -- on node1
131: DELETE FROM ks1.tbl USING TIMESTAMP 30 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' -- on node1
146: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
v3) VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2045-10-05T23:02:21.811Z', null, [{f0: -41, f1:
2087559665}], true, ([0, -1238316084, -2329], (-6.083877478577705E60),
{'04:18:36.692622432'}), '-614585-01-18', 1884771267245179089) USING TIMESTAMP
32 -- on node1
151: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
v3) VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2066-03-03T18:52:43.189Z', false, [{f0: 57425,
f1: 733043193}], false, ([112815329], (2.1263252622442584E82),
{'16:31:11.545773101'}), '-1182244-05-25', -8814465802818360141) USING
TIMESTAMP 35 -- on node1
156: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
v3) VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '1975-01-29T11:24:33.637Z', false, [{f0: 0, f1:
-1507495158}], false, ([0, 145323709, 1545676006], (-2.1924535164881936E136),
{'23:30:02.307622080'}), '-2314061-04-28', 893947983054907186) USING TIMESTAMP
37 -- on node1
165: DELETE FROM ks1.tbl USING TIMESTAMP 40 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' -- on node1
170: UPDATE ks1.tbl USING TIMESTAMP 42 SET s0=true, s1=[{f0:
-525571294, f1: 1687466755}], v0=true, v1=([-2851508539],
(9.311568420048847E-213), {'08:17:26.854857003'}), v2='-2169509-02-28',
v3=-2881124271283821918 WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 =
'2023-04-19T01:29:41.979Z' -- on node1
176: DELETE FROM ks1.tbl USING TIMESTAMP 43 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2002-04-24T06:08:24.821Z' -- on node1
182: UPDATE ks1.tbl USING TIMESTAMP 45 SET v3=null, v0=true,
v2='-522857-10-31', v1=([0], (-3.756144022058167E-91), {'14:30:56.416689406'}),
s1=[{f0: 0, f1: 1938355794}] WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 =
'1986-06-01T01:47:35.469Z' -- on node1
208: DELETE s1, s0 FROM ks1.tbl USING TIMESTAMP 51 WHERE pk0 =
107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' -- on node1
209: UPDATE ks1.tbl USING TIMESTAMP 52 SET v1=([0, 10744379,
-455061842], (7.468008149613881E-150), {'03:50:29.574209205',
'16:02:31.700167219'}), v2='-3826565-03-23', s0=true WHERE pk0 = 107 AND pk1
= 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2066-01-31T21:07:50.432Z' -- on node1
214: DELETE s1 FROM ks1.tbl USING TIMESTAMP 54 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' -- on node1
221: UPDATE ks1.tbl USING TIMESTAMP 57 SET v1=([1493,
-61912039], (-2.7390039540107187E-16), {'02:48:26.251549938',
'05:47:40.125278436', '13:30:31.797952282'}), v2='-3064129-06-14', s1=[{f0:
-17081, f1: -927761473}] WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 =
'2026-09-14T00:18:58.503Z' -- on node1
226: DELETE FROM ks1.tbl USING TIMESTAMP 58 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' -- on node1
235: DELETE FROM ks1.tbl USING TIMESTAMP 61 WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2055-01-10T21:55:20.645Z' -- on node1
248: UPDATE ks1.tbl USING TIMESTAMP 63 SET
v3=2407593008650530677, v0=false, v2='-4580493-06-03', s0=true WHERE pk0 = 107
AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2049-10-21T08:01:26.951Z' -- on node1
262: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
v3) VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2045-10-01T20:32:01.275Z', true, null, false,
([-57211, 0, -2505522], (1.676883457196297E245), {'06:37:06.904043605'}),
'-2793624-07-25', -7530275102855066373) USING TIMESTAMP 65 -- on node1
265: UPDATE ks1.tbl USING TIMESTAMP 66 SET s0=true, s1=[{f0: 0,
f1: -1612349765}], v0=true, v1=([0, -25951], (1.1868161871165525E107),
{'02:42:46.635758938', '12:56:31.740279357', '15:28:53.829638316'}),
v2='-5594895-03-03', v3=830273698217114998 WHERE pk0 = 107 AND pk1 =
'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2025-06-02T05:06:02.848Z' -- on node1
270: DELETE v2, v3, v0, v1, s1, s0 FROM ks1.tbl USING TIMESTAMP
68 WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 =
'1974-11-02T22:23:00.867Z' -- on node1
277: INSERT INTO ks1.tbl (pk0, pk1, ck0, v3, s1, s0, v0, v1,
v2) VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2065-04-20T22:44:15.506Z', -865615265601304341,
[{f0: 0, f1: 361403516}], false, true, ([0], (1.1279668862229727E278),
{'15:20:40.371429045', '16:51:35.795786739'}), '-1645820-01-03') USING
TIMESTAMP 70 -- on node1
283: UPDATE ks1.tbl USING TIMESTAMP 71 SET s0=true, s1=[{f0: 0,
f1: 2125576617}], v0=false, v1=([124486, 0], (-4.0707171784474565E46),
{'11:04:56.590153315'}), v2='-776969-05-11', v3=3998180222974361834 WHERE pk0
= 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2015-05-04T20:34:21.869Z' -- on node1
289: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
v3) VALUES (107, 'ꣵ灗큨猃灹⏦㜁쑼憠', '2012-10-25T04:39:26.068Z', true, [{f0: 1989931,
f1: 1884782764}], true, ([-2744299, 0], (-4.318197061958771E218),
{'21:00:12.723824659', '21:57:00.184611205'}), '-736363-04-03',
5958951557442308617) USING TIMESTAMP 73 -- on node1
294: UPDATE ks1.tbl USING TIMESTAMP 74 SET v0=false, s1=null
WHERE pk0 = 107 AND pk1 = 'ꣵ灗큨猃灹⏦㜁쑼憠' AND ck0 = '2000-12-13T00:04:06.594Z'
-- on node1
301: SELECT * FROM ks1.tbl WHERE s0 = true AND pk1 =
'ꣵ灗큨猃灹⏦㜁쑼憠' PER PARTITION LIMIT 626 ALLOW FILTERING -- s0 boolean (indexed with
SAI), pk1 text (indexed with SAI), on node1
Caused by: java.lang.AssertionError: Unexpected rows found:
pk0 | pk1 | ck0 | s0 | s1 | v0 | v1 | v2 | v3
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | null | true | null | null | null | null | null
Missing rows:
pk0 | pk1 | ck0 | s0 | s1 | v0 | v1
| v2 | v3
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2049-10-21T08:01:26.951Z' | true | null | false | null
| '-4580493-06-03' | 2407593008650530677
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2025-06-02T05:06:02.848Z' | true | null | true | ([0,
-25951], (1.1868161871165525E107), {'02:42:46.635758938', '12:56:31.740279357',
'15:28:53.829638316'}) | '-5594895-03-03' | 830273698217114998
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2012-10-25T04:39:26.068Z' | true | null | true |
([-2744299, 0], (-4.318197061958771E218), {'21:00:12.723824659',
'21:57:00.184611205'}) | '-736363-04-03' |
5958951557442308617
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2045-10-01T20:32:01.275Z' | true | null | false |
([-57211, 0, -2505522], (1.676883457196297E245), {'06:37:06.904043605'})
| '-2793624-07-25' | -7530275102855066373
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2015-05-04T20:34:21.869Z' | true | null | false |
([124486, 0], (-4.0707171784474565E46), {'11:04:56.590153315'})
| '-776969-05-11' | 3998180222974361834
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2065-04-20T22:44:15.506Z' | true | null | true | ([0],
(1.1279668862229727E278), {'15:20:40.371429045', '16:51:35.795786739'})
| '-1645820-01-03' | -865615265601304341
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2000-12-13T00:04:06.594Z' | true | null | false | null
| null | null
Expected:
pk0 | pk1 | ck0 | s0 | s1 | v0 | v1
| v2 | v3
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2049-10-21T08:01:26.951Z' | true | null | false | null
| '-4580493-06-03' | 2407593008650530677
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2025-06-02T05:06:02.848Z' | true | null | true | ([0,
-25951], (1.1868161871165525E107), {'02:42:46.635758938', '12:56:31.740279357',
'15:28:53.829638316'}) | '-5594895-03-03' | 830273698217114998
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2012-10-25T04:39:26.068Z' | true | null | true |
([-2744299, 0], (-4.318197061958771E218), {'21:00:12.723824659',
'21:57:00.184611205'}) | '-736363-04-03' |
5958951557442308617
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2045-10-01T20:32:01.275Z' | true | null | false |
([-57211, 0, -2505522], (1.676883457196297E245), {'06:37:06.904043605'})
| '-2793624-07-25' | -7530275102855066373
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2015-05-04T20:34:21.869Z' | true | null | false |
([124486, 0], (-4.0707171784474565E46), {'11:04:56.590153315'})
| '-776969-05-11' | 3998180222974361834
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2065-04-20T22:44:15.506Z' | true | null | true | ([0],
(1.1279668862229727E278), {'15:20:40.371429045', '16:51:35.795786739'})
| '-1645820-01-03' | -865615265601304341
107 | 'ꣵ灗큨猃灹⏦㜁쑼憠' | '2000-12-13T00:04:06.594Z' | true | null | false | null
| null | null
{code}
> Another single-node possibly static column-related SAI missing row issue
> (will update title when root cause is clear)
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-20338
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20338
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/SAI
> Reporter: Caleb Rackliffe
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x, 5.x
>
>
> Running {{SingleNodeTableWalkTest}}...
> {noformat}
> accord.utils.Property$PropertyError: Property error detected:
> Seed = -4570870071359163365
> Examples = 2147483647
> Pure = true
> Error: Unexpected results for query: SELECT * FROM ks1.tbl WHERE s1 = true
> AND v2 = 0x0000000000001d008e00000000000000 AND pk0 = 1.0844396412062203E195
> ALLOW FILTERING
> {noformat}
> {noformat}
> Steps: 400
> Values:
> State:
> Setup:
> CREATE KEYSPACE IF NOT EXISTS ks1 WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': 1};
> CREATE TABLE ks1.tbl (
> pk0 double,
> pk1 text,
> ck0 ascii,
> s0 time static,
> s1 boolean static,
> v0 varint,
> v1 bigint,
> v2 'org.apache.cassandra.db.marshal.LexicalUUIDType',
> v3 double,
> v4 ascii,
> PRIMARY KEY ((pk0, pk1), ck0)
> ) WITH CLUSTERING ORDER BY (ck0 ASC);
> CREATE INDEX tbl_pk0 ON ks1.tbl(pk0) USING 'SAI';
> CREATE CUSTOM INDEX tbl_pk1 ON ks1.tbl(pk1) USING
> 'StorageAttachedIndex';
> 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_s1 ON ks1.tbl(s1) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_v0 ON ks1.tbl(v0) USING 'SAI';
> CREATE INDEX tbl_v1 ON ks1.tbl(v1) USING 'SAI';
> CREATE CUSTOM INDEX tbl_v3 ON ks1.tbl(v3) USING
> 'StorageAttachedIndex';
> CREATE INDEX tbl_v4 ON ks1.tbl(v4) USING 'SAI';:
> org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
>
> History:
> 6: DELETE FROM ks1.tbl USING TIMESTAMP 1 WHERE pk0 =
> 1.0844396412062203E195 AND pk1 = '蚨㡦Ɱ擳麗㾢鉦鵅' AND ck0 =
> 'EkOjIqy\u000F4\u007F' -- on node1
> 9: INSERT INTO ks1.tbl (pk0, pk1, ck0, v3, v4) VALUES
> (-5.332164051882835E-118, 'ﷻṮ', '\u000DT\u007F}P', 2.1518964658843966E-154,
> '#)') USING TIMESTAMP 2 -- on node1
> 91: DELETE FROM ks1.tbl USING TIMESTAMP 3 WHERE pk0 =
> -5.332164051882835E-118 AND pk1 = 'ﷻṮ' AND ck0 = 'Z' + 'Zl' -- on node1
> 129: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v2,
> v3, v4) VALUES (1.0844396412062203E195, '蚨㡦Ɱ擳麗㾢鉦鵅', 'Q',
> '14:59:24.557825178', false, 21 * -126, -3909575580531410414,
> 0x0000000000001d008e00000000000000, 1.3611534850564156E135 -
> -1.3619298083760226E-178, '0c\u0011?\u007Fm[' + 'on]50h') USING TIMESTAMP 4
> -- on node1
> 137: DELETE FROM ks1.tbl USING TIMESTAMP 5 WHERE pk0 =
> 1.0844396412062203E195 AND pk1 = '蚨㡦Ɱ擳麗㾢鉦鵅' AND ck0 = '\u0006yhs!byx5]' --
> on node1
> 146: DELETE FROM ks1.tbl USING TIMESTAMP 6 WHERE pk0 =
> 1.0844396412062203E195 AND pk1 = '蚨㡦Ɱ擳麗㾢鉦鵅' AND ck0 = 'g3(X' +
> '\u0014\u000F' -- on node1
> 152: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, s1, v0, v1, v3,
> v4) VALUES (-5.332164051882835E-118, 'ﷻṮ', '\u0010]/d]Qa!w' +
> 'f\u0013_\u000Bt', '14:48:17.526579773', true, -1590897135,
> -2573745997185251720 - 960275326299953638, 8.598387157543732E36 -
> 0.009913671650062445, '@{$\u0011\u007Fv9' + 'YMS') USING TIMESTAMP 7 -- on
> node1
> 153: INSERT INTO ks1.tbl (pk0, pk1, ck0, s1) VALUES
> (1.0844396412062203E195, '蚨㡦Ɱ擳麗㾢鉦鵅', '\u0002`\u0006' + '_7Us\u0016H5\u0005',
> true) USING TIMESTAMP 8 -- on node1
> 163: INSERT INTO ks1.tbl (pk0, pk1, ck0, s0, v3, v4) VALUES
> (-5.332164051882835E-118, 'ﷻṮ', '\u0002U)e' + 'k{\u0007',
> '19:22:01.238358528', 13461.787488896407 - -8.477600108610068E-237,
> 'b\u0010^6' + 'n') USING TIMESTAMP 9 -- on node1
> 178: DELETE FROM ks1.tbl USING TIMESTAMP 10 WHERE pk0 =
> -5.332164051882835E-118 AND pk1 = 'ﷻṮ' AND ck0 =
> '(J\u000A$\u001A\u007F\u000D\u001EI' + '\u0016%r}Vn\u001EmQ\u000B' -- on node1
> 197: DELETE s0 FROM ks1.tbl USING TIMESTAMP 11 WHERE pk0 =
> -5.332164051882835E-118 AND pk1 = 'ﷻṮ' -- on node1
> 198: nodetool flush ks1 tbl
> 247: UPDATE ks1.tbl USING TIMESTAMP 12 SET v0=0,
> v1=6538215846805966033 * -1292336222967630169, s0='16:30:52.410070437',
> s1=false WHERE pk0 = -5.332164051882835E-118 AND pk1 = 'ﷻṮ' AND ck0 =
> 'HkA' + 'V\u0008ig\u0003A\u000Et' -- on node1
> 268: SELECT * FROM ks1.tbl WHERE s1 = true AND v2 =
> 0x0000000000001d008e00000000000000 AND pk0 = 1.0844396412062203E195 ALLOW
> FILTERING -- s1 boolean (indexed with SAI), v2
> 'org.apache.cassandra.db.marshal.LexicalUUIDType', pk0 double (indexed with
> SAI), on node1, fetch size 100
> {noformat}
> {noformat}
> Caused by: java.lang.AssertionError: Unexpected results for query: SELECT *
> FROM ks1.tbl WHERE s1 = true AND v2 = 0x0000000000001d008e00000000000000 AND
> pk0 = 1.0844396412062203E195 ALLOW FILTERING
> Caused by: java.lang.AssertionError: No rows returned
> Expected:
> pk0 | pk1 | ck0 | s0 | s1 | v0
> | v1 | v2 | v3
> | v4
> 1.0844396412062203E195 | '蚨㡦Ɱ擳麗㾢鉦鵅' | 'Q' | '14:59:24.557825178' | true |
> -2646 | -3909575580531410414 | 0x0000000000001d008e00000000000000 |
> 1.3611534850564156E135 | '0c\u0011?\u007Fm[on]50h'
> {noformat}
> I've gone through almost 1000 other seeds trying to reproduce this in a
> couple hours of local testing w/ no luck, but we'll see if the history above
> repros in a {{CQLTester}} test...
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
