Im not sure what started this. Last time I worked at the site, I was setting up flashvideo module and swftools module, everything worked just great yesterday. Now, today, when the users of the site started creating nodes (ubercart productnodes) they started getting errors. Now I cant get into one single page when logged in without having the page filled with errors, and I have no clue where to start. I have had bigger drupal installations at same webhotel before with no problem.

My webhotel has:
MySQL-databas 5.0.51a
PHP 5.2.6
PHP: memory limit 250M

I have cleared all cash tables as and tried to inactivate most of the modules at the site, but error is still there.

When not logged in there is no errors. But when logged in as superadmin or admin I get this on every page I visit at the site:

Warning: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:925593:\"Out of memory (Needed 633480 bytes)\nquery: UPDATE cache_menu SET data = 'a:569:{s:4:\\"node\\";a:26:{s:5:\\"title\\";s:7:\\"Content\\";s:13:\\"page callback\\";s:17:\\"node_page_default\\";s:16:\\"access arguments\\";a:1:{i:0;s:14:\\"access content\\";}s:4:\\"type\\";i:4;s:6:\\"module\\";s:4:\\"node\\";s:14:\\"load_fu in /home/idrottsm/public_html/kajak/includes/database.mysqli.inc on line 128

warning: mysqli_query() [function.mysqli-query]: (HY000/5): Out of memory (Needed 1048548 bytes) in /home/idrottsm/public_html/kajak/includes/database.mysqli.inc on line 108.

The error that I get for example at the modules list pages is similar, but 1000's of more error. Please if someone got any clue where to look or what to do to sort this out, spent weeks setting up this site.

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Your MySQL server is out of memory. You'll need to contact your webhost see if MySQL can be restarted or the memory limit increased.

kjpil’s picture

kjpil commented

Thank you Dave, I emailed my webhotel.
They says that there is no problem with the server. I think there is something wrong with the installation.

I think they did increase the memory limit, and now there is no error messages. But I belive the error is still there, the site is running slow.

I tried to do the cronjob, but it could not go. Then checked the log in drupal, and it says that cronjob is running, and another errormessage says cronjob been running for more than one hour without finishing. Is there anyway I could stop this cronjob if it "hanged" or something?

I did update all my modules to latetst. Disabled update status module cause I found a thread about problems with thatone.
Now I found another thread about cash menu, that it can send many packages. Should I try to do that?

Or have any other idea?

kjpil’s picture

kjpil commented

Scheduled tasks still running in the system, more then 24 hours now is that normal?
The errors is gone, but I cant start up cronjob cause it seams to be constantly running, and I havent set up any scheduled cronjobs.

kjpil’s picture

kjpil commented
Status: Active » Closed (duplicate)

Duplicate thread. Sorry about that
http://drupal.org/node/143519