CiviCRM Community Forums (archive)

Hi,

On one install, we have the site that goes down every couple of days with a mysql request eating all the cpu.

This is a 30 lines SELECT that, we assume, is generated either from an advanced search or a report.

We have asked the users and no one seems to be aware of them being the one triggering that query.

To help find the root of the problem, I've modified the queries to add the user name and ip address, so next time it goes crazy we'll know where to search.

on CRM/Core/DAO.php modify the query function
  function query($query, $i18nRewrite = TRUE) {
    // rewrite queries that should use $dbLocale-based views for multi-language installs
    global $dbLocale;
    if ($i18nRewrite and $dbLocale) {
      $query = CRM_Core_I18n_Schema::rewriteQuery($query);
    }

global $user;//XAVIER DEBUG
$debug = "WHERE ( 'user ".$user->name ."' = 'ip " .$_SERVER['REMOTE_ADDR']."' ) OR ";
$query = str_replace ("WHERE ",$debug,$query);

    return parent::query($query);
  }


So it adds in the query an OR name = ip criteria, that is obviously always OR false, so no impact on the query itself, but allows to see who has generated this query.

I'll amend once I found what is generating the query