What is 3870112724rsegmnoittet-es.sqlite

479 views
Skip to first unread message

Timo Pietilä

unread,
Sep 21, 2020, 6:59:31 AM9/21/20
to tb-ent...@mozilla.org
Hello.

I have in my TB a 3870112724rsegmnoittet-es.sqlite file on TB
profile\storage\permanent\chrome\idb that keeps on getting bigger and
bigger. What is that file? It doesn't seem to be anything important
since I can delete it and absolutely nothing happens in my mails or
anything else. Is it just some bloat that has no purpose?

It's bad that it keeps on getting bigger and bigger because it resides
in roaming profile and anything unnecessary that fills roaming is bad.

Timo Pietilä
_____________________________________________________________________
Unsubscribe at: https://mail.mozilla.org/listinfo/tb-enterprise#subscribers <<<--- Unsubscribe
Reply to tb-enterprise mailing list at: tb-ent...@mozilla.org
Send questions about the list to: tb-enterp...@mozilla.org

Marco Gaiarin

unread,
Sep 24, 2020, 7:15:18 AM9/24/20
to tb-ent...@mozilla.org
Mandi! Timo Pietilä
In chel di` si favelave...

> I have in my TB a 3870112724rsegmnoittet-es.sqlite file on TB
> profile\storage\permanent\chrome\idb that keeps on getting bigger and
> bigger. What is that file? It doesn't seem to be anything important since I
> can delete it and absolutely nothing happens in my mails or anything else.
> Is it just some bloat that has no purpose?

I can confirm this file, but i and my users have files that range from
some K to 2-3M, no more that that.

File esist also for Firefox.


> It's bad that it keeps on getting bigger and bigger because it resides in
> roaming profile and anything unnecessary that fills roaming is bad.

This is a general topic and i agree, i've also fired up this:

https://bugzilla.mozilla.org/show_bug.cgi?id=1635380

Thunderbird need to be more polite about what is 'profile' and waht is
'cache', and act accordingly.

--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.lanostrafamiglia.it/
Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797

Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
http://www.lanostrafamiglia.it/index.php/it/sostienici/5x1000
(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)

Timo Pietilä

unread,
Sep 24, 2020, 7:56:25 AM9/24/20
to tb-ent...@mozilla.org
On 24.9.2020 14.15, Marco Gaiarin wrote:
> Mandi! Timo Pietilä
> In chel di` si favelave...
>
>> I have in my TB a 3870112724rsegmnoittet-es.sqlite file on TB
>> profile\storage\permanent\chrome\idb that keeps on getting bigger and
>> bigger. What is that file? It doesn't seem to be anything important since I
>> can delete it and absolutely nothing happens in my mails or anything else.
>> Is it just some bloat that has no purpose?
>
> I can confirm this file, but i and my users have files that range from
> some K to 2-3M, no more that that.
>
> File esist also for Firefox.

10MB for TB now, 11MB for Firefox. In Firefox I have a lot of plugins,
in TB only one (tbsync for syncing outlook calendars).

>> It's bad that it keeps on getting bigger and bigger because it resides in
>> roaming profile and anything unnecessary that fills roaming is bad.
>
> This is a general topic and i agree, i've also fired up this:
>
> https://bugzilla.mozilla.org/show_bug.cgi?id=1635380
>
> Thunderbird need to be more polite about what is 'profile' and waht is
> 'cache', and act accordingly.

Agreed.

For that tb cache I have defaultpref a pref that turns global search off.

defaultPref("mailnews.database.global.indexer.enabled", false);

and locked offline downloads:

// These will disable offline downloads

lockPref("mail.server.default.offline_download", false);
lockPref("mail.server.default.autosync_offline_stores", false);
lockPref("mail.provider.enabled", false);
lockPref("mail.cloud_files.enabled", false);

Without those prefs a new user with roaming would immediately fill it
when (s)he installs TB.

Timo Pietilä

Magnus Melin

unread,
Sep 24, 2020, 8:44:53 AM9/24/20
to tb-ent...@mozilla.org
It's not a file that Thunderbird creates on purpose. From what I can
tell it *seems* this is a file that can get created by sqlite in some
error situations (i.e. crash during db operations).

 -Magnus

Marco Gaiarin

unread,
Sep 25, 2020, 11:21:15 AM9/25/20
to tb-ent...@mozilla.org
Mandi! Magnus Melin
In chel di` si favelave...

> It's not a file that Thunderbird creates on purpose. From what I can tell it
> *seems* this is a file that can get created by sqlite in some error
> situations (i.e. crash during db operations).

Could be instead IndexedDB?!

https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API

--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.lanostrafamiglia.it/
Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN)
marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797

Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
http://www.lanostrafamiglia.it/index.php/it/sostienici/5x1000
(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
Reply all
Reply to author
Forward
0 new messages