{"action":"created","issue":{"url":"https://api.github.com/repos/PowerDNS/pdns/issues/4216","repository_url":"https://api.github.com/repos/PowerDNS/pdns","labels_url":"https://api.github.com/repos/PowerDNS/pdns/issues/4216/labels{/name}","comments_url":"https://api.github.com/repos/PowerDNS/pdns/issues/4216/comments","events_url":"https://api.github.com/repos/PowerDNS/pdns/issues/4216/events","html_url":"https://github.com/PowerDNS/pdns/issues/4216","id":166717012,"number":4216,"title":"Pdns service stops working periodically and must be restarted","user":{"login":"tesargusmawan","id":12421725,"avatar_url":"https://avatars.githubusercontent.com/u/12421725?v=3","gravatar_id":"","url":"https://api.github.com/users/tesargusmawan","html_url":"https://github.com/tesargusmawan","followers_url":"https://api.github.com/users/tesargusmawan/followers","following_url":"https://api.github.com/users/tesargusmawan/following{/other_user}","gists_url":"https://api.github.com/users/tesargusmawan/gists{/gist_id}","starred_url":"https://api.github.com/users/tesargusmawan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tesargusmawan/subscriptions","organizations_url":"https://api.github.com/users/tesargusmawan/orgs","repos_url":"https://api.github.com/users/tesargusmawan/repos","events_url":"https://api.github.com/users/tesargusmawan/events{/privacy}","received_events_url":"https://api.github.com/users/tesargusmawan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-07-21T01:16:42Z","updated_at":"2016-07-21T08:07:59Z","closed_at":"2016-07-21T06:14:09Z","body":"This is happened in 4.0.0 Alpha 2, but I cannot reproduce the error.\r\n\r\nThe service stops working, maybe every 1 hour. This is the log message of `service pdns status`:\r\n\r\n> Backend reported condition which prevented lookup (GSQLBackend lookup query: Attempt to bind more parameters than query has: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?) sending out servfail \r\n\r\nRestart pdns service solves the problem. I didn't do anything at server-level when the service was running that could cause termination (ex: restart mysql service, or even add zone record)."},"comment":{"url":"https://api.github.com/repos/PowerDNS/pdns/issues/comments/234185331","html_url":"https://github.com/PowerDNS/pdns/issues/4216#issuecomment-234185331","issue_url":"https://api.github.com/repos/PowerDNS/pdns/issues/4216","id":234185331,"user":{"login":"tesargusmawan","id":12421725,"avatar_url":"https://avatars.githubusercontent.com/u/12421725?v=3","gravatar_id":"","url":"https://api.github.com/users/tesargusmawan","html_url":"https://github.com/tesargusmawan","followers_url":"https://api.github.com/users/tesargusmawan/followers","following_url":"https://api.github.com/users/tesargusmawan/following{/other_user}","gists_url":"https://api.github.com/users/tesargusmawan/gists{/gist_id}","starred_url":"https://api.github.com/users/tesargusmawan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tesargusmawan/subscriptions","organizations_url":"https://api.github.com/users/tesargusmawan/orgs","repos_url":"https://api.github.com/users/tesargusmawan/repos","events_url":"https://api.github.com/users/tesargusmawan/events{/privacy}","received_events_url":"https://api.github.com/users/tesargusmawan/received_events","type":"User","site_admin":false},"created_at":"2016-07-21T08:07:59Z","updated_at":"2016-07-21T08:07:59Z","body":"Just updated to 4.0.0.\r\n\r\nDifferent error log appeared maybe after 1 hour, though the service can still running:\r\n\r\n> Backend reported permanent error which prevented lookup (GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: MySQL server has gone away), aborting\r\n\r\n> Backend error (retry once): GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: MySQL server has gone away\r\n\r\nRestart pdns service solves the problem, at least in one hour."}}
{"actor":{"display_login":"tesargusmawan"}}