moz_annos in places.sqlite getting bigger ! - Mozilla

This is a discussion on moz_annos in places.sqlite getting bigger ! - Mozilla ; Recently, file places.sqlite getting bigger and bigger with surfing, in which the table moz_annos increaes greatly with a long value in "content" field. Mostly, "content" field has a value begin with data:image/png, at follows by a long strange string. Is ...

+ Reply to Thread
Results 1 to 10 of 10

Thread: moz_annos in places.sqlite getting bigger !

  1. moz_annos in places.sqlite getting bigger !

    Recently, file places.sqlite getting bigger and bigger with surfing,
    in which the table moz_annos increaes greatly with a long value in
    "content" field. Mostly, "content" field has a value begin with
    data:image/png, at follows by a long strange string.
    Is this normal? and how to solve this problem?

    Thanks

  2. Re: moz_annos in places.sqlite getting bigger !

    > Is this a question on code for developers because I don't know what
    > table moz_annos is -- how do I view it.
    >
    > Not all bookmarks have favicons, * as you use the bookmarks the
    > favicons get added. * The favicons are much larger than text material
    > would that have anything to do with what you see.


    You can view it with extension SQlite manager.

    there is a table named moz_favicons which save the page icons, but
    moz_annos maybe another thing.

  3. Re: moz_annos in places.sqlite getting bigger !

    On Mar 16, 10:51*am, windhair wrote:
    > > Is this a question on code for developers because I don't know what
    > > table moz_annos is -- how do I view it.

    >
    > > Not all bookmarks have favicons, * as you use the bookmarks the
    > > favicons get added. * The favicons are much larger than text material
    > > would that have anything to do with what you see.

    >
    > You can view it with extension SQlite manager.
    >
    > there is a table named moz_favicons which save the page icons, but
    > moz_annos maybe another thing.


    As best as I can determine, that database table within places.sqlite
    is tied to browser history & bookmarking (but moreso to bookmarking
    although the schema suggests otherwise). You can view the database
    schema for places.sqlite at https://wiki.mozilla.org/Placesesign_Overview#Models.
    Note below that schema there is a link to a PDF with another schema
    for it (as well as for some of the other databases used by FF3).

    In my brief testing I couldn't replicate your situation. If you clear
    your history, does it clear it? (assuming you don't mind clearing your
    history as I know some prefer to keep it to make the features of the
    "awesome bar" more useful). Do you have a bunch of unsorted bookmarks
    by any chance that were created somehow?

    JB

  4. Re: moz_annos in places.sqlite getting bigger !

    On Mar 16, 8:10*pm, Fox on the run wrote:
    > On Mar 16, 10:51*am, windhair wrote:
    >
    > > > Is this a question on code for developers because I don't know what
    > > > table moz_annos is -- how do I view it.

    >
    > > > Not all bookmarks have favicons, * as you use the bookmarks the
    > > > favicons get added. * The favicons are much larger than text material
    > > > would that have anything to do with what you see.

    >
    > > You can view it with extension SQlite manager.

    >
    > > there is a table named moz_favicons which save the page icons, but
    > > moz_annos maybe another thing.

    >
    > As best as I can determine, that database table within places.sqlite
    > is tied to browser history & bookmarking (but moreso to bookmarking
    > although the schema suggests otherwise). *You can view the database
    > schema for places.sqlite athttps://wiki.mozilla.org/Placesesign_Overview#Models.
    > Note below that schema there is a link to a PDF with another schema
    > for it (as well as for some of the other databases used by FF3).
    >
    > In my brief testing I couldn't replicate your situation. *If you clear
    > your history, does it clear it? (assuming you don't mind clearing your
    > history as I know some prefer to keep it to make the features of the
    > "awesome bar" more useful). *Do you have a bunch of unsorted bookmarks
    > by any chance that were created somehow?
    >
    > JB


    I try to delete all the items in moz_annos, the size of the
    places.sqlite decreased to 1M, and after one day surfing, the items in
    moz_annos increased to 1147, and the file size of places.sqlite
    increased to 11M. It is definitly related to the browsing history, but
    why is contains such a big information (image/png).....

  5. Re: moz_annos in places.sqlite getting bigger !

    On Mar 17, 12:12*am, windhair wrote:
    > On Mar 16, 8:10*pm, Fox on the run wrote:
    >
    >
    >
    > > On Mar 16, 10:51*am, windhair wrote:

    >
    > > > > Is this a question on code for developers because I don't know what
    > > > > table moz_annos is -- how do I view it.

    >
    > > > > Not all bookmarks have favicons, * as you use the bookmarks the
    > > > > favicons get added. * The favicons are much larger than text material
    > > > > would that have anything to do with what you see.

    >
    > > > You can view it with extension SQlite manager.

    >
    > > > there is a table named moz_favicons which save the page icons, but
    > > > moz_annos maybe another thing.

    >
    > > As best as I can determine, that database table within places.sqlite
    > > is tied to browser history & bookmarking (but moreso to bookmarking
    > > although the schema suggests otherwise). *You can view the database
    > > schema for places.sqlite athttps://wiki.mozilla.org/Placesesign_Overview#Models.
    > > Note below that schema there is a link to a PDF with another schema
    > > for it (as well as for some of the other databases used by FF3).

    >
    > > In my brief testing I couldn't replicate your situation. *If you clear
    > > your history, does it clear it? (assuming you don't mind clearing your
    > > history as I know some prefer to keep it to make the features of the
    > > "awesome bar" more useful). *Do you have a bunch of unsorted bookmarks
    > > by any chance that were created somehow?

    >
    > > JB

    >
    > I try to delete all the items in moz_annos, the size of the
    > places.sqlite decreased to 1M, and after one day surfing, the items in
    > moz_annos increased to 1147, and the file size of places.sqlite
    > increased to 11M. It is definitly related to the browsing history, but
    > why is contains such a big information (image/png).....


    some example can be seen here
    http://i34.photobucket.com/albums/d1...N-03-16_55.jpg

  6. Re: moz_annos in places.sqlite getting bigger !

    On Mar 16, 7:30*pm, windhair wrote:
    > On Mar 17, 12:12*am, windhair wrote:
    >
    >
    >
    > > On Mar 16, 8:10*pm, Fox on the run wrote:

    >
    > > > On Mar 16, 10:51*am, windhair wrote:

    >
    > > > > > Is this a question on code for developers because I don't know what
    > > > > > table moz_annos is -- how do I view it.

    >
    > > > > > Not all bookmarks have favicons, * as you use the bookmarks the
    > > > > > favicons get added. * The favicons are much larger than text material
    > > > > > would that have anything to do with what you see.

    >
    > > > > You can view it with extension SQlite manager.

    >
    > > > > there is a table named moz_favicons which save the page icons, but
    > > > > moz_annos maybe another thing.

    >
    > > > As best as I can determine, that database table within places.sqlite
    > > > is tied to browser history & bookmarking (but moreso to bookmarking
    > > > although the schema suggests otherwise). *You can view the database
    > > > schema for places.sqlite athttps://wiki.mozilla.org/Placesesign_Overview#Models.
    > > > Note below that schema there is a link to a PDF with another schema
    > > > for it (as well as for some of the other databases used by FF3).

    >
    > > > In my brief testing I couldn't replicate your situation. *If you clear
    > > > your history, does it clear it? (assuming you don't mind clearing your
    > > > history as I know some prefer to keep it to make the features of the
    > > > "awesome bar" more useful). *Do you have a bunch of unsorted bookmarks
    > > > by any chance that were created somehow?

    >
    > > > JB

    >
    > > I try to delete all the items in moz_annos, the size of the
    > > places.sqlite decreased to 1M, and after one day surfing, the items in
    > > moz_annos increased to 1147, and the file size of places.sqlite
    > > increased to 11M. It is definitly related to the browsing history, but
    > > why is contains such a big information (image/png).....

    >
    > some example can be seen herehttp://i34.photobucket.com/albums/d116/windhair/SN-03-16_55.jpg


    What is the URL entry in places that relates to it ( I notice two
    entries per URL for some reason, i.e. two for place_id=208178, two for
    208179, etc)? I could try surfing to that same URLs and see if I
    observe the same behaviour. Have you tried creating a new profile, or
    starting FF in safe mode to see if you observe the same behaviour?
    Wondering if an extension is responsible for that for some reason.
    Seems uncharacteristic of FF from what I've observed so far. I also
    notice that the anno_attritube_id is 10 and 11 respectively for each
    of the twin entries. I have only see 2 in mine. That points to
    moz_anno_attributes where 10 is bookmarkPropertiesDialog/
    folderLastUsed and 11 is placesInternal/GUID. Can't seem to find much
    on the web on those (and not knowledgeable enough to read the source
    code to figure out what it does).

    JB

  7. Re: moz_annos in places.sqlite getting bigger !

    On Mar 17, 5:37*am, cc...@bristol.ac.uk (JP. Baker) wrote:
    > In article ,
    >
    > windhair * wrote:
    > >On Mar 17, 12:12*am, windhair wrote:
    > >> On Mar 16, 8:10*pm, Fox on the run wrote:
    > >> I try to delete all the items in moz_annos, the size of the
    > >> places.sqlite decreased to 1M, and after one day surfing, the items in
    > >> moz_annos increased to 1147, and the file size of places.sqlite
    > >> increased to 11M. It is definitly related to the browsing history, but
    > >> why is contains such a big information (image/png).....

    >
    > >some example can be seen here
    > >http://i34.photobucket.com/albums/d1...N-03-16_55.jpg

    >
    > The next thing to do is to look in moz_anno_attributes to see what
    > attribute 10 represents - for me it belongs to an extension...
    > --
    > John P Baker


    Thanks John. Didn't realize that what I had for 10 & 11 wasn't
    standard. I suspect we'll find out that an extension is responsible
    for all that activity. And your input should point windhair1 to the
    extension that is responsible for that.

    JB

  8. Re: moz_annos in places.sqlite getting bigger !

    On Mar 17, 10:22*am, "David McRitchie" wrote:
    > Don't know what is going on here but the forum below has same
    > question, the name looks like it is a mirror of the newsgroup but has completely
    > different respondershttp://forums-test.mozillazine.org/viewtopic.php?f=38&t=1144415&start...
    >
    > in any case *windhair posted there with
    > "The answer is coming closer, mon_anno_attributes 10 and 11 refer to the value google-toolbar thumbnail-score and
    > URIproperties/characterSet , this seems related to google toolbar. in theoption of googletool bar, there is a term which says a
    > thumbnail will be generated for each page visited, I hope this is the reason, I will disable it and see whats going on then."
    >
    > That is one very problematic extension.


    Thanks for that update David. Glad he was able to resolve his
    problem. He may still come back and post an update here out of
    courtesy to those here who also tried to help (and were on the same
    trail), and for the benefit of archiving the solution on this
    newsgroup as well.

    JB

  9. Re: moz_annos in places.sqlite getting bigger !

    On Mar 17, 5:56*pm, "David McRitchie" wrote:
    > Another thread/group
    >
    > >http://forums-test.mozillazine.org/v...=1144415&start...

    >
    > more links for moz_annos * *don't think these were mention
    >
    > Mozilla Firefox 3 History File Format - Forensics Wikihttp://www.iterasi.net/openviewer.aspx?sqrlitid=fisciwiop0qicwbfckj4ig
    >
    > The Places database - MDChttps://developer.mozilla.org/en/The_Places_database


    the poster in mozilazine is me. I have solved the problem, it is
    related to google tool bar option, you can refer to that post in
    mozilazine.

  10. Re: moz_annos in places.sqlite getting bigger !

    On Mar 17, 1:41*pm, windhair wrote:
    > On Mar 17, 5:56*pm, "David McRitchie" wrote:
    >
    > > Another thread/group

    >
    > > >http://forums-test.mozillazine.org/v...=1144415&start...

    >
    > > more links for moz_annos * *don't think these were mention

    >
    > > Mozilla Firefox 3 History File Format - Forensics Wikihttp://www.iterasi.net/openviewer.aspx?sqrlitid=fisciwiop0qicwbfckj4ig

    >
    > > The Places database - MDChttps://developer.mozilla.org/en/The_Places_database

    >
    > the poster in mozilazine is me. I have solved the problem, it is
    > related to google tool bar option, you can refer to that post in
    > mozilazine.


    Thanks for the update. It was a learning experience for me as well.

    JB

+ Reply to Thread