Results 1 to 5 of 5

Thread: Upgrade From 5.0.24 to 7.1.1 - DB Version Mismatch

  1. #1
    Ky0
    Ky0 is offline Junior Member
    Join Date
    Jul 2011
    Posts
    6
    Rep Power
    3

    Default Upgrade From 5.0.24 to 7.1.1 - DB Version Mismatch

    Hi all!

    The first, I update zcs-5.0.14_GA_2850 to zcs-5.0.26_GA_3365. Everything ok, I can send/receive email

    But after I upgrade zcs-5.0.26_GA_3365 to zcs-7.1.1_GA_3196, Zimbra can't access from web

    Code:
    root@mail:/usr/local/src/zcs-7.1.1_GA_3196# su - zimbra -c "zmcontrol status"
             antispam                Running
             antivirus               Running
             imapproxy               Running
             ldap                    Running
             logger                  Running
             mailbox                 Stopped
                     zmmailboxdctl is not running.
             memcached               Running
             mta                     Running
             snmp                    Running
             spell                   Running
             stats                   Running
             zmconfigd               Running
    Log file
    Code:
    root@mail:~# tail /opt/zimbra/log/mailbox.log
    2011-07-09 10:47:55,316 INFO  [main] [] misc - System property os.name=Linux
    2011-07-09 10:47:55,316 INFO  [main] [] misc - System property os.version=2.6.24-23-server
    2011-07-09 10:47:55,317 INFO  [main] [] misc - System property sun.arch.data.model=64
    2011-07-09 10:47:55,317 INFO  [main] [] misc - System property sun.cpu.endian=little
    2011-07-09 10:47:55,317 INFO  [main] [] misc - System property sun.cpu.isalist=
    2011-07-09 10:47:55,317 INFO  [main] [] misc - System property sun.os.patch.level=unknown
    2011-07-09 10:47:55,330 INFO  [main] [] system - Setting mysql connector property: maxActive=100
    2011-07-09 10:47:55,336 INFO  [main] [] system - Setting mysql connector property: maxActive=100
    2011-07-09 10:47:56,195 ERROR [main] [] Versions - DB Version Mismatch: ours="65" from DB="53"
    2011-07-09 10:47:56,195 FATAL [main] [] system - Data version mismatch.  Reinitialize or upgrade the backend data store.
    This error apear when zimbra start

    Code:
    root@mail:~# tail /var/log/zimbra.log
    Jul  9 10:55:49 mail zmmailboxdmgr[19176]: assuming no other instance is running
    Jul  9 10:55:49 mail zmmailboxdmgr[19176]: file /opt/zimbra/log/zmmailboxd.pid does not exist
    Jul  9 10:55:49 mail zmmailboxdmgr[19176]: assuming no other instance is running
    Jul  9 10:55:49 mail zmmailboxdmgr[19176]: no manager process is running
    Jul  9 10:56:05 mail zmmailboxdmgr[19608]: status requested
    Jul  9 10:56:05 mail zmmailboxdmgr[19608]: stale pid 10591 found in /opt/zimbra/log/zmmailboxd_manager.pid: No such process
    Jul  9 10:56:05 mail zmmailboxdmgr[19608]: assuming no other instance is running
    Jul  9 10:56:05 mail zmmailboxdmgr[19608]: file /opt/zimbra/log/zmmailboxd.pid does not exist
    Jul  9 10:56:05 mail zmmailboxdmgr[19608]: assuming no other instance is running
    Jul  9 10:56:05 mail zmmailboxdmgr[19608]: no manager process is running
    Code:
    root@mail:~# tail -n35 /opt/zimbra/log/zmmailboxd.out
    CompilerOracle: exclude com/zimbra/cs/session/SessionMap.putAndPrune
    CompilerOracle: exclude com/zimbra/cs/mailbox/MailItem.delete
    CompilerOracle: exclude org/apache/xerces/impl/XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch
    0    INFO  [main] log - Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
    Total time for which application threads were stopped: 0.0001300 seconds
    Total time for which application threads were stopped: 0.0001190 seconds
    Zimbra server reserving server socket port=7110 bindaddr=null ssl=false
    Zimbra server reserving server socket port=7995 bindaddr=null ssl=true
    Zimbra server reserving server socket port=7143 bindaddr=null ssl=false
    Zimbra server reserving server socket port=7993 bindaddr=null ssl=true
    Zimbra server reserving server socket port=7025 bindaddr=null ssl=false
    JettyMonitor monitoring thread pool org.mortbay.thread.BoundedThreadPool@4d3c7378
    678  INFO  [main] log - Setting umask=027
    679  INFO  [main] log - Current rlimit_nofiles (soft=524288, hard=524288)
    679  INFO  [main] log - Set rlimit_nofiles (soft=65536, hard=65536)
    679  INFO  [main] log - Setting GID=1002
    679  INFO  [main] log - Setting UID=1002
    679  INFO  [main] log - jetty-6.1.22.z6
    775  INFO  [main] log - No Transaction manager found - if your webapp requires one, please configure one.
    ### Excluding compile: org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher::dispatch
    Total time for which application threads were stopped: 0.0001700 seconds
    Total time for which application threads were stopped: 0.0003290 seconds
    Total time for which application threads were stopped: 0.0001540 seconds
    Zimbra server process is running as uid=1002 euid=1002 gid=1002 egid=1002
    Total time for which application threads were stopped: 0.0001240 seconds
    Heap
     PSYoungGen      total 673792K, used 115518K [0x00000007d1000000, 0x0000000800000000, 0x0000000800000000)
      eden space 577536K, 20% used [0x00000007d1000000,0x00000007d80cfb70,0x00000007f4400000)
      from space 96256K, 0% used [0x00000007fa200000,0x00000007fa200000,0x0000000800000000)
      to   space 96256K, 0% used [0x00000007f4400000,0x00000007f4400000,0x00000007fa200000)
     PSOldGen        total 2312192K, used 0K [0x0000000743e00000, 0x00000007d1000000, 0x00000007d1000000)
      object space 2312192K, 0% used [0x0000000743e00000,0x0000000743e00000,0x00000007d1000000)
     PSPermGen       total 28160K, used 27976K [0x000000073be00000, 0x000000073d980000, 0x0000000743e00000)
      object space 28160K, 99% used [0x000000073be00000,0x000000073d9520f0,0x000000073d980000)
    Some information my system
    Code:
    Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
    RAM 10GB
    Ubuntu 8.04.4 LTS - Linux version 2.6.24-23-server (buildd@crested) (gcc version 4.2.4 (Ubuntu 4.2.4-1ubuntu3))
    
    root@mail:~# su - zimbra -c "zmcontrol -v"
    Release 7.1.1_GA_3196.UBUNTU8_64 UBUNTU8_64 FOSS edition.
    I searched many thread but I can't fix it
    Please help me solve them! thanks for read!

    - Ky0 -

  2. #2
    Ky0
    Ky0 is offline Junior Member
    Join Date
    Jul 2011
    Posts
    6
    Rep Power
    3

    Default

    I try fix it but nothing change!

    Code:
    root@mail:~# su – zimbra
     zimbra@mail:~$ mysql.server start
     zimbra@mail:~$ cd /opt/zimbra/libexec/scripts
     zimbra@mail:~$./migrate20080930-MucService.pl
     zimbra@mail:~$./migrate20090315-MobileDevices.pl
     zimbra@mail:~$./migrate20090406-DataSourceItemTable.pl
     zimbra@mail:~$./migrate20090430-highestindexed.pl
     zimbra@mail:~$./migrate20100106-MobileDevices.pl
     zimbra@mail:~$./migrate20100913-Mysql51.pl
     zimbra@mail:~$./migrate20100926-Dumpster.pl
     zimbra@mail:~$ mysql.server stop
     zimbra@mail:~$ exit
    Database version in Mysql
    Code:
     root@mail:~# su - zimbra
     zimbra@mail:~$ mysql -u zimbra
     Welcome to the MySQL monitor.  Commands end with ; or \g.
     Your MySQL connection id is 110
     Server version: 5.1.55-log Source distribution
     
     Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
     This software comes with ABSOLUTELY NO WARRANTY. This is free software,
     and you are welcome to modify and redistribute it under the GPL v2 license
     
     Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
     mysql> use zimbra;
     Reading table information for completion of table and column names
     You can turn off this feature to get a quicker startup with -A
     
     Database changed
     mysql> select * from config;
     +---------------------+-------+-------------------+---------------------+
     | name                | value | description       | modified            |
     +---------------------+-------+-------------------+---------------------+
     | db.version          | 65    | db schema version | 2011-07-14 17:42:47 |
     | index.version       | 2     | index version     | 2009-04-02 08:35:53 |
     | purge.lastMailboxId | 1645  | NULL              | 2011-07-01 11:15:25 |
     | redolog.version     | 1.31  | redolog version   | 2011-07-14 15:33:40 |
     +---------------------+-------+-------------------+---------------------+
     4 rows in set (0.00 sec)
     
     mysql>
    Restart zimbra
    Code:
     zimbra@mail:~$zmcontrol restart
    Code:
    root@mail:~# su - zimbra -c "zmcontrol status"
    Host mail.hdbank.com.vn
            antispam                Running
            antivirus               Running
            imapproxy               Running
            ldap                    Running
            logger                  Running
            mailbox                 Stopped
                    zmmailboxdctl is not running.
            memcached               Running
            mta                     Running
            snmp                    Running
            spell                   Running
            stats                   Running
            zmconfigd               Running
    
    root@mail:~# tail /opt/zimbra/log/mailbox.log
    2011-07-18 17:03:50,971 INFO  [main] [] misc - System property os.name=Linux
    2011-07-18 17:03:50,971 INFO  [main] [] misc - System property os.version=2.6.24-23-server
    2011-07-18 17:03:50,971 INFO  [main] [] misc - System property sun.arch.data.model=64
    2011-07-18 17:03:50,971 INFO  [main] [] misc - System property sun.cpu.endian=little
    2011-07-18 17:03:50,971 INFO  [main] [] misc - System property sun.cpu.isalist=
    2011-07-18 17:03:50,971 INFO  [main] [] misc - System property sun.os.patch.level=unknown
    2011-07-18 17:03:50,984 INFO  [main] [] system - Setting mysql connector property: maxActive=100
    2011-07-18 17:03:50,991 INFO  [main] [] system - Setting mysql connector property: maxActive=100
    2011-07-18 17:03:51,840 ERROR [main] [] Versions - DB Version Mismatch: ours="65" from DB="53"
    2011-07-18 17:03:51,840 FATAL [main] [] system - Data version mismatch.  Reinitialize or upgrade the backend data store.
    How to fix it?

  3. #3
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Quote Originally Posted by Ky0 View Post
    How to fix it?
    Did you actually change the db version in the database?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    Ky0
    Ky0 is offline Junior Member
    Join Date
    Jul 2011
    Posts
    6
    Rep Power
    3

    Default

    Quote Originally Posted by phoenix View Post
    Did you actually change the db version in the database?
    Certainly, I really change db version to 53 before run some scripts migrate! But don't solve the problem!

  5. #5
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Try the answer in this thread. You should take a backup of your /opt/zimbra directory before you do the upgrade and, like the poster of that fix, you try that at your own risk.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2012, 02:16 PM
  2. Upgrade from 6.0.10 to 7 beta4
    By alex70 in forum Installation
    Replies: 14
    Last Post: 05-11-2012, 02:02 PM
  3. Replies: 6
    Last Post: 03-14-2011, 04:21 AM
  4. [SOLVED] New zcs 7 install : database errors founds
    By dkbk in forum Administrators
    Replies: 4
    Last Post: 03-01-2011, 06:49 AM
  5. Debian - Upgrade from 4.5.6
    By magikman in forum Installation
    Replies: 1
    Last Post: 01-19-2008, 12:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •