{"action":"opened","issue":{"url":"https://api.github.com/repos/felixge/node-mysql/issues/1283","labels_url":"https://api.github.com/repos/felixge/node-mysql/issues/1283/labels{/name}","comments_url":"https://api.github.com/repos/felixge/node-mysql/issues/1283/comments","events_url":"https://api.github.com/repos/felixge/node-mysql/issues/1283/events","html_url":"https://github.com/felixge/node-mysql/issues/1283","id":117289827,"number":1283,"title":"Transactions on single shared (non-pooled) connection- Safe?","user":{"login":"bartonsprings","id":9456041,"avatar_url":"https://avatars.githubusercontent.com/u/9456041?v=3","gravatar_id":"","url":"https://api.github.com/users/bartonsprings","html_url":"https://github.com/bartonsprings","followers_url":"https://api.github.com/users/bartonsprings/followers","following_url":"https://api.github.com/users/bartonsprings/following{/other_user}","gists_url":"https://api.github.com/users/bartonsprings/gists{/gist_id}","starred_url":"https://api.github.com/users/bartonsprings/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartonsprings/subscriptions","organizations_url":"https://api.github.com/users/bartonsprings/orgs","repos_url":"https://api.github.com/users/bartonsprings/repos","events_url":"https://api.github.com/users/bartonsprings/events{/privacy}","received_events_url":"https://api.github.com/users/bartonsprings/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-11-17T06:05:29Z","updated_at":"2015-11-17T06:05:29Z","closed_at":null,"body":"Will the simple transaction example shown here: https://github.com/felixge/node-mysql#transactions work for a single db connection shared across the application where multiple http requests could be going on in parallel, contending for database access (using async library also).\r\n\r\nI am worried that connection may not be held through the entire transaction and due to async nature of Nodejs some other request will take the time slice in between and use the connection before the transaction is complete, which could result in messed up rollbacks and commits on same single connection. \r\n\r\nSo is it safe to use the transactions on single shared (non-pooled) connection? Thanks in advance."}}