Remote IMAP create MYSQL Error

[bens750]

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

[bens750]

Bumpity Bump, Any ideas?