postfix trouble in combination with mysql

Discussion in 'Server Operation' started by Ovidiu, Sep 12, 2010.

  1. Ovidiu

    Ovidiu Active Member

    finding more and more of these in the logs:

    Code:
    Sep 12 14:58:21 h1550830 postfix/trivial-rewrite[17386]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 14:58:22 h1550830 postfix/trivial-rewrite[17580]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 14:58:23 h1550830 postfix/trivial-rewrite[17581]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:21 h1550830 postfix/trivial-rewrite[26670]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[22799]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26585]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26582]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26597]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26604]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26600]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26607]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:24 h1550830 postfix/smtp[26614]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:54 h1550830 postfix/smtp[26601]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Sep 12 16:07:56 h1550830 authdaemond: failed to connect to mysql server (server=localhost, userid=ispconfig): Too many connections
    Sep 12 16:07:56 h1550830 pop3d: authentication error: Input/output error
    
    which is a bit odd :-( I found one single similar post here with not much of a conclusion at the end. I know my system is running a bit bad right now but there are enough mysql connections for everyone dunno how that one above timed out. but what about all those table lookup problems?

    runnind up-to-date Debian installed accoring to the perfect server setup with ispcfg3
     
    Last edited: Sep 12, 2010
  2. falko

    falko Super Moderator ISPConfig Developer

    I think it's a load problem with your MySQL server. Did you try to optimize MySQL?
     
  3. Ovidiu

    Ovidiu Active Member

    working on that. will post back here if I find it was related.
    do you have a link to a how-to? I know enough general ones, I'd be more interested in comparing what other ispcfg3 users use.

    i.e. I have 4gb of RAM and use the server in every capacity ispcfg3 enables me to: serve web pages, run DNS, serve email, run DBs...
     
  4. falko

    falko Super Moderator ISPConfig Developer

    I think the most important settings in the [mysqld] section of your my.cnf are query_cache_limit, query_cache_size, and query_cache_type as this configures the cache in MySQL so that MySQL doesn't have to perform so many queries.
     

Share This Page