Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Desktop > Error Reports

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-07-2009, 12:06 PM
New Member
 
Posts: 3
Default [SOLVED] Sync problem with Yahoo! mail

Hi all you,

I decided to give a try to Yahoo Zimbra Desktop and I was impressed by the software but... I've experienced a persistent problem when synchronizing for the first time the mail folders from Yahoo! Mail. The sync process went fine until it reached a particular folder and stopped. I've tried lots of time to continue de sync but unfortunately the problem seems to be persistent and I'm blocked: I don't get mail anymore.

I've collected the trace following the instructions in the FAQ section. This is the trace:

2009-09-07 19:35:33,955 INFO [btpool0-6] [mid=2;] offline - >>>>>>>> name=ivan_de_miguel@yahoo.es;version=1.0.3;build=1 691;release=R;os=Windows Vista x86 6.0;type=imap
2009-09-07 19:35:33,955 INFO [btpool0-6] [mid=2;] datasource - Importing data for data source 'Correo_Yahoo'
2009-09-07 19:35:33,955 INFO [btpool0-6] [mid=2;] datasource - IMAP read timeout is 60 seconds
2009-09-07 19:35:39,665 DEBUG [btpool0-6] [mid=2;] imap - S: * OK IMAP4rev1 server ready (3.5.55)
2009-09-07 19:35:39,665 DEBUG [btpool0-6] [mid=2;] imap - C: C01 CAPABILITY
2009-09-07 19:35:39,899 DEBUG [btpool0-6] [mid=2;] imap - S: * CAPABILITY IMAP4rev1 LOGIN-REFERRALS AUTH=XYMCOOKIE AUTH=XYMCOOKIEB64 AUTH=XYMPKI AUTH=XYMECOOKIE ID NAMESPACE
2009-09-07 19:35:39,915 DEBUG [btpool0-6] [mid=2;] imap - S: C01 OK CAPABILITY completed
2009-09-07 19:35:39,915 DEBUG [btpool0-6] [mid=2;] imap - C: C02 AUTHENTICATE XYMECOOKIE
2009-09-07 19:35:40,133 DEBUG [btpool0-6] [mid=2;] imap - S: +
2009-09-07 19:35:40,133 DEBUG [btpool0-6] [mid=2;] imap - C: <authentication data>
2009-09-07 19:35:40,882 DEBUG [btpool0-6] [mid=2;] imap - S: C02 OK AUTHENTICATE completed
2009-09-07 19:35:40,882 DEBUG [btpool0-6] [mid=2;] imap - C: C03 LIST "" ""
2009-09-07 19:35:41,537 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\Noselect) NIL ""
2009-09-07 19:35:41,537 DEBUG [btpool0-6] [mid=2;] imap - S: C03 OK LIST completed
2009-09-07 19:35:41,631 DEBUG [btpool0-6] [mid=2;] datasource - Found 19 folders for DataSource: { id=3a01ed25-07bf-412b-958e-f5ddcd8dfefa, type=imap, isEnabled=true, name=Correo_Yahoo, host=zimbra.imap.mail.yahoo.com, port=993, connectionType=ssl, username=ivan_de_miguel, folderId=1 }
2009-09-07 19:35:41,631 DEBUG [btpool0-6] [mid=2;] imap - C: C04 LIST "" "*"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Bulk Mail"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "AMILLENA"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Banca"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Dantza"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Draft"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Eroski"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Facebook"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Francais"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "HP"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Inbox"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Infojobs"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Meteo"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Sent"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Spanair"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Toyota"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Trash"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "TravelClub"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "Yoigo"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "eBay"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: * LIST (\HasNoChildren) NIL "euskalnet"
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - S: C04 OK LIST completed
2009-09-07 19:35:42,005 DEBUG [btpool0-6] [mid=2;] imap - C: C05 SELECT Francais
2009-09-07 19:35:42,317 DEBUG [btpool0-6] [mid=2;] imap - S: * 111 EXISTS
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] imap - S: * 0 RECENT
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] imap - S: * OK [UIDVALIDITY 23] UIDs valid
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] imap - S: * OK [UIDNEXT 6548] Predicted next UID
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] imap - S: * FLAGS (\Answered \Flagged \Deleted \Seen \Draft)
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] imap - S: * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft)] Permanent flags
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] imap - S: C05 OK [READ-WRITE] SELECT completed; now in selected state
2009-09-07 19:35:42,333 DEBUG [btpool0-6] [mid=2;] datasource - createImapFolder: itemId = 264, localPath = /Francais, remotePath = Francais, uidValidity = 23
2009-09-07 19:35:42,333 ERROR [btpool0-6] [mid=2;] datasource - Synchronization of folder 'Francais' failed
com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:btpool0-6:1252344942333:8b42f09ab4844f5c
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:111)
at com.zimbra.cs.account.DataSource.createImapFolder( DataSource.java:320)
at com.zimbra.cs.datasource.ImapSync.createFolderTrac ker(ImapSync.java:85)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:521)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:125)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:216)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:193)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:152)
at com.zimbra.cs.offline.OfflineImport.importData(Off lineImport.java:88)
at com.zimbra.cs.offline.YMailImport.importData(YMail Import.java:53)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:157)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:417)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:389)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:431)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:49)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:275)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090906145303400' defined on 'IMAP_FOLDER'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:106)
... 40 more
Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090906145303400' defined on 'IMAP_FOLDER'.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ertAndCheckDups(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doI nsert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger. insert(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.i nsertRow(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. normalInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 45 more
2009-09-07 19:35:42,333 INFO [btpool0-6] [mid=2;] yab - Importing contacts for account 'Correo_Yahoo'
2009-09-07 19:35:42,348 DEBUG [btpool0-6] [mid=2;] yab - Loaded sync state for data source 'Correo_Yahoo': {lastModSequence=2005, lastRevision=166}
2009-09-07 19:35:42,348 DEBUG [btpool0-6] [mid=2;] yab - Found 0 local contact changes
2009-09-07 19:35:44,142 DEBUG [btpool0-6] [mid=2;] yab - Sending request: GET http://address.yahooapis.com/v1/sync...=xml&myrev=166
2009-09-07 19:35:45,375 DEBUG [btpool0-6] [mid=2;] yab - Response body:
<?xml version="1.0" encoding="UTF-8"?>
<sync-response rev="166"/>
<!-- web251.address.pim.re3.yahoo.com uncompressed/chunked Mon Sep 7 10:34:59 PDT 2009 -->

2009-09-07 19:35:45,375 DEBUG [btpool0-6] [mid=2;] yab - Found 0 local contact changes
2009-09-07 19:35:45,375 DEBUG [btpool0-6] [mid=2;] yab - Pushed 0 contact changes: 0 added, 0 updated, and 0 deleted
2009-09-07 19:35:45,375 DEBUG [btpool0-6] [mid=2;] yab - Saving sync state for data source 'Correo_Yahoo': {lastModSequence=2007, lastRevision=166}
2009-09-07 19:35:45,453 INFO [btpool0-6] [mid=2;] yab - Finished importing contacts for account 'Correo_Yahoo'
2009-09-07 19:35:45,453 WARN [btpool0-6] [mid=2;] datasource - Unable to set error status for data source Correo_Yahoo.
2009-09-07 19:35:45,453 INFO [btpool0-6] [mid=2;] datasource - Import completed for data source 'Correo_Yahoo'
2009-09-07 19:35:45,453 ERROR [btpool0-6] [mid=2;] offline - sync failure: Correo_Yahoo
com.zimbra.common.service.ServiceException: system failure: Synchronization of folder 'Francais' failed
ExceptionId:btpool0-6:1252344942333:8b42f09ab4844f5c
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:298)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:221)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:193)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:152)
at com.zimbra.cs.offline.OfflineImport.importData(Off lineImport.java:88)
at com.zimbra.cs.offline.YMailImport.importData(YMail Import.java:53)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:157)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:417)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:389)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:431)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:49)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:275)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:btpool0-6:1252344942333:8b42f09ab4844f5c
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:111)
at com.zimbra.cs.account.DataSource.createImapFolder( DataSource.java:320)
at com.zimbra.cs.datasource.ImapSync.createFolderTrac ker(ImapSync.java:85)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:521)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:125)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:216)
... 35 more
Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090906145303400' defined on 'IMAP_FOLDER'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:106)
... 40 more
Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090906145303400' defined on 'IMAP_FOLDER'.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ertAndCheckDups(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doI nsert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger. insert(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.i nsertRow(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. normalInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 45 more
Reply With Quote
  #2 (permalink)  
Old 09-10-2009, 02:04 AM
New Member
 
Posts: 3
Default

It seems there was a problem with a particular mail message. This one has a big attachment (> 8 Mb). When I deleted the message, the sync went on until it was completed without any problem.

For instance I'll continue with that message in the trash but is there any solution to the problem I posted?
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com




 

SEO by vBSEO ©2011, Crawlability, Inc.