-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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 > oh, there is a lot of...: +-------+-----------+----------------------+--------+-------------+-------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-----------+----------------------+--------+-------------+-------+----------------------------------------------------------------+------------------+ | 2 | dbmail | localhost | dbmail | Sleep | 0 | | NULL | | 5 | dbmail | localhost | dbmail | Sleep | 1 | | NULL | | 6 | dbmail | localhost | dbmail | Sleep | 157 | | NULL | | 7 | dbmail | localhost | dbmail | Sleep | 16 | | NULL | | 8 | dbmail | localhost | dbmail | Sleep | 1 | | NULL | | 11 | dbmail | localhost | dbmail | Sleep | 0 | | NULL | | 8399 | mysqlrepl | xx.xx.xx.xx:46910 | NULL | Binlog Dump | 51320 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 8606 | cactiuser | localhost:54293 | cacti | Sleep | 1362 | | NULL | | 8607 | cactiuser | localhost:54294 | cacti | Sleep | 1268 | | NULL | | 8608 | cactiuser | localhost:54295 | cacti | Sleep | 1281 | | NULL | | 8609 | cactiuser | localhost:54296 | cacti | Sleep | 2810 | | NULL | | 8610 | cactiuser | localhost:54297 | cacti | Sleep | 1267 | | NULL | | 8611 | cactiuser | localhost:54298 | cacti | Sleep | 2761 | | NULL | | 8612 | cactiuser | localhost:54299 | cacti | Sleep | 1287 | | NULL | | 8613 | cactiuser | localhost:54300 | cacti | Sleep | 1289 | | NULL | | 8614 | cactiuser | localhost:54301 | cacti | Sleep | 1279 | | NULL | | 8615 | cactiuser | localhost:54302 | cacti | Sleep | 6929 | | NULL | | 8618 | cactiuser | localhost:54305 | cacti | Sleep | 1302 | | NULL | | 8619 | cactiuser | localhost:54306 | cacti | Sleep | 2747 | | NULL | | 8620 | cactiuser | localhost:54307 | cacti | Sleep | 1264 | | NULL | | 8622 | cactiuser | localhost:54309 | cacti | Sleep | 1286 | | NULL | | 8623 | cactiuser | localhost:54310 | cacti | Sleep | 1264 | | NULL | | 8624 | cactiuser | localhost:54311 | cacti | Sleep | 2761 | | NULL | | 8657 | dbmail | localhost | dbmail | Sleep | 10 | | NULL | | 8658 | dbmail | localhost | dbmail | Sleep | 214 | | NULL | | 8682 | dbmail | localhost:34399 | dbmail | Sleep | 2583 | | NULL | | 8683 | dbmail | localhost:34400 | dbmail | Sleep | 14953 | | NULL | | 8684 | dbmail | localhost:34401 | dbmail | Sleep | 14538 | | NULL | | 8815 | dbmail | localhost | dbmail | Sleep | 9 | | NULL | | 8816 | dbmail | localhost | dbmail | Sleep | 216 | | NULL | | 10954 | dbmail | localhost:54313 | dbmail | Sleep | 2586 | | NULL | | 10957 | dbmail | localhost:54316 | dbmail | Sleep | 14554 | | NULL | | 10980 | dbmail | localhost:46872 | dbmail | Sleep | 2605 | | NULL | | 13229 | dbmail | localhost | dbmail | Sleep | 6055 | | NULL | | 13353 | dbmail | localhost:41298 | dbmail | Sleep | 14956 | | NULL | | 13354 | dbmail | localhost:41299 | dbmail | Sleep | 6811 | | NULL | | 13355 | dbmail | localhost:41300 | dbmail | Sleep | 6826 | | NULL | | 13634 | cactiuser | localhost:34659 | cacti | Sleep | 1264 | | NULL | | 14857 | cactiuser | localhost:36485 | cacti | Sleep | 1279 | | NULL | | 14858 | cactiuser | localhost:36486 | cacti | Sleep | 2751 | | NULL | | 14881 | cactiuser | localhost:36513 | cacti | Sleep | 1301 | | NULL | | 14882 | root | localhost | dbmail | Sleep | 6833 | | NULL | | 14883 | dbmail | localhost:59155 | dbmail | Sleep | 6832 | | NULL | | 14884 | dbmail | localhost:59156 | dbmail | Sleep | 6829 | | NULL | | 15845 | root | localhost | dbmail | Sleep | 2605 | | NULL | | 16112 | dbmail | localhost:49800 | dbmail | Sleep | 130 | | NULL | | 16305 | dbmail | localhost:43881 | dbmail | Sleep | 16 | | NULL | | 16366 | dbmail | localhost | dbmail | Sleep | 6 | | NULL | | 16367 | dbmail | localhost | dbmail | Sleep | 211 | | NULL | | 16368 | dbmail | localhost | dbmail | Sleep | 8 | | NULL | | 16369 | dbmail | localhost | dbmail | Sleep | 214 | | NULL | | 16370 | dbmail | localhost | dbmail | Sleep | 214 | | NULL | | 16371 | dbmail | localhost | dbmail | Sleep | 216 | | NULL | | 16372 | dbmail | localhost | dbmail | Sleep | 211 | | NULL | | 16373 | dbmail | localhost | dbmail | Sleep | 214 | | NULL | | 16374 | dbmail | localhost | dbmail | Sleep | 0 | | NULL | | 16375 | dbmail | localhost | dbmail | Sleep | 213 | | NULL | | 16419 | dbmail | localhost | dbmail | Sleep | 18 | | NULL | | 16420 | dbmail | localhost | dbmail | Sleep | 18 | | NULL | | 16421 | dbmail | localhost | dbmail | Sleep | 18 | | NULL | | 16428 | root | localhost | NULL | Query | 0 | NULL | show processlist | +-------+-----------+----------------------+--------+-------------+-------+----------------------------------------------------------------+------------------+ 61 rows in set (0.00 sec) Thanks, Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSAOv4ds3frmum9swAQJKYgf/SQQeIMN2Li0APA6uyupgOP7960hmekuD 29JqLn3rTcDX3mbTmyvq/ZizuOIIK4b8EUUTkMWg3alwLDdSOz8i8m00JOD8V3Fa SzkLfDpZRtSJYzOa7qNDN6TYGehg791QgFykcBguNdUl88zeEbgWhP+2l6CZFye8 UiYqutJEYioq1tYOUzZ+b1Sa81Kt2c3+QxGw92hh5tjyIWQGsepnpioZTQyMwn3r EM/6Hj1J4DhsYvmC6U3kSgI2RWQMjApumzrYc2C0xRc7PLxM++hEgcoq7zUJ5xUP +4YowDjmWXDPGLJJMZJnXixOw4pCXA9tKRnWaPzjXxfonHgVUE6BKw== =w5Rn -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
