SQLITE_ERROR (error in sync window)

Support
1

Upon syncing, this error crops up. Anyone see this before? Is that a Sqlite error come from local disk? Or from dropbox on the other end?

Completed: 2020-05-01 12:39
Last error: Error: Error: SQLITE_ERROR: no such column: items.type_: SELECT 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.`

And I am beginning to wonder if some database issue is the reason for this longstanding problem.

2

I’ve seen this a few times on Android but only when running a version built from sources. Restarting the app fixes the issue.

3

Hmm, that’s not good, type_ is an internal property which shouldn’t appear in SELECT statements. Could you post the complete log before and after this line please? By the way which version is it?

4

Sure. And this is Joplin 1.0.201 (upgraded over several years). On Fedora 31.

2020-05-01 12:39:00: "Profile directory: /home/todd/.config/joplin-desktop"
2020-05-01 12:39:00: "Trying to load 2 master keys..."
2020-05-01 12:39:00: "Loaded master keys: 2"
2020-05-01 12:39:00: "ResourceFetcher: Auto-add resources: Mode: always"
2020-05-01 12:39:00: "ResourceFetcher: Auto-added resources: 0"
2020-05-01 12:39:00: "Refreshing notes:", "null", "null"
2020-05-01 12:39:00: "Trying to load 2 master keys..."
2020-05-01 12:39:00: "Loaded master keys: 2"
2020-05-01 12:39:00: "Scheduling sync operation...", "10000"
2020-05-01 12:39:00: "Setting up recurrent sync with interval 300"
2020-05-01 12:39:00: "Trying to load 2 master keys..."
2020-05-01 12:39:00: "Loaded master keys: 2"
2020-05-01 12:39:00: "Scheduling sync operation...", "10000"
2020-05-01 12:39:00: "Trying to load 2 master keys..."
2020-05-01 12:39:00: "Loaded master keys: 2"
2020-05-01 12:39:00: "Scheduling sync operation...", "10000"
2020-05-01 12:39:00: "Refreshing notes:", "2", "7266a242783c44a4b3cef7b87bc77ef9"
2020-05-01 12:39:00: "Scheduling sync operation...", "10000"
2020-05-01 12:39:00: "RevisionService::runInBackground: Starting background service with revision collection interval 600000"
2020-05-01 12:39:01: "DecryptionWorker: starting decryption..."
2020-05-01 12:39:01: "DecryptionWorker: completed decryption."
2020-05-01 12:39:04: "RevisionService::maintenance: Starting..."
2020-05-01 12:39:04: "RevisionService::maintenance: Service is enabled"
2020-05-01 12:39:04: "RevisionService::collectRevisions: Saved revision be178282feeb4b19b43097a4ae13d148 (for deleted note)"
2020-05-01 12:39:04: "RevisionService::collectRevisions: Created revisions for 1 notes"
2020-05-01 12:39:04: "RevisionService::maintenance: Done in 190ms"
2020-05-01 12:39:10: "SearchEngine: Updating FTS table..."
2020-05-01 12:39:10: "Preparing scheduled sync"
2020-05-01 12:39:10: "Saving updated Dropbox auth."
2020-05-01 12:39:10: "Starting scheduled sync"
2020-05-01 12:39:10: "Sync: starting: Starting synchronisation to target 7... [1588351150214]"
2020-05-01 12:39:10: "mkdir .sync"
2020-05-01 12:39:10: "SearchEngine: Updated FTS table in 59ms. Inserted: 0. Deleted: 0"
2020-05-01 12:39:24: "mkdir .lock"
2020-05-01 12:39:26: "mkdir .resource"
2020-05-01 12:39:29: "list "
2020-05-01 12:39:30: "ResourceService::indexNoteResources: Start"
2020-05-01 12:39:30: "ResourceService::indexNoteResources: Completed"
2020-05-01 12:39:30: "ResourceService::deleteOrphanResources:", "[]"
2020-05-01 12:39:32: "get .sync/version.txt"
2020-05-01 12:39:35: "put .sync/version.txt", "null"
2020-05-01 12:39:39: "Error: Error: SQLITE_ERROR: no such column: items.type_: 
2020-05-01 12:39:39: "Sync: finished: Synchronisation finished [1588351150214]"
2020-05-01 12:39:39: "Operations completed: "
2020-05-01 12:39:39: "Total folders: 89"
2020-05-01 12:39:39: "Total notes: 538"
2020-05-01 12:39:39: "Total resources: 281"
2020-05-01 12:39:39: "There was some errors:"
2020-05-01 12:39:39: "Error: Error: SQLITE_ERROR: no such column: items.type_: 
2020-05-01 12:39:39: "Setting up recurrent sync with interval 300"
2020-05-01 12:39:39: "Updating all notifications..."
2020-05-01 12:39:39: "Garbage collecting alarms..."
2020-05-01 12:39:40: "DecryptionWorker: starting decryption..."
2020-05-01 12:39:40: "DecryptionWorker: completed decryption."
2020-05-01 12:44:39: "Running background sync on timer..."
2020-05-01 12:44:39: "Scheduling sync operation...", "0"
2020-05-01 12:44:39: "Preparing scheduled sync"
2020-05-01 12:44:39: "Starting scheduled sync"
2020-05-01 12:44:39: "Sync: starting: Starting synchronisation to target 7... [1588351479230]"
2020-05-01 12:44:39: "mkdir .sync"
2020-05-01 12:44:42: "mkdir .lock"
2020-05-01 12:44:44: "mkdir .resource"
2020-05-01 12:44:48: "list "
2020-05-01 12:44:55: "get .sync/version.txt"
2020-05-01 12:45:01: "put .sync/version.txt", "null"
2020-05-01 12:45:06: "Error: Error: SQLITE_ERROR: no such column: items.type_: 
2020-05-01 12:45:06: "Sync: finished: Synchronisation finished [1588351479230]"
2020-05-01 12:45:06: "Operations completed: "
2020-05-01 12:45:06: "Total folders: 89"
2020-05-01 12:45:06: "Total notes: 538"
2020-05-01 12:45:06: "Total resources: 281"
2020-05-01 12:45:06: "There was some errors:"
2020-05-01 12:45:06: "Error: Error: SQLITE_ERROR: no such column: items.type_: 
2020-05-01 12:45:06: "Setting up recurrent sync with interval 300"
2020-05-01 12:45:07: "DecryptionWorker: starting decryption..."
2020-05-01 12:45:08: "DecryptionWorker: completed decryption."
2020-05-01 12:49:00: "RevisionService::maintenance: Starting..."
2020-05-01 12:49:00: "RevisionService::maintenance: Service is enabled"
2020-05-01 12:49:00: "RevisionService::collectRevisions: Created revisions for 0 notes"
2020-05-01 12:49:00: "RevisionService::maintenance: Done in 118ms"
2020-05-01 12:50:06: "Running background sync on timer..."
2020-05-01 12:50:06: "Scheduling sync operation...", "0"
2020-05-01 12:50:06: "Preparing scheduled sync"
2020-05-01 12:50:06: "Starting scheduled sync"
2020-05-01 12:50:06: "Sync: starting: Starting synchronisation to target 7... [1588351806967]"
2020-05-01 12:50:06: "mkdir .sync"
2020-05-01 12:50:09: "mkdir .lock"
2020-05-01 12:50:11: "mkdir .resource"
2020-05-01 12:50:13: "list "
2020-05-01 12:50:15: "get .sync/version.txt"
2020-05-01 12:50:17: "put .sync/version.txt", "null"
2020-05-01 12:50:20: "Error: Error: SQLITE_ERROR: no such column: items.type_: 
2020-05-01 12:50:20: "Sync: finished: Synchronisation finished [1588351806967]"
2020-05-01 12:50:20: "Operations completed: "
2020-05-01 12:50:20: "Total folders: 89"
2020-05-01 12:50:20: "Total notes: 538"
2020-05-01 12:50:20: "Total resources: 281"
2020-05-01 12:50:20: "There was some errors:"
2020-05-01 12:50:20: "Error: Error: SQLITE_ERROR: no such column: items.type_: 
2020-05-01 12:50:20: "Setting up recurrent sync with interval 300"
2020-05-01 12:50:21: "DecryptionWorker: starting decryption..."
2020-05-01 12:50:21: "DecryptionWorker: completed decryption."
1 Like