{"action":"created","issue":{"url":"https://api.github.com/repos/Nandaka/PixivUtil2/issues/435","repository_url":"https://api.github.com/repos/Nandaka/PixivUtil2","labels_url":"https://api.github.com/repos/Nandaka/PixivUtil2/issues/435/labels{/name}","comments_url":"https://api.github.com/repos/Nandaka/PixivUtil2/issues/435/comments","events_url":"https://api.github.com/repos/Nandaka/PixivUtil2/issues/435/events","html_url":"https://github.com/Nandaka/PixivUtil2/issues/435","id":379468081,"node_id":"MDU6SXNzdWUzNzk0NjgwODE=","number":435,"title":"SQLite3 Operational Error Disk I/O Error","user":{"login":"JustAQuinn","id":23053651,"node_id":"MDQ6VXNlcjIzMDUzNjUx","avatar_url":"https://avatars3.githubusercontent.com/u/23053651?v=4","gravatar_id":"","url":"https://api.github.com/users/JustAQuinn","html_url":"https://github.com/JustAQuinn","followers_url":"https://api.github.com/users/JustAQuinn/followers","following_url":"https://api.github.com/users/JustAQuinn/following{/other_user}","gists_url":"https://api.github.com/users/JustAQuinn/gists{/gist_id}","starred_url":"https://api.github.com/users/JustAQuinn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JustAQuinn/subscriptions","organizations_url":"https://api.github.com/users/JustAQuinn/orgs","repos_url":"https://api.github.com/users/JustAQuinn/repos","events_url":"https://api.github.com/users/JustAQuinn/events{/privacy}","received_events_url":"https://api.github.com/users/JustAQuinn/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-11-10T22:31:03Z","updated_at":"2018-11-13T04:38:26Z","closed_at":"2018-11-13T04:38:26Z","author_association":"NONE","body":"### Prerequisites\r\n\r\n* [ X] Did you read FAQ section?\r\n* [releases/pixivutil20181105.zip] Did you test with the latest [releases](https://github.com/Nandaka/PixivUtil2/releases \"latest releases\") or [commit](https://github.com/Nandaka/PixivUtil2/commits/master \"latest commit\") ?\r\n\r\n### Description\r\n\r\nMy PixivUtil2 is NOT covered by any sync or backup tool I am aware of.\r\n\r\nAttempts to download image end in console logs stating the image was downloaded but due to a Disk I/O Error they could not be added to the sqlite3 database.\r\n\r\n### Steps to Reproduce\r\n\r\nIf it matters, my DB is pretty big. It's about 45MB with over 173000 image entries. I know this because I used DB Browser for SQLite and opened my db.sqlite file.\r\n\r\n1. Activate PixivUtil2\r\n2. Use the '1' setting to get a new artist or the '2' setting to download a singular image.\r\n3. Image is downloaded and placed in the directory. \r\n4. The program attempts to write it to the database.\r\n5. An error log appears touting I/O errors.\r\n6. Program fails, asking me to press any key to exit.\r\n\r\n**Expected behavior:** [What you expected to happen]\r\n\r\nPixivUtil20181105 - INFO -  done.\r\n\r\n**Actual behavior:** [What actually happened]\r\n\r\nPixivUtil20181105 - ERROR - Traceback (most recent call last):\r\n  File \"PixivUtil2.py\", line 859, in process_image\r\n  File \"PixivDBManager.pyc\", line 496, in insertImage\r\nOperationalError: disk I/O error\r\n\r\nPixivUtil20181105 - ERROR - Error at process_image(): [Image Number]\r\nPixivUtil20181105 - ERROR - Traceback (most recent call last):\r\n  File \"PixivUtil2.py\", line 867, in process_image\r\n  File \"PixivDBManager.pyc\", line 509, in insertMangaImage\r\nOperationalError: disk I/O error\r\n\r\n### Versions\r\nPixivUtil20180918 \r\nPixivUtil20181105\r\n\r\nThe same thing happens if I try to compact it. When I tried to throw the DB.sqlite file out and start anew (after backing up), it failed with the same errors at file database creation.\r\n\r\nTraceback (most recent call last):\r\n  File \"PixivUtil2.py\", line 2171, in main\r\n  File \"PixivDBManager.pyc\", line 55, in createDatabase\r\nOperationalError: disk I/O error"},"comment":{"url":"https://api.github.com/repos/Nandaka/PixivUtil2/issues/comments/438133251","html_url":"https://github.com/Nandaka/PixivUtil2/issues/435#issuecomment-438133251","issue_url":"https://api.github.com/repos/Nandaka/PixivUtil2/issues/435","id":438133251,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODEzMzI1MQ==","user":{"login":"JustAQuinn","id":23053651,"node_id":"MDQ6VXNlcjIzMDUzNjUx","avatar_url":"https://avatars3.githubusercontent.com/u/23053651?v=4","gravatar_id":"","url":"https://api.github.com/users/JustAQuinn","html_url":"https://github.com/JustAQuinn","followers_url":"https://api.github.com/users/JustAQuinn/followers","following_url":"https://api.github.com/users/JustAQuinn/following{/other_user}","gists_url":"https://api.github.com/users/JustAQuinn/gists{/gist_id}","starred_url":"https://api.github.com/users/JustAQuinn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JustAQuinn/subscriptions","organizations_url":"https://api.github.com/users/JustAQuinn/orgs","repos_url":"https://api.github.com/users/JustAQuinn/repos","events_url":"https://api.github.com/users/JustAQuinn/events{/privacy}","received_events_url":"https://api.github.com/users/JustAQuinn/received_events","type":"User","site_admin":false},"created_at":"2018-11-13T04:38:26Z","updated_at":"2018-11-13T04:38:26Z","author_association":"NONE","body":"Moved to another drive, it works. Just to be sure, I go back and try on the old drive without changing anything. Everything works fine now. Perhaps I just needed to restart my computer (and unmount and remount the drive).\r\n\r\nThanks for your help anyway, Nandaka. Stellar program."}}
{"actor":{"display_login":"JustAQuinn"}}