Results 1 to 5 of 5

Thread: Upgrade Problem

  1. #1
    Join Date
    Aug 2006
    Posts
    18
    Rep Power
    9

    Default Upgrade Problem

    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...

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,587
    Rep Power
    58

    Default

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


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    Aug 2006
    Posts
    18
    Rep Power
    9

    Default

    Quote Originally Posted by phoenix View Post
    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.

  4. #4
    Join Date
    Aug 2006
    Posts
    18
    Rep Power
    9

    Default Restore didn't work

    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
    Last edited by freit5; 11-23-2006 at 05:19 AM.

  5. #5
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default restoring backups from older versions

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

    Does reindexing your mailbox fix the date problem?
    Bugzilla - Wiki - Downloads - Before posting... Search!

Similar Threads

  1. 4.01 to 4.02 upgrade problem (with solution)
    By criley in forum Migration
    Replies: 2
    Last Post: 09-28-2006, 11:36 PM
  2. 3.1.3OS Upgrade Problem
    By mcevoys in forum Installation
    Replies: 7
    Last Post: 06-16-2006, 09:47 AM
  3. 3.0.1 GA upgrade problem
    By kollross in forum Administrators
    Replies: 5
    Last Post: 04-04-2006, 10:42 AM
  4. Another odd GA upgrade problem (FYI)
    By meikka in forum Installation
    Replies: 0
    Last Post: 02-08-2006, 12:38 PM
  5. Odd GA upgrade problem
    By drewage in forum Installation
    Replies: 2
    Last Post: 02-08-2006, 09:17 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
  •