David Capwell created CASSANDRA-20463:
-----------------------------------------
Summary: Single node SAI query returned no rows, but should have
returned one
Key: CASSANDRA-20463
URL: https://issues.apache.org/jira/browse/CASSANDRA-20463
Project: Apache Cassandra
Issue Type: Bug
Components: Feature/SAI
Reporter: David Capwell
{code}
accord.utils.Property$PropertyError: Property error detected:
Seed = 4149076304075149205
Examples = 2147483647
Pure = true
Error: Unexpected results for query: SELECT * FROM ks14.tbl WHERE s0 = {f0:
[00000000-0000-4c00-8900-000000000000, 00000000-0000-4e00-8600-000000000000],
f1: (-1081693)} AND v0 = [{f0: 0xf25ee26ff9, f1:
00000000-0000-4c00-8f00-000000000000, f2: 4828867671695147229}, {f0:
0xb0b4c07ada406b39, f1: 00000000-0000-4f00-aa00-000000000000, f2:
1912745619852268183}, {f0: 0xbf6ed9029d, f1:
00000000-0000-4300-a900-000000000000, f2: -7059358506518605351}] PER PARTITION
LIMIT 245 ALLOW FILTERING
Steps: 400
Values:
State:
Setup:
CREATE KEYSPACE IF NOT EXISTS ks14 WITH replication = {'class':
'SimpleStrategy', 'replication_factor': 1};
CREATE TYPE IF NOT EXISTS
ks14."fhbV6AiLHY1tmL9ZvUwQTN_MVB_FK33p0AH7O8" (
f0 blob,
f1 date
);;
CREATE TYPE IF NOT EXISTS
ks14."oKWWJhpj53nvMiuiyxyfPSYrDFhBMMzB7mzMSygRur2n" (
f0 blob,
f1 uuid,
f2 bigint
);;
CREATE TYPE IF NOT EXISTS
ks14."l0NaHc9nL0urDUfbCu3zhYWHxpk2X55e4FW" (
f0 uuid
);;
CREATE TYPE IF NOT EXISTS ks14."xyVF7eEgtjRraC3zzjqw9glqKw" (
f0 list<uuid>,
f1 frozen<tuple<varint>>
);;
CREATE TYPE IF NOT EXISTS
ks14."k_AocOsoTQkxCkUYp5wbsgH6gZNUXA1XRLLK8oX0yRL6CH" (
f0 frozen<"l0NaHc9nL0urDUfbCu3zhYWHxpk2X55e4FW">,
f1 frozen<"fhbV6AiLHY1tmL9ZvUwQTN_MVB_FK33p0AH7O8">
);;
CREATE TYPE IF NOT EXISTS ks14."6xkGD5FoLazlDXt" (
f0 frozen<set<inet>>
);;
CREATE TYPE IF NOT EXISTS
ks14."JiigOTV80ExEVE0IcYCTXdtZj3ZRQjT" (
f0 float,
f1 tinyint,
f2 timeuuid
);;
CREATE TABLE ks14.tbl (
pk0 time,
ck0 ascii,
s0 frozen<"xyVF7eEgtjRraC3zzjqw9glqKw"> static,
s1 frozen<"k_AocOsoTQkxCkUYp5wbsgH6gZNUXA1XRLLK8oX0yRL6CH">
static,
v0
vector<frozen<"oKWWJhpj53nvMiuiyxyfPSYrDFhBMMzB7mzMSygRur2n">, 3>,
v1 set<frozen<"JiigOTV80ExEVE0IcYCTXdtZj3ZRQjT">>,
v2
map<frozen<set<'org.apache.cassandra.db.marshal.LexicalUUIDType'>>,
frozen<map<ascii, tinyint>>>,
v3 "6xkGD5FoLazlDXt",
PRIMARY KEY (pk0, ck0)
) WITH CLUSTERING ORDER BY (ck0 ASC)
AND additional_write_policy = '99p'
AND allow_auto_snapshot = true
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'NONE', 'rows_per_partition': 'NONE'}
AND cdc = false
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.UnifiedCompactionStrategy',
'provide_overlapping_tombstones': 'CELL', 'unchecked_tombstone_compaction':
'true'}
AND compression = {'enabled': 'false'}
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_ck0 ON ks14.tbl(ck0) USING
'StorageAttachedIndex';
CREATE CUSTOM INDEX tbl_s0 ON ks14.tbl(s0) USING
'StorageAttachedIndex';
CREATE INDEX tbl_s1 ON ks14.tbl(s1) USING 'SAI';:
org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
History:
2: INSERT INTO ks14.tbl (pk0, ck0, s0, s1, v0, v1, v2, v3)
VALUES ('15:24:54.713284573', 'u4X_\u000E' + '=', {f0:
[00000000-0000-4500-be00-000000000000, 00000000-0000-4500-9600-000000000000,
00000000-0000-4100-aa00-000000000000], f1: (-249618262)}, {f0: {f0:
00000000-0000-4300-9300-000000000000}, f1: {f0: 0x7d2cd7dcb665ff, f1:
'-3057224-01-20'}}, [{f0: 0x1b13ce62d357, f1:
00000000-0000-4a00-9100-000000000000, f2: -7969534616144402806}, {f0: 0x10, f1:
00000000-0000-4600-a300-000000000000, f2: 2287251444111785497}, {f0:
0xe60d4a48c635c099, f1: 00000000-0000-4000-8300-000000000000, f2:
-3321932337594271575}], {{f0: 5.4687741E16, f1: -21, f2:
00000000-0000-1500-9800-000000000000}}, {{0x0000000000001c009500000000000000,
0x0000000000004300af00000000000000, 0x0000000000004c008c00000000000000}:
{'\u0018nUcW.g': 24, '\u001BJ': -125}}, {f0:
{'5915:7e31:b036:6adc:51b5:c92a:de31:9178'}}) USING TIMESTAMP 1 -- on node1
18: INSERT INTO ks14.tbl (pk0, ck0, s0, v2, v0) VALUES
('15:24:54.713284573', 'z' + 'B}pQj:6j\u000E', {f0:
[00000000-0000-4f00-9b00-000000000000, 00000000-0000-4f00-8c00-000000000000,
00000000-0000-4e00-8c00-000000000000], f1: (-20)},
{{0x00000000000016008000000000000000, 0x0000000000004000a800000000000000}:
{'\u007FIh\u001DP!ZR\u007F': 80}, {0x0000000000001b00a200000000000000}:
{'?>j|': 38, 'XA\u0016\u0010YLqJ8y': 10, 'w': -7},
{0x0000000000001d00b300000000000000}: {'Q2;xH\u000D': 54}}, [{f0:
0x7966de678fee6f4b78ff, f1: 00000000-0000-4200-9300-000000000000, f2:
425033234020606327}, {f0: 0x099e705da851088a, f1:
00000000-0000-4900-a500-000000000000, f2: -1043324693464926617}, {f0: 0x82, f1:
00000000-0000-4a00-b100-000000000000, f2: -3886236555101045905}]) USING
TIMESTAMP 2 -- on node1
24: DELETE FROM ks14.tbl USING TIMESTAMP 3 WHERE pk0 =
'15:24:54.713284573' -- on node1
26: INSERT INTO ks14.tbl (pk0, ck0, s1) VALUES
('15:24:54.713284573', 'Bm/x6:A' + '#E\u0018hF$\u0013_Sj', {f0: {f0:
00000000-0000-4500-8f00-000000000000}, f1: {f0: 0x038333600c363fe0, f1:
'-4278159-06-23'}}) USING TIMESTAMP 4 -- on node1
27: INSERT INTO ks14.tbl (pk0, ck0, s0, s1, v0, v1, v2, v3)
VALUES ('15:24:54.713284573', '\u000DGp\u0013}?a"\u000A\u0017' + ',\u0000D?,',
{f0: [00000000-0000-4400-be00-000000000000,
00000000-0000-4100-b700-000000000000], f1: (-485)}, {f0: {f0:
00000000-0000-4300-b100-000000000000}, f1: {f0: 0xa43ba2, f1: '-19258-12-07'}},
[{f0: 0xe2bdcdd05f0cb9aca299, f1: 00000000-0000-4100-a200-000000000000, f2:
-4635703375859787203}, {f0: 0x4f1ddced, f1:
00000000-0000-4800-a600-000000000000, f2: -9154255985218851937}, {f0:
0xf5f32ab7e09de8, f1: 00000000-0000-4c00-9500-000000000000, f2:
-3497638706428410651}], {{f0: 9.499598E-26, f1: -24, f2:
00000000-0000-1700-bf00-000000000000}, {f0: 2.8312087E-22, f1: -95, f2:
00000000-0000-1700-8e00-000000000000}}, {{0x0000000000001c008d00000000000000}:
{'x8;\u0019418re': 28, '{\u000F': -12}, {0x00000000000041009300000000000000,
0x00000000000044009d00000000000000, 0x00000000000047009500000000000000}:
{'\u0019g': -18, '}z\u001D}7$,*v': -111}}, {f0:
{'4075:cd99:1cfc:a86d:b426:4f31:5725:fbb3', '93.23.217.146'}}) USING TIMESTAMP
5 -- on node1
49: INSERT INTO ks14.tbl (pk0, ck0, s0, s1, v0, v1, v2, v3)
VALUES ('15:24:54.713284573', '\u007Fb''r7\u001ABZ' + '\u000EtQ', {f0:
[00000000-0000-4a00-b400-000000000000], f1: (-1932147805)}, {f0: {f0:
00000000-0000-4600-a000-000000000000}, f1: {f0: 0x1c6481ccd1b634ae, f1:
'-5151070-08-31'}}, [{f0: 0xd76554b89233, f1:
00000000-0000-4c00-9900-000000000000, f2: -6579815292833175913}, {f0:
0x04758b4f6841, f1: 00000000-0000-4e00-b700-000000000000, f2:
-5729333956875029244}, {f0: 0x5ae91781, f1:
00000000-0000-4600-ad00-000000000000, f2: -7747286552872096868}], {{f0:
-2.1846645E26, f1: -10, f2: 00000000-0000-1c00-8f00-000000000000}, {f0:
-2.0433476E7, f1: -124, f2: 00000000-0000-1c00-8500-000000000000}, {f0:
-7.39581E-6, f1: 106, f2: 00000000-0000-1400-9400-000000000000}},
{{0x00000000000010009800000000000000, 0x0000000000001f00b600000000000000,
0x0000000000004300aa00000000000000}: {'\u000Aq!k': 19, '}n\u001C': 77, '~}':
-75}, {0x0000000000001c009100000000000000, 0x0000000000004a008300000000000000}:
{'kp97?6': 70}}, {f0: {'db98:3455:cc58:19db:178c:ba03:e033:5c45'}}) USING
TIMESTAMP 6 -- on node1
93: INSERT INTO ks14.tbl (pk0, ck0, s0) VALUES
('15:24:54.713284573', 'I\u001B\u000C' + 'BSZ>okc', {f0:
[00000000-0000-4c00-9800-000000000000, 00000000-0000-4d00-ae00-000000000000],
f1: (193)}) USING TIMESTAMP 7 -- on node1
110: INSERT INTO ks14.tbl (pk0, ck0, s0, s1, v0, v1, v2, v3)
VALUES ('15:24:54.713284573', '5\u0005' + 'lw', {f0:
[00000000-0000-4300-8000-000000000000, 00000000-0000-4700-a200-000000000000,
00000000-0000-4a00-bd00-000000000000], f1: (0)}, {f0: {f0:
00000000-0000-4400-9e00-000000000000}, f1: {f0: 0xdf, f1: '-1225405-01-05'}},
[{f0: 0x9d9a37a7adb2, f1: 00000000-0000-4f00-ab00-000000000000, f2:
4396843280491728876}, {f0: 0x536c7518bfe4, f1:
00000000-0000-4c00-8c00-000000000000, f2: 942270547311609747}, {f0: 0xda6fa9dc,
f1: 00000000-0000-4700-a000-000000000000, f2: -5852443534065045563}], {{f0:
-371.43243, f1: 80, f2: 00000000-0000-1d00-8c00-000000000000}, {f0:
9.4638245E-32, f1: -105, f2: 00000000-0000-1f00-ac00-000000000000}},
{{0x0000000000001e008200000000000000, 0x0000000000001f00b900000000000000,
0x00000000000045009d00000000000000}: {'\u000B': -22},
{0x00000000000045009400000000000000, 0x0000000000004900b000000000000000}:
{'Z\u0004"\u001A&c\u001AdY': 96, 'j\u0001;PEa\u0007': 52}}, {f0:
{'2679:e932:3416:9e01:4ce3:aa72:8b25:cff3', '79.125.219.103', '92.14.80.197'}})
USING TIMESTAMP 8 -- on node1
111: INSERT INTO ks14.tbl (pk0, ck0, s0, s1, v0, v1, v2, v3)
VALUES ('15:24:54.713284573', 'TQ*' + 'q`', {f0:
[00000000-0000-4c00-8900-000000000000, 00000000-0000-4e00-8600-000000000000],
f1: (-1081693)}, {f0: {f0: 00000000-0000-4400-b200-000000000000}, f1: {f0:
0x1cbeea3b, f1: '-641502-03-11'}}, [{f0: 0xf25ee26ff9, f1:
00000000-0000-4c00-8f00-000000000000, f2: 4828867671695147229}, {f0:
0xb0b4c07ada406b39, f1: 00000000-0000-4f00-aa00-000000000000, f2:
1912745619852268183}, {f0: 0xbf6ed9029d, f1:
00000000-0000-4300-a900-000000000000, f2: -7059358506518605351}], {{f0:
-1.6269294E-25, f1: -43, f2: 00000000-0000-1a00-ae00-000000000000}, {f0:
-1.38424125E-27, f1: 61, f2: 00000000-0000-1c00-8000-000000000000}, {f0:
3.14873532E12, f1: 48, f2: 00000000-0000-1800-ad00-000000000000}},
{{0x0000000000001a00be00000000000000, 0x0000000000004700b300000000000000}:
{'\u0000O\u0007\u0010m': -104, '$$9q1:\u0015': 28, '\\u0007;\u0001O': -126},
{0x0000000000004200af00000000000000}: {'\u000A': 118},
{0x0000000000004d00b000000000000000, 0x0000000000004e009500000000000000}:
{'+]8': -18, 'X2-': -60, 'Z\u0002{\u000A\u0010\u0009\u0009': 119}}, {f0:
{'5dba:874b:f28f:62ba:c681:de1a:d9a9:a44f'}}) USING TIMESTAMP 9 -- on node1
112: SELECT * FROM ks14.tbl WHERE s0 = {f0:
[00000000-0000-4c00-8900-000000000000, 00000000-0000-4e00-8600-000000000000],
f1: (-1081693)} AND v0 = [{f0: 0xf25ee26ff9, f1:
00000000-0000-4c00-8f00-000000000000, f2: 4828867671695147229}, {f0:
0xb0b4c07ada406b39, f1: 00000000-0000-4f00-aa00-000000000000, f2:
1912745619852268183}, {f0: 0xbf6ed9029d, f1:
00000000-0000-4300-a900-000000000000, f2: -7059358506518605351}] PER PARTITION
LIMIT 245 ALLOW FILTERING -- s0 frozen<"xyVF7eEgtjRraC3zzjqw9glqKw"> (indexed
with SAI), v0 vector<frozen<"oKWWJhpj53nvMiuiyxyfPSYrDFhBMMzB7mzMSygRur2n">,
3>, on node1, fetch size 1
Caused by: java.lang.AssertionError: No rows returned
Expected:
pk0 | ck0 | s0
| s1
| v0
| v1
|
v2
| v3
'15:24:54.713284573' | 'TQ*q`' | {f0: [00000000-0000-4c00-8900-000000000000,
00000000-0000-4e00-8600-000000000000], f1: (-1081693)} | {f0: {f0:
00000000-0000-4400-b200-000000000000}, f1: {f0: 0x1cbeea3b, f1:
'-641502-03-11'}} | [{f0: 0xf25ee26ff9, f1:
00000000-0000-4c00-8f00-000000000000, f2: 4828867671695147229}, {f0:
0xb0b4c07ada406b39, f1: 00000000-0000-4f00-aa00-000000000000, f2:
1912745619852268183}, {f0: 0xbf6ed9029d, f1:
00000000-0000-4300-a900-000000000000, f2: -7059358506518605351}] | {{f0:
-1.6269294E-25, f1: -43, f2: 00000000-0000-1a00-ae00-000000000000}, {f0:
-1.38424125E-27, f1: 61, f2: 00000000-0000-1c00-8000-000000000000}, {f0:
3.14873532E12, f1: 48, f2: 00000000-0000-1800-ad00-000000000000}} |
{{0x0000000000001a00be00000000000000, 0x0000000000004700b300000000000000}:
{'\u0000O\u0007\u0010m': -104, '$$9q1:\u0015': 28, '\\u0007;\u0001O': -126},
{0x0000000000004200af00000000000000}: {'\u000A': 118},
{0x0000000000004d00b000000000000000, 0x0000000000004e009500000000000000}:
{'+]8': -18, 'X2-': -60, 'Z\u0002{\u000A\u0010\u0009\u0009': 119}} | {f0:
{'5dba:874b:f28f:62ba:c681:de1a:d9a9:a44f'}}
{code}
The issue here is that step 111 isn’t being returned!!
{code}
write: [{f0: 0xf25ee26ff9, f1: 00000000-0000-4c00-8f00-000000000000, f2:
4828867671695147229}, {f0: 0xb0b4c07ada406b39, f1:
00000000-0000-4f00-aa00-000000000000, f2: 1912745619852268183}, {f0:
0xbf6ed9029d, f1: 00000000-0000-4300-a900-000000000000, f2:
-7059358506518605351}]
search: [{f0: 0xf25ee26ff9, f1: 00000000-0000-4c00-8f00-000000000000, f2:
4828867671695147229}, {f0: 0xb0b4c07ada406b39, f1:
00000000-0000-4f00-aa00-000000000000, f2: 1912745619852268183}, {f0:
0xbf6ed9029d, f1: 00000000-0000-4300-a900-000000000000, f2:
-7059358506518605351}]
SELECT *
FROM ks14.tbl
WHERE s0 = {f0: [00000000-0000-4c00-8900-000000000000,
00000000-0000-4e00-8600-000000000000], f1: (-1081693)}
AND v0 = [{f0: 0xf25ee26ff9, f1: 00000000-0000-4c00-8f00-000000000000,
f2: 4828867671695147229}, {f0: 0xb0b4c07ada406b39, f1:
00000000-0000-4f00-aa00-000000000000, f2: 1912745619852268183}, {f0:
0xbf6ed9029d, f1: 00000000-0000-4300-a900-000000000000, f2:
-7059358506518605351}]
PER PARTITION LIMIT 245
ALLOW FILTERING -- s0 frozen<"xyVF7eEgtjRraC3zzjqw9glqKw"> (indexed with SAI),
v0 vector<frozen<"oKWWJhpj53nvMiuiyxyfPSYrDFhBMMzB7mzMSygRur2n">, 3>, on node1,
fetch size 1
{code}
The search matches step 111 but it isn’t in the output
This was found in https://github.com/apache/cassandra/pull/3995
SHA: 690d79b7cbd28ac48eb795386b6133ed4bb7343d
Test: org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest
Seed: 4149076304075149205
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
