After restart Cassandra, Lucene index is not working









up vote
0
down vote

favorite













Also check the error log file of the Cassandra and didn't find any warning or error in log file. Trying to rebuild the index but not working. Again need to insert for continuing Lucene index. But my other tables are working fine. Following my current table where I am facing the problem of this. currently partition key is the text field.




CREATE TABLE app_countries(
country_name text,
id timeuuid,
"__v"
timeuuid,
continent_code text,
country_calling_code text,
created_at timestamp,
currency text,
image frozen < imageinfo > ,
in_eu boolean,
is_active boolean,
is_deleted boolean,
iso_code2 text,
iso_code3 text,
latitude float,
longitude float,
lucene text,
sort_order int,
timezone text,
updated_at timestamp,
utc_offset text,
PRIMARY KEY(country_name, id)
) WITH CLUSTERING ORDER BY(id DESC)
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';
CREATE INDEX app_countries_id_idx ON app_countries(id);
CREATE CUSTOM INDEX app_countries_lucene_idx ON app_countries(lucene) USING 'com.stratio.cassandra.lucene.Index'
WITH OPTIONS =
'refresh_seconds': '1',
'schema': '"fields":"id":"type":"uuid","country_name":"type":"string","case_sensitive":false,"currency":"type":"string","country_calling_code":"type":"string","is_active":"type":"boolean","is_deleted":"type":"boolean","sort_order":"type":"integer","created_at":"type":"date","pattern":"dd/MM/yyyy"'
;



Cassandra version: 3.11.3











share|improve this question























  • What do you mean it's not working? Are the index files gone? What do you get when you query using the index?
    – Pedro Gordo
    yesterday










  • Problem is It doesn't return anything in the condition of query match after the restart of Cassandra. If I insert newly its return only new index, not previous data.
    – meteorx
    yesterday














up vote
0
down vote

favorite













Also check the error log file of the Cassandra and didn't find any warning or error in log file. Trying to rebuild the index but not working. Again need to insert for continuing Lucene index. But my other tables are working fine. Following my current table where I am facing the problem of this. currently partition key is the text field.




CREATE TABLE app_countries(
country_name text,
id timeuuid,
"__v"
timeuuid,
continent_code text,
country_calling_code text,
created_at timestamp,
currency text,
image frozen < imageinfo > ,
in_eu boolean,
is_active boolean,
is_deleted boolean,
iso_code2 text,
iso_code3 text,
latitude float,
longitude float,
lucene text,
sort_order int,
timezone text,
updated_at timestamp,
utc_offset text,
PRIMARY KEY(country_name, id)
) WITH CLUSTERING ORDER BY(id DESC)
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';
CREATE INDEX app_countries_id_idx ON app_countries(id);
CREATE CUSTOM INDEX app_countries_lucene_idx ON app_countries(lucene) USING 'com.stratio.cassandra.lucene.Index'
WITH OPTIONS =
'refresh_seconds': '1',
'schema': '"fields":"id":"type":"uuid","country_name":"type":"string","case_sensitive":false,"currency":"type":"string","country_calling_code":"type":"string","is_active":"type":"boolean","is_deleted":"type":"boolean","sort_order":"type":"integer","created_at":"type":"date","pattern":"dd/MM/yyyy"'
;



Cassandra version: 3.11.3











share|improve this question























  • What do you mean it's not working? Are the index files gone? What do you get when you query using the index?
    – Pedro Gordo
    yesterday










  • Problem is It doesn't return anything in the condition of query match after the restart of Cassandra. If I insert newly its return only new index, not previous data.
    – meteorx
    yesterday












up vote
0
down vote

favorite









up vote
0
down vote

favorite












Also check the error log file of the Cassandra and didn't find any warning or error in log file. Trying to rebuild the index but not working. Again need to insert for continuing Lucene index. But my other tables are working fine. Following my current table where I am facing the problem of this. currently partition key is the text field.




CREATE TABLE app_countries(
country_name text,
id timeuuid,
"__v"
timeuuid,
continent_code text,
country_calling_code text,
created_at timestamp,
currency text,
image frozen < imageinfo > ,
in_eu boolean,
is_active boolean,
is_deleted boolean,
iso_code2 text,
iso_code3 text,
latitude float,
longitude float,
lucene text,
sort_order int,
timezone text,
updated_at timestamp,
utc_offset text,
PRIMARY KEY(country_name, id)
) WITH CLUSTERING ORDER BY(id DESC)
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';
CREATE INDEX app_countries_id_idx ON app_countries(id);
CREATE CUSTOM INDEX app_countries_lucene_idx ON app_countries(lucene) USING 'com.stratio.cassandra.lucene.Index'
WITH OPTIONS =
'refresh_seconds': '1',
'schema': '"fields":"id":"type":"uuid","country_name":"type":"string","case_sensitive":false,"currency":"type":"string","country_calling_code":"type":"string","is_active":"type":"boolean","is_deleted":"type":"boolean","sort_order":"type":"integer","created_at":"type":"date","pattern":"dd/MM/yyyy"'
;



Cassandra version: 3.11.3











share|improve this question
















Also check the error log file of the Cassandra and didn't find any warning or error in log file. Trying to rebuild the index but not working. Again need to insert for continuing Lucene index. But my other tables are working fine. Following my current table where I am facing the problem of this. currently partition key is the text field.




CREATE TABLE app_countries(
country_name text,
id timeuuid,
"__v"
timeuuid,
continent_code text,
country_calling_code text,
created_at timestamp,
currency text,
image frozen < imageinfo > ,
in_eu boolean,
is_active boolean,
is_deleted boolean,
iso_code2 text,
iso_code3 text,
latitude float,
longitude float,
lucene text,
sort_order int,
timezone text,
updated_at timestamp,
utc_offset text,
PRIMARY KEY(country_name, id)
) WITH CLUSTERING ORDER BY(id DESC)
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';
CREATE INDEX app_countries_id_idx ON app_countries(id);
CREATE CUSTOM INDEX app_countries_lucene_idx ON app_countries(lucene) USING 'com.stratio.cassandra.lucene.Index'
WITH OPTIONS =
'refresh_seconds': '1',
'schema': '"fields":"id":"type":"uuid","country_name":"type":"string","case_sensitive":false,"currency":"type":"string","country_calling_code":"type":"string","is_active":"type":"boolean","is_deleted":"type":"boolean","sort_order":"type":"integer","created_at":"type":"date","pattern":"dd/MM/yyyy"'
;



Cassandra version: 3.11.3








cassandra lucene cassandra-lucene-index






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited yesterday

























asked yesterday









meteorx

147




147











  • What do you mean it's not working? Are the index files gone? What do you get when you query using the index?
    – Pedro Gordo
    yesterday










  • Problem is It doesn't return anything in the condition of query match after the restart of Cassandra. If I insert newly its return only new index, not previous data.
    – meteorx
    yesterday
















  • What do you mean it's not working? Are the index files gone? What do you get when you query using the index?
    – Pedro Gordo
    yesterday










  • Problem is It doesn't return anything in the condition of query match after the restart of Cassandra. If I insert newly its return only new index, not previous data.
    – meteorx
    yesterday















What do you mean it's not working? Are the index files gone? What do you get when you query using the index?
– Pedro Gordo
yesterday




What do you mean it's not working? Are the index files gone? What do you get when you query using the index?
– Pedro Gordo
yesterday












Problem is It doesn't return anything in the condition of query match after the restart of Cassandra. If I insert newly its return only new index, not previous data.
– meteorx
yesterday




Problem is It doesn't return anything in the condition of query match after the restart of Cassandra. If I insert newly its return only new index, not previous data.
– meteorx
yesterday

















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53224368%2fafter-restart-cassandra-lucene-index-is-not-working%23new-answer', 'question_page');

);

Post as a guest



































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53224368%2fafter-restart-cassandra-lucene-index-is-not-working%23new-answer', 'question_page');

);

Post as a guest














































































Popular posts from this blog

Use pre created SQLite database for Android project in kotlin

Darth Vader #20

Ondo