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.
