Non Admin users - Error Query Limit 1000 - Database 100% CPU Usage


with SuiteCRM latest version, fresh install, I’m using “users Role” to assign users rights.

But when a “non-admin” users performs some task (i.e. new Lead or Opportunity) often DB server CPU goes 100% and after few seconds on sugarcrm.log we get [ERROR]: Query Limit 1000 reached for xxxx module.

If I switch same user to admin, all works fine, but I can’t restrict access applying ACL.

Any Idea?

Try increasing the query limit. You can increase the Query limit in the config.php file, line 366.