[jira] [Created] (CASSANDRA-14441) Materialized view is not deleting/updating data when made changes in base table

["SWAPNIL BALWANT BHISEY (JIRA)" <ji...@apache.org>]

SWAPNIL BALWANT BHISEY created CASSANDRA-14441:
--------------------------------------------------

             Summary: Materialized view is not deleting/updating data when made changes in base table
                 Key: CASSANDRA-14441
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14441
             Project: Cassandra
          Issue Type: Bug
          Components: Materialized Views
            Reporter: SWAPNIL BALWANT BHISEY
             Fix For: 3.11.x


we have seen issue in mat view for 3.11.1 where mat view

1) we have inserted a row in test table and the same recored is in test_mat table, with Enabled = true,
2) when I update the same record with Enabled = False, a new row is created in test_mat table(one with true and one with false) but in test table original record got updated to FALSE.
3) when I delete the record using Feature UUID then only the record with Fales is getting deleted in both the tables. however I can see the TRUE record in test_mat table.

Issue is not reproducible in 3.11.2
Steps


CREATE TABLE test ( 
 feature_uuid uuid, 
 namespace text, 
 feature_name text, 
 allocation_type text, 
 description text, 
 enabled boolean, 
 expiration_dt timestamp, 
 last_modified_dt timestamp, 
 last_modified_user text, 
 persist_allocations boolean, 
 rule text, 
 PRIMARY KEY (feature_uuid, namespace, feature_name, allocation_type) 
) WITH CLUSTERING ORDER BY (namespace ASC, feature_name ASC, allocation_type 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.3 
 AND default_time_to_live = 63072000 
 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.3 
 AND speculative_retry = '99PERCENTILE'; 
 
CREATE MATERIALIZED VIEW test_mat AS 
 SELECT allocation_type, enabled, feature_uuid, namespace, feature_name, last_modified_dt, last_modified_user, persist_allocations, rule 
 FROM test
 WHERE feature_uuid IS NOT NULL AND allocation_type IS NOT NULL AND namespace IS NOT NULL AND feature_name IS NOT NULL AND enabled IS NOT NULL 
 PRIMARY KEY (allocation_type, enabled, feature_uuid, namespace, feature_name) 
 WITH CLUSTERING ORDER BY (enabled ASC, feature_uuid ASC, namespace ASC, feature_name 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'; 
 
 
INSERT INTO test (feature_uuid, namespace, feature_name, allocation_type, description, enabled, expiration_dt, last_modified_dt, last_modified_user, persist_allocations,rule) VALUES (uuid(),'Service','NEW','preallocation','20newproduct',TRUE,'2019-10-02 05:05:05 -0500','2018-08-03 06:06:06 -0500','swapnil',TRUE,'NEW'); 
UPDATE test SET enabled=FALSE WHERE feature_uuid=b2d5c245-e30e-4ea8-8609-d36b627dbb2a and namespace='Service' and feature_name='NEW' and allocation_type='preallocation' IF EXISTS ; 
Delete from test where feature_uuid=98e6ebcc-cafd-4889-bf3d-774a746a3298;

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org