[support] Severe Hanging (and sometimes MySql crashes) When Approving Comments

[Big Brother]

It appears to be a problem with the Karma module we are using. The
call in questions arise when we call a query for the Top Rated
Comments, which we display to the user in a sidebar.

Oddly enough, this only happens on the weekends and then doesn't give
us any problems during the week.

Has anyone ever heard of the Karma module causing a problem?

-David

On Tue, Jun 17, 2008 at 8:08 AM, Earnie Boyd
<earnie at users.sourceforge.net> wrote:
> Quoting Big Brother <ignorance.is.strength at gmail.com>:
>
>> Thanks for the responses.
>>
>> I have too many modules to list them all... it would take too long.
>>
>> It's something to do with MySql accessing the comments table. It then
>> locks and hangs.
>>
>> I am not using persistent connections.
>>
>> The Processlist indicates a number of 'SELECT count(node.nid) FROM
>> node LEFT JOIN
>> comments' statements which send data forever, and a few 'SELECT node.nid,
>> comments.timestamp' which copy to tmp forever.
>>
>> Possible relevant modules:
>> Karma
>> Path
>> Localizer
>> Panels
>>
>
> The only suggestion I have is for you to start turning off modules
> until you find the one causing the problem and then open an issue for
> that module.  It may be a combination of modules causing an issue; some
> modules are not compatible with other modules.  If you find a
> combination issue then open an issue in both modules so that they can
> document the travesty.
>
> Earnie -- http://for-my-kids.com/
> -- http://give-me-an-offer.com/
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>