moz_annos in places.sqlite getting bigger !
windhair1
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
David McRitchie
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.
windhair
> 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.
Fox on the run
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/Places:Design_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
windhair
> On Mar 16, 10:51 am, windhair <songya...@gmail.com> 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
> 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).....
windhair
some example can be seen here
http://i34.photobucket.com/albums/d116/windhair/SN-03-16_55.jpg
Fox on the run
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
JP. Baker
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
Fox on the run
> In article <f5d4de3a-9f61-4035-985b-96c0daab6...@a12g2000yqm.googlegroups.com>,
>
> windhair <windh...@gmail.com> wrote:
> >On Mar 17, 12:12 am, windhair <windh...@gmail.com> wrote:
> >> On Mar 16, 8:10 pm, Fox on the run <jjrbouc...@gmail.com> 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/d116/windhair/SN-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
David McRitchie
question, the name looks like it is a mirror of the newsgroup but has completely
different responders
http://forums-test.mozillazine.org/viewtopic.php?f=38&t=1144415&start=0&st=0&sk=t&sd=a
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 the option 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.
Ron Hunter
--
Ron Hunter rphu...@charter.net
Fox on the run
> 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
>
> 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 the option 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
David McRitchie
> http://forums-test.mozillazine.org/viewtopic.php?f=38&t=1144415&start=0&st=0&sk=t&sd=a
more links for moz_annos don't think these were mention
Mozilla Firefox 3 History File Format - Forensics Wiki
http://www.iterasi.net/openviewer.aspx?sqrlitid=fisciwiop0qicwbfckj4ig
The Places database - MDC
https://developer.mozilla.org/en/The_Places_database
windhair
> Another thread/group
>
> >http://forums-test.mozillazine.org/viewtopic.php?f=38&t=1144415&start...
>
> more links for moz_annos don't think these were mention
>
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.
Fox on the run
Thanks for the update. It was a learning experience for me as well.
JB