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
    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

















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
    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















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 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




















  • 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














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.






share|improve this answer





















    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















    Required, but never shown

























    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.






    share|improve this answer

























      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.






      share|improve this answer























        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.






        share|improve this answer












        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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Dec 1 at 2:41









        Mis94

        5741619




        5741619






























            draft saved

            draft discarded




















































            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.




            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















            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







            這個網誌中的熱門文章

            Hercules Kyvelos

            Tangent Lines Diagram Along Smooth Curve

            Yusuf al-Mu'taman ibn Hud