All notes missing

OS version Windows Version 10.0.19044 Build 19044
Joplin Version : Joplin 2.7.15 (prod, win32)

Client ID: 6d5d77cf4e9a448492c07e361414ad52
Sync Version: 3
Profile Version: 41
Keychain Supported: Yes

Revision: 8352e23

Problem:
When I logged in this morning, I found Joplin not opening and after a restart of the laptop, Joplin app loaded but all my notes are missing. I am not syncing to any backup location. Is there anyway to recover the lost notes? A log snippet from after reboot is below:

2022-06-01 08:12:07: "Database was open successfully"
2022-06-01 08:12:07: "Checking for database schema update..."
2022-06-01 08:12:07: "Current database version", "null"
2022-06-01 08:12:07: "Upgrading database from version 0"
2022-06-01 08:12:07: "Converting database to version 1"
2022-06-01 08:12:07: "Converting database to version 2"
2022-06-01 08:12:07: "Converting database to version 3"
2022-06-01 08:12:07: "Converting database to version 4"
2022-06-01 08:12:07: "Converting database to version 5"
2022-06-01 08:12:07: "Converting database to version 6"
2022-06-01 08:12:07: "Converting database to version 7"
2022-06-01 08:12:07: "Converting database to version 8"
2022-06-01 08:12:07: "Converting database to version 9"
2022-06-01 08:12:07: "Converting database to version 10"
2022-06-01 08:12:07: "Converting database to version 11"
2022-06-01 08:12:07: "Converting database to version 12"
2022-06-01 08:12:07: "Converting database to version 13"
2022-06-01 08:12:07: "Converting database to version 14"
2022-06-01 08:12:07: "Converting database to version 15"
2022-06-01 08:12:07: "Converting database to version 16"
2022-06-01 08:12:07: "Converting database to version 17"
2022-06-01 08:12:07: "Converting database to version 18"
2022-06-01 08:12:07: "Converting database to version 19"
2022-06-01 08:12:07: "Converting database to version 20"
2022-06-01 08:12:07: "Converting database to version 21"
2022-06-01 08:12:07: "Converting database to version 22"
2022-06-01 08:12:07: "Converting database to version 23"
2022-06-01 08:12:07: "Converting database to version 24"
2022-06-01 08:12:07: "Converting database to version 25"
2022-06-01 08:12:07: "Converting database to version 26"
2022-06-01 08:12:07: "Converting database to version 27"
2022-06-01 08:12:07: "Converting database to version 28"
2022-06-01 08:12:07: "Converting database to version 29"
2022-06-01 08:12:07: "Converting database to version 30"
2022-06-01 08:12:07: "Converting database to version 31"
2022-06-01 08:12:07: "Converting database to version 32"
2022-06-01 08:12:07: "Converting database to version 33"
2022-06-01 08:12:07: "Converting database to version 34"
2022-06-01 08:12:07: "Migration failed with fallback and will not be repeated - saving version number"
2022-06-01 08:12:07: "Converting database to version 35"
2022-06-01 08:12:07: "Converting database to version 36"
2022-06-01 08:12:07: "Converting database to version 37"
2022-06-01 08:12:07: "Converting database to version 38"
2022-06-01 08:12:07: "Converting database to version 39"
2022-06-01 08:12:07: "Converting database to version 40"
2022-06-01 08:12:07: "Converting database to version 41"
2022-06-01 08:12:07: "New version: 41. Previously recorded version: 0"
2022-06-01 08:12:07: "Initializing tables..."
2022-06-01 08:12:07: "KeychainService: checking if keychain supported"
2022-06-01 08:12:07: "KeychainService: tried to set and get password. Result was:", "mytest"
2022-06-01 08:12:07: e2ee/utils: "Master password is not set - trying to get it from the active master key..."
2022-06-01 08:12:07: handleSyncStartupOperation: "Processing operation:", "0"
2022-06-01 08:12:07: App: "Client ID: 6d5d77cf4e9a448492c07e361414ad52"
2022-06-01 08:12:07: "First start: detected locale as en_GB"
2022-06-01 08:12:07: models/Setting: "Skipping all default migrations..."
2022-06-01 08:12:07: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:07: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:07: "ResourceFetcher: Auto-add resources: Mode: always"
2022-06-01 08:12:07: "ResourceFetcher: Auto-added resources: 0"
2022-06-01 08:12:07: "Running migration: 20"
2022-06-01 08:12:08: "Running migration: 27"
2022-06-01 08:12:08: "Running migration: 33"
2022-06-01 08:12:08: "SearchEngine: Updating FTS table..."
2022-06-01 08:12:08: "Running migration: 35"
2022-06-01 08:12:08: "SearchEngine: Updating FTS table..."
2022-06-01 08:12:09: App: ""syncInfoCache" was changed - setting up encryption related code"
2022-06-01 08:12:09: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:09: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:09: App: ""syncInfoCache" was changed - setting up encryption related code"
2022-06-01 08:12:09: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:09: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:09: App: ""syncInfoCache" was changed - setting up encryption related code"
2022-06-01 08:12:09: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:09: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:09: "app.start: doing regular boot"
2022-06-01 08:12:09: App: ""syncInfoCache" was changed - setting up encryption related code"
2022-06-01 08:12:09: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:09: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:09: App: ""syncInfoCache" was changed - setting up encryption related code"
2022-06-01 08:12:09: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:09: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:09: App: ""syncInfoCache" was changed - setting up encryption related code"
2022-06-01 08:12:09: e2ee/utils: "Trying to load 0 master keys..."
2022-06-01 08:12:09: e2ee/utils: "Loaded master keys: 0"
2022-06-01 08:12:09: RevisionService: "runInBackground: Starting background service with revision collection interval 600000"
2022-06-01 08:12:09: SpellCheckerServiceDriverNative: "Set effective language from "en-GB" to "en-GB""
2022-06-01 08:12:10: "DecryptionWorker: cannot start because no master key is currently loaded."
2022-06-01 08:12:10: "Preparing scheduled sync"
2022-06-01 08:12:10: "Sync cancelled - no sync target is selected."
2022-06-01 08:12:10: "Updating all notifications..."
2022-06-01 08:12:10: "Garbage collecting alarms..."
2022-06-01 08:12:11: "DecryptionWorker: cannot start because no master key is currently loaded."
2022-06-01 08:12:13: RevisionService: "maintenance: Starting..."
2022-06-01 08:12:13: RevisionService: "maintenance: Service is enabled"
2022-06-01 08:12:13: RevisionService: "collectRevisions: Created revisions for 0 notes"
2022-06-01 08:12:13: RevisionService: "maintenance: Done in 152ms"
2022-06-01 08:12:14: checkForUpdates: "Starting..."
2022-06-01 08:12:14: checkForUpdates: "Checking with options {"includePreReleases":false}"
2022-06-01 08:12:14: checkForUpdates: "Current version: 2.7.15"
2022-06-01 08:12:14: checkForUpdates: "Latest version: 2.7.15"
2022-06-01 08:12:14: checkForUpdates: "Is Pre-release:", "false"
2022-06-01 08:12:14: checkForUpdates: "Done."
2022-06-01 08:12:17: "SearchEngine: Updating FTS table..."
2022-06-01 08:12:17: "SearchEngine: Updated FTS table in 42ms. Inserted: 5. Deleted: 0"
2022-06-01 08:12:39: "ResourceService::indexNoteResources: Start"
2022-06-01 08:12:39: "ResourceService::indexNoteResources: Completed"
2022-06-01 08:12:39: "ResourceService::deleteOrphanResources:", ""
2022-06-01 08:12:40: "Preparing scheduled sync"
2022-06-01 08:12:40: "Sync cancelled - no sync target is selected."
2022-06

Many thanks

Pam

How far back does that log file go? It almost looks like there was no database for Joplin to connect to as that looks like the first lines of a new profile being created..

If you look at the properties of C:\Users\yourUsername\.config\joplin-desktop\database.sqlite, what is the created date?

If you have somehow lost the entire database and didn't make any backups then there isn't much that can be done unless you somehow just moved the contents of your profile directory to somewhere else on the machine by mistake.

The log file goes back to 2022-04-14 when the original notes were first created.

The sqllite file says it was created today- in line with the logfile. The notes were updated yesterday until midnight and saved.

No, I did not move the profile directory. When laptop was opened this morning, I was not able to open Joplin, so restarted the laptop.

Thank you
Pam

Additionally, I can also see all the image files from April in the /resources folder.

Unfortunately I don't know what to suggest then, the sqlite database is what holds literally all of your notebooks, notes, revisions etc. so if that has been lost somehow and the current database is brand new then there simply isn't anything to recover unless you can get that original sqlite database back.

Thank you for your time and help. I will see if there is any way to recover

No problem and I know it doesn't help but if (and I hope you can) you recover your notes then the best way to keep them backed up is by installing the Simple Backup plugin which can automate a note export that keeps everything safe (using joplin's sync alone isn't really a "proper" backup as anything that happens locally is often then reflected to the sync target).

I couldn't recover the notes but i had a backup from April and restored to that.
But unfortunately, Joplin is still giving me errors. I got the below error this afternoon and the notes are lost again.
image

Now I have reinstalled Joplin and restored to a previous backup. However, I am not able to export my notes as JEX as it's giving me the below error:

"Could not export notes: UNKNOWN: unknown error, open 'path to an.md file'"

Can you please look in to this problem?

Thanks

Just an idea, but have you been trying to synchronise the Joplin profile folder and then use it on different devices by any chance? If so, this can possibly lead to disastrous consequences. Also, please make sure your hardware (and specifically the disk, i.e. check the SMART data for it) is in good condition.

Not using it on other devices. Hardware checks are all OK.

It seems like your database might be corrupted somehow, if you search for sqlite_notadb you can find a bunch of stuff related to it.

You might want to have a look at seeing if you can repair a copy of it manually and see if that works. Although if you are at a point where the jex export works again I would strongly advise you start over with the imported jex file.