Results 1 to 2 of 2

Thread: Remote IMAP create MYSQL Error

  1. #1
    Join Date
    May 2006
    Location
    New York, NY
    Posts
    13
    Rep Power
    9

    Default Remote IMAP create MYSQL Error

    Howdy,

    I'm currently running a split-server setup (smtp, mailbox, ldap) on
    Release 5.0.13_GA_2792.RHEL4_20090206100559 RHEL4 NETWORK edition

    There is a user that is experiencing an issue when adding a Remote IMAP Server, nothing too special about it -
    No TLS
    No Changed Port
    Username: domain\user
    Folder Redirected to: RPD Warehouse

    But when attempting to "Get External Mail" Zimbra is dumping an unhandled Exception.

    The account is at ~50% quote use

    Any Ideas?

    Thanks

    Ben


    2009-03-26 13:21:24,576 INFO [btpool0-4431] [name=username@domain.com;mid=231;ip=72.48.XXX.XXX; ds=RPD Warehouse;ua=ZimbraWebClient - FF3.0 (Win)/5.0.13_GA_2792.RHEL4;] datasource - Found new remote folder Public Folders/Human Resources/Merchandising Mgr.. Creating local folder /RPD Warehouse/Public Folders/Human Resources/Merchandising Mgr..
    2009-03-26 13:21:24,630 INFO [btpool0-4431] [name=username@domain.com;mid=231;ip=72.48.XXX.XXX; ds=RPD Warehouse;ua=ZimbraWebClient - FF3.0 (Win)/5.0.13_GA_2792.RHEL4;] datasource - Import completed for data source 'RPD Warehouse'
    2009-03-26 13:21:24,630 INFO [btpool0-4431] [name=username@domain.com;mid=231;ip=72.48.XXX.XXX; ds=RPD Warehouse;ua=ZimbraWebClient - FF3.0 (Win)/5.0.13_GA_2792.RHEL4;] SoapEngine - handler exception
    com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
    ExceptionId:btpool0-4431:1238088084578:e0d35644d50df681
    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:324)
    at com.zimbra.cs.datasource.ImapImport.importData(Ima pImport.java:274)
    at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:154)
    at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:120)
    at com.zimbra.cs.service.mail.ImportData.handle(Impor tData.java:62)
    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:269)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
    at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:190)
    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$CachedCha in.doFilter(ServletHandler.java:1093)
    at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
    at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132)
    at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1084)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
    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.rewrite.RewriteHandler.h andle(RewriteHandler.java:350)
    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.mysql.jdbc.exceptions.MySQLIntegrityConstraint ViolationException: Duplicate entry '231-67967' for key 1

    Query being executed when exception was thrown:

    com.mysql.jdbc.ServerPreparedStatement[16594] - INSERT INTO mboxgroup31.imap_folder (mailbox_id, item_id, data_source_id, local_path, remote_path, uid_validity) VALUES (231, 67967, '51800357-9a9f-481a-a15c-6b48d39a5099', '/RPD Warehouse/Public Folders/Human Resources/Merchandising Mgr.', 'Public Folders/Human Resources/Merchandising Mgr.', 81)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:931)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1160)
    at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:685)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1400)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1314)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1299)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
    at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:106)
    ... 35 more

  2. #2
    Join Date
    May 2006
    Location
    New York, NY
    Posts
    13
    Rep Power
    9

    Default

    Bumpity Bump, Any ideas?

Similar Threads

  1. [SOLVED] Moving Zimbra to a new server
    By krolen in forum Administrators
    Replies: 109
    Last Post: 02-05-2009, 10:38 AM
  2. [SOLVED] Debian Etch 32 / 64: MTA not working
    By xflip in forum Installation
    Replies: 2
    Last Post: 01-18-2008, 03:58 AM
  3. Postfix problem
    By jimbo in forum Administrators
    Replies: 46
    Last Post: 07-23-2007, 05:24 AM
  4. Error 256 on Installation
    By RuinExplorer in forum Installation
    Replies: 5
    Last Post: 10-19-2006, 09:19 AM
  5. Cannot determine services - exiting
    By tawas in forum Installation
    Replies: 7
    Last Post: 04-25-2006, 02:47 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
  •