Results 1 to 2 of 2

Thread: Logger misbehaving

  1. #1
    kaffemand is offline Member
    Join Date
    Jan 2007
    Posts
    11
    Rep Power
    8

    Default Logger misbehaving

    Hi,

    I've noticed a few times over the past week that my server becomes very slow. The slowdown is centered around /opt/zimbra/libexec/logswatch and the logger mysqld.

    Logging into the mysqld, and doing a "show processlist;" reveals that it's busy inserting old log records in the raw_logs database..
    Code:
    mysql> show processlist;
    +-------+--------+-----------+---------------+---------+------+--------+------------------------------------------------------------------------------------------------------+
    | Id    | User   | Host      | db            | Command | Time | State  | Info                                                                                                 |
    +-------+--------+-----------+---------------+---------+------+--------+------------------------------------------------------------------------------------------------------+
    |     3 | zimbra | localhost | zimbra_logger | Query   |    0 | update | insert into raw_logs(log_date, loghost, app, pid, msg, postfix_qid) values ('2008-03-31 16:04:27','z | 
    | 38588 | root   | localhost | NULL          | Query   |    1 | NULL   | show processlist                                                                                     | 
    +-------+--------+-----------+---------------+---------+------+--------+------------------------------------------------------------------------------------------------------+
    Further searching the raw_logs table reveals that for just this second, every log message is shown twice!

    What's going on?

    5.0.4 Open source on CENTOS 5.

  2. #2
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 28
    Last Post: 05-21-2008, 12:04 PM
  2. logger stopped by itself
    By zzzzsg in forum Administrators
    Replies: 23
    Last Post: 08-15-2007, 03:55 PM
  3. Disabling logger
    By siburny in forum Administrators
    Replies: 0
    Last Post: 12-01-2006, 12:42 PM
  4. Logger not working in 4.0 RC1
    By jdell in forum Administrators
    Replies: 11
    Last Post: 08-24-2006, 07:50 PM
  5. Replies: 18
    Last Post: 03-20-2006, 02:22 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
  •