The following issue has been REOPENED.
======================================================================
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: 25-Jan-09 23:03 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
======================================================================
----------------------------------------------------------------------
grosjo - 26-Nov-08 15:52
----------------------------------------------------------------------
2.3.3 is the version, not 2.3.4
----------------------------------------------------------------------
paul - 26-Nov-08 16:31
----------------------------------------------------------------------
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.
----------------------------------------------------------------------
grosjo - 26-Nov-08 17:14
----------------------------------------------------------------------
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
----------------------------------------------------------------------
grosjo - 21-Dec-08 09:25
----------------------------------------------------------------------
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
----------------------------------------------------------------------
grosjo - 21-Dec-08 09:26
----------------------------------------------------------------------
The problem shall come from dbmail-deliver (I am not using dbmail-lmtp)
----------------------------------------------------------------------
paul - 21-Dec-08 12:10
----------------------------------------------------------------------
please don't paste logs. Use the fileupload. This report is quickly
becoming unreadable.
that said. I'll look into it.
----------------------------------------------------------------------
paul - 28-Dec-08 17:19
----------------------------------------------------------------------
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.
----------------------------------------------------------------------
paul - 25-Jan-09 13:32
----------------------------------------------------------------------
I'm closing this report due to lack of feedback
----------------------------------------------------------------------
grosjo - 25-Jan-09 23:03
----------------------------------------------------------------------
hey, the issue is still there and no way to get any "last query" (or please
tell me how to do that).
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
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
