[
https://issues.apache.org/jira/browse/CASSANDRA-20464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caleb Rackliffe updated CASSANDRA-20464:
----------------------------------------
Resolution: Duplicate
Status: Resolved (was: Open)
> Single node non partition restricted SAI query returned a row that didn't
> match the SELECT WHERE clause
> -------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-20464
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20464
> Project: Apache Cassandra
> Issue Type: Bug
> Components: Feature/SAI
> Reporter: David Capwell
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.0.x
>
>
> https://github.com/apache/cassandra/pull/3995
> SHA: b9aa139eea8dceafbee11806e54fccf8c991b6c2
> {code}
> accord.utils.Property$PropertyError: Property error detected:
> Seed = 7125320270568386663
> Examples = 2147483647
> Pure = true
> Error: Unexpected results for query: SELECT * FROM ks6.tbl WHERE pk0 =
> 0x0000000000001800a600000000000000 AND v0 = ({-26056:
> 0x0000000000001b008000000000000000, -21531:
> 0x0000000000001c00a100000000000000, 17626:
> 0x0000000000001700ac00000000000000}, [00000000-0000-4d00-9600-000000000000])
> AND s1 = [(-15, 0xf3, '2031-06-12T15:49:41.735Z'), (-39804064,
> 0xea1b24cda189, '2047-09-17T12:55:01.056Z'), (-177128752, 0x60,
> '1973-04-26T04:43:46.861Z')] AND ck0 = '1997-09-07T02:52:26.194Z' AND v1 =
> [{f0: 'fbdb:857d:2f3d:4446:b7fe:5869:ddd4:59b0'}] AND pk1 =
> 0x0000000000004700b700000000000000 LIMIT 981 ALLOW FILTERING
> Steps: 400
> Values:
> State:
> Setup:
> CREATE KEYSPACE IF NOT EXISTS ks6 WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': 1};
> CREATE TYPE IF NOT EXISTS ks6."w3WpWQw0hwNIvcbbngL17iTbwwW3aFu"
> (
> f0 inet
> );;
> CREATE TABLE ks6.tbl (
> pk0 'org.apache.cassandra.db.marshal.LexicalUUIDType',
> pk1 'org.apache.cassandra.db.marshal.LexicalUUIDType',
> ck0 timestamp,
> s0 vector<frozen<list<date>>, 2> static,
> s1 vector<frozen<tuple<varint, blob, timestamp>>, 3> static,
> v0 frozen<tuple<frozen<map<smallint,
> 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, frozen<list<uuid>>>>,
> v1 vector<frozen<"w3WpWQw0hwNIvcbbngL17iTbwwW3aFu">, 1>,
> PRIMARY KEY ((pk0, pk1), 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',
> 'only_purge_repaired_tombstones': 'true', 'provide_overlapping_tombstones':
> 'ROW', 'tombstone_threshold': '0.18691611', 'unchecked_tombstone_compaction':
> 'false'}
> 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 INDEX tbl_ck0 ON ks6.tbl(ck0) USING 'SAI';
> CREATE INDEX tbl_v0 ON ks6.tbl(v0) USING 'SAI';:
> org.apache.cassandra.distributed.test.cql3.SingleNodeTableWalkTest.State
> History:
> 160: INSERT INTO ks6.tbl (pk0, pk1, ck0, s0, s1, v0, v1) VALUES
> (0x0000000000001800a600000000000000, 0x0000000000004700b700000000000000,
> '1997-09-07T02:52:26.194Z', [['-240459-10-18', '-5209105-03-10'],
> ['-5873406-02-24']], [(-15, 0xf3, '2031-06-12T15:49:41.735Z'), (-39804064,
> 0xea1b24cda189, '2047-09-17T12:55:01.056Z'), (-177128752, 0x60,
> '1973-04-26T04:43:46.861Z')], ({-26056: 0x0000000000001b008000000000000000,
> -21531: 0x0000000000001c00a100000000000000, 17626:
> 0x0000000000001700ac00000000000000}, [00000000-0000-4d00-9600-000000000000]),
> [{f0: 'b1f0:39de:b185:323e:e33a:4317:8ae4:d1bc'}]) USING TIMESTAMP 53 -- on
> node1
> 161: SELECT * FROM ks6.tbl WHERE pk0 =
> 0x0000000000001800a600000000000000 AND v0 = ({-26056:
> 0x0000000000001b008000000000000000, -21531:
> 0x0000000000001c00a100000000000000, 17626:
> 0x0000000000001700ac00000000000000}, [00000000-0000-4d00-9600-000000000000])
> AND s1 = [(-15, 0xf3, '2031-06-12T15:49:41.735Z'), (-39804064,
> 0xea1b24cda189, '2047-09-17T12:55:01.056Z'), (-177128752, 0x60,
> '1973-04-26T04:43:46.861Z')] AND ck0 = '1997-09-07T02:52:26.194Z' AND v1 =
> [{f0: 'fbdb:857d:2f3d:4446:b7fe:5869:ddd4:59b0'}] AND pk1 =
> 0x0000000000004700b700000000000000 LIMIT 981 ALLOW FILTERING -- pk0
> 'org.apache.cassandra.db.marshal.LexicalUUIDType', v0
> frozen<tuple<frozen<map<smallint,
> 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, frozen<list<uuid>>>>
> (indexed with SAI), s1 vector<frozen<tuple<varint, blob, timestamp>>, 3>, ck0
> timestamp (indexed with SAI), v1
> vector<frozen<"w3WpWQw0hwNIvcbbngL17iTbwwW3aFu">, 1>, pk1
> 'org.apache.cassandra.db.marshal.LexicalUUIDType', on node1
> Caused by: java.lang.AssertionError: Unexpected rows found:
> pk0 | pk1 | ck0
> | s0
> | s1
> |
> v0
>
> | v1
> 0x0000000000001800a600000000000000 | 0x0000000000004700b700000000000000 |
> '1997-09-07T02:52:26.194Z' | [['-240459-10-18', '-5209105-03-10'],
> ['-5873406-02-24']] | [(-15, 0xf3, '2031-06-12T15:49:41.735Z'), (-39804064,
> 0xea1b24cda189, '2047-09-17T12:55:01.056Z'), (-177128752, 0x60,
> '1973-04-26T04:43:46.861Z')] | ({-26056: 0x0000000000001b008000000000000000,
> -21531: 0x0000000000001c00a100000000000000, 17626:
> 0x0000000000001700ac00000000000000}, [00000000-0000-4d00-9600-000000000000])
> | [{f0: 'b1f0:39de:b185:323e:e33a:4317:8ae4:d1bc'}]
> Expected:
> pk0 | pk1 | ck0 | s0 | s1 | v0 | v1
> {code}
> The issue looks to be that v1 doesn’t match
> {code}
> 0x0000000000001800a600000000000000,
>
> -- pk0
> 0x0000000000004700b700000000000000,
>
> -- pk1
> '1997-09-07T02:52:26.194Z',
>
> -- ck0
> [['-240459-10-18', '-5209105-03-10'], ['-5873406-02-24']],
>
> -- s0
> [(-15, 0xf3, '2031-06-12T15:49:41.735Z'), (-39804064, 0xea1b24cda189,
> '2047-09-17T12:55:01.056Z'), (-177128752, 0x60, '1973-04-26T04:43:46.861Z')],
> -- s1
> ({-26056: 0x0000000000001b008000000000000000, -21531:
> 0x0000000000001c00a100000000000000, 17626:
> 0x0000000000001700ac00000000000000}, [00000000-0000-4d00-9600-000000000000]),
> -- v0
> [{f0: 'b1f0:39de:b185:323e:e33a:4317:8ae4:d1bc'}]
>
> -- v1
> ) USING TIMESTAMP 53 -- on node1
> SELECT *
> FROM ks6.tbl
> WHERE pk0 = 0x0000000000001800a600000000000000
> AND v0 = ({-26056: 0x0000000000001b008000000000000000, -21531:
> 0x0000000000001c00a100000000000000, 17626:
> 0x0000000000001700ac00000000000000}, [00000000-0000-4d00-9600-000000000000])
> AND s1 = [(-15, 0xf3, '2031-06-12T15:49:41.735Z'), (-39804064,
> 0xea1b24cda189, '2047-09-17T12:55:01.056Z'), (-177128752, 0x60,
> '1973-04-26T04:43:46.861Z')]
> AND ck0 = '1997-09-07T02:52:26.194Z'
> AND v1 = [{f0: 'fbdb:857d:2f3d:4446:b7fe:5869:ddd4:59b0'}]
> AND pk1 = 0x0000000000004700b700000000000000
> LIMIT 981
> ALLOW FILTERING -- pk0 'org.apache.cassandra.db.marshal.LexicalUUIDType', v0
> frozen<tuple<frozen<map<smallint,
> 'org.apache.cassandra.db.marshal.LexicalUUIDType'>>, frozen<list<uuid>>>>
> (indexed with SAI), s1 vector<frozen<tuple<varint, blob, timestamp>>, 3>, ck0
> timestamp (indexed with SAI), v1
> vector<frozen<"w3WpWQw0hwNIvcbbngL17iTbwwW3aFu">, 1>, pk1
> 'org.apache.cassandra.db.marshal.LexicalUUIDType', on node1
> {code}
--
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
