Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: POP3 check on Exchange server issue

  1. #1
    gcarter is offline Member
    Join Date
    Feb 2007
    Posts
    10
    Rep Power
    8

    Default Zimbra Error

    Hello,

    Forwarding the error from the pop server when you attempt to open the pop box.

    This only happens for some, others such as myself do not have any issue.

    -gc
    Attached Images Attached Images

  2. #2
    bburtin is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    9

    Default

    Please post the error and stack trace from mailbox.log, so we know exactly what's going wrong.

  3. #3
    gcarter is offline Member
    Join Date
    Feb 2007
    Posts
    10
    Rep Power
    8

    Default Maillog Error Entry

    Here is the mail log entry.

    2007-02-15 10:57:28,638 WARN [Thread-1708] [] mailbox - Import from DataSource: { id=5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3, type=pop3, isEnabled=true, name=exchange, host=mail02.rglholdings.com, p
    ort=110, connectionType=cleartext, username=mkrause, folderId=2 } failed
    com.zimbra.common.service.ServiceException: system failure: Unable to store UID
    at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:175)
    at com.zimbra.cs.db.DbPop3Message.storeUid(DbPop3Mess age.java:74)
    at com.zimbra.cs.mailbox.Pop3Import.fetchMessages(Pop 3Import.java:212)
    at com.zimbra.cs.mailbox.Pop3Import.importData(Pop3Im port.java:106)
    at com.zimbra.cs.mailbox.DataSourceManager.importData (DataSourceManager.java:145)
    at com.zimbra.cs.service.mail.ImportData$Pop3Client.r un(ImportData.java:78)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraint ViolationException: Duplicate entry 'AAQip2cAAAw1Ye/9FaWb8yE87lg2GRCJ-5b3d4bbd-3c6b-4bcf-9313-7d30b16' for key 2


    -gc

  4. #4
    bburtin is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    9

    Default

    Either Exchange is returning two messages with the same UID or there's a bug in the ID reconciliation logic. We need to figure out which it is. Please run the following query in MySQL and send me the results. First:

    $ mysql -e "SELECT id, group_id FROM zimbra.mailbox WHERE account_id = '<user account id>'"

    to get the id and group_id of the user. Then

    $ mysql -e "SELECT * FROM mboxgroup<group_id>.pop3_message WHERE mailbox_id = <mailbox_id> AND data_source_id = '5b3d4bbd-3c6b-4bcf-9313-7d30b16' AND uid = 'AAQip2cAAAw1Ye/9FaWb8yE87lg2GRCJ'"

    and just for grins:

    $ mysql -e "SELECT COUNT(*) FROM mboxgroup1.pop3_message WHERE mailbox_id = 1 AND data_source_id = '5b3d4bbd-3c6b-4bcf-9313-7d30b16'"

    Hopefully this will help us get to the bottom of what's going wrong.

  5. #5
    reza225 is offline Advanced Member
    Join Date
    Aug 2006
    Location
    San Diego
    Posts
    193
    Rep Power
    8

    Default

    ever find out what it was?

  6. #6
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Quote Originally Posted by reza225 View Post
    ever find out what it was?
    I guess not as there's no follow-up from the original poster. Do you have the same problem? If so, could you try the steps bburtin has outlined and post the details back here.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  7. #7
    reza225 is offline Advanced Member
    Join Date
    Aug 2006
    Location
    San Diego
    Posts
    193
    Rep Power
    8

    Default

    no but im going to be using exchange and zimbra here shortly, if i do have issues i'll be sure to follow up.

  8. #8
    gcarter is offline Member
    Join Date
    Feb 2007
    Posts
    10
    Rep Power
    8

    Default MySQL Results

    So sorry, I have been swamped in the past week with various projects I needed to finish and did not have time to respond in a timely manner.

    Here is my query results:

    zimbra@zimbra1:~> mysql -e "SELECT id, group_id FROM zimbra.mailbox WHERE account_id = '71fa160c-7472-4167-9e2f-330ed27c543f'"
    +----+----------+
    | id | group_id |
    +----+----------+
    | 8 | 8 |
    +----+----------+
    zimbra@zimbra1:~>

    Next I issued:

    mysql -e "SELECT * FROM mboxgroup8.pop3_message WHERE mailbox_id = 8 AND 8 = '5b3d4bbd-3c6b-4bcf-9313-7d30b16' AND uid = 'AAQip2cAAAw1Ye/9FaWb8yE87lg2GRCJ'"

    No results came back.

    Here is the complete table by the way:

    zimbra@zimbra1:~> mysql -e "SELECT * FROM mboxgroup8.pop3_message"
    +------------+--------------------------------------+----------------------------------+---------+
    | mailbox_id | data_source_id | uid | item_id |
    +------------+--------------------------------------+----------------------------------+---------+
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAA3o2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 398 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAAap2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 420 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAAdp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 423 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAAIp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 401 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAAjo2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 391 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAALp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 408 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAApo2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 394 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAAUp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 417 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgbp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 421 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgcp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 422 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgep2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 424 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgfp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 426 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgho2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 390 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgIp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 403 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgjo2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 392 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgMp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 409 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgRp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 414 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAgUp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 418 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQ/o2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 400 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQ2o2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 397 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQIp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 402 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQJp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 404 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQoo2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 393 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQOp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 411 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAQRp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 413 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAw4o2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 399 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwJp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 405 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwKp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 407 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwNp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 410 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwqo2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 395 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwSp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 415 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwTp2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 416 |
    | 8 | 5b3d4bbd-3c6b-4bcf-9313-7d30b16292e3 | AAwzo2cAAAw1Ye/9FaWb8yE87lg2GRCJ | 396 |
    +------------+--------------------------------------+----------------------------------+---------+

    And finally:

    zimbra@zimbra1:~> mysql -e "SELECT COUNT(*) FROM mboxgroup1.pop3_message WHERE mailbox_id = 1 AND data_source_id = '5b3d4bbd-3c6b-4bcf-9313-7d30b16'"
    +----------+
    | COUNT(*) |
    +----------+
    | 0 |
    +----------+

    If there is anything I can do to assist, let me know.

    I do have a VPN link I can give you to directly access the box remotely. It is just a test system, so it is not being used by a large number of people at the moment.

    -gc

  9. #9
    bburtin is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    9

    Default

    Shoot me now. This a capitalization issue ("AAQip2cAAAw1Ye/9FaWb8yE87lg2GRCJ" vs. "AAQIp2cAAAw1Ye/9FaWb8yE87lg2GRCJ"). Java is case-sensitive and MySQL isn't. Thanks for reporting the bug and helping me research this. I filed a bug for this issue:

    http://bugzilla.zimbra.com/show_bug.cgi?id=15090

  10. #10
    gcarter is offline Member
    Join Date
    Feb 2007
    Posts
    10
    Rep Power
    8

    Default No Problem!

    Anything I can do to help!

    Keep up the good work guys....the source is a veritable treasure trove of Ajax recipes and some of them are quite ingenious!

    Keep up the good work!

    -gc

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. initializing ldap...FAILED(256)ERROR
    By manjunath in forum Installation
    Replies: 39
    Last Post: 06-07-2013, 10:27 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  4. Error 256 on Installation
    By RuinExplorer in forum Installation
    Replies: 5
    Last Post: 10-19-2006, 09:19 AM
  5. Getting problems in FC4 while instalation
    By kitty_bhoo in forum Installation
    Replies: 13
    Last Post: 09-12-2006, 10:34 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
  •