auth: Error: auth worker: Aborted request: Lookup timed out

[ML mail]

Do you know what is Dovecot's default SQL query time out and with which parameter can I maybe increase that timeout?

Thanks for the hint regarding the userdb prefetch, that makes sense and I have now put the userdb prefetch before the userdb SQL as recommended.

Doing that I also noticed that in my /etc/dovecot/conf.d/10-auth.conf I still have the system user authentication enabled with this line:


!include auth-system.conf.ext

although I am using SQL only (PostgreSQL). Can I safely disable this line you think?


On Friday, January 30, 2015 9:45 AM, Steffen Kaiser <skdovecot at smail.inf.fh-brs.de> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 30 Jan 2015, ML mail wrote:

> I was checking the errors on my mailbox server using "doveadm log errors" and found that around 2-3 times a day I get the following error:
>
> Jan 29 22:14:43 auth: Error: auth worker: Aborted request: Lookup timed out
>
> Any ideas if this is a bad sign? For example some timeout on my side which is too low or is it just an aborted connection from the side of the IMAP client?

1st bet is that the SQL query timed out. It is bad sign.


>
> The configuration on my Dovecot mailbox server can be found here:
>
> http://article.gmane.org/gmane.mail.imap.dovecot/80823

you should place userdb prefetch before userdb sql. The current order 
makes no sense. But this is not the source of your problem.

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQEVAwUBVMtDknz1H7kL/d9rAQIgHwf7BluhPtKfdZR31VoVsfyEgteQT0rAXE6r
bsv96ToibGO+9gFjk3LM745FFJuFwiBsSCqRIrF4KxXBoI4wBY072JlLwnBjOh/C
57wwvVTw8DIPEkMin0cCOo/OLHXXaGs0h9vcQ86F/m4wnQTyMD1l2YYEdAITpoQM
s+nqfzPiYfTSsHCOovEdb2L54VYpgJvTE8BXehdvd2sSpygaCZEV91R1ToxGZypy
Y1gdd6YR6AIPiBQXdw0rlLJABiSHGwcV1s7g1xBz2exZguxfBDDuP97OPCU+D+c6
efVVqVoedJMi1311/jIYdtyxUjYUGYZXzsKcBCYuyYPWjQ82MdKyLw==
=rbCo
-----END PGP SIGNATURE-----