Rebuild of label index in neo4j












1














My Neo4J instance suddenly stopped working, I think my drive ran out of space due to some unrelated logfiles. Anyway, now I cannot start Neo4J, it start, over and over again. If i check the consistency of the database I get the following message. (It does not work neither on version 3.3.5 or 3.4.1)




WARN : Label index was not properly shutdown and rebuild is required.
Label index: neostore.labelscanstore.db
WARN : Index was not properly shutdown and rebuild is required.
Index[ IndexRule[id=1, descriptor=Index( GENERAL, :label0 ), provider={key=lucene, version=1.0}] ]
WARN : Index was not properly shutdown and rebuild is required.
Index[ IndexRule[id=3, descriptor=Index( GENERAL, :label1 ), provider={key=lucene, version=1.0}] ]




I see that there are a few very old answers related to something that might be similar. Are they still valid or how am I supposed to solve this?



When I try to start Neo4J I get




Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Start request repeated too quickly.
Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Failed with result 'exit-code'.
Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: Failed to start Neo4j Graph Database.
root@v22018054377066500:~# service neo4j start
root@v22018054377066500:~# service neo4j status
● neo4j.service - Neo4j Graph Database
Loaded: loaded (/lib/systemd/system/neo4j.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: exit-code) since Fri 2018-11-23 15:36:21 CET; 2ms ago
Process: 22073 ExecStart=/usr/share/neo4j/bin/neo4j console (code=exited, status=1/FAILURE)











share|improve this question





























    1














    My Neo4J instance suddenly stopped working, I think my drive ran out of space due to some unrelated logfiles. Anyway, now I cannot start Neo4J, it start, over and over again. If i check the consistency of the database I get the following message. (It does not work neither on version 3.3.5 or 3.4.1)




    WARN : Label index was not properly shutdown and rebuild is required.
    Label index: neostore.labelscanstore.db
    WARN : Index was not properly shutdown and rebuild is required.
    Index[ IndexRule[id=1, descriptor=Index( GENERAL, :label0 ), provider={key=lucene, version=1.0}] ]
    WARN : Index was not properly shutdown and rebuild is required.
    Index[ IndexRule[id=3, descriptor=Index( GENERAL, :label1 ), provider={key=lucene, version=1.0}] ]




    I see that there are a few very old answers related to something that might be similar. Are they still valid or how am I supposed to solve this?



    When I try to start Neo4J I get




    Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Start request repeated too quickly.
    Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Failed with result 'exit-code'.
    Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: Failed to start Neo4j Graph Database.
    root@v22018054377066500:~# service neo4j start
    root@v22018054377066500:~# service neo4j status
    ● neo4j.service - Neo4j Graph Database
    Loaded: loaded (/lib/systemd/system/neo4j.service; enabled; vendor preset: enabled)
    Active: activating (auto-restart) (Result: exit-code) since Fri 2018-11-23 15:36:21 CET; 2ms ago
    Process: 22073 ExecStart=/usr/share/neo4j/bin/neo4j console (code=exited, status=1/FAILURE)











    share|improve this question



























      1












      1








      1







      My Neo4J instance suddenly stopped working, I think my drive ran out of space due to some unrelated logfiles. Anyway, now I cannot start Neo4J, it start, over and over again. If i check the consistency of the database I get the following message. (It does not work neither on version 3.3.5 or 3.4.1)




      WARN : Label index was not properly shutdown and rebuild is required.
      Label index: neostore.labelscanstore.db
      WARN : Index was not properly shutdown and rebuild is required.
      Index[ IndexRule[id=1, descriptor=Index( GENERAL, :label0 ), provider={key=lucene, version=1.0}] ]
      WARN : Index was not properly shutdown and rebuild is required.
      Index[ IndexRule[id=3, descriptor=Index( GENERAL, :label1 ), provider={key=lucene, version=1.0}] ]




      I see that there are a few very old answers related to something that might be similar. Are they still valid or how am I supposed to solve this?



      When I try to start Neo4J I get




      Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Start request repeated too quickly.
      Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Failed with result 'exit-code'.
      Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: Failed to start Neo4j Graph Database.
      root@v22018054377066500:~# service neo4j start
      root@v22018054377066500:~# service neo4j status
      ● neo4j.service - Neo4j Graph Database
      Loaded: loaded (/lib/systemd/system/neo4j.service; enabled; vendor preset: enabled)
      Active: activating (auto-restart) (Result: exit-code) since Fri 2018-11-23 15:36:21 CET; 2ms ago
      Process: 22073 ExecStart=/usr/share/neo4j/bin/neo4j console (code=exited, status=1/FAILURE)











      share|improve this question















      My Neo4J instance suddenly stopped working, I think my drive ran out of space due to some unrelated logfiles. Anyway, now I cannot start Neo4J, it start, over and over again. If i check the consistency of the database I get the following message. (It does not work neither on version 3.3.5 or 3.4.1)




      WARN : Label index was not properly shutdown and rebuild is required.
      Label index: neostore.labelscanstore.db
      WARN : Index was not properly shutdown and rebuild is required.
      Index[ IndexRule[id=1, descriptor=Index( GENERAL, :label0 ), provider={key=lucene, version=1.0}] ]
      WARN : Index was not properly shutdown and rebuild is required.
      Index[ IndexRule[id=3, descriptor=Index( GENERAL, :label1 ), provider={key=lucene, version=1.0}] ]




      I see that there are a few very old answers related to something that might be similar. Are they still valid or how am I supposed to solve this?



      When I try to start Neo4J I get




      Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Start request repeated too quickly.
      Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: neo4j.service: Failed with result 'exit-code'.
      Nov 23 15:36:08 v22018054377066500.supersrv.de systemd[1]: Failed to start Neo4j Graph Database.
      root@v22018054377066500:~# service neo4j start
      root@v22018054377066500:~# service neo4j status
      ● neo4j.service - Neo4j Graph Database
      Loaded: loaded (/lib/systemd/system/neo4j.service; enabled; vendor preset: enabled)
      Active: activating (auto-restart) (Result: exit-code) since Fri 2018-11-23 15:36:21 CET; 2ms ago
      Process: 22073 ExecStart=/usr/share/neo4j/bin/neo4j console (code=exited, status=1/FAILURE)








      neo4j lucene






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 23 '18 at 14:38

























      asked Nov 23 '18 at 10:16









      Bjørn Øst Hansen

      7217




      7217
























          2 Answers
          2






          active

          oldest

          votes


















          0














          Recently, I was in the same starting situation. At the end of the day the removal and recreation of all indices and constrains solved my issue.



          DROP INDEX ON :Person(name)
          DROP CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE

          CREATE INDEX ON :Person(name)
          CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE





          share|improve this answer

















          • 1




            I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
            – Bjørn Øst Hansen
            Nov 23 '18 at 14:36












          • I ended up exporting to Graphml and importing again, that solved it
            – Bjørn Øst Hansen
            Dec 4 '18 at 10:08



















          0














          I ended up exporting to Graphml using apoc and importing again, that solved it






          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',
            autoActivateHeartbeat: false,
            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%2f53444735%2frebuild-of-label-index-in-neo4j%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Recently, I was in the same starting situation. At the end of the day the removal and recreation of all indices and constrains solved my issue.



            DROP INDEX ON :Person(name)
            DROP CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE

            CREATE INDEX ON :Person(name)
            CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE





            share|improve this answer

















            • 1




              I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
              – Bjørn Øst Hansen
              Nov 23 '18 at 14:36












            • I ended up exporting to Graphml and importing again, that solved it
              – Bjørn Øst Hansen
              Dec 4 '18 at 10:08
















            0














            Recently, I was in the same starting situation. At the end of the day the removal and recreation of all indices and constrains solved my issue.



            DROP INDEX ON :Person(name)
            DROP CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE

            CREATE INDEX ON :Person(name)
            CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE





            share|improve this answer

















            • 1




              I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
              – Bjørn Øst Hansen
              Nov 23 '18 at 14:36












            • I ended up exporting to Graphml and importing again, that solved it
              – Bjørn Øst Hansen
              Dec 4 '18 at 10:08














            0












            0








            0






            Recently, I was in the same starting situation. At the end of the day the removal and recreation of all indices and constrains solved my issue.



            DROP INDEX ON :Person(name)
            DROP CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE

            CREATE INDEX ON :Person(name)
            CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE





            share|improve this answer












            Recently, I was in the same starting situation. At the end of the day the removal and recreation of all indices and constrains solved my issue.



            DROP INDEX ON :Person(name)
            DROP CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE

            CREATE INDEX ON :Person(name)
            CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Nov 23 '18 at 11:06









            ThirstForKnowledge

            6351112




            6351112








            • 1




              I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
              – Bjørn Øst Hansen
              Nov 23 '18 at 14:36












            • I ended up exporting to Graphml and importing again, that solved it
              – Bjørn Øst Hansen
              Dec 4 '18 at 10:08














            • 1




              I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
              – Bjørn Øst Hansen
              Nov 23 '18 at 14:36












            • I ended up exporting to Graphml and importing again, that solved it
              – Bjørn Øst Hansen
              Dec 4 '18 at 10:08








            1




            1




            I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
            – Bjørn Øst Hansen
            Nov 23 '18 at 14:36






            I thought about the same, but I cannot start the database. I have updated the question with the error message i get when starting neo4j
            – Bjørn Øst Hansen
            Nov 23 '18 at 14:36














            I ended up exporting to Graphml and importing again, that solved it
            – Bjørn Øst Hansen
            Dec 4 '18 at 10:08




            I ended up exporting to Graphml and importing again, that solved it
            – Bjørn Øst Hansen
            Dec 4 '18 at 10:08













            0














            I ended up exporting to Graphml using apoc and importing again, that solved it






            share|improve this answer


























              0














              I ended up exporting to Graphml using apoc and importing again, that solved it






              share|improve this answer
























                0












                0








                0






                I ended up exporting to Graphml using apoc and importing again, that solved it






                share|improve this answer












                I ended up exporting to Graphml using apoc and importing again, that solved it







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Dec 4 '18 at 10:08









                Bjørn Øst Hansen

                7217




                7217






























                    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%2f53444735%2frebuild-of-label-index-in-neo4j%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







                    Popular posts from this blog

                    What visual should I use to simply compare current year value vs last year in Power BI desktop

                    How to ignore python UserWarning in pytest?

                    Alexandru Averescu