Intermittent but consistent Memory Issue [#180438]

Devel reveals that my pages are using about 29+M at devel_shutdown.

Php and Drupal have 64M allocated.

Cache is disabled.

On occasion, I get a blank page - mostly on admin pages. Doesn't seem to matter which page, all are subject to the occasional blank page. Sometimes the page loads correctly, other times it loads blank. Every time I get the blank page, I get the exact same message in my server logs.

[Wed Oct 03 18:29:00 2007] [error] [client 76.999.999.61] PHP Fatal error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 517085 bytes) in /home/virtual/site100/fst/var/www/html/sfn/modules/views/views_cache.inc on line 146

The error is always views_cache.inc on line 146.

As I proceed, the blank pages become more frequent. Finally, all I can get are blank pages. When this happens, I have to manually go to phpMyAdmin and empty cache_content and cache_filter to get the pages working again.

I would be happy to provide any additional diagnostic information that may be desired. This is very a very stubborn problem that is screwing up my site and I would really appreciate any help you can provide.

Thanks in advance - jarea

Comments

Comment #1

jarea commented 3 October 2007 at 18:33

This issue is open with very similar circumstances, most notably at http://drupal.org/node/147583 which refers to views_cache.inc 144 rather than 146.

There, KarenS suggests:

My first guess is that the tables array is being created and cached and it is too large because you have lots of modules enabled. Or maybe it's the size of the default views being cached. Those are just guesses, though.

That would certainly be applicable in my instance, as I have 44 modules activated.

The code block referred to in the error message is as follows:

      $views_tables['tables'] = $table_data;

      foreach ($table_data as $name => $table) {
        if (is_array($table['filters'])) {
          foreach ($table['filters'] as $filter => $data) {
            $data['table'] = $name;
            // translate for deprecated APIs...
            if ($data['option'] && !is_array($data['option'])) {
              if ($data['option'] == 'string' || $data['option'] == 'integer') {
                $data['option'] = array('#type' => 'textfield', '#size' => 10, '#maxlength' => 255);
              }
              else {
                $data['option'] = array('#type' => 'select', '#options' => $data['option']);
              }
            }
            if ($data['list']) {
              $data['value'] = array('#type' => 'select', '#options' => $data['list'], '#validate' => array('views_filter_validate_array' => array($data['name'])));
              if ($data['list-type'] != 'select') {
                $data['value']['#multiple'] = TRUE;
              }
            }
            else if (!$data['value']) {
              $data['value'] = array('#type' => 'textfield', '#size' => 10, '#maxlength' => 255);
            }
            $views_tables['filters']['titles']["$name.$filter"] = $data['name'];
            $views_tables['filters']['base']["$name.$filter"] = $data;
          }
        }
        if (is_array($table['fields'])) {
          foreach ($table['fields'] as $field => $data) {
            if ($data['option'] && !is_array($data['option'])) {
              if ($data['option'] == 'string' || $data['option'] == 'integer') {
                $data['option'] = array('#type' => 'textfield', '#size' => 10, '#maxlength' => 255);
              }
              else {
                $data['option'] = array('#type' => 'select', '#options' => $data['option']);
              }
            }
            $data['table'] = $name;
            $views_tables['fields']['titles']["$name.$field"] = $data['name'];
            $views_tables['fields']['base']["$name.$field"] = $data;
          }
        }
        if (is_array($table['sorts'])) {
          foreach ($table['sorts'] as $field => $data) {
            $data['table'] = $name;
            if ($data['option'] && !is_array($data['option'])) {
              if ($data['option'] == 'string' || $data['option'] == 'integer') {
                $data['option'] = array('#type' => 'textfield', '#size' => 10, '#maxlength' => 255);
              }
              else {
                $data['option'] = array('#type' => 'select', '#options' => $data['option']);
              }
            }
            $views_tables['sorts']['titles']["$name.$field"] = $data['name'];
            $views_tables['sorts']['base']["$name.$field"] = $data;
          }
        }
      }
      cache_set("views_tables:$locale", 'cache_views', serialize($views_tables));                     <---- Line 146
    }
  }
  return ($full ? $views_tables : $views_tables['tables']);
}

The problem, like KarenS' guess seems to point to something going wrong while setting the cache.