1419639 - Data manager "Forget About This Domain" doesn't erase from webappstore.sqlite

Status: UNCONFIRMED

(SeaMonkey :: General, defect)

Description

[Jaiy]

User Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Firefox/52.0 SeaMonkey/2.49.1
Build ID: 20171116132526

Steps to reproduce:

1. Visit a site that causes entries to be created in webappstore.sqlite.
2. Go to Data Manager, click on site, choose "Forget About This Domain".
3. Check all boxes for things to forget.
4. Click Forget.


Actual results:

Site disappeared from Data Manager (good).  However on closing and re-opening Data Manager, the site is back.


Expected results:

It shouldn't have been back.

Examining webappstore.sqlite using the sqlite3(1) utility shows entries for the site remaining.  You have to look carefully because they use the reverse domain name.  Shutting SM down, manually deleting the unwanted entries from webappstore.sqlite and restarting SM now no longer shows the entries in Data Manager.

Comment 1

[Frank-Rainer Grahl (:frg)]

Can you provide a domain for which you have this problem?

Comment 2

[Jaiy]

wunderground.com
youtube.com

Many sites do this for me.  Just visiting the top-level site creates the localStorage entry in webappstore.sqlite.

However, I've observed that if the Data Manager is already open when you visit the site, you do not see the localStorage entry in the Data Manager at first.  You need to close and reopen the Data Manager and then it is shown.  When you click on the site's domain in Data Manager, it'll show Cookies (probably) and also Storage.  Clicking on Storage shows an entry for localStorage of 0 bytes.

There are probably several bugs here...

1.  The Data Manager doesn't immediately show the Storage once it is created - Data Manager only shows Storage after closing and reopening the Data Manager.

2.  Data Manager always seems to show localStorage size of 0 bytes.  However, if you look at the webappstore.sqlite db (e.g., using the command "sqlite3 webappstore.sqlite .dump" you can very clearly see many bytes of data stored there.  Data Manager should not show 0 bytes.

3.  As reported before, clicking on the domain and the "Forget About This Domain" and checking the Storage box and clicking Forget, will temporarily remove the entry from Data Manager.  But closing/reopening Data Manager then shows the Storage back again, still with 0 size and, if you re-run the db dump command, you see no items were deleted from webappstore.sqlite.

Comment 3

[Frank-Rainer Grahl (:frg)]

>
2.  Data Manager always seems to show localStorage size of 0 bytes.  However, if you look at the webappstore.sqlite db (e.g., using the command "sqlite3 webappstore.sqlite .dump" you can very clearly see many bytes of data stored there.  Data Manager should not show 0 bytes.
<

This is a known bug. The storage size can no longer be calculated easily and was just to be set to 0 until we figure out what to do with it. See bug 1045989.

Comment 4

[Jaiy]

OK on the storage size being dealt with separately in the other bug report.

But the issue of non-clearing of data from webappstore.sqlite when you tell it to forget localStorage is separate and is the main point of this bug report.