Developers of Sympa

["Kristina Clair" <address@concealed>]

Hi there,

This patch breaks deleting of rows in mysql 5.0.  Single-quoting the table
name and column name produces a syntax error.  Either not quoting them or
using backticks is ok syntax.

Since originally reporting this problem, I've discovered the following:

* The increased disk usage seems to be due to the way mysql manages
deleted rows in MYISAM tables. When it deletes a row, it doesn't free the
disk space because it will supposedly reuse it. Sometimes apparently this
doesn't happen efficiently. Running 'optimize table' can free this disk
space.

* The messages in bulkspool_table don't necessarily get removed
immediately, but there is a task which removes them at the end of the day.
So i think when I originally reported this problem, what I reported was
normal behavior, and i just wasn't aware that the messages would be
removed that night.

Kristina


> 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
>>
>