Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
01-07-2023 10:03 PM
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-
All the sessions of the conference are now available online