CiviCRM Community Forums (archive)

There's a query run by an Activities Report which, when run by a user with restricted access, causes the MySQL server to lock up using all the CPU. It never stops until the server is restarted by root.

I was able to locate the offending SQL, and to isolate the 2 INNER JOIN ACL clauses that cause the problem. But I haven't got my head round quite how the ACL system works behind the scenes, specifically, how civicrm_acl_contact_cache is populated.

I've put the (commented) SQL at http://pastebin.com/KnUzQuvw

(I'm on MySQL 5.1.61, Debian Squeeze)

Any things I should check? The ACLs are not complex - basically one group of users is only allowed access to one particular contact sub-type. The Activities Report should just list activities related to the signed in user for the current month.

It's difficult to debug because the cache table is temporary/has changing content.

Thanks