Client crashes on startup - eM Client (6.0.20498.0)

MikeI · June 28, 2014, 12:08pm

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.DbRepository1.RemoveByItems[ST](Object senderContext, IEnumerable1 items)    at MailClient.Storage.Data.SQLite.DbRepository1.Remove[ST](Object senderContext, IEnumerable1 items)    at MailClient.RepositoryExtensions.Remove[T,ST](IRepository1 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

100663598
System.Data.SQLite
System.Data.SQLite.SQLite3
Reset

System.Data.SQLite
System.Data.SQLite.SQLiteStatement
stmt

83
2c162

100663597
System.Data.SQLite
System.Data.SQLite.SQLite3
Step

System.Data.SQLite
System.Data.SQLite.SQLiteStatement
stmt

3c
bb

100663982
System.Data.SQLite
System.Data.SQLite.SQLiteDataReader
NextResult

12f
150

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

100663757
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteReader

System.Data
System.Data.CommandBehavior
behavior

c
26

100663760
System.Data.SQLite
System.Data.SQLite.SQLiteCommand
ExecuteNonQuery

6
21

100685560
MailClient
MailClient.Storage.Data.SQLite.DbMailRepository
RemoveOids

MailClient

mscorlib
System.Object
senderContext

mscorlib
System.String
oidList

mscorlib

items

22e
512

100670176
MailClient
MailClient.Storage.Data.SQLite.DbRepository1</type> <name>RemoveByItems</name> <genericarguments> <argument> <assembly>MailClient</assembly> <type></type> </argument> </genericarguments> <parameters> <parameter> <assembly>mscorlib</assembly> <type>System.Object</type> <name>senderContext</name> </parameter> <parameter> <assembly>mscorlib</assembly> <type></type> <name>items</name> </parameter> </parameters> </method> <offset>151</offset> <nativeoffset>366</nativeoffset> <frame> <method> <modulename>MailClient.exe</modulename> <metadatatoken>100670177</metadatatoken> <assembly>MailClient</assembly> <type>MailClient.Storage.Data.SQLite.DbRepository1
Remove

MailClient

mscorlib
System.Object
senderContext

mscorlib

items

1c
a0

100670256
MailClient
MailClient.RepositoryExtensions
Remove

MailClient

MailClient

MailClient

repository

mscorlib

items

0
5f

100668604
MailClient
MailClient.Imap.Synchronizer+SynchronizeMessagesCommand
RemoveDeletedMessages

MailClient
MailClient.Imap.ConnectionContext
context

11b
308

100668600
MailClient
MailClient.Imap.Synchronizer+SynchronizeMessagesCommand
ExecuteInternal

MailClient
MailClient.Commands.WorkerStatus
status

378
6e9

100668435
MailClient
MailClient.Imap.Synchronizer+ImapCommand
Execute

MailClient
MailClient.Commands.WorkerStatus
status

0
1d

100664006
MailClient
MailClient.Commands.Command
Process

MailClient
MailClient.Commands.WorkerStatus
status

15
53

100664056
MailClient
MailClient.Commands.SynchronizationQueue
ThreadWorker

mscorlib
System.Object
threadData

8c
11a

100669370
mscorlib
System.Threading.ThreadHelper
ThreadStart_Context

mscorlib
System.Object
state

25
9b

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

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

100668985
mscorlib
System.Threading.ExecutionContext
Run

mscorlib
System.Threading.ExecutionContext
executionContext

mscorlib
System.Threading.ContextCallback
callback

mscorlib
System.Object
state

2b
40

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)

Paul_Technical_Suppo · June 30, 2014, 9:18am

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

That’s what I ended up doing. I started over and rebuilding a new database. Yes, this is IMAP.

Paul_Technical_Suppo · June 30, 2014, 1:14pm

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

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.

Paul_Technical_Suppo · June 30, 2014, 1:43pm

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.