Rebuild of label index in neo4j
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
add a comment |
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
add a comment |
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
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
neo4j lucene
edited Nov 23 '18 at 14:38
asked Nov 23 '18 at 10:16
Bjørn Øst Hansen
7217
7217
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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
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
add a comment |
I ended up exporting to Graphml using apoc and importing again, that solved it
add a comment |
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
});
}
});
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%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
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
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
add a comment |
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
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
add a comment |
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
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
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
add a comment |
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
add a comment |
I ended up exporting to Graphml using apoc and importing again, that solved it
add a comment |
I ended up exporting to Graphml using apoc and importing again, that solved it
add a comment |
I ended up exporting to Graphml using apoc and importing again, that solved it
I ended up exporting to Graphml using apoc and importing again, that solved it
answered Dec 4 '18 at 10:08
Bjørn Øst Hansen
7217
7217
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%2f53444735%2frebuild-of-label-index-in-neo4j%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