I have a 2 node Cassandra server. The consistency level for reads is LOCAL_ONE. However, when one of the nodes goes down, my read query returns no result. If both are up, then the results return fine as expected
Both the node is in the same DC.
[root@cassandra-7 ~]# nodetool status Datacenter: singaporedo ======================= Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns Host ID Rack UN Node-1-IP 406.66 GiB 1 ? 9159fc01-f08a-4334-bb29-5b3cf7d5727f rack-1 UN Node-2-IP 380.15 GiB 1 ? 2aca8bd7-f211-4913-888f-1749d7e000a4 rack-1
Table Description
adsizz@cqlsh:adserv> describe conversion_by_uid;
CREATE TABLE adserv.conversion_by_uid (
uid uuid PRIMARY KEY,
android_id text,
app_version text,
brand text,
browser text,
camp_id int,
carrier text,
city text,
click_id text,
clk_browser text,
clk_carrier text,
clk_city text,
clk_country text,
clk_device_type text,
clk_event_code int,
clk_gaid text,
clk_id text,
clk_idfa text,
clk_ip text,
clk_is_mob boolean,
clk_is_tab boolean,
clk_platform text,
clk_platform_mkr text,
clk_platform_ver text,
clk_province text,
clk_redirected_frm_camp int,
clk_redirected_frm_cr int,
clk_redirection_valid boolean,
clk_referer text,
clk_sub_id1 text,
clk_sub_id2 text,
clk_sub_id3 text,
clk_sub_id4 text,
clk_sub_id5 text,
clk_sub_pub text,
clk_timestamp timestamp,
clk_uid text,
clk_unique_id text,
clk_user_agent text,
commission decimal,
conv_city text,
conv_country text,
conv_ip text,
conv_os text,
conv_os_ver text,
conv_platform text,
conv_platform_ver text,
conv_type int,
country text,
creative_id int,
device_type text,
event_code int,
event_name text,
event_type text,
gaid text,
idfa text,
imei text,
ip text,
is_mob boolean,
is_tab boolean,
order_id text,
order_val text,
partners_trans_id text,
payout decimal,
platform text,
platform_mkr text,
platform_ver text,
province text,
pub_id int,
revenue text,
sdk_ver text,
sub_pub text,
time_gap_seconds int,
timestamp timestamp,
trans_id1 text,
trans_id2 text,
trans_id3 text,
trans_id4 text,
trans_id5 text,
user_agent text,
wifi text
) WITH 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.DeflateCompressor'}
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';
