hi

i run into a problem that my calendar behaved strange - it loaded slow and showed me the view of yesterday. also calendar widgets froze the hildon desktop.

anyway i discovered that the /home/user/.calendar/calendardb was far too big - 120MB around.

i tried to sync it to pc or other phone or syncml services - n900 took for ever to sync and nothing was synced.
i also tried to export calendar with the calendar's own export function. it did not work.

so i tried to extract calendar info from the db file and discovered it is a sqlite3 db-file.

this made things easy - even possible on device (i used for performance reasons the pc):
- sqlite3 calendardb .dump >calendardb.dump

with that dumped sql file (now 250mb large) i checked that it repeated one sql command far too often:

"INSERT INTO "XProperties" VALUES(180,'X-EPOCAGENDAENTRYTYPE','TODO');"

i deleted the block of repeated sql commands and let only one command stay.

i created a sqlite3 db file :
- cat calendardb.fixed |sqlite3 calendardb (i have now 280k file)
- sqlite3 calendardb .reindex

this file i put back to /home/user/.calendar and my calendar and widgets are usable again.

did not test the sync yet - but it will work i guess.

ciao and good luck