Issue 1:
I used the neo4j-admin command to import the csv file to initialize the database, but an exception occurred when I executed the command. The exception message indicates that the :TYPE column is a empty value, but I checked all the csv files, and no empty value was found.

Neo4j Version: 4.3.2-enterprise

Operating System: RHEL7 (physical server)

JDK: 11.0.12, Name:OpenJDK 64-Bit Server VM, Vendor:Red Hat, Inc

Expected behavior

Imported successfully

Actual behavior

I'm getting the following error:

WARNING Import failed. The store files in /opt/neo4j-enterprise-4.3.2/data/databases/neo4j are left as they are, although they are likely in an unusable state. Starting a database on these store files will likely fail or observe inconsistent records so start at your own risk or delete the store manually
java.lang.IllegalArgumentException: org.neo4j.internal.kernel.api.exceptions.schema.IllegalTokenNameException: '' is not a valid token name. Token names cannot be empty or contain any null-bytes.
at org.neo4j.internal.batchimport.store.BatchingTokenRepository.getOrCreateId(BatchingTokenRepository.java:94)
at org.neo4j.internal.batchimport.store.BatchingTokenRepository.getOrCreateId(BatchingTokenRepository.java:76)
at org.neo4j.internal.batchimport.RelationshipImporter.type(RelationshipImporter.java:155)
at org.neo4j.internal.batchimport.input.InputEntity.replayOnto(InputEntity.java:354)
at org.neo4j.internal.batchimport.input.csv.EagerCsvInputChunk.next(EagerCsvInputChunk.java:45)
at org.neo4j.internal.batchimport.input.csv.CsvInputChunkProxy.next(CsvInputChunkProxy.java:75)
at org.neo4j.internal.batchimport.ExhaustingEntityImporterRunnable.run(ExhaustingEntityImporterRunnable.java:57)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
at org.neo4j.internal.helpers.NamedThreadFactory$2.run(NamedThreadFactory.java:110)
Caused by: org.neo4j.internal.kernel.api.exceptions.schema.IllegalTokenNameException: '' is not a valid token name. Token names cannot be empty or contain any null-bytes.
at org.neo4j.internal.kernel.api.TokenWrite.checkValidTokenName(TokenWrite.java:139)
at org.neo4j.internal.batchimport.store.BatchingTokenRepository.getOrCreateId(BatchingTokenRepository.java:90)
... 12 more

Steps to reproduce

The header being like

ID,Address,_source_id,_target_id,:START_ID,:END_ID,:TYPE

The data being like

XXXXXXXX1,"#12-11 XXXX XXXXX XXXX XXXXX, XXXXX XXXXX",XXXXXXXX1,"#12-11 XXXX XXXXX XXXX XXXXX, XXXXX XXXXX",XXXXXXXX1,"#12-11 XXXX XXXXX XXXX XXXXX, XXXXX XXXXX",Address
XXXXXXXX2,"#35-00 XXXX XXXXX XXXX XXXXX, XXXXX XXXXX",XXXXXXXX2,"#35-00 XXXX XXXXX XXXX XXXXX, XXXXX XXXXX",XXXXXXXX2,"#35-00 XXXX XXXXX XXXX XXXXX, XXXXX XXXXX",Address

Command used like:

neo4j-admin import --database=neo4j --multiline-fields=true --skip-bad-relationships=true --skip-duplicate-nodes=true --nodes import/tmp0dxbylxm.csv,import/tmp7e7712_l.csv --relationships import/tmpagndf1k5.csv,import/tmp51gid3pj.csv,import/tmpb669w63v.csv

Additional information

Sorry that the original data cannot be provided for security reasons.

I can be sure that the type column in the csv is not empty, but there will be spaces between words.

All csv is generated based on the to_csv method of the pandas library in python.

dataframe.to_csv(temp_file, sep=',', header=True, index=False, encoding='utf-8', quotechar='"')

I will be very appreciate if you can provide more information that may cause the exception.

Issue 2:
Environment

neo4j-enterprise-3.4.1-windows.zip & neo4j-enterprise-3.4.4-windows.zip
neo4j.conf
dbms.memory.heap.initial_size=5g
dbms.memory.heap.max_size=5g
dbms.memory.pagecache.size=7g
# dbms.directories.import=import
PC: Surface Pro 4
OS: Microsoft Windows 10 Professional 64bit 10.0.15063
CPU: Intel(R) Core(TM) i7-6650U CPU @ 2.20GHz 2208Mhz, 2 cores, 4 logic processors
HD: 1 TB SSD + 1 TB SSD
RAM: 16 GB
Data Source:
https://snap.stanford.edu/data/twitter-2010.txt.gz
twitter-2010.txt.gz (5,501,785,223 bytes, 1,468,365,182 lines)

Steps to reproduce

Step 0:
CREATE CONSTRAINT ON (person:Person) ASSERT person.id IS UNIQUE

Step 1: (did complete in 8,210,673 ms)
USING PERIODIC COMMIT 1000
LOAD CSV FROM "file:///C:/poc/import/twitter-2010.txt.gz" AS line FIELDTERMINATOR ' '
WITH DISTINCT toInt(line[0]) as id
MERGE (n:Person {id:id})
ON CREATE
SET n.name = toString(id),
n.sex = ["Male", "Female"][(id % 2)],
n.age = (id % 50) + 15,
n.country = ["China", "U.S.A", "France", "Britain", "Russia", "Canada", "Germany", "Japan", "Italy"][(id % 9)]

Step 2: (did complete in 3,803,455 ms)
USING PERIODIC COMMIT 1000
LOAD CSV FROM "file:///C:/poc/import/twitter-2010.txt.gz" AS line FIELDTERMINATOR ' '
WITH DISTINCT toInt(line[1]) as id
MERGE (n:Person {id:id})
ON CREATE
SET n.name = toString(id),
n.sex = ["Male", "Female"][(id % 2)],
n.age = (id % 50) + 15,
n.country = ["China", "U.S.A", "France", "Britain", "Russia", "Canada", "Germany", "Japan", "Italy"][(id % 9)]

Step 3: (didn't complete even after 2 days or longer with no error report either)
USING PERIODIC COMMIT 1000
LOAD CSV FROM "file:///C:/poc/import/twitter-2010.txt.gz" AS line FIELDTERMINATOR ' '
WITH toInt(line[0]) as id, toInt(line[1]) as id1
MATCH (n:Person {id:id}), (n1:Person {id:id1})
MERGE (n)-[r:FOLLOWS]->(n1)
ON CREATE
SET r.degree = (id+id1)%100

Actual behavior

Step 0, 1, 2 proves to be successful where step 1 took 8,210,673 ms, step 2 took 3,803,455 ms, but step 3 didn't complete even after 2 days or longer with no error report either.

Expected behavior

Step 3 are exprected to be complete within a few hrs or within a day max and if not it should at least generating an error report.

Log Files

debug.log

security.log