547513 - Thunderbird starts only in safe-mode and local.sqlite grows in excess

Status: RESOLVED DUPLICATE of bug 352976

(Calendar :: Lightning Only, defect)

Description

[Leonardo Mendez]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2) Gecko/20100124 Firefox/3.6 (Swiftfox)
Build Identifier: Lightning 1.0b1

After importing my .ics from kontact, Thunderbird worked with Lightning fine for some weeks.

Some days ago, opening Thunderbird become slower, until it never opened again (unless, of course in safe mode).

Although I have not too much information in my calendar, I've found that local.sqlite file was about 12MB. 

After opening it with sqlitebrowser I've realized that table cal_relations had more than 600000 rows (!!) and a lot of them were duplicated rows.

The solution I've found with 4 SQL queries solved the problem so I have Thunderbird/Lightning working fine again:

1. CREATE TABLE relations2 (...) [Same specification as cal_relations]
2. INSERT INTO relations2 SELECT DISTINCT * FROM cal_relations
3. DELETE FROM cal_relations
4. INSERT INTO cal_relations SELECT * FROM relations2

After compacting the database it's size is 400KB (1/30 of it's original size)

Reproducible: Didn't try

Comment 1

[Philipp Kewisch [:Fallen][☁️📆]]

Have you been using 1.0pre builds before you switched to 1.0b1 ? There was a bug on this regarding cal_alarms, and I believe I also fixed the relations table.

If you create a new profile and try the import there, does the same behavior happen?

Comment 2

[Leonardo Mendez]

I've started with 1.0b without previous Lightning installations.

After a long time using thunderbird 2 (without Lightning), I've updated to 3.0 and then installed Lightning. After that I've imported the .ics that was exported from kontact.

I'll try with a new profile, but I think it will take some days to know if the same behaviour happens.

Comment 3

[Wayne Mery (:wsmwk)]

(In reply to comment #2)
> I'll try with a new profile, but I think it will take some days to know if the
> same behaviour happens.

Leonardo, you had good results?

Comment 4

[Leonardo Mendez]

No good news after some testing.

Lightning has been installed and reinstalled twice and nothing changed. 

Perhaps, the point could be near a daily event I have in my calendar. The event repeats every day, but each day I edit the daily occurrence deattaching it from repetition. 

This is what happened today with the file size after saving the event for friday 18th.

BTW. The description of the event has no more than 25 lines.


leonardo@nbleo:~/.thunderbird/Profiles/k52sn0yr.default/calendar-data$ ls -l
total 7580
-rw-r--r-- 1 leonardo leonardo     169 2010-05-03 10:36 correct.sql
-rw-r--r-- 1 leonardo leonardo 7418880 2010-06-18 10:57 local.sqlite
-rw-r--r-- 1 leonardo leonardo  316304 2010-06-18 10:57 local.sqlite-journal
leonardo@nbleo:~/.thunderbird/Profiles/k52sn0yr.default/calendar-data$ ls -l
total 10508
-rw-r--r-- 1 leonardo leonardo      169 2010-05-03 10:36 correct.sql
-rw-r--r-- 1 leonardo leonardo 10739712 2010-06-18 10:57 local.sqlite
leonardo@nbleo:~/.thunderbird/Profiles/k52sn0yr.default/calendar-data$

Comment 5

[Leonardo Mendez]

And, after running the queries stated before, and compacting the database with sqlitebrowser this is what we have:


leonardo@nbleo:~/.thunderbird/Profiles/k52sn0yr.default/calendar-data$ ls -l
total 640
-rw-r--r-- 1 leonardo leonardo    169 2010-05-03 10:36 correct.sql
-rw-r--r-- 1 leonardo leonardo 644096 2010-06-18 11:07 local.sqlite
leonardo@nbleo:~/.thunderbird/Profiles/k52sn0yr.default/calendar-data$

Comment 6

[Philipp Kewisch [:Fallen][☁️📆]]

So it seems this is just excess sqlite data, I think this could be fixed by bug: