The error "IMEX failed to complete: could not export database: [...] Error code 1: SQL error or missing database" should list the actual errno or the actual SQL error message in full

[ell1e]

I've seen a user, who apparently tried to export a backup in delta chat desktop, come to me with the following error: IMEX failed to complete: could not export database: failed to export attached backup data base: disk I/O error: Error code 1: SQL error or missing database In the log file, there doesn't seem to be anything more specific either than this vague error message.

If I'm reading this error correctly, it might include 1. any errno like EIO with an actual disk error indicating a hardware problem, 2. or any errno like EPERM indicating a permission problem, 3. or any errno like ENOENT indicating the database was moved around or the path somehow assembled wrongly indicating an install problem, 4. or any SQL error indicating any sort of schema problem with the underlying database.

This seems like too many potential error sources mapped to a single error message. I suggest that the error message should include either the actual system errno on Linux, or the actual SQL error in case of a schema issue.

• Operating System (Linux/Mac/Windows/iOS/Android): Linux
• Delta Chat Version: Delta Chat Desktop 1.52.1 from flathub, Delta Chat Core v1.155.1
• Expected behavior: The error message gives either the exact system errno on Linux, or the SQL error message in full, or at least logs this information to the log file.
• Actual behavior: Neither the error message nor the log file seem to include the detailed underlying error.
• Steps to reproduce the problem: 1. Not sure how exactly users commonly run into this error
• Screenshots:
• Logs:

[link2xt]

Another similar bug #5933, also flathub

[ell1e]

I could be wrong but I think the person mentioned using Linux Mint.

[ell1e]

Perhaps a more detailed error message, e.g. one that shows the errno, would help with figuring out what the underlying problem is?

[link2xt]

Possibly fixed by flathub/chat.delta.desktop#158

[Hocuri]

Perhaps a more detailed error message, e.g. one that shows the errno, would help with figuring out what the underlying problem is?

I don't think we can do anything here. The error comes from here:

core/src/imex.rs

Lines 796 to 798 in 483f4ea

	let res = conn
	.query_row("SELECT sqlcipher_export('backup')", [], |_row| Ok(()))
	.context("failed to export to attached backup database");

and "disk I/O error: Error code 1: SQL error or missing database" is what rusqlite gives us. Maybe it could be fixed in rusqlite, maybe in SQLite, I don't know.

Since there is nothing actionable here, I think we can close this issue?

[ell1e]

Thanks so much for looking into this.