A NOTE has been added to this issue.
======================================================================
http://www.dbmail.org/mantis/view.php?id=740
======================================================================
Reported By: grosjo
Assigned To:
======================================================================
Project: DBMail
Issue ID: 740
Category: Database layer
Reproducibility: always
Severity: major
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 26-Nov-08 15:41 CET
Last Modified: 26-Nov-08 17:14 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) )
======================================================================
----------------------------------------------------------------------
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
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
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
