Thread: Postfix often finds MySQL inaccessible
View Single Post
  #9  
Old 4th November 2011, 06:43
ande ande is offline
Junior Member
  
Join Date: Jan 2008
Location: Freiburg, Germany
Posts: 29
Thanks: 5
Thanked 0 Times in 0 Posts
Default
The mysql and postfix config file are almost identical. Will post more details later.

After having turned on mysql.log, I've seen something:

Mail mail-related queries are 10fold:

Code:
546 Query	SELECT access FROM mail_access WHERE source='postcodeloterijnl2011@gmail.com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='gmail.com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='postcodeloterijnl2011@' and type = 'sender' and active = 'y' and server_id = 1
		  545 Query	SELECT access FROM mail_access WHERE source='unknown' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113.36.82' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113.36' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189' and type = 'client' and active = 'y'
		  546 Query	SELECT access FROM mail_access WHERE source='postcodeloterijnl2011@gmail.com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='gmail.com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='postcodeloterijnl2011@' and type = 'sender' and active = 'y' and server_id = 1
		  545 Query	SELECT access FROM mail_access WHERE source='unknown' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113.36.82' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113.36' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189' and type = 'client' and active = 'y'
		  546 Query	SELECT access FROM mail_access WHERE source='postcodeloterijnl2011@gmail.com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='gmail.com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='com' and type = 'sender' and active = 'y' and server_id = 1
		  546 Query	SELECT access FROM mail_access WHERE source='postcodeloterijnl2011@' and type = 'sender' and active = 'y' and server_id = 1
		  545 Query	SELECT access FROM mail_access WHERE source='unknown' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113.36.82' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113.36' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189.113' and type = 'client' and active = 'y'
		  545 Query	SELECT access FROM mail_access WHERE source='189' and type = 'client' and active = 'y'
The exact same series query is repeated at once about ten times. How can that happen?
Reply With Quote