[Postfix-es] warning: mysql query failed

[mrpg en vfemail.net]

Hola, escribo por lo siguiente:

-Descripcion:

Tengo postfix 2.1 funcionando con dominios virtuales en debian 3.1 con
mysql. Todo funciona bien, pero a veces postfix no acepta emails y da
error 451 (reintente luego). Al parecer a veces pierde la conexion con
mysql. No tengo errores en mysql.err ni en mysql.log, mysql esta corriendo.

Oct 3 13:09:16 localhost postfix/smtpd[18110]: warning: mysql query
failed: Lost connection to MySQL server during query

Esto es a veces. De resto funciona bien, envia bien, los alias funcionan
bien, tengo dos dominios virtuales y el envio y la entrega funcionan
bien. No hay ningun mensaje de error en el log de mysql.

-Version:
/usr/sbin/postconf -d mail_version
mail_version = 2.1.5

-¿Cómo está instalado Postfix?

 Tengo el paquete Debian (apt-get).

-Software/parches adicionales

Tengo postgrey y:

ii postfix 2.1.5-9
ii postfix-doc 2.1.5-9
ii postfix-mysql 2.1.5-9
ii postfix-tls 2.1.5-9

-mail.log: verbose (smtpd -v)

Oct 3 13:09:16 localhost postfix/smtpd[18110]: >>> CHECKING RECIPIENT
MAPS <<<
Oct 3 13:09:16 localhost postfix/smtpd[18110]: ctable_locate: leave
existing entry key prueba2 en fau.ucv.ve
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
recipient_canonical_maps: prueba2 en fau.ucv.ve: not found
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
recipient_canonical_maps: prueba2: not found
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
recipient_canonical_maps: @fau.ucv.ve: not found
Oct 3 13:09:16 localhost postfix/smtpd[18110]: mail_addr_find:
prueba2 en fau.ucv.ve -> (not found)
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
canonical_maps: prueba2 en fau.ucv.ve: not found
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
canonical_maps: prueba2: not found
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
canonical_maps: @fau.ucv.ve: not found
Oct 3 13:09:16 localhost postfix/smtpd[18110]: mail_addr_find:
prueba2 en fau.ucv.ve -> (not found)
Oct 3 13:09:16 localhost postfix/smtpd[18110]: dict_mysql_lookup using
sql query: select destination from forwardings where source =
'prueba2 en fau.ucv.ve'
Oct 3 13:09:16 localhost postfix/smtpd[18110]: dict_mysql_get_active:
found active connection to host 127.0.0.1
Oct 3 13:09:16 localhost postfix/smtpd[18110]: warning: mysql query
failed: Lost connection to MySQL server during query
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
virtual_alias_maps: prueba2 en fau.ucv.ve: search aborted
Oct 3 13:09:16 localhost postfix/smtpd[18110]: mail_addr_find:
prueba2 en fau.ucv.ve -> (try again)
Oct 3 13:09:16 localhost postfix/smtpd[18110]: NOQUEUE: reject: RCPT
from a.a.ucv.ve[1.1.1.1]: 451 <prueba2 @fau.ucv.ve>: Temporary lookup
failure; from=<webmaster en correo.fau.ucv.ve> to=<prueba2 en fau.ucv.ve>
proto=ESMTP helo=<[17 2.17.71.187]>
Oct 3 13:09:16 localhost postfix/smtpd[18110]: >
cid10.arq.ucv.ve[172.17.71.187]: 451 <prueba2 en fau.ucv.ve>: Temporary
lookup failure
Oct 3 13:09:16 localhost postfix/smtpd[18110]: watchdog_pat: 0x80889e0
Oct 3 13:09:19 localhost postfix/smtpd[18110]: smtp_get: EOF
Oct 3 13:09:19 localhost postfix/smtpd[18110]: lost connection after
RCPT from a.a.ucv.ve[1.1.1.1]
Oct 3 13:09:19 localhost postfix/smtpd[18110]: smtpd_chat_notify: notify
postmaster

- mail.info:

Oct 3 13:09:16 localhost postfix/smtpd[18110]: dict_mysql_get_active:
found active connection to host 127.0.0.1
Oct 3 13:09:16 localhost postfix/smtpd[18110]: warning: mysql query
failed: Lost connection to MySQL server during query
Oct 3 13:09:16 localhost postfix/smtpd[18110]: maps_find:
virtual_alias_maps: prueba2 en fau.ucv.ve: search aborted
Oct 3 13:09:16 localhost postfix/smtpd[18110]: mail_addr_find:
prueba2 en fau.ucv.ve -> (try again)
Oct 3 13:09:16 localhost postfix/smtpd[18110]: NOQUEUE: reject: RCPT
from a.a.ucv.ve[1.1.1.1]: 451 <prueba2 @fau.ucv.ve>: Temporary lookup
failure; from=<webmaster en correo.fau.ucv.ve> to=<prueba2 en fau.ucv.ve>
proto=ESMTP helo=<[1.1.1.1]>
Oct 3 13:09:16 localhost postfix/smtpd[18110]: >
cid10.arq.ucv.ve[1.1.1.1]: 451 <prueba2 en fau.ucv.ve>: Temporary lookup
failure
Oct 3 13:09:16 localhost postfix/smtpd[18110]: watchdog_pat: 0x80889e0
Oct 3 13:09:19 localhost postfix/smtpd[18110]: smtp_get: EOF
Oct 3 13:09:19 localhost postfix/smtpd[18110]: lost connection after
RCPT from a.a.ucv.ve[1.1.1.1]
Oct 3 13:09:19 localhost postfix/smtpd[18110]: smtpd_chat_notify: notify
postmaster

- postconf -n:

a:/var/log$ /usr/sbin/postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = yes
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
default_destination_concurrency_limit = 10
delay_warning_time = 12h
disable_vrfy_command = yes
inet_interfaces = all
local_destination_concurrency_limit = 2
mailbox_command = /usr/bin/maildrop -d ${USER}
mailbox_size_limit = 20971520
message_size_limit = 20971520
mime_header_checks = regexp:/etc/postfix/maps/mime_header_checks.regexp
mydestination = localhost # QUITAR CORREO FAU
myhostname = correo.fau.ucv.ve
mynetworks = 127.0.0.0/8
myorigin = /etc/mailname
recipient_delimiter = +
relayhost =
smtpd_banner = $myhostname ESMTP $mail_name
smtpd_data_restrictions = reject_unauth_pipelining, permit
smtpd_helo_required = yes
smtpd_helo_restrictions = reject_invalid_hostname, reject_unknown_hostname
smtpd_recipient_restrictions = reject_non_fqdn_hostname,
reject_non_fqdn_sender, reject_non_fqdn_recipient,
reject_unknown_recipient_domain, permit_mynetworks,
permit_sasl_authenticated,  reject_unauth_destination,  warn_if_reject,
reject_rbl_client sbl-xbl.spamhaus.org,  warn_if_reject,
reject_rbl_client dsn.rfc-ignorant.org,  warn_if_reject,
reject_rbl_client bl.spamcop.net,  warn_if_reject, reject_rbl_client
relays.ordb.org,  warn_if_reject, reject_rbl_client list.dsbl.org,
check_policy_service inet:127.0.0.1:60000
smtpd_sasl_auth_enable = yes
smtpd_sender_restrictions = reject_unknown_address
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
virtual_alias_domains =
virtual_alias_maps =
mysql:/etc/postfix/mysql-virtual_forwardings.cf,mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:5000
virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_limit = 20971520
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_transport = maildrop
virtual_uid_maps = static:5000


No se me ocurre nada excepto que sea culpa de mysql y no de postfix.
¿Será que mysql se cae y se reinicia y por eso lo veo corriendo y sigue
funcionando? No tengo errores en mysql.err ni en mysql.log

Comentarios bienvenidos, gracias.

-------------------------------------------------
This mail sent through Virus Free Email
http://www.vfemail.net