"out of memory" errors every day
Hi,
I'm getting "out of memory" errors on my site almost every day. I've tried optimizing the cache tables, clearing the cache and even disabling the cache. The errors keep coming. Currently the error message is...
user warning: Out of memory (Needed 2092896 bytes) query: SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 9 ORDER BY r.weight, f.fid in /nfs/c03/h01/mnt/47382/domains/powervote.org/html/modules/upload/upload.module on line 566.
The PHP memory limit for this site is 99M.
There is a custom module on the site that was written by my predecessor. I don't know if it is the culprit. I'm not even sure why it was written in the first place, but I can't disable it because it seems to have a role in providing the output for all the content types as well as handling of various forms.
The web host says they can find no problem on their end.
-Ryan
mine just started today as
mine just started today as well... not sure whats going on...
Out of memory errors
I too just started getting similar errors today. I have a 5.10 install with Ubercart, and started by receiving the following error:
Out of memory (Needed 2091016 bytes) query: SELECT DISTINCT nid FROM node WHERE type = 'donation' in /nfs/c03/h01/mnt/49585/domains/omahavna.com/html/includes/database.mysql.inc on line 172.
I thought the culprit might be the Ubercart Donation Products module, so I disabled it. I then started getting the following error upon every cron run:
Out of memory (Needed 2091024 bytes) query: SELECT GREATEST(COALESCE(c.last_comment_timestamp, 0), n.changed) as last_change, n.nid FROM node n LEFT JOIN node_comment_statistics c ON n.nid = c.nid WHERE n.status = 1 AND ((GREATEST(n.changed, COALESCE(c.last_comment_timestamp, 0)) = 0 AND n.nid > 0) OR (n.changed > 0 OR c.last_comment_timestamp > 0)) ORDER BY GREATEST(n.changed, c.last_comment_timestamp) ASC, n.nid ASC LIMIT 0, 100 in /nfs/c03/h01/mnt/49585/domains/omahavna.com/html/includes/database.mysql.inc on line 172.
This has killed the site's search functionality, as it can't index the content, and my user accounts have vanished from the "List users" screen.
I can't figure out the problem. I have a 99M memory limit with my host (Media Temple Grid Service), and have tried upping the memory limit to 256M...which doesn't help.
I'm stumped.
**Follow Up** I just upgraded to Drupal 5.11, but it did help fix the issues.
also on MT - but not seeing this with d6.4
haven't done the 6.5 release that came out today, but i was getting some errors earlier this week - actually getting white screens when doing admin tasks - called MT and they advised me to reset the php.ini back to 99M (had it at 128) - but i'm not sure that's the problem...sounds similar, somehow related...
so at any rate, i used their nifty sql tools, ran the slow queries log, repaired the tables and all of that - but there really were no screwy long queries and nothing else seemed unusual, and i'm not using ubercart, just stuff like views, cck, og and so on...
i have read some stuff about modules not using inner join and in turn burdening the servers and tables on lookups...but i'm not a programmer and have no idea how to dig into modules to see what might be a culprit, and not so sure that it's even a module!
........................................................................
i love to waste time: http://twitter.com/passingnotes
Funny, I'm running into
Funny, I'm running into these problems on Media Temple too. They insist it's not on their end.
ahhh, three of us! now we can point them to a thread!
i think we should all log in over the next couple of days and submit the same issue AND all point to this specific thread!!!
title: drupal memory issues
summary
link to this thread:
........................................................................
i love to waste time: http://twitter.com/passingnotes
I'm having this problem too...
And I'm on Media Temple too. Has anyone figured out what's going on?
sounds like it's time for a support request to MT!!
i'm going to submit this issue though i have NOT seen it in a little while (on grid)
are you fellow MT users on the grid server shared thing?
........................................................................
i love to waste time: http://twitter.com/passingnotes