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