The following issue has been UPDATED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=740 ====================================================================== Reported By: grosjo Assigned To: paul ====================================================================== Project: DBMail Issue ID: 740 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: feedback target: ====================================================================== Date Submitted: 26-Nov-08 15:41 CET Last Modified: 28-Jan-09 10:17 CET ====================================================================== Summary: DB connections not closed Description: Hi
When many emails are sent (dbmail-deliver), connections to the DB are not closed and many are "sleep" It leads my system to have about 400 connections of dbmail to mysql, among them maybe 10 are active. I set to 50 the limit in dbmail,conf I suggest to verify the connection management to Mysql (maybe use only few 'permanent' connections (i.e. reuse existing connections) ) ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- duplicate of 0000738 Memory leak resulting in crash ====================================================================== ---------------------------------------------------------------------- (0002671) grosjo (reporter) - 26-Nov-08 15:52 http://www.dbmail.org/mantis/view.php?id=740#c2671 ---------------------------------------------------------------------- 2.3.3 is the version, not 2.3.4 ---------------------------------------------------------------------- (0002672) paul (administrator) - 26-Nov-08 16:31 http://www.dbmail.org/mantis/view.php?id=740#c2672 ---------------------------------------------------------------------- Why do you have so many dbmail-deliver processes running? They should normally be short-lived processes, and thus shouldn't be able to keep database connections alive for very long. ---------------------------------------------------------------------- (0002673) grosjo (reporter) - 26-Nov-08 17:14 http://www.dbmail.org/mantis/view.php?id=740#c2673 ---------------------------------------------------------------------- I do not have many dbmail-deliver running (the supervision shows up to 3, based on Postfix policy) but the threads seems keeping running connections, and mysql reports about hundreds connections, and a "show processlist" make a large list of "sleeping" dbmail (cf below, I remove the processes not linked to dbmail) Id User Host db Command Time State Info 1 event_scheduler localhost NULL Daemon 545038 Waiting on empty queue NULL 843669 dbmail localhost services_dbmail Execute 154 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843670 dbmail localhost services_dbmail Sleep 370 NULL 843671 dbmail localhost services_dbmail Sleep 370 NULL 843672 dbmail localhost services_dbmail Sleep 370 NULL 843673 dbmail localhost services_dbmail Sleep 370 NULL 843709 dbmail localhost services_dbmail Execute 154 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843710 dbmail localhost services_dbmail Sleep 369 NULL 843711 dbmail localhost services_dbmail Sleep 369 NULL 843712 dbmail localhost services_dbmail Sleep 369 NULL 843713 dbmail localhost services_dbmail Sleep 369 NULL 843729 dbmail localhost services_dbmail Execute 154 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843730 dbmail localhost services_dbmail Sleep 368 NULL 843731 dbmail localhost services_dbmail Sleep 368 NULL 843732 dbmail localhost services_dbmail Sleep 368 NULL 843733 dbmail localhost services_dbmail Sleep 368 NULL 843764 dbmail localhost services_dbmail Execute 154 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843765 dbmail localhost services_dbmail Sleep 362 NULL 843766 dbmail localhost services_dbmail Sleep 362 NULL 843767 dbmail localhost services_dbmail Sleep 362 NULL 843768 dbmail localhost services_dbmail Sleep 362 NULL 843863 dbmail localhost services_dbmail Execute 47 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843869 dbmail localhost services_dbmail Sleep 213 NULL 843874 dbmail localhost services_dbmail Sleep 213 NULL 843878 dbmail localhost services_dbmail Sleep 213 NULL 843880 dbmail localhost services_dbmail Sleep 213 NULL 843909 replication 194.106.115.117:50677 NULL Binlog Dump 60 Writing to net NULL 843911 dbmail localhost services_dbmail Execute 45 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843912 dbmail localhost services_dbmail Execute 45 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843913 dbmail localhost services_dbmail Sleep 47 NULL 843914 dbmail localhost services_dbmail Execute 42 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843915 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843916 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843917 dbmail localhost services_dbmail Sleep 47 NULL 843918 dbmail localhost services_dbmail Sleep 47 NULL 843919 dbmail localhost services_dbmail Sleep 47 NULL 843920 dbmail localhost services_dbmail Sleep 47 NULL 843921 dbmail localhost services_dbmail Sleep 47 NULL 843922 dbmail localhost services_dbmail Sleep 47 NULL 843923 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843924 dbmail localhost services_dbmail Sleep 47 NULL 843925 dbmail localhost services_dbmail Sleep 47 NULL 843926 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843927 dbmail localhost services_dbmail Sleep 47 NULL 843928 dbmail localhost services_dbmail Sleep 47 NULL 843929 dbmail localhost services_dbmail Sleep 47 NULL 843930 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843931 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843932 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843933 dbmail localhost services_dbmail Sleep 47 NULL 843934 dbmail localhost services_dbmail Sleep 47 NULL 843935 dbmail localhost services_dbmail Sleep 47 NULL 843936 dbmail localhost services_dbmail Sleep 47 NULL 843937 dbmail localhost services_dbmail Sleep 47 NULL 843938 dbmail localhost services_dbmail Sleep 47 NULL 843939 dbmail localhost services_dbmail Sleep 47 NULL 843940 dbmail localhost services_dbmail Sleep 47 NULL 843941 dbmail localhost services_dbmail Sleep 47 NULL 843942 dbmail localhost services_dbmail Sleep 47 NULL 843943 dbmail localhost services_dbmail Sleep 47 NULL 843944 dbmail localhost services_dbmail Sleep 47 NULL 843945 dbmail localhost services_dbmail Sleep 47 NULL 843946 dbmail localhost services_dbmail Sleep 47 NULL 843947 dbmail localhost services_dbmail Sleep 47 NULL 843948 dbmail localhost services_dbmail Sleep 47 NULL 843949 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843950 dbmail localhost services_dbmail Sleep 47 NULL 843951 dbmail localhost services_dbmail Sleep 47 NULL 843952 dbmail localhost services_dbmail Sleep 47 NULL 843953 dbmail localhost services_dbmail Sleep 47 NULL 843954 dbmail localhost services_dbmail Sleep 47 NULL 843955 dbmail localhost services_dbmail Sleep 47 NULL 843956 dbmail localhost services_dbmail Sleep 47 NULL 843957 dbmail localhost services_dbmail Sleep 47 NULL 843958 dbmail localhost services_dbmail Sleep 47 NULL 843959 dbmail localhost services_dbmail Sleep 47 NULL 843960 dbmail localhost services_dbmail Sleep 47 NULL 843961 dbmail localhost services_dbmail Sleep 47 NULL 843962 dbmail localhost services_dbmail Sleep 47 NULL 843963 dbmail localhost services_dbmail Sleep 47 NULL 843964 dbmail localhost services_dbmail Sleep 47 NULL 843965 dbmail localhost services_dbmail Sleep 47 NULL 843966 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843967 dbmail localhost services_dbmail Sleep 47 NULL 843968 dbmail localhost services_dbmail Sleep 47 NULL 843969 dbmail localhost services_dbmail Sleep 47 NULL 843970 dbmail localhost services_dbmail Sleep 47 NULL 843971 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843972 dbmail localhost services_dbmail Sleep 47 NULL 843973 dbmail localhost services_dbmail Sleep 47 NULL 843974 dbmail localhost services_dbmail Sleep 47 NULL 843975 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843976 dbmail localhost services_dbmail Sleep 47 NULL 843977 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843978 dbmail localhost services_dbmail Sleep 47 NULL 843979 dbmail localhost services_dbmail Execute 42 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843980 dbmail localhost services_dbmail Sleep 47 NULL 843981 dbmail localhost services_dbmail Sleep 47 NULL 843982 dbmail localhost services_dbmail Sleep 47 NULL 843983 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843984 dbmail localhost services_dbmail Sleep 47 NULL 843985 dbmail localhost services_dbmail Sleep 47 NULL 843986 dbmail localhost services_dbmail Sleep 47 NULL 843987 dbmail localhost services_dbmail Sleep 47 NULL 843988 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843989 dbmail localhost services_dbmail Sleep 47 NULL 843990 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 843991 dbmail localhost services_dbmail Sleep 47 NULL 843992 dbmail localhost services_dbmail Sleep 47 NULL 843993 dbmail localhost services_dbmail Sleep 47 NULL 843994 dbmail localhost services_dbmail Sleep 47 NULL 843995 dbmail localhost services_dbmail Sleep 47 NULL 843996 dbmail localhost services_dbmail Sleep 47 NULL 843997 dbmail localhost services_dbmail Sleep 47 NULL 843998 dbmail localhost services_dbmail Sleep 47 NULL 843999 dbmail localhost services_dbmail Sleep 47 NULL 844000 dbmail localhost services_dbmail Sleep 47 NULL 844001 dbmail localhost services_dbmail Sleep 47 NULL 844002 dbmail localhost services_dbmail Sleep 47 NULL 844003 dbmail localhost services_dbmail Sleep 47 NULL 844004 dbmail localhost services_dbmail Sleep 47 NULL 844005 dbmail localhost services_dbmail Sleep 47 NULL 844006 dbmail localhost services_dbmail Execute 42 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844007 dbmail localhost services_dbmail Execute 42 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844008 dbmail localhost services_dbmail Execute 42 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844009 dbmail localhost services_dbmail Sleep 47 NULL 844010 dbmail localhost services_dbmail Sleep 47 NULL 844011 dbmail localhost services_dbmail Sleep 47 NULL 844012 dbmail localhost services_dbmail Sleep 47 NULL 844013 dbmail localhost services_dbmail Sleep 47 NULL 844014 dbmail localhost services_dbmail Sleep 47 NULL 844015 dbmail localhost services_dbmail Sleep 47 NULL 844016 dbmail localhost services_dbmail Sleep 47 NULL 844017 dbmail localhost services_dbmail Sleep 47 NULL 844018 dbmail localhost services_dbmail Sleep 47 NULL 844019 dbmail localhost services_dbmail Sleep 47 NULL 844020 dbmail localhost services_dbmail Sleep 47 NULL 844021 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844022 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844023 dbmail localhost services_dbmail Sleep 47 NULL 844024 dbmail localhost services_dbmail Sleep 47 NULL 844025 dbmail localhost services_dbmail Sleep 47 NULL 844026 dbmail localhost services_dbmail Sleep 47 NULL 844027 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844028 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844029 dbmail localhost services_dbmail Sleep 47 NULL 844030 dbmail localhost services_dbmail Sleep 47 NULL 844031 dbmail localhost services_dbmail Sleep 47 NULL 844032 dbmail localhost services_dbmail Sleep 47 NULL 844033 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844034 dbmail localhost services_dbmail Sleep 47 NULL 844035 dbmail localhost services_dbmail Sleep 47 NULL 844036 dbmail localhost services_dbmail Sleep 47 NULL 844037 dbmail localhost services_dbmail Sleep 47 NULL 844038 dbmail localhost services_dbmail Sleep 47 NULL 844039 dbmail localhost services_dbmail Sleep 47 NULL 844040 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844041 dbmail localhost services_dbmail Sleep 47 NULL 844042 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844043 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844044 dbmail localhost services_dbmail Sleep 47 NULL 844045 dbmail localhost services_dbmail Sleep 47 NULL 844046 dbmail localhost services_dbmail Sleep 47 NULL 844047 dbmail localhost services_dbmail Sleep 47 NULL 844048 dbmail localhost services_dbmail Sleep 47 NULL 844049 dbmail localhost services_dbmail Sleep 47 NULL 844050 dbmail localhost services_dbmail Sleep 47 NULL 844051 dbmail localhost services_dbmail Sleep 47 NULL 844052 dbmail localhost services_dbmail Sleep 47 NULL 844053 dbmail localhost services_dbmail Sleep 47 NULL 844054 dbmail localhost services_dbmail Sleep 47 NULL 844055 dbmail localhost services_dbmail Sleep 47 NULL 844056 dbmail localhost services_dbmail Sleep 47 NULL 844057 dbmail localhost services_dbmail Sleep 47 NULL 844058 dbmail localhost services_dbmail Sleep 47 NULL 844059 dbmail localhost services_dbmail Sleep 47 NULL 844060 dbmail localhost services_dbmail Sleep 47 NULL 844061 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844062 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844063 dbmail localhost services_dbmail Sleep 47 NULL 844064 dbmail localhost services_dbmail Sleep 47 NULL 844065 dbmail localhost services_dbmail Sleep 47 NULL 844066 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844067 dbmail localhost services_dbmail Sleep 47 NULL 844068 dbmail localhost services_dbmail Sleep 47 NULL 844069 dbmail localhost services_dbmail Sleep 47 NULL 844070 dbmail localhost services_dbmail Sleep 47 NULL 844071 dbmail localhost services_dbmail Sleep 47 NULL 844072 dbmail localhost services_dbmail Sleep 47 NULL 844073 dbmail localhost services_dbmail Sleep 47 NULL 844074 dbmail localhost services_dbmail Sleep 47 NULL 844075 dbmail localhost services_dbmail Sleep 47 NULL 844076 dbmail localhost services_dbmail Execute 44 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844077 dbmail localhost services_dbmail Execute 43 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844078 dbmail localhost services_dbmail Execute 43 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844079 dbmail localhost services_dbmail Sleep 46 NULL 844080 dbmail localhost services_dbmail Sleep 46 NULL 844081 dbmail localhost services_dbmail Sleep 46 NULL 844082 dbmail localhost services_dbmail Sleep 46 NULL 844083 dbmail localhost services_dbmail Sleep 46 NULL 844084 dbmail localhost services_dbmail Sleep 46 NULL 844085 dbmail localhost services_dbmail Sleep 46 NULL 844086 dbmail localhost services_dbmail Sleep 46 NULL 844087 dbmail localhost services_dbmail Sleep 46 NULL 844088 dbmail localhost services_dbmail Sleep 46 NULL 844089 dbmail localhost services_dbmail Sleep 46 NULL 844090 dbmail localhost services_dbmail Sleep 46 NULL 844091 dbmail localhost services_dbmail Execute 43 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844092 dbmail localhost services_dbmail Sleep 46 NULL 844093 dbmail localhost services_dbmail Sleep 46 NULL 844094 dbmail localhost services_dbmail Sleep 46 NULL 844095 dbmail localhost services_dbmail Sleep 46 NULL 844096 dbmail localhost services_dbmail Execute 43 Sending data SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=? AND n.headername IN ('resent-message-id','message-id') AND v.headervalue=? AND p.internal_date > NOW() - INTERVAL 3 DAY 844097 dbmail localhost services_dbmail Sleep 46 NULL 844098 dbmail localhost services_dbmail Sleep 46 NULL 844099 dbmail localhost services_dbmail Sleep 46 NULL 844100 dbmail localhost services_dbmail Sleep 46 NULL 844109 admin_monitor localhost NULL Init DB 0 NULL NULL ---------------------------------------------------------------------- (0002706) grosjo (reporter) - 21-Dec-08 09:25 http://www.dbmail.org/mantis/view.php?id=740#c2706 ---------------------------------------------------------------------- THis is still not solved and I have currently hundreds of "unclosed sleeping connections" with the latest GIT and the maximum connections set to 50. Id User Host db Command Time State Info 1516552 dbmail localhost services_dbmail Sleep 706 NULL 1516553 dbmail localhost services_dbmail Sleep 2433 NULL 1516554 dbmail localhost services_dbmail Sleep 2433 NULL 1516555 dbmail localhost services_dbmail Sleep 2433 NULL 1516556 dbmail localhost services_dbmail Sleep 2433 NULL 1516557 dbmail localhost services_dbmail Sleep 694 NULL 1516558 dbmail localhost services_dbmail Sleep 2433 NULL 1516559 dbmail localhost services_dbmail Sleep 2433 NULL 1516560 dbmail localhost services_dbmail Sleep 2433 NULL 1516561 dbmail localhost services_dbmail Sleep 2433 NULL 1516562 dbmail localhost services_dbmail Sleep 712 NULL 1516563 dbmail localhost services_dbmail Sleep 2433 NULL 1516564 dbmail localhost services_dbmail Sleep 2433 NULL 1516565 dbmail localhost services_dbmail Sleep 2433 NULL 1516566 dbmail localhost services_dbmail Sleep 2433 NULL 1516575 dbmail localhost services_dbmail Sleep 26 NULL 1516576 dbmail localhost services_dbmail Sleep 2393 NULL 1516577 dbmail localhost services_dbmail Sleep 2393 NULL 1516578 dbmail localhost services_dbmail Sleep 2393 NULL 1516579 dbmail localhost services_dbmail Sleep 2393 NULL 1516581 dbmail localhost services_dbmail Sleep 9 NULL 1516582 dbmail localhost services_dbmail Sleep 2360 NULL 1516583 dbmail localhost services_dbmail Sleep 2360 NULL 1516584 dbmail localhost services_dbmail Sleep 2360 NULL 1516585 dbmail localhost services_dbmail Sleep 2360 NULL 1516586 dbmail localhost services_dbmail Sleep 705 NULL 1516587 dbmail localhost services_dbmail Sleep 2356 NULL 1516588 dbmail localhost services_dbmail Sleep 2356 NULL 1516589 dbmail localhost services_dbmail Sleep 2356 NULL 1516590 dbmail localhost services_dbmail Sleep 2356 NULL 1518966 dbmail localhost services_dbmail Sleep 711 NULL 1518967 dbmail localhost services_dbmail Sleep 712 NULL 1518968 dbmail localhost services_dbmail Sleep 712 NULL 1518969 dbmail localhost services_dbmail Sleep 712 NULL 1518970 dbmail localhost services_dbmail Sleep 712 NULL 1523965 dbmail localhost services_dbmail Sleep 308 NULL 1523971 dbmail localhost services_dbmail Sleep 308 NULL 1523972 dbmail localhost services_dbmail Sleep 308 NULL 1523973 dbmail localhost services_dbmail Sleep 308 NULL 1523981 dbmail localhost services_dbmail Sleep 307 NULL 1523982 dbmail localhost services_dbmail Sleep 307 NULL 1523983 dbmail localhost services_dbmail Sleep 307 NULL 1523984 dbmail localhost services_dbmail Sleep 307 NULL 1523986 dbmail localhost services_dbmail Sleep 306 NULL 1523987 dbmail localhost services_dbmail Sleep 306 NULL 1523988 dbmail localhost services_dbmail Sleep 306 NULL 1523989 dbmail localhost services_dbmail Sleep 306 NULL 1524017 dbmail localhost services_dbmail Sleep 300 NULL 1524018 dbmail localhost services_dbmail Sleep 300 NULL 1524019 dbmail localhost services_dbmail Sleep 300 NULL 1524020 dbmail localhost services_dbmail Sleep 300 NULL 1524042 dbmail localhost services_dbmail Sleep 215 NULL 1524043 dbmail localhost services_dbmail Sleep 215 NULL 1524044 dbmail localhost services_dbmail Sleep 215 NULL 1524045 dbmail localhost services_dbmail Sleep 215 NULL 1524046 dbmail localhost services_dbmail Sleep 215 NULL 1524047 dbmail localhost services_dbmail Sleep 215 NULL 1524048 dbmail localhost services_dbmail Sleep 215 NULL 1524049 dbmail localhost services_dbmail Sleep 215 NULL 1524050 dbmail localhost services_dbmail Sleep 215 NULL 1524051 dbmail localhost services_dbmail Sleep 215 NULL 1524053 dbmail localhost services_dbmail Sleep 215 NULL 1524054 dbmail localhost services_dbmail Sleep 215 NULL 1524155 dbmail localhost services_dbmail Sleep 215 NULL 1524156 dbmail localhost services_dbmail Sleep 215 NULL 1524157 dbmail localhost services_dbmail Sleep 215 NULL 1524158 dbmail localhost services_dbmail Sleep 215 NULL 1524182 dbmail localhost services_dbmail Sleep 120 NULL 1524183 dbmail localhost services_dbmail Sleep 120 NULL 1524184 dbmail localhost services_dbmail Sleep 120 NULL 1524187 dbmail localhost services_dbmail Sleep 120 NULL 1524188 dbmail localhost services_dbmail Sleep 120 NULL 1524193 dbmail localhost services_dbmail Sleep 120 NULL 1524194 dbmail localhost services_dbmail Sleep 120 NULL 1524197 dbmail localhost services_dbmail Sleep 120 NULL 1524198 dbmail localhost services_dbmail Sleep 120 NULL 1524202 dbmail localhost services_dbmail Sleep 120 NULL 1524204 dbmail localhost services_dbmail Sleep 120 NULL 1524205 dbmail localhost services_dbmail Sleep 120 NULL 1524206 dbmail localhost services_dbmail Sleep 120 NULL 1524207 dbmail localhost services_dbmail Sleep 120 NULL 1524208 dbmail localhost services_dbmail Sleep 120 NULL 1524209 dbmail localhost services_dbmail Sleep 120 NULL 1524210 dbmail localhost services_dbmail Sleep 120 NULL 1524211 dbmail localhost services_dbmail Sleep 120 NULL 1524212 dbmail localhost services_dbmail Sleep 120 NULL 1524213 dbmail localhost services_dbmail Sleep 120 NULL 1524214 dbmail localhost services_dbmail Sleep 120 NULL 1524215 dbmail localhost services_dbmail Sleep 120 NULL 1524216 dbmail localhost services_dbmail Sleep 120 NULL 1524217 dbmail localhost services_dbmail Sleep 120 NULL 1524218 dbmail localhost services_dbmail Sleep 120 NULL 1524219 dbmail localhost services_dbmail Sleep 120 NULL 1524220 dbmail localhost services_dbmail Sleep 120 NULL 1524221 dbmail localhost services_dbmail Sleep 120 NULL 1524222 dbmail localhost services_dbmail Sleep 120 NULL 1524226 dbmail localhost services_dbmail Sleep 120 NULL 1524228 dbmail localhost services_dbmail Sleep 120 NULL 1524229 dbmail localhost services_dbmail Sleep 120 NULL 1524230 dbmail localhost services_dbmail Sleep 120 NULL 1524232 dbmail localhost services_dbmail Sleep 120 NULL 1524233 dbmail localhost services_dbmail Sleep 120 NULL 1524234 dbmail localhost services_dbmail Sleep 120 NULL 1524235 dbmail localhost services_dbmail Sleep 120 NULL 1524236 dbmail localhost services_dbmail Sleep 120 NULL 1524237 dbmail localhost services_dbmail Sleep 120 NULL 1524238 dbmail localhost services_dbmail Sleep 120 NULL 1524239 dbmail localhost services_dbmail Sleep 120 NULL 1524240 dbmail localhost services_dbmail Sleep 120 NULL 1524241 dbmail localhost services_dbmail Sleep 120 NULL 1524242 dbmail localhost services_dbmail Sleep 120 NULL 1524243 dbmail localhost services_dbmail Sleep 120 NULL 1524244 dbmail localhost services_dbmail Sleep 120 NULL 1524245 dbmail localhost services_dbmail Sleep 120 NULL 1524246 dbmail localhost services_dbmail Sleep 120 NULL 1524247 dbmail localhost services_dbmail Sleep 120 NULL 1524248 dbmail localhost services_dbmail Sleep 120 NULL 1524249 dbmail localhost services_dbmail Sleep 120 NULL 1524250 dbmail localhost services_dbmail Sleep 120 NULL 1524251 dbmail localhost services_dbmail Sleep 120 NULL 1524252 dbmail localhost services_dbmail Sleep 120 NULL 1524253 dbmail localhost services_dbmail Sleep 120 NULL 1524254 dbmail localhost services_dbmail Sleep 120 NULL 1524255 dbmail localhost services_dbmail Sleep 120 NULL 1524256 dbmail localhost services_dbmail Sleep 120 NULL 1524258 dbmail localhost services_dbmail Sleep 120 NULL 1524259 dbmail localhost services_dbmail Sleep 120 NULL 1524260 dbmail localhost services_dbmail Sleep 120 NULL 1524261 dbmail localhost services_dbmail Sleep 120 NULL 1524262 dbmail localhost services_dbmail Sleep 120 NULL 1524263 dbmail localhost services_dbmail Sleep 120 NULL 1524264 dbmail localhost services_dbmail Sleep 120 NULL 1524265 dbmail localhost services_dbmail Sleep 120 NULL 1524266 dbmail localhost services_dbmail Sleep 120 NULL 1524268 dbmail localhost services_dbmail Sleep 120 NULL 1524269 dbmail localhost services_dbmail Sleep 120 NULL 1524270 dbmail localhost services_dbmail Sleep 120 NULL 1524271 dbmail localhost services_dbmail Sleep 120 NULL 1524272 dbmail localhost services_dbmail Sleep 120 NULL 1524274 dbmail localhost services_dbmail Sleep 120 NULL 1524275 dbmail localhost services_dbmail Sleep 120 NULL 1524276 dbmail localhost services_dbmail Sleep 120 NULL 1524277 dbmail localhost services_dbmail Sleep 120 NULL 1524278 dbmail localhost services_dbmail Sleep 120 NULL 1524279 dbmail localhost services_dbmail Sleep 120 NULL 1524280 dbmail localhost services_dbmail Sleep 120 NULL 1524281 dbmail localhost services_dbmail Sleep 120 NULL 1524282 dbmail localhost services_dbmail Sleep 120 NULL 1524283 dbmail localhost services_dbmail Sleep 120 NULL 1524284 dbmail localhost services_dbmail Sleep 120 NULL 1524286 dbmail localhost services_dbmail Sleep 120 NULL 1524287 dbmail localhost services_dbmail Sleep 120 NULL 1524288 dbmail localhost services_dbmail Sleep 120 NULL 1524289 dbmail localhost services_dbmail Sleep 120 NULL 1524294 dbmail localhost services_dbmail Sleep 120 NULL 1524296 dbmail localhost services_dbmail Sleep 120 NULL 1524297 dbmail localhost services_dbmail Sleep 120 NULL 1524299 dbmail localhost services_dbmail Sleep 120 NULL 1524300 dbmail localhost services_dbmail Sleep 120 NULL 1524301 dbmail localhost services_dbmail Sleep 120 NULL 1524302 dbmail localhost services_dbmail Sleep 120 NULL 1524303 dbmail localhost services_dbmail Sleep 120 NULL 1524304 dbmail localhost services_dbmail Sleep 120 NULL 1524305 dbmail localhost services_dbmail Sleep 120 NULL 1524306 dbmail localhost services_dbmail Sleep 120 NULL 1524307 dbmail localhost services_dbmail Sleep 120 NULL 1524308 dbmail localhost services_dbmail Sleep 120 NULL 1524309 dbmail localhost services_dbmail Sleep 120 NULL 1524310 dbmail localhost services_dbmail Sleep 120 NULL 1524311 dbmail localhost services_dbmail Sleep 120 NULL 1524312 dbmail localhost services_dbmail Sleep 120 NULL 1524314 dbmail localhost services_dbmail Sleep 120 NULL 1524315 dbmail localhost services_dbmail Sleep 120 NULL 1524317 dbmail localhost services_dbmail Sleep 120 NULL 1524318 dbmail localhost services_dbmail Sleep 120 NULL 1524319 dbmail localhost services_dbmail Sleep 120 NULL 1524320 dbmail localhost services_dbmail Sleep 120 NULL 1524324 dbmail localhost services_dbmail Sleep 120 NULL 1524325 dbmail localhost services_dbmail Sleep 120 NULL 1524326 dbmail localhost services_dbmail Sleep 120 NULL 1524327 dbmail localhost services_dbmail Sleep 120 NULL 1524328 dbmail localhost services_dbmail Sleep 120 NULL 1524329 dbmail localhost services_dbmail Sleep 120 NULL 1524330 dbmail localhost services_dbmail Sleep 120 NULL 1524332 dbmail localhost services_dbmail Sleep 120 NULL 1524333 dbmail localhost services_dbmail Sleep 120 NULL 1524335 dbmail localhost services_dbmail Sleep 120 NULL 1524336 dbmail localhost services_dbmail Sleep 120 NULL 1524337 dbmail localhost services_dbmail Sleep 120 NULL 1524338 dbmail localhost services_dbmail Sleep 120 NULL 1524339 dbmail localhost services_dbmail Sleep 120 NULL 1524340 dbmail localhost services_dbmail Sleep 120 NULL 1524341 dbmail localhost services_dbmail Sleep 120 NULL 1524342 dbmail localhost services_dbmail Sleep 120 NULL 1524343 dbmail localhost services_dbmail Sleep 120 NULL 1524344 dbmail localhost services_dbmail Sleep 120 NULL 1524345 dbmail localhost services_dbmail Sleep 120 NULL 1524346 dbmail localhost services_dbmail Sleep 120 NULL 1524347 dbmail localhost services_dbmail Sleep 120 NULL 1524348 dbmail localhost services_dbmail Sleep 120 NULL 1524349 dbmail localhost services_dbmail Sleep 120 NULL 1524350 dbmail localhost services_dbmail Sleep 120 NULL 1524351 dbmail localhost services_dbmail Sleep 120 NULL 1524352 dbmail localhost services_dbmail Sleep 120 NULL 1524353 dbmail localhost services_dbmail Sleep 120 NULL 1524354 dbmail localhost services_dbmail Sleep 120 NULL 1524357 dbmail localhost services_dbmail Sleep 120 NULL 1524358 dbmail localhost services_dbmail Sleep 120 NULL 1524359 dbmail localhost services_dbmail Sleep 120 NULL 1524360 dbmail localhost services_dbmail Sleep 120 NULL 1524361 dbmail localhost services_dbmail Sleep 120 NULL 1524362 dbmail localhost services_dbmail Sleep 120 NULL 1524363 dbmail localhost services_dbmail Sleep 120 NULL 1524364 dbmail localhost services_dbmail Sleep 120 NULL 1524365 dbmail localhost services_dbmail Sleep 120 NULL 1524369 dbmail localhost services_dbmail Sleep 118 NULL 1524370 dbmail localhost services_dbmail Sleep 118 NULL 1524371 dbmail localhost services_dbmail Sleep 118 NULL 1524372 dbmail localhost services_dbmail Sleep 118 NULL 1524385 dbmail localhost services_dbmail Sleep 54 NULL 1524386 dbmail localhost services_dbmail Sleep 54 NULL 1524387 dbmail localhost services_dbmail Sleep 54 NULL 1524388 dbmail localhost services_dbmail Sleep 54 NULL ---------------------------------------------------------------------- (0002707) grosjo (reporter) - 21-Dec-08 09:26 http://www.dbmail.org/mantis/view.php?id=740#c2707 ---------------------------------------------------------------------- The problem shall come from dbmail-deliver (I am not using dbmail-lmtp) ---------------------------------------------------------------------- (0002708) paul (administrator) - 21-Dec-08 12:10 http://www.dbmail.org/mantis/view.php?id=740#c2708 ---------------------------------------------------------------------- please don't paste logs. Use the fileupload. This report is quickly becoming unreadable. that said. I'll look into it. ---------------------------------------------------------------------- (0002721) paul (administrator) - 28-Dec-08 17:19 http://www.dbmail.org/mantis/view.php?id=740#c2721 ---------------------------------------------------------------------- Those open connections cannot come from dbmail-deliver, since that is typically a very short running process. If you could catch the last query for such sleeping connections that would at least give me a hint where to look. ---------------------------------------------------------------------- (0002732) paul (administrator) - 25-Jan-09 13:32 http://www.dbmail.org/mantis/view.php?id=740#c2732 ---------------------------------------------------------------------- I'm closing this report due to lack of feedback ---------------------------------------------------------------------- (0002735) grosjo (reporter) - 25-Jan-09 23:03 http://www.dbmail.org/mantis/view.php?id=740#c2735 ---------------------------------------------------------------------- hey, the issue is still there and no way to get any "last query" (or please tell me how to do that). ---------------------------------------------------------------------- (0002737) paul (administrator) - 26-Jan-09 12:13 http://www.dbmail.org/mantis/view.php?id=740#c2737 ---------------------------------------------------------------------- What version have you last tested this on? Try using syslog_logging_levels=511 in dbmail.conf. That will produce massive amounts of debug output. ---------------------------------------------------------------------- (0002738) grosjo (reporter) - 28-Jan-09 09:32 http://www.dbmail.org/mantis/view.php?id=740#c2738 ---------------------------------------------------------------------- I made it, but it is mostly impossible to figure out wich mysql statement are linked to the 400 connections pending ! Is it possible to go from the other side, and check the "db_close" in dbmail-deliver binary ? ---------------------------------------------------------------------- (0002739) paul (administrator) - 28-Jan-09 10:17 http://www.dbmail.org/mantis/view.php?id=740#c2739 ---------------------------------------------------------------------- dbmail-deliver cannot and will not generate 400 connections. I repeat myself: it's a short-running process. Try: cat testemail.eml|dbmail-deliver -u youruser grep deliver /var/log/mail.log Issue History Date Modified Username Field Change ====================================================================== 26-Nov-08 15:41 grosjo New Issue 26-Nov-08 15:52 grosjo Note Added: 0002671 26-Nov-08 16:31 paul Note Added: 0002672 26-Nov-08 17:14 grosjo Note Added: 0002673 26-Nov-08 19:57 paul Relationship added duplicate of 0000738 05-Dec-08 20:58 paul Assigned To => paul 05-Dec-08 20:58 paul Status new => resolved 05-Dec-08 20:58 paul Resolution open => fixed 05-Dec-08 20:58 paul Fixed in Version => 2.3.5 21-Dec-08 09:15 grosjo Status resolved => feedback 21-Dec-08 09:15 grosjo Resolution fixed => reopened 21-Dec-08 09:15 grosjo Note Added: 0002705 21-Dec-08 09:15 grosjo Note Added: 0002706 21-Dec-08 09:19 grosjo Note Edited: 0002706 21-Dec-08 09:19 grosjo Note Deleted: 0002705 21-Dec-08 09:25 grosjo Note Edited: 0002706 21-Dec-08 09:26 grosjo Note Added: 0002707 21-Dec-08 12:10 paul Note Added: 0002708 28-Dec-08 17:19 paul Note Added: 0002721 25-Jan-09 13:32 paul Note Added: 0002732 25-Jan-09 13:32 paul Status feedback => resolved 25-Jan-09 13:32 paul Resolution reopened => fixed 25-Jan-09 23:03 grosjo Status resolved => feedback 25-Jan-09 23:03 grosjo Resolution fixed => reopened 25-Jan-09 23:03 grosjo Note Added: 0002735 26-Jan-09 12:13 paul Note Added: 0002737 28-Jan-09 09:32 grosjo Note Added: 0002738 28-Jan-09 10:17 paul Note Added: 0002739 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
