On 5 March 2013 16:47, Wietse Venema <[email protected]> wrote: > Simon Brereton: >> Hi >> >> After years of a smoothly running mail server, my logs are starting to >> fill with this error message: >> fatal: proxy:mysql:/etc/postfix/mailalias.cf(0,lock|fold_fix): table >> lookup problem > > I would expcet to see some warning before an uninformative "fatal" message. > BTW the "(0,lock|fold_fix)" are Postfix-internal flags. It does not mean > that there is a problem locking mysql. the lock would be used with > files such as Berkeley DB. > > Wietse
Yes, I suppose there would be! I found two different types. Mar 5 08:45:12 mail postfix/smtpd[24830]: connect from unknown[117.6.222.107] Mar 5 08:45:14 mail postfix/proxymap[24831]: warning: mysql query failed: MySQL server has gone away Mar 5 08:45:14 mail postfix/trivial-rewrite[24833]: fatal: proxy:mysql:/etc/postfix/mailalias.cf(0,lock|fold_fix): table lookup problem Mar 5 08:45:15 mail postfix/master[4283]: warning: process /usr/lib/postfix/trivial-rewrite pid 24833 exit status 1 Mar 5 08:45:16 mail postfix/trivial-rewrite[24854]: fatal: proxy:mysql:/etc/postfix/mailalias.cf(0,lock|fold_fix): table lookup problem Mar 5 08:45:17 mail postfix/smtpd[24830]: warning: problem talking to service rewrite: Success Mar 5 08:45:17 mail postfix/master[4283]: warning: process /usr/lib/postfix/trivial-rewrite pid 24854 exit status 1 Mar 5 08:45:17 mail postfix/master[4283]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling and Mar 5 10:53:21 mail postfix/smtpd[29350]: connect from unknown[81.213.239.67] Mar 5 10:53:22 mail postfix/proxymap[26043]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Mar 5 10:53:22 mail postfix/trivial-rewrite[26046]: fatal: proxy:mysql:/etc/postfix/mailalias.cf(0,lock|fold_fix): table lookup problem Mar 5 10:53:23 mail postfix/master[4283]: warning: process /usr/lib/postfix/trivial-rewrite pid 26046 exit status 1 Mar 5 10:53:24 mail postfix/trivial-rewrite[29357]: fatal: proxy:mysql:/etc/postfix/mailalias.cf(0,lock|fold_fix): table lookup problem Mar 5 10:53:25 mail postfix/smtpd[29350]: warning: problem talking to service rewrite: Success Mar 5 10:53:25 mail postfix/master[4283]: warning: process /usr/lib/postfix/trivial-rewrite pid 29357 exit status 1 Mar 5 10:53:25 mail postfix/master[4283]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling mysqld.sock does exist.. mail:~# ls /var/run/mysqld/mysqld.sock srwxrwxrwx 1 mysql mysql 0 Mar 5 12:14 /var/run/mysqld/mysqld.sock I rebooted the box and until now I haven't had a repeat of the error. I suppose it's just possible that after ~500 days uptime a reset was needed, but I'm always wary when problems like this suddenly appear. There isn't a heavy load, and so I tend to regard symptoms like this as highly suspicious. As per my initial email, I don't think postfix caused this in anyway, but of course it felt the force of it. I wonder now I can increase the redundancy. Simon
