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