If I try to do the following query:

'select * from node_revisions where body LIKE "%http%"'

I get the following error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 5120188 bytes) in /includes/form.inc on line 577

On a second server, I get a blank page. Searching for other terms seems to work, but anything like "http", including "http://" and "http:" all fail.

Comments

nig’s picture

nig commented

I get similar. For me its, "Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 11152622 bytes) in /home/healhead/public_html/modules/dba/dba.module on line 263"

It is causing cron.php to not complete.

Any ideas?

Ng

greggles’s picture

greggles
he/him
Primary language English
Location Denver, Colorado, USA
commented
Status: Active » Closed (fixed)

Your queries are very "expensive" in server resources and are exhausting (using) all of the memory that php has allocated to your process.

The only two solution that I know is to limit your query somehow like using "limit 10" or another where condition OR allocating more memory to your php processes (which you may or may not be able to do - see http://drupal.org/node/76156 for more details on changing this value).