Alexander Sterligov created CASSANDRA-8203: ----------------------------------------------
Summary: Unexpected null static column Key: CASSANDRA-8203 URL: https://issues.apache.org/jira/browse/CASSANDRA-8203 Project: Cassandra Issue Type: Bug Reporter: Alexander Sterligov Schema: {quote} cqlsh:iss> describe table target_state; CREATE TABLE iss.target_state ( cell ascii, host ascii, service ascii, active ascii, cell_etag timeuuid static, etag timeuuid, states map<ascii, ascii>, PRIMARY KEY (cell, host, service) ) WITH CLUSTERING ORDER BY (host ASC, service ASC) AND bloom_filter_fp_chance = 0.01 AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}' AND comment = '' AND compaction = \{'min_threshold': '4', 'unchecked_tombstone_compaction': 'true', 'tombstone_compaction_interval': '43200', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold': '32'} AND compression = \{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'} AND dclocal_read_repair_chance = 0.1 AND default_time_to_live = 0 AND gc_grace_seconds = 86400 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 = '99.0PERCENTILE'; {quote} Range query: {quote} cqlsh:iss> select cell, host, service, cell_etag, etag from target_state LIMIT 50000; {quote} Contains in the middle of results: {quote} 60630000000065955650000000063097470000054552016:ya(200,15) | ams1-0003.search.yandex.net | 18265 | null | 737a05e0-5532-11e4-bf0b-efa731c31cd0 {quote} Data is unchanged, and another query gives non-null cell_etag column {quote} cqlsh:iss> select host, service, cell_etag, etag from target_state where cell = '60630000000065955650000000063097470000054552016:ya(200,15)' and host = 'ams1-0003.search.yandex.net' and service = '18265'; host | service | cell_etag | etag -----------------------------+---------+--------------------------------------+-------------------------------------- ams1-0003.search.yandex.net | 18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 | 737a05e0-5532-11e4-bf0b-efa731c31cd0 (1 rows) {quote} -- This message was sent by Atlassian JIRA (v6.3.4#6332)