database disk image is malformed after the computer shuts down unexpectedly

[shenzhigang]

Operating system

macOS

Joplin version

3.2.11

Desktop version info

15.2

Current behaviour

Expected behaviour

No response

Logs

An error occurred: Fatal error:

Error: SQLITE_CORRUPT: database disk image is malformed: CREATE TABLE folders (id TEXT PRIMARY KEY, title TEXT NOT NULL DEFAULT "", created_time INT NOT NULL, updated_time INT NOT NULL);

Error: Error: SQLITE_CORRUPT: database disk image is malformed: CREATE TABLE folders (id TEXT PRIMARY KEY, title TEXT NOT NULL DEFAULT "", created_time INT NOT NULL, updated_time INT NOT NULL);
at DatabaseDriverNode.sqliteErrorToJsError (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database-driver-node.js:23:18)
at JoplinDatabase.sqliteErrorToJsError (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database.js:27:30)
at JoplinDatabase.tryCall (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database.js:130:32)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async JoplinDatabase.transactionExecBatch (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database.js:184:17)
at async JoplinDatabase.upgradeDatabase (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/JoplinDatabase.js:814:17)
at async JoplinDatabase.initialize (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/JoplinDatabase.js:886:28)
at async Application.start (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/BaseApplication.js:660:9)
at async Application.start (/Applications/Joplin.app/Contents/Resources/app.asar/app.js:365:16)
at async main (file:///Applications/Joplin.app/Contents/Resources/app.asar/main-html.js:119:22)

[laurent22]

That cannot be recovered from, so you'll need to recover from backup.

Note also that if you have the Backup plugin enabled, your data is saved to ~/JoplinBackup