Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 12th September 2010, 16:44
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default postfix trouble in combination with mysql

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 by Ovidiu; 12th September 2010 at 16:52.
Reply With Quote
Sponsored Links
  #2  
Old 13th September 2010, 12:44
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

I think it's a load problem with your MySQL server. Did you try to optimize MySQL?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 13th September 2010, 14:23
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default

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...
Reply With Quote
  #4  
Old 14th September 2010, 15:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Tags
mysql, postfix, table lookup

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
dovecot: lda: Fatal: Unknown user dpicella Installation/Configuration 1 22nd August 2010 02:59
Mail server using Postfix, Dovecot, Mysql... Postfix virtual maps doesn't work?? tarasbuljba HOWTO-Related Questions 33 28th May 2010 14:33
ftp authentication fails fooboo Installation/Configuration 34 26th March 2010 14:04
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47


All times are GMT +2. The time now is 04:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.