Results 1 to 6 of 6

Thread: [SOLVED] Schema version mismatch. Expected version 2. Version in the database is 0.

Threaded View

  1. #1
    Join Date
    Mar 2007
    Location
    Small village in the center of Italy
    Posts
    350
    Rep Power
    8

    Default [SOLVED] Schema version mismatch. Expected version 2. Version in the database is 0.

    I got UPGRADE FAILED - exiting
    during upgrade from 5.0.0 to zcs-5.0.3_GA_2101.RHEL5.20080319105041
    i warn others who want upgarde to keep care.

    i suggest to answer N to
    Do you want to verify message store database integrity? [Y] N
    maybe answering Y might have caused
    ERROR 1040 (08004): Too many connections

    i dunno...

    here the final steps toward death...


    Fri Mar 21 00:29:03 2008: Updating DB schema version from 50 to 51.
    Running /opt/zimbra/libexec/scripts/migrate20080213-IndexDeferredColumn.pl
    Fri Mar 21 00:29:05 2008: Verified schema version 51.
    Fri Mar 21 00:29:05 2008: Adding idx_deferred_count column to Mailbox table.
    Fri Mar 21 00:29:08 2008: Verified schema version 51.
    Fri Mar 21 00:29:08 2008: Updating DB schema version from 51 to 52.
    Stopping mysql
    An upgrade of the logger schema is necessary from version 0
    Running /opt/zimbra/libexec/scripts/migrateLogger1-index.pl
    Fri Mar 21 00:29:26 2008: Adding Indices
    Fri Mar 21 00:29:26 2008: alter table mta add index i_arrive_time (arrive_time);
    alter table amavis add index i_arrive_time (arrive_time);
    alter table mta_aggregate add index i_period_start (period_start);
    alter table mta_aggregate add index i_period_end (period_end);
    alter table amavis_aggregate add index i_period_start (period_start);
    alter table amavis_aggregate add index i_period_end (period_end);
    CREATE TABLE config (
    name VARCHAR(255) NOT NULL PRIMARY KEY,
    value TEXT,
    description TEXT,
    modified TIMESTAMP
    ) ENGINE = MyISAM;

    ERROR 1040 (08004): Too many connections
    Running /opt/zimbra/libexec/scripts/migrateLogger2-config.pl
    Fri Mar 21 00:29:28 2008: Adding Config
    Fri Mar 21 00:29:28 2008: DROP TABLE IF EXISTS config;
    CREATE TABLE config (
    name VARCHAR(255) NOT NULL PRIMARY KEY,
    value TEXT,
    description TEXT,
    modified TIMESTAMP
    ) ENGINE = MyISAM;

    ERROR 1040 (08004): Too many connections
    Fri Mar 21 00:29:28 2008: DELETE from zimbra_logger.config WHERE name = 'db.version';
    INSERT into zimbra_logger.config (name,value) values ('db.version',2);

    ERROR 1040 (08004): Too many connections
    Running /opt/zimbra/libexec/scripts/migrateLogger3-diskindex.pl
    Fri Mar 21 00:29:29 2008: SELECT value FROM config WHERE name = 'db.version'
    ERROR 1040 (08004): Too many connections
    Fri Mar 21 00:29:30 2008: Schema version mismatch. Expected version 2. Version in the database is 0.

    Script failed with code 1 - exiting
    UPGRADE FAILED - exiting
    Last edited by maumar; 03-20-2008 at 05:50 PM.

Similar Threads

  1. Debian - Upgrade from 4.5.6
    By magikman in forum Installation
    Replies: 1
    Last Post: 01-19-2008, 12:59 PM
  2. 4.0.4 to 4.5.6 upgrade failed in network edition
    By chenthil in forum Administrators
    Replies: 1
    Last Post: 08-27-2007, 10:36 AM
  3. [SOLVED] Simple backup question...
    By dameron in forum Administrators
    Replies: 3
    Last Post: 08-25-2007, 10:36 PM
  4. Upgrading from 3.1.4_GA_518 to 4.0.3_GA_406
    By a2mc in forum Installation
    Replies: 6
    Last Post: 11-13-2006, 12:52 PM
  5. Fix for SA Configure Files Version Mismatch
    By unilogic in forum Developers
    Replies: 1
    Last Post: 12-03-2005, 07:37 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
  •