{"action":"opened","issue":{"url":"https://api.github.com/repos/sraustein/rpki-scratch-monkey/issues/1","repository_url":"https://api.github.com/repos/sraustein/rpki-scratch-monkey","labels_url":"https://api.github.com/repos/sraustein/rpki-scratch-monkey/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/sraustein/rpki-scratch-monkey/issues/1/comments","events_url":"https://api.github.com/repos/sraustein/rpki-scratch-monkey/issues/1/events","html_url":"https://github.com/sraustein/rpki-scratch-monkey/issues/1","id":168522169,"number":1,"title":"rpkid drops timer event when mysqld is down","user":{"login":"sraustein","id":5701713,"avatar_url":"https://avatars.githubusercontent.com/u/5701713?v=3","gravatar_id":"","url":"https://api.github.com/users/sraustein","html_url":"https://github.com/sraustein","followers_url":"https://api.github.com/users/sraustein/followers","following_url":"https://api.github.com/users/sraustein/following{/other_user}","gists_url":"https://api.github.com/users/sraustein/gists{/gist_id}","starred_url":"https://api.github.com/users/sraustein/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sraustein/subscriptions","organizations_url":"https://api.github.com/users/sraustein/orgs","repos_url":"https://api.github.com/users/sraustein/repos","events_url":"https://api.github.com/users/sraustein/events{/privacy}","received_events_url":"https://api.github.com/users/sraustein/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"sraustein","id":5701713,"avatar_url":"https://avatars.githubusercontent.com/u/5701713?v=3","gravatar_id":"","url":"https://api.github.com/users/sraustein","html_url":"https://github.com/sraustein","followers_url":"https://api.github.com/users/sraustein/followers","following_url":"https://api.github.com/users/sraustein/following{/other_user}","gists_url":"https://api.github.com/users/sraustein/gists{/gist_id}","starred_url":"https://api.github.com/users/sraustein/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sraustein/subscriptions","organizations_url":"https://api.github.com/users/sraustein/orgs","repos_url":"https://api.github.com/users/sraustein/repos","events_url":"https://api.github.com/users/sraustein/events{/privacy}","received_events_url":"https://api.github.com/users/sraustein/received_events","type":"User","site_admin":false},"assignees":[{"login":"sraustein","id":5701713,"avatar_url":"https://avatars.githubusercontent.com/u/5701713?v=3","gravatar_id":"","url":"https://api.github.com/users/sraustein","html_url":"https://github.com/sraustein","followers_url":"https://api.github.com/users/sraustein/followers","following_url":"https://api.github.com/users/sraustein/following{/other_user}","gists_url":"https://api.github.com/users/sraustein/gists{/gist_id}","starred_url":"https://api.github.com/users/sraustein/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sraustein/subscriptions","organizations_url":"https://api.github.com/users/sraustein/orgs","repos_url":"https://api.github.com/users/sraustein/repos","events_url":"https://api.github.com/users/sraustein/events{/privacy}","received_events_url":"https://api.github.com/users/sraustein/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-07-31T15:08:35Z","updated_at":"2016-07-31T15:08:35Z","closed_at":null,"body":"Initial report was \"rpkid doesn't seem to be updating anything except\r\nwhen I force it manually via the GUI\".  Postmortem showed that\r\ninternal cron had stopped running a month earlier, last entry showing\r\nit suggests that something awful had happened to mysqld, rpkid didn't\r\nhandle the error gracefully (ie, dropped the event due to the\r\nexception), and ever since then it had only been running when poked by\r\nsomething else (up-down, left right, ...).\r\n\r\nJun 28 09:32:33 work0 rpkid[1748]: Finished cron run started at 2011-06-28T09:32:08Z\r\nJun 28 09:34:08 work0 rpkid[1748]: Unhandled exception from timer: (2002, \"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)\")\r\nJun 28 09:34:08 work0 rpkid[1748]: Exception caught in errback() at /usr/local/lib/python2.6/site-packages/rpki/async.py:189 called from /usr/local/lib/python2.6/site-packages/rpki/async.py:212\r\nJun 28 09:34:08 work0 rpkid[1748]: Traceback (most recent call last):\r\nJun 28 09:34:08 work0 rpkid[1748]:   File \"/usr/local/lib/python2.6/site-packages/rpki/async.py\", line 208, in runq\r\nJun 28 09:34:08 work0 rpkid[1748]:     t.handler()\r\nJun 28 09:34:08 work0 rpkid[1748]:   File \"/usr/local/lib/python2.6/site-packages/rpki/rpkid.py\", line 294, in cron\r\nJun 28 09:34:08 work0 rpkid[1748]:     self.sql.ping()\r\nJun 28 09:34:08 work0 rpkid[1748]:   File \"/usr/local/lib/python2.6/site-packages/rpki/sql.py\", line 86, in ping\r\nJun 28 09:34:08 work0 rpkid[1748]:     return self.db.ping(True)\r\nJun 28 09:34:08 work0 rpkid[1748]: OperationalError: (2002, \"Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)\")\r\nJun 29 00:00:00 work0 newsyslog[37091]: logfile turned over due to size>100K\r\n\r\nPresumably we just need to handle the exception from self.db.ping().\r\n\r\nTest by turning off mysqld while between rpkid cron cycles and seeing\r\nhow rpkid responds."}}
{"actor":{"display_login":"sraustein"}}