[
https://issues.apache.org/jira/browse/CASSANDRA-20463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caleb Rackliffe reassigned CASSANDRA-20463:
-------------------------------------------
Assignee: Caleb Rackliffe
> 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
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x
>
>
> {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: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
