{"action":"created","issue":{"url":"https://api.github.com/repos/xybu/onedrive-d/issues/84","labels_url":"https://api.github.com/repos/xybu/onedrive-d/issues/84/labels{/name}","comments_url":"https://api.github.com/repos/xybu/onedrive-d/issues/84/comments","events_url":"https://api.github.com/repos/xybu/onedrive-d/issues/84/events","html_url":"https://github.com/xybu/onedrive-d/issues/84","id":47067447,"number":84,"title":"OperationalError: database is locked","user":{"login":"msunela","id":435402,"avatar_url":"https://avatars.githubusercontent.com/u/435402?v=3","gravatar_id":"","url":"https://api.github.com/users/msunela","html_url":"https://github.com/msunela","followers_url":"https://api.github.com/users/msunela/followers","following_url":"https://api.github.com/users/msunela/following{/other_user}","gists_url":"https://api.github.com/users/msunela/gists{/gist_id}","starred_url":"https://api.github.com/users/msunela/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msunela/subscriptions","organizations_url":"https://api.github.com/users/msunela/orgs","repos_url":"https://api.github.com/users/msunela/repos","events_url":"https://api.github.com/users/msunela/events{/privacy}","received_events_url":"https://api.github.com/users/msunela/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":14,"created_at":"2014-10-28T19:02:45Z","updated_at":"2015-02-26T02:36:37Z","closed_at":null,"body":"Quite soon after the start of the main.py, inotify and both worker threads die, because of database locking error. Here's the traceback:\r\n\r\n```python\r\nException in thread inotify:\r\nTraceback (most recent call last):\r\n  File \"/usr/lib/python3.4/threading.py\", line 920, in _bootstrap_inner\r\n    self.run()\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 277, in run\r\n    self.on_task_created(row)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 195, in on_task_created\r\n    self.cursor.execute('SELECT * FROM tasks WHERE task_type IN (\"get\", \"put\") AND local_path=?', (path + name,))\r\nsqlite3.OperationalError: database is locked\r\n\r\nException in thread worker-0:\r\nTraceback (most recent call last):\r\n  File \"/usr/lib/python3.4/threading.py\", line 920, in _bootstrap_inner\r\n    self.run()\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 405, in run\r\n    self.do_postwork(row)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 364, in do_postwork\r\n    self.update_entry(new_info)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 305, in update_entry\r\n    update_entry(self.conn, entry)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 109, in update_entry\r\n    '(:parent_path, :name, :id, :parent_id, :type, :size, :client_updated_time, :status)', entry)\r\nsqlite3.OperationalError: database is locked\r\n\r\nException in thread worker-1:\r\nTraceback (most recent call last):\r\n  File \"/usr/lib/python3.4/threading.py\", line 920, in _bootstrap_inner\r\n    self.run()\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 419, in run\r\n    self.do_postwork(row, update)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 364, in do_postwork\r\n    self.update_entry(new_info)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 305, in update_entry\r\n    update_entry(self.conn, entry)\r\n  File \"/home/share/onedrive-d/onedrive_d/daemon.py\", line 109, in update_entry\r\n    '(:parent_path, :name, :id, :parent_id, :type, :size, :client_updated_time, :status)', entry)\r\nsqlite3.OperationalError: database is locked\r\n```"},"comment":{"url":"https://api.github.com/repos/xybu/onedrive-d/issues/comments/76111927","html_url":"https://github.com/xybu/onedrive-d/issues/84#issuecomment-76111927","issue_url":"https://api.github.com/repos/xybu/onedrive-d/issues/84","id":76111927,"user":{"login":"xybu","id":2307178,"avatar_url":"https://avatars.githubusercontent.com/u/2307178?v=3","gravatar_id":"","url":"https://api.github.com/users/xybu","html_url":"https://github.com/xybu","followers_url":"https://api.github.com/users/xybu/followers","following_url":"https://api.github.com/users/xybu/following{/other_user}","gists_url":"https://api.github.com/users/xybu/gists{/gist_id}","starred_url":"https://api.github.com/users/xybu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xybu/subscriptions","organizations_url":"https://api.github.com/users/xybu/orgs","repos_url":"https://api.github.com/users/xybu/repos","events_url":"https://api.github.com/users/xybu/events{/privacy}","received_events_url":"https://api.github.com/users/xybu/received_events","type":"User","site_admin":false},"created_at":"2015-02-26T02:36:37Z","updated_at":"2015-02-26T02:36:37Z","body":"Give me 5 min so I can push my local stuff to \"future\".\n\nSent from my Windows Phone\n________________________________\nFrom: MM128<mailto:notifications@github.com>\nSent: ‎2/‎25/‎2015 9:35 PM\nTo: xybu/onedrive-d<mailto:onedrive-d@noreply.github.com>\nCc: Xiangyu Bu<mailto:xybu92@live.com>\nSubject: Re: [onedrive-d] OperationalError: database is locked (#84)\n\nOh, shit. Good call. I installed the 1.0 again.\n\n---\nReply to this email directly or view it on GitHub:\nhttps://github.com/xybu/onedrive-d/issues/84#issuecomment-76111835\n"}}