[CASSANDRA-11198] Materialized view inconsistency

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Severity: Normal
• Assignee: Carl Yeksigian
• Reporter: Gábor Auth

Authors

Carl Yeksigian

• Created: 19/Feb/16 21:10
• Updated: 16/Apr/19 09:30
• Resolved: 10/May/17 00:54

Description

Here is a materialized view:

> DESCRIBE MATERIALIZED VIEW unit_by_transport ;

CREATE MATERIALIZED VIEW unit_by_transport AS
    SELECT *
    FROM unit
    WHERE transportid IS NOT NULL AND type IS NOT NULL
    PRIMARY KEY (transportid, id)
    WITH CLUSTERING ORDER BY (id ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = ''
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99PERCENTILE';

I cannot reproduce this but sometimes and somehow happened the same issue (https://issues.apache.org/jira/browse/CASSANDRA-10910):

> SELECT transportid, id, type FROM unit_by_transport WHERE transportid=24f90d20-d61f-11e5-9d3c-8fc3ad6906e2 and id=99c05a70-d686-11e5-a169-97287061d5d1;

 transportid                          | id                                   | type
--------------------------------------+--------------------------------------+------
 24f90d20-d61f-11e5-9d3c-8fc3ad6906e2 | 99c05a70-d686-11e5-a169-97287061d5d1 | null

(1 rows)

> SELECT transportid, id, type FROM unit WHERE id=99c05a70-d686-11e5-a169-97287061d5d1;

 transportid | id | type
-------------+----+------

(0 rows)

Issue Links

• is related to: CASSANDRA-11475 MV code refactor