Developers of Sympa

[Thomas Berry <address@concealed>]

I think I found the problem

In Bulk.pm,

line 157:
   my $statement = sprintf "DELETE FROM `%s` WHERE `%s` = 
'%s'",$table,$key,$messagekey;

should be:
   my $statement = sprintf "DELETE FROM '%s' WHERE '%s' = 
'%s'",$table,$key,$messagekey;


I'll submit a bug report and a patch file.

Thomas

address@concealed wrote:
> Hello,
>
> Today I was investigating why our mysql disk space use has been growing
> very fast since upgrading to 6.0.1, and I discovered that the
> bulkspool_table has 1800 entries in it, while the bulkmailer_table has no
> entries. So, somehow messages are not being removed from bulkspool_table
> appropriately sometimes.
>
> Has anyone seen this happen?  Any ideas where I should start looking for
> causes for this?
>
> Thanks,
> Kristina