cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

neo4j create node constraint index failed

version: neo4j 4.4.3

after import data with admin-import, I want to create index with 

``cat /mnt/neo4j/shell/create_index.cql | /mnt/neo4j/neo4j4.4/bin/cypher-shell`

create_index.cql statement as below:

CREATE CONSTRAINT company_constraint IF NOT EXISTS FOR (n:Company) REQUIRE n.keyNo IS UNIQUE;
CREATE CONSTRAINT person_constraint IF NOT EXISTS FOR (n:Person) REQUIRE n.keyNo IS UNIQUE;

 

but recently, the create index job always failed at first time, when i run again it worked.

failed log as below, is there any way to avoid this? why this happened? pls take a look, thanks in advance.

```

2023-01-07 20:17:43.015+0000 INFO  [o.n.k.i.a.s.ConstraintIndexCreator] [neo4j/05f66bef] Starting constraint creation: Constraint( name='company_constraint', type='UNIQUENESS', schema=(:Company {keyNo}) ).
2023-01-07 20:17:43.445+0000 INFO  [o.n.k.i.a.i.IndexPopulationJob] [neo4j/05f66bef] Index population started: [Index( id=3, name='company_constraint', type='UNIQUE BTREE', schema=(:Company {keyNo}), indexProvider='native-btree-1.0' )]
2023-01-07 20:23:04.996+0000 INFO  [o.n.k.i.a.i.IndexPopulationJob] [neo4j/05f66bef] Completed node store scan. Flushing all pending updates.
MultipleIndexPopulator{activeTasks=0, batchedUpdatesFromScan = [org.neo4j.kernel.impl.api.index.MultipleIndexPopulator$IndexPopulation@553697ec], concurrentUpdateQueue = 0}
2023-01-07 20:28:20.116+0000 INFO  [o.n.k.i.a.i.IndexPopulationJob] [neo4j/05f66bef] Index creation finished for index [Index( id=3, name='company_constraint', type='UNIQUE BTREE', schema=(:Company {keyNo}), indexProvider='native-btree-1.0' )].
2023-01-07 20:28:20.156+0000 INFO  [o.n.k.i.a.s.ConstraintIndexCreator] [neo4j/05f66bef] Constraint Constraint( name='company_constraint', type='UNIQUENESS', schema=(:Company {keyNo}) ) populated, starting verification.
2023-01-07 20:28:20.166+0000 INFO  [o.n.k.i.a.i.IndexPopulationJob] [neo4j/05f66bef] TIME/PHASE Final: SCAN[totalTime=3s284ms], MERGE[totalTime=2m26s15ms], BUILD[totalTime=2m27s57ms], APPLY_EXTERNAL[totalTime=19s626ms], FLIP[totalTime=2s460ms]
2023-01-07 20:42:11.915+0000 INFO  [o.n.k.i.t.l.c.CheckPointerImpl] [neo4j/05f66bef] Checkpoint triggered by "Scheduled checkpoint for every 15 minutes threshold" @ txId: 3 checkpoint started...
2023-01-07 20:42:13.252+0000 INFO  [o.n.k.i.t.l.c.CheckPointerImpl] [neo4j/05f66bef] Checkpoint triggered by "Scheduled checkpoint for every 15 minutes threshold" @ txId: 3 checkpoint completed in 1s 335ms
2023-01-07 20:42:13.259+0000 INFO  [o.n.k.i.t.l.p.LogPruningImpl] [neo4j/05f66bef] No log version pruned. The strategy used was '1 days'.
2023-01-07 20:43:47.874+0000 ERROR [o.n.s.NeoWebServer] An error has occurred while sending a response
org.neo4j.server.http.cypher.format.api.ConnectionException: Failed to write to the response stream
        at org.neo4j.server.http.cypher.format.output.json.ExecutionResultSerializer.writeErrors(ExecutionResultSerializer.java:489) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.format.output.json.ExecutionResultSerializer.writeTransactionInfo(ExecutionResultSerializer.java:250) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.format.output.json.ExecutionResultSerializer.handleEvent(ExecutionResultSerializer.java:116) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.OutputEventStreamImpl.notifyListener(OutputEventStreamImpl.java:105) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.OutputEventStreamImpl.writeTransactionInfo(OutputEventStreamImpl.java:94) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.Invocation.sendTransactionStateInformation(Invocation.java:438) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.Invocation.execute(Invocation.java:120) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.OutputEventStreamImpl.produceEvents(OutputEventStreamImpl.java:63) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.format.output.json.JsonMessageBodyWriter.writeTo(JsonMessageBodyWriter.java:60) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.neo4j.server.http.cypher.format.output.json.JsonMessageBodyWriter.writeTo(JsonMessageBodyWriter.java:37) ~[neo4j-server-4.4.3.jar:4.4.3]
        at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:242) ~[jersey-common-2.34.jar:?]
        at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:227) ~[jersey-common-2.34.jar:?]
        at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:139) ~[jersey-common-2.34.jar:?]
        at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:85) ~[jersey-server-2.34.jar:?]
        at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:139) ~[jersey-common-2.34.jar:?]
        at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:61) ~[jersey-server-
0 REPLIES 0