Database Failed Verification and repairing plus recovery fails

I tried several times to recover from backup without success. Please see the error I receive below and advise.

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 10: ‘disk I/O error’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteException.cs:line 86
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 506
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 324
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteDataReader.cs:line 156
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 317
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 273
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 443
at MailClient.Storage.Data.DataStore.GetConnectionInternal(String relativeName, Boolean privateConnection) in C:\Users\filip\actions-runner_work\emclient\emclient\MailClient.Storage\Data\DataStore.cs:line 233
at MailClient.DbRepair.CorruptionChecker.CheckCorruption(RepairOptions repairOptions, CancellationToken token) in C:\Users\filip\actions-runner_work\emclient\emclient\MailClient\DbRepair\CorruptionChecker.cs:line 82
at MailClient.DbRepair.CheckingProcess.Check(CancellationToken token) in C:\Users\filip\actions-runner_work\emclient\emclient\MailClient\DbRepair\CheckingProcess.cs:line 41
Data:
databaseFile: 90137ec3-6c6b-4d0f-98aa-eb35ecb29d77\9e4781ca-a090-4ba9-8279-9628b88d3eec\mail_data.dat

Thanks,
Lexe

Close eM Client and run a disk check on your C: drive.
When that is done, restart Windows and eM Client and try again.

I am running Windows 11 and the client won’t start past the database scan. Also, there is nothing wrong with the drive. Is there any way to change the path of the data without starting the app 1st? Like a config file, for example?
Here is the message I get when starting the app and then fails:

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 11: ‘malformed database schema (17e7aae4efcd44a5)’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteException.cs:line 64
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 506
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 324
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteDataReader.cs:line 156
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 302
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 273
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery() in C:\Users\filip\actions-runner_work\emclient\emclient\Dependencies\Microsoft.Data.Sqlite.Core\SqliteCommand.cs:line 440
at MailClient.Storage.Data.DataStore.GetConnectionInternal(String relativeName, Boolean privateConnection) in C:\Users\filip\actions-runner_work\emclient\emclient\MailClient.Storage\Data\DataStore.cs:line 176
at MailClient.DbRepair.CorruptionChecker.CheckCorruption(RepairOptions repairOptions, CancellationToken token) in C:\Users\filip\actions-runner_work\emclient\emclient\MailClient\DbRepair\CorruptionChecker.cs:line 82
at MailClient.DbRepair.CheckingProcess.Check(CancellationToken token) in C:\Users\filip\actions-runner_work\emclient\emclient\MailClient\DbRepair\CheckingProcess.cs:line 41
Data:
databaseFile: 90137ec3-6c6b-4d0f-98aa-eb35ecb29d77\9e4781ca-a090-4ba9-8279-9628b88d3eec\conversations.dat

This usually means that the database is heavily corrupted so there are few options.

Some users have found that restarting Windows, or restarting eM Client a few times resolves the issue, but otherwise:

  1. If you have a recent backup, you can delete the current eM Client database, then restore the backup and eM Client should start working again without any problems.

  2. If you don’t have a backup, but all your data is synced with servers, then you can delete the database and start over. After adding your accounts, eM Client will resync with the server.

By default, the database is stored at C:\Users\yourusername\AppData\Roaming\eM Client. You may have to enable hidden items in Windows Explorer to get there. I suggest just renaming the eM Client folder, rather than deleting it, until everything is working again.

Renaming the bad data folder, unarchiving the backup data folder, and renaming the recovery folder worked! Thanks so much for your guidance!

1 Like