CEDB grows up infinit and slow down the system

fs-support_ZU · Sep 2nd 2011

Hello,
in the last time we encounter more and more the problem that CEDB grows up infinite. After some investigations we saw that the launch of some .NET applications causes this problem. We were not able to isolate the area within the .NET application which causes the problem until now. But we checked CEDB and find that one entry for "repllog.exe" is inserted after each reboot. This behavior may slow down the system (e.g. ActiveSync does not connect any more ...).

Use the following workaround to prevent growing of CEDB.
1. check CEDB for multiple entries
2. delete the multiple entries

Sample code

C

#include "stdafx.h"
#include <windows.h>
#include <commctrl.h>
#include <afx.h>
CEOID DBqueue;
WORD QueueRecs = 0;
CEOID DBevents;
WORD EventRecs = 0;
void CheckFor_DB_notify(void);
void CheckAndDelete_DB_notify_multiple(void);
int _tmain(int argc, _TCHAR* argv[])
{
// List the avail. DBs
CheckFor_DB_notify();
// Check "DBevents" for multiple entries and delete them
if(DBevents != 0)
CheckAndDelete_DB_notify_multiple();
// TODO: check next DB ...
return 0;
}
// ******************************************************************************
// List DBs and chech access to "DBevents"
void CheckFor_DB_notify()
{
HANDLE FoundDB;
CEOID CurrentOID;
CEOID ceoidRet=0;
CString sQueue =_T("DB_notify_queue");
CString sEvents =_T("DB_notify_events");
FoundDB = CeFindFirstDatabaseEx(NULL, 0);
if(FoundDB == INVALID_HANDLE_VALUE)
{
RETAILMSG( 1, (TEXT("No Databases found\r\n")));
}
else
{
while( CurrentOID = CeFindNextDatabaseEx( FoundDB, 0 ) )
{
CEOIDINFO OIDInfo;
RETAILMSG( 1, (TEXT("Database found\n")));
if(CeOidGetInfoEx(NULL, CurrentOID, &OIDInfo))
{
if(OIDInfo.wObjType == OBJTYPE_DATABASE)
{
RETAILMSG(1, (TEXT(" Database: %s\r\n"), OIDInfo.infDatabase.szDbaseName ));
RETAILMSG(1, (TEXT(" Size: %d\r\n"), OIDInfo.infDatabase.dwSize ));
RETAILMSG(1, (TEXT(" Records: %d\r\n"), OIDInfo.infDatabase.wNumRecords ));
if (sQueue.CompareNoCase(OIDInfo.infDatabase.szDbaseName) == 0)
{
DBqueue = CurrentOID;
QueueRecs = OIDInfo.infDatabase.wNumRecords;
}
else if (sEvents.CompareNoCase(OIDInfo.infDatabase.szDbaseName) == 0)
{
DBevents = CurrentOID;
EventRecs = OIDInfo.infDatabase.wNumRecords;
}
}
else
RETAILMSG( 1, (TEXT("Failed to get info for this database\r\n")));
}
}
CloseHandle( FoundDB );
}
}
// ******************************************************************************
// Check "DBevents" for multiple entries and delete them
void CheckAndDelete_DB_notify_multiple(void)
{
CEGUID guid;
CREATE_SYSTEMGUID(&guid);
HANDLE hDatabase = CeOpenDatabaseEx2(&guid, &DBevents, NULL,NULL,CEDB_AUTOINCREMENT, NULL);
if(hDatabase != INVALID_HANDLE_VALUE)
{
WORD wPropId = 0;
CEPROPVAL* Buffer = NULL;
DWORD dwSizeOfBuffer = 0;
CEOID ceoidRecord;
DWORD checked=0;
DWORD deleted = 0;
while (ceoidRecord = CeReadRecordPropsEx(hDatabase, CEDB_ALLOWREALLOC, &wPropId, /*Number of properties*/NULL,
(LPBYTE*) &Buffer, &dwSizeOfBuffer, NULL/*hHeap*/))
{
CEPROPVAL* BufferCmp = NULL;
DWORD dwSizeOfBufferCmp = 0;
WORD wPropIdCmp = 0;
for(WORD i=0 ;i<EventRecs-1-checked-deleted; i++)
{
CEOID ceoidRecordCmp = CeReadRecordPropsEx(hDatabase, CEDB_ALLOWREALLOC,
&wPropIdCmp, /*Number of properties*/NULL, (LPBYTE*)&BufferCmp, &dwSizeOfBufferCmp, /*hHeap*/NULL);
if( ceoidRecordCmp && wcscmp(Buffer->val.lpwstr,BufferCmp->val.lpwstr) == 0 /*&& TODO: do additional
comparison checks*/)
{
RETAILMSG( 1, (TEXT("Found duplicate entries: %s - %s\r\n"),Buffer->val.lpwstr,BufferCmp->val.lpwstr));
if(CeDeleteRecord(hDatabase, ceoidRecordCmp))
{
RETAILMSG( 1, (TEXT("Delete duplicate entry: %s\r\n"),BufferCmp->val.lpwstr));
deleted++;
checked--;
break;
}
else
RETAILMSG( 1, (TEXT("Error while delete duplicate entry, error: %d\r\n"),GetLastError()));
}
}
checked++;
LocalFree(BufferCmp);
if(CeSeekDatabaseEx(hDatabase, CEDB_SEEK_BEGINNING, checked, 0, NULL)==0)
{
RETAILMSG( 1, (TEXT("Error while seek db, error: %d\r\n"),GetLastError()));
}
}
RETAILMSG( 1, (TEXT("%d Records deleted from DB_notify_events\r\n"),deleted));
LocalFree(Buffer);
CloseHandle(hDatabase);
}
}

Display More

Festus · Nov 18th 2011

Cannot open the zipped exe. When I try to open it on a PicoMOD, it sasy "... is not a valid Windows CE application" and when I try to open it weith WinXP, it says "... ist keine zulässige Win32 Anwendung"

fs-support_ZU · Nov 18th 2011

Hello,
- i can download the file (IE)
- i can extract it on my PC
- i can run it on a WCE device
if this not possible in your enviroment?

Festus · Nov 18th 2011

OK, sorry. It seems that there was an problem copying the exe to an usb stick. Retried and it workes.

Can this also make any other problems than ActiveSync does not connect?

Festus · Nov 23rd 2011

1. I run the application on my PicoMOD6.
But I do not get any output messages from the application, neither by double clicking the exe in the explorer nor by starting it out from the command line.
Is this behaviour ok?

2. Is it possible that these double entries affect something other than just Active Sync? We use Sockets to communicate via Ethernet and sometimes it can happen, that Reading from the Socket fails with the System.IO.IOException -> Unable to read data from the transport connection.

fs-support_ZU · Nov 23rd 2011

Hello

1. as you can see from sample source code the output is only available on debug line (RETAILMSG( 1,...).
2. If there are multiple entries for "activesync" this may also effect other functionalities because the system may be very slow. But in your case i am not sure ... .

Festus · Nov 24th 2011

When I run the program, I get the following debug messages:

Database found Database: RecycleData
Size: 356
Records: 0
Database found Database: DB_notify_queue
Size: 520
Records: 1
Database found Database: DB_notify_events
Size: 888
Records: 7
Found duplicate entries: repllog.exe - repllog.exe
Delete duplicate entry: repllog.exe
Found duplicate entries: repllog.exe - repllog.exe
Delete duplicate entry: repllog.exe
Found duplicate entries: repllog.exe - repllog.exe
Delete duplicate entry: repllog.exe
Error while seek db, error: 25
3 Records deleted from DB_notify_events

What means the line:
Error while seek db, error: 25

fs-support_ZU · Nov 24th 2011

Hello,
as you can see from sample source code a seek to "checked++" is not possible! As you can also see from source, the code for seek into database is redundant and you can remove it (sorry, i think it is a hangover from an other purpose).

Festus · Nov 24th 2011

Thank you for your answer.

I'm not familiar with C++ so "as you can see from the sample code" is not 100% correct

Festus · Dec 1st 2011

Is it possible that the DB is not saved after duplacte entries are deleted?

After a reboot, the entries are still in the DB

fs-support_ZU · Dec 2nd 2011

Hello,
in general "CloseHandle" should flush the changes. Did you restart before "CloseHandle"?
PS: you may call "CeFlushDBVol" before "CloseHandle"

fs-support_ZU · Sep 18th 2015

This probelem seems to be resolved under WCE7!
Refer https://social.msdn.microsoft.…eboot?forum=winembplatdev and release notes for kb2981224.

PiersPiper · Oct 6th 2021

Hi, guys! Windows has been lagging very much lately. I reinstalled the system, but nothing helped. What can you advise?

fs-support_ZU · Oct 6th 2021

Hello,

reinstalltion may not help if the problem is caused by the "CEDB problem". If you install the same kernel again the registry is not retset to default. Best would be to apply EBoot commands "R" and "E" and reinstall your application again. But i would recommend to check CEDB to be sure we have this problem here.

If we have not the "CEDB problem", have you some more details?

E.g. is it related to your application or even to WCE?

Debugout?

Does it occur on your own beaseboard and on SKIT too?

Kernelversion/date? Board?

Can you access via Ethernet in this case and run CEShell (shell -c -> gi thrd -> threadtime)?

Share