POP3 check on Exchange server issue

[gcarter]

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

[bburtin]

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

[gcarter]

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

[bburtin]

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.

[reza225]

ever find out what it was?

[phoenix]

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.

[reza225]

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

[gcarter]

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

[bburtin]

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

[gcarter]

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