{"action":"created","issue":{"url":"https://api.github.com/repos/node-red/node-red/issues/991","repository_url":"https://api.github.com/repos/node-red/node-red","labels_url":"https://api.github.com/repos/node-red/node-red/issues/991/labels{/name}","comments_url":"https://api.github.com/repos/node-red/node-red/issues/991/comments","events_url":"https://api.github.com/repos/node-red/node-red/issues/991/events","html_url":"https://github.com/node-red/node-red/issues/991","id":176939354,"number":991,"title":"Cannot enqueue Query after fatal error","user":{"login":"kenvernaillenvub","id":16806925,"avatar_url":"https://avatars.githubusercontent.com/u/16806925?v=3","gravatar_id":"","url":"https://api.github.com/users/kenvernaillenvub","html_url":"https://github.com/kenvernaillenvub","followers_url":"https://api.github.com/users/kenvernaillenvub/followers","following_url":"https://api.github.com/users/kenvernaillenvub/following{/other_user}","gists_url":"https://api.github.com/users/kenvernaillenvub/gists{/gist_id}","starred_url":"https://api.github.com/users/kenvernaillenvub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kenvernaillenvub/subscriptions","organizations_url":"https://api.github.com/users/kenvernaillenvub/orgs","repos_url":"https://api.github.com/users/kenvernaillenvub/repos","events_url":"https://api.github.com/users/kenvernaillenvub/events{/privacy}","received_events_url":"https://api.github.com/users/kenvernaillenvub/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":11,"created_at":"2016-09-14T15:29:32Z","updated_at":"2016-09-14T20:56:39Z","closed_at":null,"body":"My node-red applications directs MQTT messages to my MySQL database.\r\nWhen I noticed a lot of data was missing in the database, I checked the logs and found thousands errors like:\r\n\r\n> [error] [mysql:3a8296e6.89951a] Error: Cannot enqueue Query after fatal error.\r\n\r\nWhen I searched for the error before these errors (the fatal one), I found:\r\n\r\n> [error] [mysql:3a8296e6.89951a] Error: Connection lost: The server closed the connection.\r\n\r\nIn a relevant mysqljs error (https://github.com/mysqljs/mysql/issues/832), they notice that the db connection is not released properly. Can this be the case?\r\n\r\nI don't know if this has anything to do with it, but I noticed some errors like this too (also before this issue):\r\n\r\n> [error] [MySQLdatabase:4a1035a.a61eacc] Error: connect ECONNREFUSED\r\n\r\n\r\n_Context:_\r\n_[info] Node-RED version: v0.14.4_\r\n_[info] Node.js  version: v0.10.25_\r\n_[info] Linux 4.4.0-28-generic x64 LE_\r\n"},"comment":{"url":"https://api.github.com/repos/node-red/node-red/issues/comments/247150666","html_url":"https://github.com/node-red/node-red/issues/991#issuecomment-247150666","issue_url":"https://api.github.com/repos/node-red/node-red/issues/991","id":247150666,"user":{"login":"dceejay","id":5375409,"avatar_url":"https://avatars.githubusercontent.com/u/5375409?v=3","gravatar_id":"","url":"https://api.github.com/users/dceejay","html_url":"https://github.com/dceejay","followers_url":"https://api.github.com/users/dceejay/followers","following_url":"https://api.github.com/users/dceejay/following{/other_user}","gists_url":"https://api.github.com/users/dceejay/gists{/gist_id}","starred_url":"https://api.github.com/users/dceejay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dceejay/subscriptions","organizations_url":"https://api.github.com/users/dceejay/orgs","repos_url":"https://api.github.com/users/dceejay/repos","events_url":"https://api.github.com/users/dceejay/events{/privacy}","received_events_url":"https://api.github.com/users/dceejay/received_events","type":"User","site_admin":false},"created_at":"2016-09-14T20:56:39Z","updated_at":"2016-09-14T20:56:39Z","body":"Yes, none of the other nodes buffer. Buffering , queue management, and error recovery are all topics beyond the scope of a \"simple\" database node :-)"}}
{"actor":{"display_login":"dceejay"}}