MikeI
June 28, 2014, 12:08pm
1
Client crashes on start up then starts consistency check. Finishes restarts then crashes again. I’ve uninstalled/reinstalled, but same result as I didn’t want to start with a new database. Any other options to try and fix my existing database?
error has occurred:System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
SQL logic error or missing database
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader…ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at MailClient.Storage.Data.SQLite.DbMailRepository.RemoveOids[ST](Object senderContext, String oidList, IEnumerable1 items) at MailClient.Storage.Data.SQLite.DbRepository
1.RemoveByItems[ST](Object senderContext, IEnumerable1 items) at MailClient.Storage.Data.SQLite.DbRepository
1.Remove[ST](Object senderContext, IEnumerable1 items) at MailClient.RepositoryExtensions.Remove[T,ST](IRepository
1 repository, IEnumerable`1 items)
at MailClient.Imap.Synchronizer.SynchronizeMessagesCommand.RemoveDeletedMessages(ConnectionContext context)
at MailClient.Imap.Synchronizer.SynchronizeMessagesCommand.ExecuteInternal(WorkerStatus status)
at MailClient.Imap.Synchronizer.ImapCommand.Execute(WorkerStatus status)
at MailClient.Commands.Command.Process(WorkerStatus status)
at MailClient.Commands.SynchronizationQueue.ThreadWorker(Object threadData)
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)
" rel=“nofollow”>http://emclient.com/ns/report ">; eM Client 6.0.20498.0 false Microsoft Windows NT 6.2.9200.0 4.0.30319.34014 System.Data.SQLite.SQLiteException SQL logic error or missing database SQL logic error or missing database System.Data.SQLite
System.Data.SQLite.dll 100663598 System.Data.SQLite System.Data.SQLite.SQLite3 Reset System.Data.SQLite System.Data.SQLite.SQLiteStatement stmt 83 2c162
System.Data.SQLite.dll 100663597 System.Data.SQLite System.Data.SQLite.SQLite3 Step System.Data.SQLite System.Data.SQLite.SQLiteStatement stmt 3c bb
System.Data.SQLite.dll 100663982 System.Data.SQLite System.Data.SQLite.SQLiteDataReader NextResult 12f 150
System.Data.SQLite.dll 100663943 System.Data.SQLite System.Data.SQLite.SQLiteDataReader .ctor System.Data.SQLite System.Data.SQLite.SQLiteCommand cmd System.Data System.Data.CommandBehavior behave 5d 71
System.Data.SQLite.dll 100663757 System.Data.SQLite System.Data.SQLite.SQLiteCommand ExecuteReader System.Data System.Data.CommandBehavior behavior c 26
System.Data.SQLite.dll 100663760 System.Data.SQLite System.Data.SQLite.SQLiteCommand ExecuteNonQuery 6 21
MailClient.exe 100685560 MailClient MailClient.Storage.Data.SQLite.DbMailRepository RemoveOids MailClient mscorlib System.Object senderContext mscorlib System.String oidList mscorlib items 22e 512
MailClient.exe 100670176 MailClient MailClient.Storage.Data.SQLite.DbRepository1</type><br> <name>RemoveByItems</name><br> <genericarguments><br> <argument><br> <assembly>MailClient</assembly><br> <type></type><br> </argument><br> </genericarguments><br> <parameters><br> <parameter><br> <assembly>mscorlib</assembly><br> <type>System.Object</type><br> <name>senderContext</name><br> </parameter><br> <parameter><br> <assembly>mscorlib</assembly><br> <type></type><br> <name>items</name><br> </parameter><br> </parameters><br> </method><br> <offset>151</offset><br> <nativeoffset>366</nativeoffset><br> <br> <frame> <br> <method><br> <modulename>MailClient.exe</modulename><br> <metadatatoken>100670177</metadatatoken><br> <assembly>MailClient</assembly><br> <type>MailClient.Storage.Data.SQLite.DbRepository
1 Remove MailClient mscorlib System.Object senderContext mscorlib items 1c a0
MailClient.exe 100670256 MailClient MailClient.RepositoryExtensions Remove MailClient MailClient MailClient repository mscorlib items 0 5f
MailClient.exe 100668604 MailClient MailClient.Imap.Synchronizer+SynchronizeMessagesCommand RemoveDeletedMessages MailClient MailClient.Imap.ConnectionContext context 11b 308
MailClient.exe 100668600 MailClient MailClient.Imap.Synchronizer+SynchronizeMessagesCommand ExecuteInternal MailClient MailClient.Commands.WorkerStatus status 378 6e9
MailClient.exe 100668435 MailClient MailClient.Imap.Synchronizer+ImapCommand Execute MailClient MailClient.Commands.WorkerStatus status 0 1d
MailClient.exe 100664006 MailClient MailClient.Commands.Command Process MailClient MailClient.Commands.WorkerStatus status 15 53
MailClient.exe 100664056 MailClient MailClient.Commands.SynchronizationQueue ThreadWorker mscorlib System.Object threadData 8c 11a
mscorlib.dll 100669370 mscorlib System.Threading.ThreadHelper ThreadStart_Context mscorlib System.Object state 25 9b
mscorlib.dll 100668987 mscorlib System.Threading.ExecutionContext RunInternal mscorlib System.Threading.ExecutionContext executionContext mscorlib System.Threading.ContextCallback callback mscorlib System.Object state mscorlib System.Boolean preserveSyncCtx 70 a6
mscorlib.dll 100668986 mscorlib System.Threading.ExecutionContext Run mscorlib System.Threading.ExecutionContext executionContext mscorlib System.Threading.ContextCallback callback mscorlib System.Object state mscorlib System.Boolean preserveSyncCtx 0 15
mscorlib.dll 100668985 mscorlib System.Threading.ExecutionContext Run mscorlib System.Threading.ExecutionContext executionContext mscorlib System.Threading.ContextCallback callback mscorlib System.Object state 2b 40
mscorlib.dll 100669367 mscorlib System.Threading.ThreadHelper ThreadStart mscorlib System.Object obj f 4d 0 MailClient.exe C:\Program Files (x86)\eM Client\MailClient.exe MailClient.exe MailClient.exe 6.0.20498.0 eM Client eM Client 6.0.20498.0 False False False False False Language Neutral ntdll.dll C:\WINDOWS\SYSTEM32\ntdll.dll ntdll.dll ntdll.dll.mui 6.3.9600.17031 (winblue_gdr.140221-1952) NT Layer DLL Microsoft® Windows® Operating System 6.3.9600.17031 False False False False False English (United States) MSCOREE.DLL C:\WINDOWS\SYSTEM32\MSCOREE.DLL mscoree.dll mscoree.dll 6.3.9600.16384 (winblue_rtm.130821-1623) Microsoft .NET Runtime Execution Engine Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) KERNEL32.dll C:\WINDOWS\SYSTEM32\KERNEL32.dll kernel32 kernel32 6.3.9600.17031 (winblue_gdr.140221-1952) Windows NT BASE API Client DLL Microsoft® Windows® Operating System 6.3.9600.17031 False False False False False English (United States) KERNELBASE.dll C:\WINDOWS\SYSTEM32\KERNELBASE.dll Kernelbase.dll Kernelbase.dll.mui 6.3.9600.17031 (winblue_gdr.140221-1952) Windows NT BASE API Client DLL Microsoft® Windows® Operating System 6.3.9600.17031 False False False False False English (United States) ADVAPI32.dll C:\WINDOWS\SYSTEM32\ADVAPI32.dll advapi32.dll advapi32.dll.mui 6.3.9600.16384 (winblue_rtm.130821-1623) Advanced Windows 32 Base API Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) msvcrt.dll C:\WINDOWS\SYSTEM32\msvcrt.dll msvcrt.dll msvcrt.dll 7.0.9600.16384 (winblue_rtm.130821-1623) Windows NT CRT DLL Microsoft® Windows® Operating System 7.0.9600.16384 False False False False False English (United States) sechost.dll C:\WINDOWS\SYSTEM32\sechost.dll sechost.dll sechost.dll.mui 6.3.9600.16384 (winblue_rtm.130821-1623) Host for SCM/SDDL/LSA Lookup APIs Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) RPCRT4.dll C:\WINDOWS\SYSTEM32\RPCRT4.dll rpcrt4.dll rpcrt4.dll.mui 6.3.9600.16384 (winblue_rtm.130821-1623) Remote Procedure Call Runtime Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) SspiCli.dll C:\WINDOWS\SYSTEM32\SspiCli.dll security.dll security.dll 6.3.9600.16408 (winblue_gdr.130920-1803) Security Support Provider Interface Microsoft® Windows® Operating System 6.3.9600.16408 False False False False False English (United States) CRYPTBASE.dll C:\WINDOWS\SYSTEM32\CRYPTBASE.dll cryptbase.dll cryptbase.dll 6.3.9600.16384 (winblue_rtm.130821-1623) Base cryptographic API DLL Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) bcryptPrimitives.dll C:\WINDOWS\SYSTEM32\bcryptPrimitives.dll bcryptprimitives.dll bcryptprimitives.dll 6.3.9600.17031 (winblue_gdr.140221-1952) Windows Cryptographic Primitives Library Microsoft® Windows® Operating System 6.3.9600.17031 False False False False False English (United States) mscoreei.dll C:\Windows\Microsoft.NET \Framework\v4.0.30319\mscoreei.dll mscoreei.dll mscoreei.dll 4.0.30319.34014 built by: FX45W81RTMGDR Microsoft .NET Runtime Execution Engine Microsoft® .NET Framework 4.0.30319.34014 False False False True False English (United States) SHLWAPI.dll C:\WINDOWS\SYSTEM32\SHLWAPI.dll SHLWAPI SHLWAPI.DLL.MUI 6.3.9600.16384 (winblue_rtm.130821-1623) Shell Light-weight Utility Library Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) combase.dll C:\WINDOWS\SYSTEM32\combase.dll COMBASE.DLL COMBASE.DLL.MUI 6.3.9600.16384 (winblue_rtm.130821-1623) Microsoft COM for Windows Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) USER32.dll C:\WINDOWS\SYSTEM32\USER32.dll user32 user32 6.3.9600.16384 (winblue_rtm.130821-1623) Multi-User Windows USER API Client DLL Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) GDI32.dll C:\WINDOWS\SYSTEM32\GDI32.dll gdi32 gdi32 6.3.9600.17111 (winblue_gdr.140429-1523) GDI Client DLL Microsoft® Windows® Operating System 6.3.9600.17111 False False False False False English (United States) IMM32.DLL C:\WINDOWS\system32\IMM32.DLL imm32 imm32 6.3.9600.17031 (winblue_gdr.140221-1952) Multi-User Windows IMM32 API Client DLL Microsoft® Windows® Operating System 6.3.9600.17031 False False False False False English (United States) MSCTF.dll C:\WINDOWS\SYSTEM32\MSCTF.dll MSCTF MSCTF.DLL.MUI 6.3.9600.16384 (winblue_rtm.130821-1623) MSCTF Server DLL Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) clr.dll C:\Windows\Microsoft.NET \Framework\v4.0.30319\clr.dll clr.dll clr.dll 4.0.30319.34014 built by: FX45W81RTMGDR Microsoft .NET Runtime Common Language Runtime - WorkStation Microsoft® .NET Framework 4.0.30319.34014 False False False True False English (United States) MSVCR120_CLR0400.dll C:\WINDOWS\SYSTEM32\MSVCR120_CLR0400.dll msvcr120_clr0400.dll msvcr120_clr0400.dll 12.00.20806.33440 built by: FX45W81RTMREL Microsoft® C Runtime Library Microsoft® Visual Studio® 12 CTP 12.00.20806.33440 False False False False False English (United States) mscorlib.ni.dll C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\mscorlib\c90ef9a73ea0044641d31b19023aad61\mscorlib.ni.dll mscorlib.dll mscorlib.dll 4.0.30319.34014 built by: FX45W81RTMGDR Microsoft Common Language Runtime Class Library Microsoft® .NET Framework 4.0.30319.34014 False False False True False English (United States) ole32.dll C:\WINDOWS\SYSTEM32\ole32.dll OLE32.DLL OLE32.DLL.MUI 6.3.9600.16384 (winblue_rtm.130821-1623) Microsoft OLE for Windows Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States) kernel.appcore.dll C:\WINDOWS\SYSTEM32\kernel.appcore.dll kernel.appcore.dll kernel.appcore.dll 6.3.9600.16384 (winblue_rtm.130821-1623) AppModel API Host Microsoft® Windows® Operating System 6.3.9600.16384 False False False False False English (United States)
Hi Mike, unfortunately this seems like a broken/corrupt database.
You can try to download this tool http://www.emclient.com/tools/dbrepairrebuildall.exe and run it, but if that won’t help, I’m afraid you’ll have to setup a fresh database? Do you have backup? Did you have any local data in eM Client? Are you using IMAP?
Thank you,
Paul.
MikeI
June 30, 2014, 1:08pm
3
That’s what I ended up doing. I started over and rebuilding a new database. Yes, this is IMAP.
Hi again Mike, if you still have the original database, you could send us your sqlite.log file for more information on why this crash occurred, but if the dbrepair tool doesn’t work, there’s not much we could do about it.
I suggest keeping a backup if you want to be sure not to lose any local data, but if you’re using IMAP all your data should be safe on the server.
Thank you and sorry for the inconvenience,
Paul.
MikeI
June 30, 2014, 1:17pm
5
I didn’t lose any data because I am using IMAP and both mailboxes just rebuilt themselves, it just took a long time as they’re rather large.
I understand, again sorry for the inconvenience, hope this won’t happen again, let us know if you come across any other issue or questions.
Thank you,
Paul.