View Single Post
  #5 (permalink)  
Old 01-31-2009, 09:50 AM
Mccreations Mccreations is offline
Active Member
 
Posts: 49
Default

Quote:
Originally Posted by uxbod View Post
Ok, so lets try the following
Code:
su - zimbra
logmysql
use zimbra_logger;
show tables;
check table mta;
Repeat for all tables.
Code:
+----------------------+-------+----------+----------+
| Table                | Op    | Msg_type | Msg_text |
+----------------------+-------+----------+----------+
| zimbra_logger.amavis | check | status   | OK       |
+----------------------+-------+----------+----------+
+--------------------------------+-------+----------+----------+
| Table                          | Op    | Msg_type | Msg_text |
+--------------------------------+-------+----------+----------+
| zimbra_logger.amavis_aggregate | check | status   | OK       |
+--------------------------------+-------+----------+----------+
+----------------------+-------+----------+----------+
| Table                | Op    | Msg_type | Msg_text |
+----------------------+-------+----------+----------+
| zimbra_logger.config | check | status   | OK       |
+----------------------+-------+----------+----------+
+------------------------------+-------+----------+----------+
| Table                        | Op    | Msg_type | Msg_text |
+------------------------------+-------+----------+----------+
| zimbra_logger.disk_aggregate | check | status   | OK       |
+------------------------------+-------+----------+----------+
+-------------------+-------+----------+----------+
| Table             | Op    | Msg_type | Msg_text |
+-------------------+-------+----------+----------+
| zimbra_logger.mta | check | status   | OK       |
+-------------------+-------+----------+----------+
+-----------------------------+-------+----------+----------+
| Table                       | Op    | Msg_type | Msg_text |
+-----------------------------+-------+----------+----------+
| zimbra_logger.mta_aggregate | check | status   | OK       |
+-----------------------------+-------+----------+----------+
+----------------------------------+-------+----------+----------------------------------------------------------+
| Table                            | Op    | Msg_type | Msg_text                                                 |
+----------------------------------+-------+----------+----------------------------------------------------------+
| zimbra_logger.processing_history | check | warning  | 2 clients are using or haven't closed the table properly |
| zimbra_logger.processing_history | check | status   | OK                                                       |
+----------------------------------+-------+----------+----------------------------------------------------------+
+------------------------+-------+----------+----------+
| Table                  | Op    | Msg_type | Msg_text |
+------------------------+-------+----------+----------+
| zimbra_logger.raw_logs | check | status   | OK       |
+------------------------+-------+----------+----------+
+------------------------------+-------+----------+----------------------------------------------------------+
| Table                        | Op    | Msg_type | Msg_text                                                 |
+------------------------------+-------+----------+----------------------------------------------------------+
| zimbra_logger.service_status | check | warning  | 3 clients are using or haven't closed the table properly |
| zimbra_logger.service_status | check | status   | OK                                                       |
+------------------------------+-------+----------+----------------------------------------------------------+
Thanks for all the help. If worse comes to worse, I guess I could wait until the installation gets to the stopping services point and just kill the processes manually in another session.

EDIT: I just tried to stop my server. The logger using all of the CPU doesn't seem to be related to the setup problem, because now when I stop my server:

Code:
        Stopping stats...Done
        Stopping mta...Done
        Stopping spell...Done
        Stopping snmp...Done
        Stopping archiving...Done
        Stopping antivirus...Done
        Stopping antispam...Done
        Stopping imapproxy...Done
        Stopping mailbox...FAILED
Stopping zmmtaconfig...failed.
Stopping mailboxd...done.
Stopping mysqld... done.
        Stopping logger...Done
        Stopping ldap...Done
So it's not the logger? And then I run a ps and these are the processes left over:

Code:
zimbra    3489  0.2  0.0   7144  4920 ?        S    Jan10  76:46 /usr/bin/perl /opt/zimbra/libexec/zmmtaconfig
zimbra   13690  0.0  0.0   7136  1916 pts/1    S    10:48   0:00 su - zimbra
zimbra   13691  0.0  0.0   4640  2044 pts/1    S    10:48   0:00 -su
zimbra   15685  0.0  0.0   2960   744 ?        Ss   10:50   0:00 /opt/zimbra/clamav/bin/freshclam --config-file=/opt/zimbra/conf/freshclam.conf -d --checks=12
zimbra   15692  0.0  1.3 113208 110428 ?       Ss   10:51   0:00 /opt/zimbra/clamav/sbin/clamd --config-file=/opt/zimbra/conf/clamd.conf
zimbra   17618 63.0  0.2 478476 17020 ?        Sl   10:54   0:00 /opt/zimbra/java/bin/java -client -Xmx256m -Dzimbra.home=/opt/zimbra -Djava.library.path=/opt/zimbra/lib -Djava.ext.dirs=/opt/zimbra/java/jre/lib/ext:/opt/zimbra/lib/jars:/opt/zimbra/lib/ext-common:/opt/zimbra/lib/ext/clamscanner com.zimbra.cs.account.ProvUtil -l garpu
And the process 3489 won't die, I kill it and nothing happens

Last edited by Mccreations; 01-31-2009 at 09:57 AM..
Reply With Quote