{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/11986","repository_url":"https://api.github.com/repos/neo4j/neo4j","labels_url":"https://api.github.com/repos/neo4j/neo4j/issues/11986/labels{/name}","comments_url":"https://api.github.com/repos/neo4j/neo4j/issues/11986/comments","events_url":"https://api.github.com/repos/neo4j/neo4j/issues/11986/events","html_url":"https://github.com/neo4j/neo4j/issues/11986","id":342679587,"node_id":"MDU6SXNzdWUzNDI2Nzk1ODc=","number":11986,"title":"Load CSV didn't complete even after 2 days or longer","user":{"login":"zhizh","id":4264151,"node_id":"MDQ6VXNlcjQyNjQxNTE=","avatar_url":"https://avatars3.githubusercontent.com/u/4264151?v=4","gravatar_id":"","url":"https://api.github.com/users/zhizh","html_url":"https://github.com/zhizh","followers_url":"https://api.github.com/users/zhizh/followers","following_url":"https://api.github.com/users/zhizh/following{/other_user}","gists_url":"https://api.github.com/users/zhizh/gists{/gist_id}","starred_url":"https://api.github.com/users/zhizh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhizh/subscriptions","organizations_url":"https://api.github.com/users/zhizh/orgs","repos_url":"https://api.github.com/users/zhizh/repos","events_url":"https://api.github.com/users/zhizh/events{/privacy}","received_events_url":"https://api.github.com/users/zhizh/received_events","type":"User","site_admin":false},"labels":[{"id":695463446,"node_id":"MDU6TGFiZWw2OTU0NjM0NDY=","url":"https://api.github.com/repos/neo4j/neo4j/labels/3.4","name":"3.4","color":"f9d0c4","default":false},{"id":19073042,"node_id":"MDU6TGFiZWwxOTA3MzA0Mg==","url":"https://api.github.com/repos/neo4j/neo4j/labels/cypher","name":"cypher","color":"009800","default":false}],"state":"open","locked":false,"assignee":{"login":"SaschaPeukert","id":6998439,"node_id":"MDQ6VXNlcjY5OTg0Mzk=","avatar_url":"https://avatars0.githubusercontent.com/u/6998439?v=4","gravatar_id":"","url":"https://api.github.com/users/SaschaPeukert","html_url":"https://github.com/SaschaPeukert","followers_url":"https://api.github.com/users/SaschaPeukert/followers","following_url":"https://api.github.com/users/SaschaPeukert/following{/other_user}","gists_url":"https://api.github.com/users/SaschaPeukert/gists{/gist_id}","starred_url":"https://api.github.com/users/SaschaPeukert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SaschaPeukert/subscriptions","organizations_url":"https://api.github.com/users/SaschaPeukert/orgs","repos_url":"https://api.github.com/users/SaschaPeukert/repos","events_url":"https://api.github.com/users/SaschaPeukert/events{/privacy}","received_events_url":"https://api.github.com/users/SaschaPeukert/received_events","type":"User","site_admin":false},"assignees":[{"login":"SaschaPeukert","id":6998439,"node_id":"MDQ6VXNlcjY5OTg0Mzk=","avatar_url":"https://avatars0.githubusercontent.com/u/6998439?v=4","gravatar_id":"","url":"https://api.github.com/users/SaschaPeukert","html_url":"https://github.com/SaschaPeukert","followers_url":"https://api.github.com/users/SaschaPeukert/followers","following_url":"https://api.github.com/users/SaschaPeukert/following{/other_user}","gists_url":"https://api.github.com/users/SaschaPeukert/gists{/gist_id}","starred_url":"https://api.github.com/users/SaschaPeukert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SaschaPeukert/subscriptions","organizations_url":"https://api.github.com/users/SaschaPeukert/orgs","repos_url":"https://api.github.com/users/SaschaPeukert/repos","events_url":"https://api.github.com/users/SaschaPeukert/events{/privacy}","received_events_url":"https://api.github.com/users/SaschaPeukert/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-07-19T10:56:05Z","updated_at":"2018-07-27T08:43:03Z","closed_at":null,"author_association":"NONE","body":"### Environment\r\n\r\n    neo4j-enterprise-3.4.1-windows.zip & neo4j-enterprise-3.4.4-windows.zip\r\n    neo4j.conf\r\n        dbms.memory.heap.initial_size=5g\r\n        dbms.memory.heap.max_size=5g\r\n        dbms.memory.pagecache.size=7g\r\n        # dbms.directories.import=import\r\n    PC:  Surface Pro 4\r\n    OS:  Microsoft Windows 10 Professional 64bit 10.0.15063 \r\n    CPU: Intel(R) Core(TM) i7-6650U CPU @ 2.20GHz 2208Mhz, 2 cores, 4 logic processors\r\n    HD:  1 TB SSD + 1 TB SSD\r\n    RAM: 16 GB \r\n    Data Source:\r\n        https://snap.stanford.edu/data/twitter-2010.txt.gz\r\n        twitter-2010.txt.gz (5,501,785,223 bytes, 1,468,365,182 lines)\r\n\r\n### Steps to reproduce\r\n\r\n    Step 0:\r\n        CREATE CONSTRAINT ON (person:Person) ASSERT person.id IS UNIQUE\r\n\r\n    Step 1: (did complete in 8,210,673 ms)\r\n        USING PERIODIC COMMIT 1000\r\n        LOAD CSV FROM \"file:///C:/poc/import/twitter-2010.txt.gz\" AS line FIELDTERMINATOR ' '\r\n        WITH DISTINCT toInt(line[0]) as id\r\n        MERGE (n:Person {id:id})\r\n        ON CREATE\r\n        SET n.name = toString(id),\r\n            n.sex = [\"Male\", \"Female\"][(id % 2)],\r\n            n.age = (id % 50) + 15,\r\n            n.country = [\"China\", \"U.S.A\", \"France\", \"Britain\", \"Russia\", \"Canada\", \"Germany\", \"Japan\", \"Italy\"][(id % 9)]\r\n\r\n    Step 2: (did complete in 3,803,455 ms)\r\n        USING PERIODIC COMMIT 1000\r\n        LOAD CSV FROM \"file:///C:/poc/import/twitter-2010.txt.gz\" AS line FIELDTERMINATOR ' '\r\n        WITH DISTINCT toInt(line[1]) as id\r\n        MERGE (n:Person {id:id})\r\n        ON CREATE\r\n            SET n.name = toString(id),\r\n            n.sex = [\"Male\", \"Female\"][(id % 2)],\r\n            n.age = (id % 50) + 15,\r\n            n.country = [\"China\", \"U.S.A\", \"France\", \"Britain\", \"Russia\", \"Canada\", \"Germany\", \"Japan\", \"Italy\"][(id % 9)]\r\n\r\n    Step 3: (didn't complete even after 2 days or longer with no error report either)\r\n        USING PERIODIC COMMIT 1000\r\n        LOAD CSV FROM \"file:///C:/poc/import/twitter-2010.txt.gz\" AS line FIELDTERMINATOR ' '\r\n        WITH toInt(line[0]) as id, toInt(line[1]) as id1\r\n        MATCH (n:Person {id:id}), (n1:Person {id:id1})\r\n        MERGE (n)-[r:FOLLOWS]->(n1)\r\n        ON CREATE\r\n        SET r.degree = (id+id1)%100\r\n\r\n### Actual behavior\r\n\r\nStep 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**.\r\n\r\n### Expected behavior\r\n\r\nStep 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.\r\n\r\n### Log Files\r\n\r\n[debug.log](https://github.com/neo4j/neo4j/files/2211038/debug.log)\r\n[security.log](https://github.com/neo4j/neo4j/files/2211039/security.log)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/comments/408353581","html_url":"https://github.com/neo4j/neo4j/issues/11986#issuecomment-408353581","issue_url":"https://api.github.com/repos/neo4j/neo4j/issues/11986","id":408353581,"node_id":"MDEyOklzc3VlQ29tbWVudDQwODM1MzU4MQ==","user":{"login":"SaschaPeukert","id":6998439,"node_id":"MDQ6VXNlcjY5OTg0Mzk=","avatar_url":"https://avatars0.githubusercontent.com/u/6998439?v=4","gravatar_id":"","url":"https://api.github.com/users/SaschaPeukert","html_url":"https://github.com/SaschaPeukert","followers_url":"https://api.github.com/users/SaschaPeukert/followers","following_url":"https://api.github.com/users/SaschaPeukert/following{/other_user}","gists_url":"https://api.github.com/users/SaschaPeukert/gists{/gist_id}","starred_url":"https://api.github.com/users/SaschaPeukert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SaschaPeukert/subscriptions","organizations_url":"https://api.github.com/users/SaschaPeukert/orgs","repos_url":"https://api.github.com/users/SaschaPeukert/repos","events_url":"https://api.github.com/users/SaschaPeukert/events{/privacy}","received_events_url":"https://api.github.com/users/SaschaPeukert/received_events","type":"User","site_admin":false},"created_at":"2018-07-27T08:43:03Z","updated_at":"2018-07-27T08:43:03Z","author_association":"CONTRIBUTOR","body":"@zhizh Thanks for reporting this. We will have a look at it"}}
{"actor":{"display_login":"SaschaPeukert"}}