[rt-devel] Too many tables; MySQL can only use 61 tables in a join
jfearn at redhat.com
Mon Nov 19 18:34:20 EST 2012
On 11/20/2012 12:21 AM, Henti Smith wrote:
> Good day all.
> I did a RT upgrade from 3.8.4 to 4.0.7 over the weekend.
> We did a POC to make sure everything works, and all seemed fine. No
> problems we could see. After the upgrade we see this error.
> Nov 19 12:13:44 violator RT: DBD::mysql::st execute failed: Too many
> tables; MySQL can only use 61 tables in a join at
> /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line
> 587. (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm:587)
> Attached is an example from the rt.log file.
> Any help would be appreciated.
DBIx::SearchBuilder has an interesting way of caculating joins that can
negatively affect MySQL. Sounds like you've hit the same feature in
DBIx::SearchBuilder as leads to this  bug.
The patch on that bug might be worth a shot ... on a test instance of
More information about the rt-devel