{"action":"reopened","issue":{"url":"https://api.github.com/repos/laurent22/joplin/issues/703","repository_url":"https://api.github.com/repos/laurent22/joplin","labels_url":"https://api.github.com/repos/laurent22/joplin/issues/703/labels{/name}","comments_url":"https://api.github.com/repos/laurent22/joplin/issues/703/comments","events_url":"https://api.github.com/repos/laurent22/joplin/issues/703/events","html_url":"https://github.com/laurent22/joplin/issues/703","id":346251636,"node_id":"MDU6SXNzdWUzNDYyNTE2MzY=","number":703,"title":"Ubuntu 18, SQLITE_CORRUPT","user":{"login":"kgolding","id":1952463,"node_id":"MDQ6VXNlcjE5NTI0NjM=","avatar_url":"https://avatars1.githubusercontent.com/u/1952463?v=4","gravatar_id":"","url":"https://api.github.com/users/kgolding","html_url":"https://github.com/kgolding","followers_url":"https://api.github.com/users/kgolding/followers","following_url":"https://api.github.com/users/kgolding/following{/other_user}","gists_url":"https://api.github.com/users/kgolding/gists{/gist_id}","starred_url":"https://api.github.com/users/kgolding/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kgolding/subscriptions","organizations_url":"https://api.github.com/users/kgolding/orgs","repos_url":"https://api.github.com/users/kgolding/repos","events_url":"https://api.github.com/users/kgolding/events{/privacy}","received_events_url":"https://api.github.com/users/kgolding/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-07-31T15:56:02Z","updated_at":"2018-09-06T17:00:05Z","closed_at":null,"author_association":"NONE","body":"### Operating system\r\n\r\n- Linux\r\n\r\n### Application\r\n\r\n- Desktop\r\n\r\nHave been trying to get Joplin running on Ubuntu 18 synced via Dropbox from a Windows PC. The sync kept getting stuck around 1276 items. I removed all the .config settings, and downloaded the appimage again and got the same issue. I left the previous install running for 7 days and it never got past 1276 items.\r\n\r\nSo, I have enabled debug mode, and have found this in the log:\r\n\r\n````2018-07-30 13:11:22: \"get 74f7d23b80fa48165e56fd6193e83ae3.md\"\r\n2018-07-30 13:11:23: \"Sync: createLocal: remote exists but local does not: (Remote 74f7d23b80fa48165e56fd6193e83ae3.md)\"\r\n2018-07-30 13:11:23: \"Reducer action\", \"SYNC_REPORT_UPDATE\"\r\n2018-07-30 13:11:23: \"get .resource/74f7d23b80fa48165e56fd6193e83ae3\"\r\n2018-07-30 13:15:35: \"Running background sync on timer...\"\r\n2018-07-30 13:15:35: \"Scheduling sync operation...\"\r\n2018-07-30 13:15:35: \"Preparing scheduled sync\"\r\n2018-07-30 13:15:35: \"Starting scheduled sync\"\r\n2018-07-30 13:15:36: \"Error: Error: SQLITE_CORRUPT: database disk image is malformed: \r\n\t\t\t\tSELECT items.`id`,items.`parent_id`,items.`title`,items.`body`,items.`created_time`,items.`updated_time`,items.`is_conflict`,items.`latitude`,items.`longitude`,items.`altitude`,items.`author`,items.`source_url`,items.`is_todo`,items.`todo_due`,items.`todo_completed`,items.`source`,items.`source_application`,items.`application_data`,items.`order`,items.`user_created_time`,items.`user_updated_time`,items.`encryption_cipher_text`,items.`encryption_applied`\r\n\t\t\t\tFROM `notes` items\r\n\t\t\t\tWHERE id NOT IN (\r\n\t\t\t\t\tSELECT item_id FROM sync_items WHERE sync_target = 7\r\n\t\t\t\t)\r\n\t\t\t\tAND is_conflict = 0 AND encryption_applied = 0\r\n\t\t\t\tLIMIT 100\r\n\t\t\t: \r\nCode: SQLITE_CORRUPT\r\nError: Error: SQLITE_CORRUPT: database disk image is malformed: \r\n\t\t\t\tSELECT items.`id`,items.`parent_id`,items.`title`,items.`body`,items.`created_time`,items.`updated_time`,items.`is_conflict`,items.`latitude`,items.`longitude`,items.`altitude`,items.`author`,items.`source_url`,items.`is_todo`,items.`todo_due`,items.`todo_completed`,items.`source`,items.`source_application`,items.`application_data`,items.`order`,items.`user_created_time`,items.`user_updated_time`,items.`encryption_cipher_text`,items.`encryption_applied`\r\n\t\t\t\tFROM `notes` items\r\n\t\t\t\tWHERE id NOT IN (\r\n\t\t\t\t\tSELECT item_id FROM sync_items WHERE sync_target = 7\r\n\t\t\t\t)\r\n\t\t\t\tAND is_conflict = 0 AND encryption_applied = 0\r\n\t\t\t\tLIMIT 100\r\n\t\t\t: \r\n    at DatabaseDriverNode.sqliteErrorToJsError (/tmp/.mount_JoplinJSV03Q/app/resources/app/lib/database-driver-node.js:22:16)\r\n    at JoplinDatabase.sqliteErrorToJsError (/tmp/.mount_JoplinJSV03Q/app/resources/app/lib/database.js:26:24)\r\n    at JoplinDatabase.tryCall (/tmp/.mount_JoplinJSV03Q/app/resources/app/lib/database.js:89:17)\r\n    at <anonymous>\r\n    at process._tickCallback (internal/process/next_tick.js:188:7)\"````\r\n\r\nI have opened the database in DB Browser and it seems to read all ok. Have also set auto sync to never."}}
{"actor":{"display_login":"laurent22"}}