>> * You should not try on real clusters directly. >Why not? :) It's highly recommended that you complete a full repair before the GC grace period expires, otherwise it's possible you could experience zombie data (i.e. data that was previously deleted coming back to life)
See http://thelastpickle.com/blog/2016/07/27/about-deletes-and-tombstones.html for a good overview of the problem On Mon, 2 Oct 2017 at 16:51 Gábor Auth <auth.ga...@gmail.com> wrote: > Hi, > > On Mon, Oct 2, 2017 at 5:55 AM Varun Barala <varunbaral...@gmail.com> > wrote: > >> *select gc_grace_seconds from system_schema.tables where keyspace_name = >> 'keyspace' and table_name = 'number_item;* >> > > cassandra@cqlsh:mat> DESCRIBE TABLE mat.number_item; > > > CREATE TABLE mat.number_item ( > nodeid uuid, > type text, > created timeuuid, > value float, > PRIMARY KEY (nodeid, type, created) > ) WITH CLUSTERING ORDER BY (type ASC, created ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'} > AND cdc = false > 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 = 3600 > 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'; > > cassandra@cqlsh:mat> select gc_grace_seconds from system_schema.tables > where keyspace_name = 'mat' and table_name = 'number_item'; > > gc_grace_seconds > ------------------ > 3600 > > (1 rows) > > Bye, > Gábor Auth > -- *Justin Cameron*Senior Software Engineer <https://www.instaclustr.com/> This email has been sent on behalf of Instaclustr Pty. Limited (Australia) and Instaclustr Inc (USA). This email and any attachments may contain confidential and legally privileged information. If you are not the intended recipient, do not copy or disclose its content, but please reply to this email immediately and highlight the error to the sender and then immediately delete the message.
