View Issue Details

IDProjectCategoryView StatusLast Update
0018841phplist applicationBounce Managementpublic01-09-17 12:59
Reporterduncanc 
PrioritynormalSeverityminorReproducibilitysometimes
Status newResolutionopen 
Product Version3.3.1 
Target VersionFixed in Version 
Summary0018841: Advanced bounce processing should process only bounces with related user
DescriptionThis is related to issue 17860 to do with the processing of bounces for bounce rules, https://mantis.phplist.org/view.php?id=17860

For the query that gets the number of bounces to process, add a join to the bounce and user tables, and for the main query that gets each bounce add a join to the user table.

Now the processing will select only bounces that have a related user (through the user_message_bounce table).

This will correct the number of bounces that are reported. In this case there are 5,382 rows in user_message_bounce table but only 13 in bounce table, yet the code tries to iterate over all rows in user_message_bounce.

phpList - Processing bounces based on active bounce rules
phpList - processed 500 out of 5832 bounces for advanced bounce rules
phpList - processed 1000 out of 5832 bounces for advanced bounce rules
phpList - processed 1500 out of 5832 bounces for advanced bounce rules
phpList - processed 2000 out of 5832 bounces for advanced bounce rules
phpList - processed 2500 out of 5832 bounces for advanced bounce rules
phpList - processed 3000 out of 5832 bounces for advanced bounce rules
phpList - processed 3500 out of 5832 bounces for advanced bounce rules
phpList - processed 4000 out of 5832 bounces for advanced bounce rules
phpList - processed 4500 out of 5832 bounces for advanced bounce rules
phpList - processed 5000 out of 5832 bounces for advanced bounce rules
phpList - processed 5500 out of 5832 bounces for advanced bounce rules
phpList - processed 6000 out of 5832 bounces for advanced bounce rules

By joining to the user table some later queries to get user data and the confirmed and blacklisted status values can be removed.
TagsNo tags attached.

Activities

There are no notes attached to this issue.