Re: reputation / mysql problem

From: SM <sm_at_resistor.net>
Date: Mon, 11 Jun 2012 10:24:20 -0700

Hi Andreas,
At 05:42 11-06-2012, Andreas Schulze wrote:
>my database holding the reputation database grows drastic.
>since some days opendkim-genstats does not work anymore.
>
>opendkim-genstats: started at Mon Jun 11 14:12:41 2012
>opendkim-genstats: connected to database
>opendkim-genstats: report started in /repute/htdocs/report/index.html.15204
>opendkim-genstats: constructing temporary table
>opendkim-genstats: populating temporary table
>opendkim-genstats: INSERT INTO TEMPORARY TABLE failed: The total
>number of locks exceeds the lock
>table size

You shouldn't have a lock problem with INNODB. What does "SHOW
ENGINE INNODB STATUS" show?

Regards,
-sm
Received on Mon Jun 11 2012 - 17:34:36 PST