From 8d18b671d3e6e0c871f6cc81cf6ddc58589f35ce Mon Sep 17 00:00:00 2001 From: "martin f. krafft" Date: Sun, 2 Mar 2008 16:45:09 +0100 Subject: [PATCH 1/1] no more slew magic when selecting expired messages --- bin/process-delayed-queue | 2 +- bin/release-delayed-messages | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/bin/process-delayed-queue b/bin/process-delayed-queue index e978a40..6ab1163 100755 --- a/bin/process-delayed-queue +++ b/bin/process-delayed-queue @@ -8,7 +8,7 @@ RESUBMIT=$HOME/.etc/mailfilter/bin/resubmit DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite -QUERY='select * from messages where release_ts < strftime("%s", "now")' +QUERY='select * from messages where release_ts <= strftime("%s", "now")' $SQLITE -list -separator ' ' $DELAYED_QUEUE_DB "$QUERY" \ | while read msgid basefile ts; do diff --git a/bin/release-delayed-messages b/bin/release-delayed-messages index 6a057c9..fd381d3 100755 --- a/bin/release-delayed-messages +++ b/bin/release-delayed-messages @@ -6,7 +6,7 @@ MAILDIR=$HOME/.maildir SQLITE=/usr/bin/sqlite3 DELAYED_QUEUE_DB=$HOME/.var/procmail/delayed-queue.sqlite -QUERY="update messages set release_ts = strftime('%s', 'now') - 10 where filename like '.delayed/%'" +QUERY="update messages set release_ts = strftime('%s', 'now') where filename like '.delayed/%'" $SQLITE $DELAYED_QUEUE_DB "$QUERY" exec $HOME/.etc/mailfilter/bin/process-delayed-queue -- 2.39.5