<h2 dir="auto">Guidelines</h2>
<p dir="auto">Please note that GitHub issues are only meant for bug reports/feature requests.  If you have questions on how to use Neo4j, please ask on <a href="http://stackoverflow.com/questions/tagged/neo4j" rel="nofollow">StackOverflow</a> instead of creating an issue here.</p>
<p dir="auto">If you want to make a feature request then there is no guideline, so feel free to stop reading and open an issue. If you have a bug report however, please continue reading.<br>
To help us understand your issue, please specify important details, primarily:</p>
<ul dir="auto">
<li>
<p dir="auto">Neo4j version: 3.5.3 Enterprise</p>
</li>
<li>
<p dir="auto">Operating system: Linux</p>
</li>
<li>
<p dir="auto">API/Driver: OpenJDK 1.8.0_201</p>
</li>
<li>
<p dir="auto"><code class="notranslate">~/../../../usr/bin/neo4j-admin</code> import --nodes "import/uids-header.csv,import/uid_no.<em>" --nodes "import/ga-header.csv,import/ggl_no.</em>"  --nodes "import/citystate-header.csv,import/city_no.<em>" --relationships:OBSERVED_WITH "import/rels-header.csv,import/ggl_li.</em>  --relationships:VISITED_FROM "import/rels-header.csv,import/city_li.<em>" --ignore-missing-nodes --delimiter="~" --high-io=true <code class="notranslate">--id-type=actual</code><br>
vs<br>
<code class="notranslate">~/../../../usr/bin/neo4j-admin</code> import --nodes "import/uids-header.csv,import/uid_no.</em>" --nodes "import/ga-header.csv,import/ggl_no.<em>"  --nodes "import/citystate-header.csv,import/city_no.</em>" --relationships:OBSERVED_WITH "import/rels-header.csv,import/ggl_li.*  --relationships:VISITED_FROM "import/rels-header.csv,import/city_li.*" --ignore-missing-nodes --delimiter="~" --high-io=true <code class="notranslate">--id-type=integer</code></p>
</li>
<li>
<p dir="auto">Expected behavior : actual id should be faster on load. Each csv contains node data from Redshift  with a node_id field based on Row_number() and ASC sorted. The first file goes from 1 to 2.4 Billion the second file ggl_no starts at where the last one left off plus 1, and continues to 5.4 Billion. These row_number tables were used to write the pairwise  links from uid_no to ggl_no which are defined in ggl_li, same for city_li.</p>
</li>
<li>
<p dir="auto">Actual behavior: The first run is with id-type actual<br>
(1/4) Node import 2019-04-06 00:33:07.510+0000<br>
Estimated number of nodes: 5.16 G<br>
Estimated disk space usage: 372.56 GB<br>
Estimated required memory usage: 1020.01 MB<br>
.......... .......... .......... .......... ..........   5% ∆9m 14s 169ms<br>
.......... .......... .......... .......... ..........  10% ∆9m 19s 910ms<br>
.......... .......... .......... .......... ..........  15% ∆9m 16s 647ms<br>
.......... .......... .......... .......... ..........  20% ∆9m 19s 566ms<br>
.......... .......... .......... .......... ..........  25% ∆7m 52s 829ms<br>
.......... .......... .......... .......... ..........  30% ∆7m 48s 373ms<br>
.......... .......... .......... .......... ..........  35% ∆6m 19s 909ms<br>
.......... .......... .......... .......... ..........  40% ∆7m 39s 613ms<br>
.......... .......... .......... .......... ..........  45% ∆7m 29s 365ms<br>
.......... .......... .......... .......... ..........  50% ∆7m 52s 382ms<br>
.......... .......... .......... .......... ..........  55% ∆9m 31s 845ms<br>
.......... .......... .......... .......... ..........  60% ∆16m 14s 117ms<br>
.......... .......... .......... .......... ..........  65% ∆16m 13s 717ms<br>
.......... .......... .......... .......... ..........  70% ∆16m 18s 966ms<br>
.......... .......... .......... .......... ..........  75% ∆16m 7s 677ms<br>
.......... .......... .......... .......... ..........  80% ∆15m 48s 866ms<br>
.......... .......... .......... .......... ..........  85% ∆15m 28s 920ms<br>
.......... .......... .......... .......... ..........  90% ∆15m 3s 62ms<br>
.......... .......... .......... .......... ..........  95% ∆12m 55s 803ms<br>
.......... .......... .......... .......... .......... 100% ∆1ms<br>
IMPORT FAILED in 3h 37m 21s 862ms.<br>
Data statistics is not available.<br>
Peak memory usage: 0.00 B<br>
Error in input data<br>
Caused by:ERROR in input<br>
data source: BufferedCharSeeker[source:/var/lib/neo4j/import/seg_no0035_part_00.csv, position:1896888, line:33873]<br>
in field: :LABEL:3<br>
for header: [node_id:ID, segment_id:string, :LABEL]<br>
raw field value: Segment<br>
original error: Id 4294967295 is reserved and can't be used as a regular record id</p>
</li>
</ul>
<p dir="auto">Second run is with id-type= integer<br>
.......... .......... .......... .-........ ..........  35% ∆1m 47s 769ms<br>
.......... .......... .......... .......... ..........  40% ∆1ms<br>
.......... .......... .......... .......... ..........  45% ∆200ms<br>
.......... .......... .......... .......... ..........  50% ∆3m 42s 23ms<br>
.......... .......... .......... .......... ..........  55% ∆3m 930ms<br>
.......... .......... .......... .......... ..........  60% ∆2m 54s 750ms<br>
.......... .......... .......... .......... ..........  65% ∆2m 51s 136ms<br>
.......... .......... .......... .......... ..........  70% ∆2m 48s 332ms<br>
.......... .......... .......... .......... ..........  75% ∆1m 4s 256ms<br>
.......... .......... .......... .......... ..........  80% ∆10s 809ms<br>
.......... .......... .......... .......... ..........  85% ∆11s 612ms<br>
.......... .......... .......... .......... ..........  90% ∆59s 988ms<br>
.......... .......... .......... .......... ..........  95% ∆4m 23s 188ms<br>
.......... .......... .......... .......... .......... 100% ∆3m 56s 173ms</p>
<p dir="auto">Exception in thread "Thread-18" java.lang.RuntimeException: org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.DuplicateInputIdException: Id '1154243009' is defined more than once in group 'global id space'<br>
at org.neo4j.unsafe.impl.batchimport.staging.AbstractStep.issuePanic(AbstractStep.java:155)<br>
at org.neo4j.unsafe.impl.batchimport.staging.AbstractStep.issuePanic(AbstractStep.java:147)<br>
at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep.lambda$receive$0(LonelyProcessingStep.java:59)<br>
at java.lang.Thread.run(Thread.java:748)<br>
Caused by: org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.DuplicateInputIdException: Id '1154243009' is defined more than once in group 'global id space'<br>
at org.neo4j.unsafe.impl.batchimport.input.BadCollector$NodesProblemReporter.exception(BadCollector.java:278)<br>
at org.neo4j.unsafe.impl.batchimport.input.BadCollector.collect(BadCollector.java:168)<br>
at org.neo4j.unsafe.impl.batchimport.input.BadCollector.collectDuplicateNode(BadCollector.java:135)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.detectDuplicateInputIds(EncodingIdMapper.java:606)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:522)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:239)<br>
at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:56)<br>
at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep.lambda$receive$0(LonelyProcessingStep.java:53)<br>
... 1 more</p>
<p dir="auto">IMPORT FAILED in 1h 31m 19s 634ms.<br>
Data statistics is not available.<br>
Peak memory usage: 39.25 GB<br>
Duplicate input ids that would otherwise clash can be put into separate id space, read more about how to use id spaces in the manual: <a href="https://neo4j.com/docs/operations-manual/3.5/tools/import/file-header-format/#import-tool-id-spaces" rel="nofollow">https://neo4j.com/docs/operations-manual/3.5/tools/import/file-header-format/#import-tool-id-spaces</a><br>
Caused by:Id '1154243009' is defined more than once in group 'global id space'</p>
<p dir="auto">Additionally, include (as appropriate) log-files, stacktraces, and other debug output.</p>
<p dir="auto">I'm using neo4j 2.1.4. I have nodes - POINT and relationships - ROAD I have index on ROAD property - OBJ_COD and ID. ID is my legacy property, not the result of ID(relationship) neo4j function</p>
<blockquote>
<p dir="auto">:schema ls -l :ROAD</p>
<p dir="auto">Indexes<br>
ON :ROAD(OBJ_COD) ONLINE<br>
ON :ROAD(ID)      ONLINE</p>
<p dir="auto">No constraints</p>
</blockquote>
<p dir="auto">I want to search ROAD by OBJ_COD or ID value, but cypher don'use index to lookup relationship.</p>
<blockquote>
<p dir="auto">neo4j-sh (?)$ profile MATCH (a)-[r:<code class="notranslate">ROAD</code> {ID:333275}]-(b:<code class="notranslate">POINT</code>) RETURN r LIMIT 1;</p>
<p dir="auto">ColumnFilter<br>
|<br>
+TraversalMatcher</p>
<p dir="auto">+------------------+------+---------+-------------+----------------+<br>
|         Operator | Rows |  DbHits | Identifiers |          Other |<br>
+------------------+------+---------+-------------+----------------+<br>
|     ColumnFilter |    2 |       0 |             | keep columns r |<br>
| TraversalMatcher |    2 | 2265843 |             |        a, r, a |<br>
+------------------+------+---------+-------------+----------------+</p>
</blockquote>
<p dir="auto">How can I force cypher to use existing index to search single relationship?</p>