{"action":"created","issue":{"url":"https://api.github.com/repos/thp/urlwatch/issues/96","repository_url":"https://api.github.com/repos/thp/urlwatch","labels_url":"https://api.github.com/repos/thp/urlwatch/issues/96/labels{/name}","comments_url":"https://api.github.com/repos/thp/urlwatch/issues/96/comments","events_url":"https://api.github.com/repos/thp/urlwatch/issues/96/events","html_url":"https://github.com/thp/urlwatch/issues/96","id":178759590,"number":96,"title":"Sporadic SQLite error: Error binding parameter 0 - probably unsupported type.","user":{"login":"jwm","id":37176,"avatar_url":"https://avatars.githubusercontent.com/u/37176?v=3","gravatar_id":"","url":"https://api.github.com/users/jwm","html_url":"https://github.com/jwm","followers_url":"https://api.github.com/users/jwm/followers","following_url":"https://api.github.com/users/jwm/following{/other_user}","gists_url":"https://api.github.com/users/jwm/gists{/gist_id}","starred_url":"https://api.github.com/users/jwm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwm/subscriptions","organizations_url":"https://api.github.com/users/jwm/orgs","repos_url":"https://api.github.com/users/jwm/repos","events_url":"https://api.github.com/users/jwm/events{/privacy}","received_events_url":"https://api.github.com/users/jwm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-09-23T01:09:29Z","updated_at":"2016-10-24T14:01:58Z","closed_at":null,"body":"Hi Thomas, thanks for writing urlwatch, it's exactly what I needed.\r\n\r\nI have it watching ~100 URLs and sporadically get an SQLite exception on a subset of URLs for that run. It doesn't happen with any URL(s) in particular, but it does happen regularly (perhaps not every single run, but most of the time) and usually happens for a few URLs in a run.\r\n\r\nThis is with urlwatch 2.5, minidb 2.0.1, SQLite 3.8.7.1, and Python 3.4.2 (the latter two are from Debian jessie packaging).\r\n\r\nI put some debugging output in the affected exception handler. The query and args are:\r\n\r\n```\r\n  SELECT data, timestamp FROM CacheEntry WHERE guid = ? ORDER BY timestamp DESC LIMIT ?\r\n  ['2483ad9118822dd4099841a766fc86b65625d20e', 1]\r\n```\r\n\r\nIt's puzzling since I'd think the GUID would always be a string.\r\n\r\n```\r\n  Traceback (most recent call last):\r\n    File \"/usr/lib/python3/dist-packages/urlwatch/handler.py\", line 65, in process\r\n      self.load()\r\n    File \"/usr/lib/python3/dist-packages/urlwatch/handler.py\", line 57, in load\r\n      self.old_data, self.timestamp = self.cache_storage.load(self.job, self.job.get_guid())\r\n    File \"/usr/lib/python3/dist-packages/urlwatch/storage.py\", line 322, in load\r\n      where=CacheEntry.c.guid == guid, limit=1):\r\n    File \"/usr/local/lib/python3.4/dist-packages/minidb.py\", line 932, in query\r\n      return db.query(cls, select=select, where=where, order_by=order_by, group_by=group_by,\r\n  limit=limit)\r\n    File \"/usr/local/lib/python3.4/dist-packages/minidb.py\", line 401, in query\r\n      result = self._execute(sql, args)\r\n    File \"/usr/local/lib/python3.4/dist-packages/minidb.py\", line 158, in _execute\r\n      return self.db.execute(sql, args)\r\n  sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported type.\r\n```"},"comment":{"url":"https://api.github.com/repos/thp/urlwatch/issues/comments/255748984","html_url":"https://github.com/thp/urlwatch/issues/96#issuecomment-255748984","issue_url":"https://api.github.com/repos/thp/urlwatch/issues/96","id":255748984,"user":{"login":"thp","id":135241,"avatar_url":"https://avatars.githubusercontent.com/u/135241?v=3","gravatar_id":"","url":"https://api.github.com/users/thp","html_url":"https://github.com/thp","followers_url":"https://api.github.com/users/thp/followers","following_url":"https://api.github.com/users/thp/following{/other_user}","gists_url":"https://api.github.com/users/thp/gists{/gist_id}","starred_url":"https://api.github.com/users/thp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thp/subscriptions","organizations_url":"https://api.github.com/users/thp/orgs","repos_url":"https://api.github.com/users/thp/repos","events_url":"https://api.github.com/users/thp/events{/privacy}","received_events_url":"https://api.github.com/users/thp/received_events","type":"User","site_admin":false},"created_at":"2016-10-24T14:01:58Z","updated_at":"2016-10-24T14:01:58Z","body":"Do we have a test case that can reliably reproduce this is or is simply sporadic? Googling for that specific error message didn't yield anything that looks related."}}
{"actor":{"display_login":"thp"}}