Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

webappsstore.sqlite* is 14MB. How do I reduce the size? Storage for Firefox is over 35MB.

  • 10 replies
  • 5 have this problem
  • 1 view
  • Last reply by user469307

more options

I am running Firefox 20 on an LG Optimus Slider with ARMv6 & Android 2.3.4. I moved Firefox to the SD card, but this only moves part of Firefox. The rest remains within Firefox's primary memory (e.g. under /data/data). This directory is 35MB, which is quite large:

   # du -ks /data/data/org.mozilla.firefox/files/mozilla/foo.default
   34777   /data/data/org.mozilla.firefox/files/mozilla/foo.default

Under my profile directory (foo.default), I note that webappsstore.sqlite & webappsstore.sqlite-wal take up a whopping 14MB worth of space. 14MB is huge! How do I reduce this space?

   # pwd
   /data/data/org.mozilla.firefox/files/mozilla/foo.default
   # du -ks * | sort -n | tail
   3549    safebrowsing
   4080    Cache
   4096    webappsstore.sqlite
   6072    adblockplus
   10600  webappsstore.sqlite-wal
I am running Firefox 20 on an LG Optimus Slider with ARMv6 & Android 2.3.4. I moved Firefox to the SD card, but this only moves part of Firefox. The rest remains within Firefox's primary memory (e.g. under /data/data). This directory is 35MB, which is quite large: # du -ks /data/data/org.mozilla.firefox/files/mozilla/foo.default 34777 /data/data/org.mozilla.firefox/files/mozilla/foo.default Under my profile directory (foo.default), I note that webappsstore.sqlite & webappsstore.sqlite-wal take up a whopping 14MB worth of space. 14MB is huge! How do I reduce this space? # pwd /data/data/org.mozilla.firefox/files/mozilla/foo.default # du -ks * | sort -n | tail 3549 safebrowsing 4080 Cache 4096 webappsstore.sqlite 6072 adblockplus 10600 webappsstore.sqlite-wal

Modified by user469307

Chosen solution

Yes, the webappsstore.sqlite-wal (wal: Write-Ahead Logging) shouldn't be there after Firefox is closed. This sounds quite large to me for a temp file.

You can try to delete both (all) webappsstore.sqlite files to make Firefox rebuild them.

Read this answer in context 👍 2

All Replies (10)

more options

Many site issues can be caused by corrupt cookies or cache. In order to try to fix these problems, the first step is to clear both cookies and the cache. The Firefox cache temporarily stores images, scripts, and other parts of websites while you are browsing.
Note: This will temporarily log you out of all sites you're logged in to. To clear cache and cookies, do the following:

  1. Tap the menu icon located at the top right corner. This is the icon with 3 bars. On older Android devices you'll have to press the hardware menu key and then tap More.
  2. Tap Settings.
  3. After that, you will be taken to the settings screen. In the settings screen, look under the section Privacy & Security and select Clear private data.
  4. You will then be taken to a list of what can be cleared. Select the following 2 for deletion:
    • Cookies & active logins
    • Cache
  5. After those have been selected, tap the Clear data button to actually clear the cache and cookies.


Did this help you with your problems? Please let us know!

more options

Thank you for the suggestion. That is similar to what I read at Document Object Model (DOM) > DOM Storage > Storage location and clearing the data.

Unfortunately, it does not work.

At this point, the filesize of webappstore.sqlite-wml has grown by 2MB. Here is the size in bytes.

   4096   webappstore.sqlite
   12137 webappstore.sqlite-wml
more options

A sqlite-wal file is a kind of temp file used to log database updates. The file should be automatically cleared when you exit Firefox, but you might need to use Quit for that to happen (Menu button > More > Quit).

more options

Chosen Solution

Yes, the webappsstore.sqlite-wal (wal: Write-Ahead Logging) shouldn't be there after Firefox is closed. This sounds quite large to me for a temp file.

You can try to delete both (all) webappsstore.sqlite files to make Firefox rebuild them.

more options

Unfortunately, "Quit" does not remove these files.

more options

This worked. I reduced the size of Firefox by over 14MB. Webappsstore.sqlite* were eventually created again, and are all about 32 or 97 bytes.

I wouldn't call this a solution, but it is a workaround. It requires knowledge of the filesystem and the ability to delete those files, and root access to the filesystem.

From this article, it sounds like the files can be deleted as needed. They will be re-created when needed.

http://kb.mozillazine.org/Webappsstore.sqlite#Deleting

Modified by user469307

more options

Those suggested problems will not solve the issue here.

Bug 857888 has been opened to investigate the possibility of reducing the size of those databases.

more options

Will removing webappstore.sqlite & webappstore.sqlite-wml work as a workaround?

more options

Not advised as that will corrupt the profile.

more options

And I certainly don't want to corrupt my profile, but it seems to be the only solution at the moment. webappsstore.sqlite-wal routinely grows to 8MB or larger. Sometimes the problem does clear up on it's own after 4-5 days, but I have no idea how to trigger the condition to clean it up.