[Dspam-devel] [ dspam-Bug Tracker-2989984 ] maintenance script: command run twice in a row?

[SourceForge.net <no...@so...>]

Bug Tracker item #2989984, was opened at 2010-04-20 18:38
Message generated for change (Settings changed) made by sbajic
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989984&group_id=250683

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: contrib/thunderbird
Group: v3.9.0
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: interfaSys ()
>Assigned to: Stevan Bajic (sbajic)
Summary: maintenance script: command run twice in a row?

Initial Comment:
The script generates this statement twice in a row:
SET timestamp=1271780703;
SELECT token,spam_hits,innocent_hits,unix_timestamp(last_hit) FROM dspam_token_data WHERE uid=14;

Since it's quite a costly operation, wouldn't it be possible to only call it once?
This must be from dspam_clean.

I'm calling it like this:
 /usr/local/bin/dspam_maintenance.sh --logdays=30 --signatures=30 --unused=60 --with-sql-optimization --verbose

and the result is
Enabled drivers are: mysql_drv
Running dspam_logrotate in the background
Active driver is: mysql_drv
Running dspam_clean ...
  * without purging old signatures


----------------------------------------------------------------------

Comment By: Stevan Bajic (sbajic)
Date: 2010-04-22 01:10

Message:
Hallo Oliver,

what do you mean with "twice in a row"? Could you post logs showing all
commands issued by the maintenance script?

What have you done to see that the select was issued twice? Have you
turned on query logging in MySQL? Could you post this log or at least a
bunch of SQL queries that have been executed to illustrate that the query
is executed twice?

If you have MySQL query log active then try to call manually dspam_clean
with the appropriate switches and then look again if you see twice this
select clause and let me know if the query gets executed twice.

Stevan

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2989984&group_id=250683