Upgrade Problem

[freit5]

I upgraded from 3.1.4 to 4.0.4 on RHEL4 yesterday and everything went well, no problems or errors. This morning I check my mail and one week of mail is missing. I did backup so I should be able to restore it but I'm puzzled why this happened...

[phoenix]

Have a look in the deferred queue in the Admin UI, is it there?

[freit5]

Originally Posted by phoenix

Have a look in the deferred queue in the Admin UI, is it there?

No, not there. Also noticed that my Inbox is only going back to Sep 20th and it should go back to Sep 1st. All my other folders like sent are up to date.

I was reading mail around 10 last night so its puzzling to say the least.

[freit5]

Just great, tried to restore the account and it didn't work.

Message: system failure: restoring table: mailbox
com.zimbra.cs.service.ServiceException: system failure: restoring table: mailbox
at com.zimbra.cs.service.ServiceException.FAILURE(Ser viceException.java:174)
at com.zimbra.cs.db.DbBackup.loadTable(DbBackup.java: 70)
at com.zimbra.cs.db.DbBackup.loadTable(DbBackup.java: 43)
at com.zimbra.cs.backup.RestoreAccountSession.loadTab lesFromLocalFile(RestoreAccountSession.java:452)
at com.zimbra.cs.backup.FileBackupTarget$RestoreAcctS ession.loadTables(FileBackupTarget.java:1423)
at com.zimbra.cs.backup.RestoreAccountSession.startRe store(RestoreAccountSession.java:177)
at com.zimbra.cs.backup.FileBackupTarget.restore(File BackupTarget.java:343)
at com.zimbra.cs.backup.BackupManager.restore(BackupM anager.java:366)
at com.zimbra.cs.service.backup.Restore.handle(Restor e.java:123)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:261)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:162)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:84)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:223)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:173)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:541)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Data truncation: Data truncated for column 'tracking_imap' at row 1

Query being executed when exception was thrown:

LOAD DATA LOCAL INFILE '/opt/zimbra/backup-pre-4.0/sessions/full-20061122.212641.375/accounts/83c85a92-09cf-4be7-821c-79113d60311b/mailbox.dat' REPLACE INTO TABLE mailbox FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWa rnings(SQLError.java:709)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncati on(MysqlIO.java:3410)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1804)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:773)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.execute(DelegatingPreparedStatement.java:256)
at com.zimbra.cs.db.DbBackup.loadTable(DbBackup.java: 68)
... 29 more

Error code: service.FAILURE
Method: ZmCsfeCommand.prototype.invoke
Details:soap:Receiver

[dkarp]

You can't restore a 3.* backup to a 4.* install. The schemas aren't compatible.

Does reindexing your mailbox fix the date problem?