On 9/7/10 , Sep 7, 11:56 AM, Timo Sirainen wrote:
On Sat, 2010-09-04 at 12:17 -0700, David Jonas wrote:
Sep 4 11:27:47 dovecot: dict: Error: sql dict: commit failed: Not connected to database Hmm. dict process thinks that all of its SQL connections are in use. Although why that happens is slightly strange, because unless you changed the defaults one process can handle only a single client connection at a time, and normally one client wouldn't be sending multiple requests simultaneously. I didn't change any defaults regarding dict.
service dict { unix_listener dict { group = vmail mode = 0600 user = vmail } }
imap-login and pop3-login have "service_count = 0" , but the protocol directives only have "mail_plugins" set, e.g.:
protocol imap { mail_plugins = $mail_plugins imap_quota }
There is anyway a potential problem with an asynchronous SQL query not being finished when a synchronous SQL query is started. Although that's a problem only with PostgreSQL, not MySQL. Anyway, should be fixed some day..
Well, see if this helps: http://hg.dovecot.org/dovecot-2.0/rev/902f008f17cf The patch didn't seem to make a difference. I'm still seeing the error.
If you have any ideas on debugging I'm open to trying them. Dovecot 2.0.1 running on CentOS release 4.8 (Final) i386. MySQL AB's devel/client/shared rpms, 4.1.22. I can insert some logging probes (or whatever you like) if you give me pointers on how and where.