[SOLVED] Error Upgrading 5.0.2 to 5.0.4 URGENT

[jayel]

Hello I have following error when upgrading. Pleas help. Mailserver got to work urgent.

Upgrading from 5.0.2_GA_1975 to 5.0.4_GA_2101
Stopping zimbra services
Verifying /opt/zimbra/conf/my.cnf
Starting mysql
Starting logger mysql
Sun Mar 30 12:11:18 2008: SELECT value FROM config WHERE name = 'db.version'
ERROR 1040 (08004): Too many connections
This appears to be 5.0.2_GA
Redolog Version: 1.22 New Redolog Version: 1.22
Backup Version: 7.0 New Backup Version: 7.0
Stopping mysql
An upgrade of the logger schema is necessary from version 0
Running /opt/zimbra/libexec/scripts/migrateLogger1-index.pl
Sun Mar 30 12:11:39 2008: Adding Indices
Sun Mar 30 12:11:39 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
Sun Mar 30 12:11:41 2008: Adding Config
Sun Mar 30 12:11:41 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
Sun Mar 30 12:11:42 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
Sun Mar 30 12:11:44 2008: SELECT value FROM config WHERE name = 'db.version'
ERROR 1040 (08004): Too many connections
Sun Mar 30 12:11:44 2008: Schema version mismatch.  Expected version 2.  Version in the database is 0.

Script failed with code 1 - exiting
UPGRADE FAILED - exiting

Help

Greets John

[jayel]

How do I return to 5.0.2

I know it is sunday but we are open and the email server doesn't work. Its about 4 hours now that I am trying to make it work. When just want to run zmcontrol start after the error of upgrading i get.

Host mail.robotronic.be
        Starting ldap...Done.
        Starting logger...Done.
        Starting mailbox...Done.
        Starting antispam...Done.
        Starting antivirus...Done.
        Starting snmp...Done.
        Starting spell...Done.
        Starting mta...FAILED
postmap: fatal: bad string length 0 < 1: mail_owner =
postalias: fatal: bad string length 0 < 1: mail_owner =
postfix failed to start


        Starting stats...Done.

John

[jayel]

I tried to rerun the old zimbra 5.0.2 to upgrade. that doesn't work also
Pleas help guys.
This is in zimbra.log file

Mar 30 14:32:04 mail CRON[8615]: (pam_unix) session opened for user zimbra by (uid=0)
Mar 30 14:32:13 mail zmmailboxdmgr[8808]: status requested
Mar 30 14:32:13 mail zmmailboxdmgr[8808]: status OK
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: antispam: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: antivirus: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: ldap: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: logger: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: mailbox: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: mta: Stopped
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: saslauthd: is
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: snmp: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: spell: Running
Mar 30 14:32:14 mail zimbramon[8618]: 8618:info: 2008-03-30 14:32:04, STATUS: mail.robotronic.be: stats: Running
Mar 30 14:32:14 mail CRON[8615]: (pam_unix) session closed for user zimbra
Mar 30 14:32:31 mail postfix/postqueue[8884]: fatal: bad string length 0 < 1: mail_owner =

John

[dijichi2]

your upgrade failed for whatever reason, repairing it will be very difficult. restore from your backup.

[jayel]

Hey thx for the response.

Restore from my backup ?
How do I do that?
I can't get the mailserver running !! How can I restore the backup then?

John

[jayel]

Hey,

I am al out of ideas here. I am not an Linux expert.
We bought a 5 years license in january.
But with a simpel upgrade, my mail system crashes???

I can't believe that there is nobody that can help me ??

John

[gmsmith]

Did you do a full backup before you started the upgrade? Do you have a copy of /opt/zimbra prior to your upgrade? You may want to open a ticket with Zimbra Support (http://support.zimbra.com)

[jayel]

I did a copy but it freezed copying on /opt/zimbra/postfix/spool/
After an hour I stopped the copy process with ctrl/c. Because my boss wanted the mail system running.
So I have an partial copy. but not the whole thing. I know its stupid.
I have a daily backup. But that is just the mails I think.

I am still in the learning process of linux and zimbra.

A ticket ? How do I do that?? And will my problem be solved then?

John

[gmsmith]

Part of your NE license includes support, by submitting a ticket at http://support.zimbra.com they should be able to help you as best they can. Remember without a good backup, you may run into some problems.

[jayel]

I see that I have "2 tickets remaining".
But how do I open a new ticket. Do I have to "Submit a new case" ?

John