Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 33

Thread: Zimlet to clear AutoComplete cache for user ?

  1. #21
    liverpoolfcfan's Avatar
    liverpoolfcfan is offline Outstanding Member
    Join Date
    Oct 2009
    Location
    Dublin, IRELAND
    Posts
    710
    Rep Power
    6

    Default

    Thank you.

    I can see that there is metadata stored in there under my original userid

    myaccount@zimbra.company.country

    However, when I make the same select using my up-to-date userid

    myaccount@mycompany.country

    I get no data returned.

    1. Is that because the mailbox record got set up originally with the zimbra. userid, and that was populated into the comment field ? The account is still the same - its Domain name just changed - but the comment never got changed when I renamed the domain - Is that right ?

    2. I can see the old format addresses in the metadata. Is there a way to safely delete them ? Can I delete the contents of the a.metadata column, and if I do will it just start fresh collecting data again ?

    Thanks,
    Vincent

  2. #22
    Rich Graves is offline Outstanding Member
    Join Date
    Jan 2007
    Location
    Minnesota
    Posts
    718
    Rep Power
    9

    Default

    The root cause of this was found in Bug 40081 - Unable to get rid of emailed contact which per Bug 43772 - Autocomplete / Emailed contacts error only became public on January 8th.

    There is a workaround; see last comment to 40081.

  3. #23
    jurness is offline Senior Member
    Join Date
    Jun 2009
    Location
    Oakland, CA
    Posts
    58
    Rep Power
    6

    Default

    Quote Originally Posted by Rich Graves View Post
    The root cause of this was found in Bug 40081 - Unable to get rid of emailed contact which per Bug 43772 - Autocomplete / Emailed contacts error only became public on January 8th.

    There is a workaround; see last comment to 40081.
    Can you mention which comment you are referring to? That bug has a lot of action going on.

  4. #24
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,485
    Rep Power
    56

    Default

    Quote Originally Posted by jurness View Post
    Can you mention which comment you are referring to? That bug has a lot of action going on.
    I would have thought it was this:
    Quote Originally Posted by Rich Graves View Post
    There is a workaround; see last comment to 40081.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #25
    cayaraa's Avatar
    cayaraa is offline Special Member
    Join Date
    Jul 2009
    Posts
    106
    Rep Power
    6

    Default

    There is more info about this problem found here:
    Old display names in autocomplete

    The quick answer is to set this for a few days (two weeks?):
    zmprov ma user@domain.com zimbraContactRankingTableSize 0
    After the phantom accounts are gone from autocompelte set it back to 40.

  6. #26
    jurness is offline Senior Member
    Join Date
    Jun 2009
    Location
    Oakland, CA
    Posts
    58
    Rep Power
    6

    Default

    Quote Originally Posted by cayaraa View Post
    There is more info about this problem found here:
    Old display names in autocomplete

    The quick answer is to set this for a few days (two weeks?):
    zmprov ma user@domain.com zimbraContactRankingTableSize 0
    After the phantom accounts are gone from autocompelte set it back to 40.
    In the bug report it mentions 2 days to clear out the caching but after waiting 48 hours I am still seeing old email addresses in the webclient. I verified that none of the email addresses were in my zimbra account calendars and obviously this is not coming from the GAL since this is all about a zimbra domainname change from a test to production domain name.

    Bummer that I need to wait two weeks. Is there anything more definitive here than two days or two weeks? (which is kinda not that definitive...)

  7. #27
    John Munro is offline Senior Member
    Join Date
    Nov 2006
    Location
    Japan
    Posts
    51
    Rep Power
    8

    Default

    Following the closure of Bug 40081 – Unable to get rid of emailed contact this is still happening for us on 6.0.9 NE despite the entry not being in the address book. Perhaps due to a corrupt entry in the metadata field:
    (sanitized)
    ...ntag1:ri69e1:ti1290662525228ee19:sss@domain.ac. jpd1:n122r. Michael SSS", aaa@domain.ac.jp, ggg@domain.ac.jp, "Alexander GGG" <ggg@domain.ac.jp>, "Edda KKK1:ri12e1:ti1290668940981ee36:taka...
    This produces the following JSON AutoCompleteResponse when autocompleting 'sz':
    "Dr. Michael SSS", aaa@domain.ac.jp, ggg@domain.ac.jp, "Alexander GGG" <ggg@domain.ac.jp>, "Edda KKKKKK" <sss@domain.ac.jp>
    Clicking the 'Remove' link results in a message saying:
    The ranking of address ggg@domain.ac.jp has been reset. Addresses are ranked based on how often you have sent to them.

    However it is sss@domain.ac.jp that needs to be removed!

    We have set:
    Code:
    zmprov ma problem_account zimbraContactRankingTableSize 0
    for four days now without the metadata being cleared out.

    I wish to clear this up quickly so I need to confirm the correct mysql UPDATE command to zero out the metadata field.

    From comment 11 in Bug 43772 - Autocomplete / Emailed contacts error the table structure is:

    Code:
    *************************** 1. row ***************************
      Field: mailbox_id
       Type: int(10) unsigned
       Null: NO
        Key: PRI
    Default: 0
      Extra: 
    *************************** 2. row ***************************
      Field: section
       Type: varchar(64)
       Null: NO
        Key: PRI
    Default: 
      Extra: 
    *************************** 3. row ***************************
      Field: metadata
       Type: mediumtext
       Null: YES
        Key: 
    Default: NULL
      Extra:
    The SELECT command is:
    Code:
    su - zimbra
    mysql
    SELECT metadata FROM zimbra.mailbox_metadata WHERE mailbox_id=44 AND section='CONTACT_RANKINGS';
    After some testing on a test server, the following seems to work:
    Code:
    UPDATE zimbra.mailbox_metadata SET metadata='' WHERE mailbox_id=44 AND section='CONTACT_RANKINGS';
    Of course the mailbox_id needs to match the id of the problem mailbox. The mailbox_id can be found with:
    Code:
    zmprov gmi problem_child@domain.com
    This does seem to zero out the appropriate data in the rankings and new data seems to be correctly added to it upon subsequent email sending.

    However, I am concerned about any possible side effects (i.e. indexes out of sync) of directly modifying the data. Can anyone comment?

  8. #28
    John Munro is offline Senior Member
    Join Date
    Nov 2006
    Location
    Japan
    Posts
    51
    Rep Power
    8

    Default

    6 days now after setting zimbraContactRankingTableSize to zero and the ranking table has not been reset...
    zmprov ma problem_account zimbraContactRankingTableSize 0

  9. #29
    cayaraa's Avatar
    cayaraa is offline Special Member
    Join Date
    Jul 2009
    Posts
    106
    Rep Power
    6

    Default

    Quote Originally Posted by John Munro View Post
    6 days now after setting zimbraContactRankingTableSize to zero and the ranking table has not been reset...
    zmprov ma problem_account zimbraContactRankingTableSize 0
    Back when I used the 0 table size it took two weeks to clear it out. I hadn't had to think about this because we've been on 6.0.7 which didn't have the ranking table....upgraded to 6.0.9 and now I'm seeing it again.....and this new forget link doesn't seem to be removing anything from the ranking table. I guess it just moves it so that its at the bottom of the list?

    I love having an un-editable "address book"....

  10. #30
    John Munro is offline Senior Member
    Join Date
    Nov 2006
    Location
    Japan
    Posts
    51
    Rep Power
    8

    Default

    It's been two weeks and the data still hasn't been cleared out of the ranking table so I have bitten the bullet and implemented my hack above. Will keep all informed if I come across any side-effects.
    Code:
    su - zimbra
    zmprov gmi problem_child@domain.com  # to get <zimbra_id>
    mysql
    UPDATE zimbra.mailbox_metadata SET metadata='' WHERE mailbox_id=<zimbra_id> AND section='CONTACT_RANKINGS';

Page 3 of 4 FirstFirst 1234 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 03-05-2010, 01:13 AM
  2. Replies: 21
    Last Post: 02-04-2010, 10:06 AM
  3. Samba and POSIX undeploy problem
    By catnipper in forum Zimlets
    Replies: 0
    Last Post: 09-02-2009, 10:51 AM
  4. can't you help me
    By iwan siahaan in forum Administrators
    Replies: 6
    Last Post: 12-17-2007, 06:53 PM
  5. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •