Uwe Kiewel wrote: > Paul J Stevens schrieb: >> Uwe Kiewel wrote: >>>>> But, mysqld does not report any problems... >>>> Could be a network error, or resource depletion. The first would not be >>>> detected by the mysql server, the second would generate a message in the >>>> mysql error log. >>> I think I can close out the network, because it is a local host >>> connection. So, MySQL and dbmail runs on the same host. >> That's too easy. There is a problem. And it's in your mysql setup. >> Something is causing those mysql connection errors. > >> Also, the hostname in your logs suggests you are running on a vmware >> image. That is /relevant/ information. Especially if dbmail is not in >> the same image as mysql. > > > No. At the host, there was running vmware in the past. Now, it is a > physical machine running mysql and dbmail. Only, I didn't change the > hostname. > > Additionally, I do replication for having a 2nd database. > > >>>>> Apr 12 17:36:02 vm-host dbmail/imap4d[15580]: Error:[serverchild] >>>>> serverchild.c,PerformChildTask(+298): could not connect to database >>>> Again, same thing: network problem or max_connections depleted. >>> I checked it: >>> >>> mysql> show variables like '%connect%'; >>> +--------------------------+-------------------+ >>> | Variable_name | Value | >>> +--------------------------+-------------------+ >>> | character_set_connection | latin1 | >>> | collation_connection | latin1_swedish_ci | >>> | connect_timeout | 5 | >>> | init_connect | | >>> | max_connect_errors | 10 | >>> | max_connections | 100 | >>> | max_user_connections | 0 | >>> +--------------------------+-------------------+ >> all very standard. But combining errno 104 with >> http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html > >> leads connect_timeout as a possible cullprit. Increase that value to >> something significantly larger, like 60. > > Ok, I changed it. > > >>> But, how can I check the current connection count? >> mysqladmin processlist
> show processlist | > +-------+-----------+----------------------+--------+-------------+-------+----------------------------------------------------------------+------------------+ > 61 rows in set (0.00 sec) In that case, you should probably increase max_connections as well. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
