View Single Post
  #6 (permalink)  
Old 02-01-2009, 12:01 AM
maumar maumar is offline
Elite Member
 
Posts: 286
Default [SOLVED] Schema version mismatch. Expected version 2. Version in the database is 0

i realize that there was a messy with logger and cron had made it worst, issuing a ps ax i got:

Code:
.. snip ..
0002 ?        S      0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --external-locking --log-error=/opt/zimbra/log/logger_mys
10061 ?        Sl     0:20 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db
10215 ?        S      4:48 /usr/bin/perl /opt/zimbra/libexec/zmlogger
10473 ?        S      1:17 /usr/bin/perl /tmp/.swatch_script.7348
11056 ?        Z      0:00 [zmlogger] <defunct>
11149 ?        S      1:08 /usr/bin/perl /tmp/.swatch_script.19885
11479 ?        S      1:24 /usr/bin/perl /tmp/.swatch_script.11834
11656 ?        Z      0:00 [zmlogger] <defunct>
11694 ?        S      1:21 /usr/bin/perl /tmp/.swatch_script.9847
11865 ?        S      0:28 /usr/bin/perl /tmp/.swatch_script.19105
12027 ?        S      5:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
12229 ?        S      4:51 /usr/bin/perl /opt/zimbra/libexec/zmlogger
12408 ?        Z      0:00 [zmlogger] <defunct>
12677 ?        S      0:38 /usr/bin/perl /tmp/.swatch_script.18011
12949 ?        S      0:37 /usr/bin/perl /tmp/.swatch_script.5920
13087 ?        S      0:47 /usr/bin/perl /tmp/.swatch_script.13082
13230 ?        Z      0:00 [zmlogger] <defunct>
13301 ?        Z      0:00 [zmlogger] <defunct>
13399 ?        S      1:00 /usr/bin/perl /tmp/.swatch_script.23053
13503 ?        Z      0:00 [zmlogger] <defunct>
13539 ?        S      0:06 /usr/bin/perl /tmp/.swatch_script.6211
13709 ?        Z      0:00 [zmlogger] <defunct>
14010 ?        Z      0:00 [zmlogger] <defunct>
14438 ?        S      0:26 /usr/bin/perl /tmp/.swatch_script.27855
14510 ?        S      1:15 /usr/bin/perl /tmp/.swatch_script.5330
14678 ?        S      1:43 /usr/bin/perl /tmp/.swatch_script.23204
14742 ?        Ss     0:04 /usr/sbin/sshd
14951 ?        S      0:57 /usr/bin/perl /tmp/.swatch_script.15496
14988 ?        Z      0:00 [zmlogger] <defunct>
15062 ?        S      4:27 /usr/bin/perl /opt/zimbra/libexec/zmlogger
15078 ?        Z      0:00 [zmlogger] <defunct>
15226 ?        S      0:28 /usr/bin/perl /tmp/.swatch_script.24500
15228 ?        Z      0:00 [zmlogger] <defunct>
15359 ?        S      0:56 /usr/bin/perl /tmp/.swatch_script.17262
15431 ?        S      1:12 /usr/bin/perl /tmp/.swatch_script.22749
15667 ?        S      0:11 /usr/bin/perl /tmp/.swatch_script.28318
15726 ?        Ssl   20:00 /usr/sbin/named -u named -t /var/named/chroot
15775 ?        Z      0:00 [zmlogger] <defunct>
15830 ?        S      1:05 /usr/bin/perl /tmp/.swatch_script.3513
15900 ?        Z      0:00 [zmlogger] <defunct>
16033 ?        S      4:23 /usr/bin/perl /opt/zimbra/libexec/zmlogger
16043 ?        Z      0:00 [zmlogger] <defunct>
16409 ?        Z      0:00 [zmlogger] <defunct>
16567 ?        S      0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --pid-file=/opt/zimbra/log/logswatch.pid --sc
16569 ?        S      0:00 /usr/bin/perl /tmp/.swatch_script.16567
16700 ?        S      0:00 /usr/bin/perl /opt/zimbra/libexec/swatch --config-file=/opt/zimbra/conf/swatchrc --use-cpan-file-tail --script-dir=/tmp -t /var/log/zimbra.log
16706 ?        S      0:00 /usr/bin/perl /tmp/.swatch_script.16700
16814 ?        S      0:34 /usr/bin/perl /opt/zimbra/libexec/zmmtaconfig
16956 ?        Z      0:00 [zmlogger] <defunct>
17129 ?        S      1:06 /usr/bin/perl /tmp/.swatch_script.15963
17682 ?        Z      0:00 [zmlogger] <defunct>
17813 ?        S      0:44 /usr/bin/perl /tmp/.swatch_script.26011
17892 ?        Z      0:00 [zmlogger] <defunct>
18526 ?        Ss     0:09 /usr/sbin/httpd
18707 ?        S      0:16 /usr/bin/perl /tmp/.swatch_script.15914
18745 ?        S      0:39 /usr/bin/perl /tmp/.swatch_script.4994
18968 ?        S      0:25 /usr/bin/perl /tmp/.swatch_script.14574
19023 ?        Z      0:00 [zmlogger] <defunct>
19173 ?        S      1:19 /usr/bin/perl /tmp/.swatch_script.25415
19324 ?        Z      0:00 [zmlogger] <defunct>
19467 ?        Z      0:00 [zmlogger] <defunct>
19687 ?        Z      0:00 [zmlogger] <defunct>
19709 ?        S      1:21 /usr/bin/perl /tmp/.swatch_script.10614
19993 ?        S      1:11 /usr/bin/perl /tmp/.swatch_script.19152
20350 ?        Z      0:00 [zmlogger] <defunct>
20538 ?        S      4:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
21805 ?        S      0:57 /usr/bin/perl /tmp/.swatch_script.23652
21997 ?        S      1:03 /usr/bin/perl /tmp/.swatch_script.23684
22068 ?        Z      0:00 [zmlogger] <defunct>
22407 ?        Z      0:00 [zmlogger] <defunct>
22505 ?        S      1:20 /usr/bin/perl /tmp/.swatch_script.6702
22632 ?        S      4:43 /usr/bin/perl /opt/zimbra/libexec/zmlogger
22920 ?        S      1:14 /usr/bin/perl /tmp/.swatch_script.3588
23066 ?        S      1:13 /usr/bin/perl /tmp/.swatch_script.14651
23284 ?        S      0:40 /usr/bin/perl /tmp/.swatch_script.1572
23322 ?        S      0:52 /usr/bin/perl /tmp/.swatch_script.22187
23479 ?        Z      0:00 [zmlogger] <defunct>
23508 ?        S      0:48 /usr/bin/perl /tmp/.swatch_script.18878
23513 ?        Z      0:00 [zmlogger] <defunct>
23644 ?        S      4:11 /usr/bin/perl /opt/zimbra/libexec/zmlogger
23829 ?        Z      0:00 [zmlogger] <defunct>
24081 ?        S      1:16 /usr/bin/perl /tmp/.swatch_script.4673
24168 ?        Z      0:00 [zmlogger] <defunct>
24290 ?        S      0:34 /usr/bin/perl /tmp/.swatch_script.30721
24548 ?        Z      0:00 [zmlogger] <defunct>
24757 ?        S      0:01 /usr/bin/perl /tmp/.swatch_script.31665
24900 ?        Z      0:00 [zmlogger] <defunct>
24928 ?        Z      0:00 [zmlogger] <defunct>
25074 ?        S      0:01 /usr/bin/perl /tmp/.swatch_script.25018
25089 ?        Z      0:00 [zmlogger] <defunct>
25281 ?        S      1:32 /usr/bin/perl /tmp/.swatch_script.2313
25741 ?        Z      0:00 [zmlogger] <defunct>
25869 ?        S      0:40 /usr/bin/perl /tmp/.swatch_script.23421
26382 ?        Z      0:00 [zmlogger] <defunct>
26618 ?        S      1:36 /usr/bin/perl /tmp/.swatch_script.30190
26802 ?        S      1:15 /usr/bin/perl /tmp/.swatch_script.26752
27128 ?        Z      0:00 [zmlogger] <defunct>
27191 ?        Z      0:00 [zmlogger] <defunct>
27637 ?        S      0:26 /usr/bin/perl /tmp/.swatch_script.15361
27675 ?        Z      0:00 [zmlogger] <defunct>
28184 ?        S      0:14 /usr/bin/perl /tmp/.swatch_script.4198
28595 ?        S      0:00 [pdflush]
28686 ?        Z      0:00 [zmlogger] <defunct>
28877 ?        S      0:00 [pdflush]
30014 ?        S      1:24 /usr/bin/perl /tmp/.swatch_script.7799
30358 ?        Z      0:00 [zmlogger] <defunct>
30509 ?        S      0:30 /usr/bin/perl /tmp/.swatch_script.3747
30908 ?        Z      0:00 [zmlogger] <defunct>
31531 ?        S      0:05 /usr/bin/perl /tmp/.swatch_script.5777
31682 ?        S      0:59 /usr/bin/perl /tmp/.swatch_script.15195
32009 ?        Z      0:00 [zmlogger] <defunct>
32063 ?        Ss     0:50 crond
32228 ?        Z      0:00 [zmlogger] <defunct>
during installation stopping, i was taking a coffe break, and during this period zimbra cron was keeping to retry to connect to logger.

To fix all this mess i did (i am into a Centos 5):
Code:
1. chkconfig zimbra off
2. mv /var/spool/cron/zimbra /tmp
3. reboot
after reboot, with zimbra not running and no silly cron script around, issuing a ps ax gave a very clean situation.
I redid upgrade and now 5.0.12 is working like a charm.

The lesson is:
it would be sane if during zimbra installation, zimbra cron could be disabled, if one's place.
my 2 cents.

Last edited by maumar; 02-01-2009 at 12:13 AM..
Reply With Quote