Bug Tracker item #2989984, was opened at 2010-04-20 18:38 Message generated for change (Comment added) 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: Nobody/Anonymous (nobody) 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 ------------------------------------------------------------------------------ _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
