{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/12030","repository_url":"https://api.github.com/repos/neo4j/neo4j","labels_url":"https://api.github.com/repos/neo4j/neo4j/issues/12030/labels{/name}","comments_url":"https://api.github.com/repos/neo4j/neo4j/issues/12030/comments","events_url":"https://api.github.com/repos/neo4j/neo4j/issues/12030/events","html_url":"https://github.com/neo4j/neo4j/issues/12030","id":356864770,"node_id":"MDU6SXNzdWUzNTY4NjQ3NzA=","number":12030,"title":"Connection to the database terminated. This can happen due to network instabilities, or due to restarts of the database while I execute the following query","user":{"login":"rmgpinto","id":24584,"node_id":"MDQ6VXNlcjI0NTg0","avatar_url":"https://avatars0.githubusercontent.com/u/24584?v=4","gravatar_id":"","url":"https://api.github.com/users/rmgpinto","html_url":"https://github.com/rmgpinto","followers_url":"https://api.github.com/users/rmgpinto/followers","following_url":"https://api.github.com/users/rmgpinto/following{/other_user}","gists_url":"https://api.github.com/users/rmgpinto/gists{/gist_id}","starred_url":"https://api.github.com/users/rmgpinto/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmgpinto/subscriptions","organizations_url":"https://api.github.com/users/rmgpinto/orgs","repos_url":"https://api.github.com/users/rmgpinto/repos","events_url":"https://api.github.com/users/rmgpinto/events{/privacy}","received_events_url":"https://api.github.com/users/rmgpinto/received_events","type":"User","site_admin":false},"labels":[{"id":19073042,"node_id":"MDU6TGFiZWwxOTA3MzA0Mg==","url":"https://api.github.com/repos/neo4j/neo4j/labels/cypher","name":"cypher","color":"009800","default":false,"description":null},{"id":647067906,"node_id":"MDU6TGFiZWw2NDcwNjc5MDY=","url":"https://api.github.com/repos/neo4j/neo4j/labels/team-cypher","name":"team-cypher","color":"44ffcc","default":false,"description":""}],"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":3,"created_at":"2018-09-04T15:31:01Z","updated_at":"2020-01-09T12:44:22Z","closed_at":null,"author_association":"NONE","body":"I'm getting `Connection to the database terminated. This can happen due to network instabilities, or due to restarts of the database while I execute the following query`:\r\n\r\n```\r\nUSING PERIODIC COMMIT\r\nLOAD CSV WITH HEADERS FROM \"file:///u_t.csv\" AS row\r\nMATCH (u:User), (t:Topic)\r\nWHERE u.id = row.user_id AND t.id = row.topic_id\r\nMERGE (u)-[:INTERESTED_IN]->(t);\r\n```\r\n\r\n```\r\n$ QUERY='USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM \"file:///u_t.csv\" AS row MATCH (u:User), (t:Topic) WHERE u.id = row.user_id AND t.id = row.topic_id MERGE (u)-[:INTERESTED_IN]->(t);'\r\n$ /var/lib/neo4j/bin/cypher-shell -a $NEO4J_ADDRESS -p 7687 --format plain \\\"$QUERY\\\"\r\n```\r\n\r\nThe file has only 54595 rows.\r\nThe the `cypher-shell` process exits, but the rows continue to be loaded.\r\nI was expecting the `cypher-shell` to be blocked until the data load was completed.\r\n\r\n- Neo4j version: 3.4.5-enterprise (Docker)\r\n- Operating system: AWS AMI Linux\r\n- API/Driver: Cypher Shell"},"comment":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/comments/572545495","html_url":"https://github.com/neo4j/neo4j/issues/12030#issuecomment-572545495","issue_url":"https://api.github.com/repos/neo4j/neo4j/issues/12030","id":572545495,"node_id":"MDEyOklzc3VlQ29tbWVudDU3MjU0NTQ5NQ==","user":{"login":"sherfert","id":22634484,"node_id":"MDQ6VXNlcjIyNjM0NDg0","avatar_url":"https://avatars0.githubusercontent.com/u/22634484?v=4","gravatar_id":"","url":"https://api.github.com/users/sherfert","html_url":"https://github.com/sherfert","followers_url":"https://api.github.com/users/sherfert/followers","following_url":"https://api.github.com/users/sherfert/following{/other_user}","gists_url":"https://api.github.com/users/sherfert/gists{/gist_id}","starred_url":"https://api.github.com/users/sherfert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sherfert/subscriptions","organizations_url":"https://api.github.com/users/sherfert/orgs","repos_url":"https://api.github.com/users/sherfert/repos","events_url":"https://api.github.com/users/sherfert/events{/privacy}","received_events_url":"https://api.github.com/users/sherfert/received_events","type":"User","site_admin":false},"created_at":"2020-01-09T12:44:22Z","updated_at":"2020-01-09T12:44:22Z","author_association":"CONTRIBUTOR","body":"@pricklywiggles @rmgpinto \r\nThis was fixed in 3.5 quite a while ago, but we forgot to close the issue. Can you please verify on a recent 3.5 version that you don't get this error any more?"}}
{"actor":{"display_login":"sherfert"}}