Hi Wietse,
On Wed, 19 Nov 2025, Wietse Venema via Postfix-users wrote:
Jozsef Kadlecsik via Postfix-users:
We use mysql-driven lookups for almost everything and sometimes there are
warnings in the logs saying:
Nov 19 00:50:12 smtp2 postfix/trivial-rewrite[52211]: warning:
proxy:mysql:/etc/postfix/mysql/user_transport.cf lookup error for "address"
Nov 19 00:50:12 smtp2 postfix/trivial-rewrite[52211]: warning: transport_maps
lookup failure
Does proxymap log an error?
No, nothing.
Does mysqld log an error?
There's no error in the mysqld log.
However, checking the email traffic just before the warning it turned out
that sometimes ridiculously long (autogenerated) email addresses are in
use. Checking the called procedure manually with it an SQL error could be
triggered:
ERROR 1406 (22001): Data too long for column 'email' at row 0
I.e, the varchar length in the procedure definition was not long
enough.
As far as I see such errors are not reported anywhere, just the
consequences.
What was misleading is that after the overly long email address triggered
the warning, several normal email address processing emitted the warning
too and therefore the long address itself was not suspicious enough.
Maybe it's an SQL session handling issue and the error condition is not
cleaned up before/during the next procedure call? I'm just guessing.
Best regards,
Jozsef
The database is on the machine itself, connected over unix socket. It
seems it is a temporary issue because next minute "it works". However it
is a visible error for smtp clients which then must retry.
What should be checked? How could mysql lookups be debugged?
Best regards,
Jozsef
--
E-mail : [email protected], [email protected],
[email protected]
Address: Wigner Research Centre for Physics
H-1525 Budapest 114, POB. 49, Hungary
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
