Results 1 to 6 of 6

Thread: Tracking down calendar 'issues'

  1. #1
    mbd
    mbd is offline Senior Member
    Join Date
    Dec 2006
    Location
    Melbourne, AU
    Posts
    58
    Rep Power
    8

    Default Tracking down calendar 'issues'

    Hi,

    We're having some reports of calendar/appointment oddities from one of our users at the moment. The details are fairly vague, but include:

    * one (unfortunately important and almost missed) appointment that 'disappeared', and

    * intermittant appointments that are an hour out.

    I've re-indexed the user's mailbox (a couple of times over the past month or two) but that doesn't appear to have stopped the reports. We do not have other users reporting similar issues with appointments being an hour out. I am currently trying to get more specific details to try and troubleshoot based on facts, but I'm not 100% certain that it's not a PEBKAC.

    In the meantime, I would like to try and discover is the most appropriate way to hunt the issues down through logs, etc.

    So far, I've seen INFO level log entries indicating when an appointment is created or removed in mailbox.log - I've also seen that increasing the mailop logging for the user to debug by running 'zmprov aal user@domain zimbra.mailop debug' shows more details, so that if it happens again (as of now, and assuming I don't forget to run it again if I restart the server), I might have more info/evidence.

    Is there any other advice that can be offered that might assist when trying to hunting down these kind of vague/random issues? For example, does the SQL db store all the calendar records somewhere in such a way that one can track the history of an appointment, even if it were deleted? (I'd love to be able to search it for the appointment name, find the times it was created, modified and/or removed).

    thanks for any assistance that can be offered!

  2. #2
    p24t is offline Moderator
    Join Date
    Mar 2007
    Location
    Austin
    Posts
    441
    Rep Power
    8

    Default

    I have had one employee recently ask about an appointment that disappeared. It was no longer on his calendar, but was still on all of the invitees'.

    However, I'm running 5.0.10 so I can't really say if this is still an issue or not. I'm hoping to convince management to let me update more often

  3. #3
    rchinn is offline Active Member
    Join Date
    Dec 2007
    Location
    Missouri
    Posts
    30
    Rep Power
    7

    Default

    We have had sporadic reports of disappearing events, as well. It's very difficult to get any evidence to report to Zimbra, though. For all we know, these users are accidentally deleting the event from their calendars.

    The calendar data is stored in MySQL in the mboxgroup*.appointment and mboxgroup*.mail_item tables if you want to poke around. It seems like deleting an event from your calendar doesn't remove it from MySQL, but I cannot decipher the metadata to determine what makes an event "deleted". I have tried running zmcalchk but it usually hangs after a few events and never recovers.

  4. #4
    cpnguyen is offline Junior Member
    Join Date
    Sep 2008
    Location
    San Diego, CA
    Posts
    9
    Rep Power
    6

    Default

    All,

    Sorry to bring up an old thread, but I also have a user report appointments 'disappearing' from the shared calendar.

    Other than the mailbox.log, is there a way to easily track appointments on a shared calendar? A possible solution is for emails to be sent out to a user/group when appointments are created/modified/deleted. It would greatly help in auditing.

    Any suggestions?

  5. #5
    mbd
    mbd is offline Senior Member
    Join Date
    Dec 2006
    Location
    Melbourne, AU
    Posts
    58
    Rep Power
    8

    Default

    It won't help in backtracking an existing issue, but you can turn on extra logging for specific users, which apparently will last until the next server restart. We ran the following:

    Code:
    zmprov aal <username@domain> zimbra.mailop debug
    Zimbra Support also suggested we add

    Code:
    zmprov aal <username@domain> zimbra.soap debug
    From there, it's a matter of waiting until the user in question reports an issue that occurs and hope you can see some information to use (or provide to Zimbra Support).

  6. #6
    cpnguyen is offline Junior Member
    Join Date
    Sep 2008
    Location
    San Diego, CA
    Posts
    9
    Rep Power
    6

    Default

    Thanks to mbd, I have been able to locate an appointment that has disappeared.

    Here are the details on the appt from mailbox.log:
    Code:
    2010-02-26 12:11:23,701 DEBUG [btpool0-4494://xxxx/service/soap/SearchRequest/SearchRequest] [name=mr@xxxx;aname=lp@xxxx;mid=3;ip=xxx.xxx.xx.xxx;] soap - SOAP response: 
    {
      "Header": {
        "context": {
          "session": {
            "id": "11153",
            "_content": "11153"
          },
          "change": {
            "token": 90610,
            "acct": "9af45478-9335-422c-93d5-1808664b38fa"
          },
          "_jsns": "urn:zimbra"
        }
      },
      "Body": {
        "SearchResponse": {
          "sortBy": "none",
          "offset": 0,
          "appt": [
            {
              "or": {
                "a": "mr@xxxx",
                "url": "mr@xxxx",
                "sentBy": "lp@xxxx"
              },
              "x_uid": "0d3d4285-cb2f-484d-930a-bc72ffdc16d0",
              "uid": "0d3d4285-cb2f-484d-930a-bc72ffdc16d0",
              "inst": [{
                  "s": 1268265600000,
                  "ridZ": "20100311T000000Z",
                  "ex": true,
                  "invId": "9af45478-9335-422c-93d5-1808664b38fa:270-6758",
                  "compNum": 0,
                  "fr": "2/25/10--1515 NO NOTES DUE TO PRIOR SYSTEM FAILURE.",
                  "name": "E F C 1500",
                  "recur": false
                }],
              "ptst": "AC",
              "fb": "B",
              "fba": "B",
              "transp": "O",
              "name": "M, B, C, Other",
              "loc": "",
              "isOrg": true,
              "id": "9af45478-9335-422c-93d5-1808664b38fa:270",
              "invId": "9af45478-9335-422c-93d5-1808664b38fa:270-269",
              "compNum": 0,
              "l": "9af45478-9335-422c-93d5-1808664b38fa:441",
              "status": "CONF",
              "class": "PUB",
              "dur": 7200000,
              "recur": true,
              "f": "",
              "t": "",
              "rev": 84793,
              "s": 0,
              "d": 1264803977000,
              "md": 1267139746,
              "ms": 90501,
              "cm": true,
              "score": 1.0,
              "sf": ""
            },
    It appears that this appointment is a modified instance of a recurring series.

    I have confirmed that modified instances are also deleted when the parent series is deleted, but I need to verify the same has happened to this appointment.

    From the above, any suggestions on how I should proceed in tracking down this missing appt?

    Release 6.0.5_GA_2213.RHEL5_64_20100203001950 CentOS5_64 FOSS edition.

    TIA

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Big random issues with calendar...
    By Zoltan67 in forum Users
    Replies: 0
    Last Post: 01-07-2009, 10:11 AM
  2. Calendar Sync Issues
    By glassman in forum Zimbra Connector for Outlook
    Replies: 0
    Last Post: 05-14-2008, 10:43 AM
  3. Zimbra Calendar and Thunderbird Calendar issues
    By jwf6911 in forum Administrators
    Replies: 0
    Last Post: 02-28-2008, 05:41 AM
  4. Issues with Outlook Calendar Migration - ics
    By soxfan in forum Migration
    Replies: 2
    Last Post: 02-28-2007, 06:50 PM
  5. Calendar Issues on M2
    By incarose in forum Users
    Replies: 26
    Last Post: 12-17-2005, 06:57 PM

Posting Permissions

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