{"action":"created","issue":{"url":"https://api.github.com/repos/sidorares/node-mysql2/issues/322","repository_url":"https://api.github.com/repos/sidorares/node-mysql2","labels_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/322/labels{/name}","comments_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/322/comments","events_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/322/events","html_url":"https://github.com/sidorares/node-mysql2/issues/322","id":159873445,"number":322,"title":"[Need help]Streamming rows problem","user":{"login":"dsonet","id":457552,"avatar_url":"https://avatars.githubusercontent.com/u/457552?v=3","gravatar_id":"","url":"https://api.github.com/users/dsonet","html_url":"https://github.com/dsonet","followers_url":"https://api.github.com/users/dsonet/followers","following_url":"https://api.github.com/users/dsonet/following{/other_user}","gists_url":"https://api.github.com/users/dsonet/gists{/gist_id}","starred_url":"https://api.github.com/users/dsonet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsonet/subscriptions","organizations_url":"https://api.github.com/users/dsonet/orgs","repos_url":"https://api.github.com/users/dsonet/repos","events_url":"https://api.github.com/users/dsonet/events{/privacy}","received_events_url":"https://api.github.com/users/dsonet/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sidorares/node-mysql2/labels/needs%20investigation","name":"needs investigation","color":"207de5"},{"url":"https://api.github.com/repos/sidorares/node-mysql2/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-06-13T04:59:00Z","updated_at":"2016-08-18T02:11:09Z","closed_at":null,"body":"I'm using a pool, get one connection to fetch rows, use another one to update rows back to mysql.\r\nWhen the dataset is very small, like 100 rows, it works. But when it's little bigger, it stuck, the updateRow seems never invoked.any one could help?\r\n```javascript\r\npool.getConnection(function (err, conn) {\r\n    conn.query(\"SELECT * FROM table\")\r\n            .on('result', function (row) {\r\n                conn.pause()\r\n                updateRow(row, function(){conn.resume()}) //update it back\r\n            })\r\n})\r\nfunction updateRow(row, resume) {\r\n    pool.getConnection(function (err, conn) {\r\n        conn.query('UPDATE table SET ....', function(err, result) {\r\n            resume()\r\n        })\r\n    })   \r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/sidorares/node-mysql2/issues/comments/240604520","html_url":"https://github.com/sidorares/node-mysql2/issues/322#issuecomment-240604520","issue_url":"https://api.github.com/repos/sidorares/node-mysql2/issues/322","id":240604520,"user":{"login":"tienvx","id":3327643,"avatar_url":"https://avatars.githubusercontent.com/u/3327643?v=3","gravatar_id":"","url":"https://api.github.com/users/tienvx","html_url":"https://github.com/tienvx","followers_url":"https://api.github.com/users/tienvx/followers","following_url":"https://api.github.com/users/tienvx/following{/other_user}","gists_url":"https://api.github.com/users/tienvx/gists{/gist_id}","starred_url":"https://api.github.com/users/tienvx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tienvx/subscriptions","organizations_url":"https://api.github.com/users/tienvx/orgs","repos_url":"https://api.github.com/users/tienvx/repos","events_url":"https://api.github.com/users/tienvx/events{/privacy}","received_events_url":"https://api.github.com/users/tienvx/received_events","type":"User","site_admin":false},"created_at":"2016-08-18T02:11:09Z","updated_at":"2016-08-18T02:11:09Z","body":"Hey @sidorares , sorry the schema is private so I can not post it.\r\n\r\nThe table have 110k rows, 17 columns (including 1 longtext column). Also in my case, the query is\r\n`SELECT id, a, b, c, d... FROM table`\r\nNot the same with @dsonet .Hope it help."}}
{"actor":{"display_login":"tienvx"}}