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
cassandra lucene cassandra-lucene-index
add a comment |
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
cassandra lucene cassandra-lucene-index
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
Nov 9 at 12:51
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
Nov 9 at 18:17
What version of Lucene index are you using?
– Mis94
Nov 29 at 1:49
add a comment |
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
cassandra lucene cassandra-lucene-index
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
cassandra lucene cassandra-lucene-index
edited Nov 9 at 20:34
asked Nov 9 at 10:55
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
Nov 9 at 12:51
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
Nov 9 at 18:17
What version of Lucene index are you using?
– Mis94
Nov 29 at 1:49
add a comment |
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
Nov 9 at 12:51
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
Nov 9 at 18:17
What version of Lucene index are you using?
– Mis94
Nov 29 at 1:49
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
Nov 9 at 12:51
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
Nov 9 at 12:51
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
Nov 9 at 18:17
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
Nov 9 at 18:17
What version of Lucene index are you using?
– Mis94
Nov 29 at 1:49
What version of Lucene index are you using?
– Mis94
Nov 29 at 1:49
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
I don't know what version of Cassandra Lucene index you are using but if you or anyone still facing the same problem it seems from the comment here that it is an issue in some older versions and it is fixed in newer versions, so check that the version you are using is a new version not suffering the issue and follow the build steps to produce the jar.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I don't know what version of Cassandra Lucene index you are using but if you or anyone still facing the same problem it seems from the comment here that it is an issue in some older versions and it is fixed in newer versions, so check that the version you are using is a new version not suffering the issue and follow the build steps to produce the jar.
add a comment |
up vote
0
down vote
I don't know what version of Cassandra Lucene index you are using but if you or anyone still facing the same problem it seems from the comment here that it is an issue in some older versions and it is fixed in newer versions, so check that the version you are using is a new version not suffering the issue and follow the build steps to produce the jar.
add a comment |
up vote
0
down vote
up vote
0
down vote
I don't know what version of Cassandra Lucene index you are using but if you or anyone still facing the same problem it seems from the comment here that it is an issue in some older versions and it is fixed in newer versions, so check that the version you are using is a new version not suffering the issue and follow the build steps to produce the jar.
I don't know what version of Cassandra Lucene index you are using but if you or anyone still facing the same problem it seems from the comment here that it is an issue in some older versions and it is fixed in newer versions, so check that the version you are using is a new version not suffering the issue and follow the build steps to produce the jar.
answered Dec 1 at 2:41
Mis94
5741619
5741619
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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
Nov 9 at 12:51
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
Nov 9 at 18:17
What version of Lucene index are you using?
– Mis94
Nov 29 at 1:49