Fatal error: Allowed memory size of 16777216 bytes exhausted

Paradise-Bodies - February 11, 2008 - 07:35

Everytime i install a new module i get this:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 138333 bytes) in /webroot/vhosts/paradise-bodies.com/docs/drupal/modules/views/views_cache.inc on line 146

or this:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 185966 bytes) in /webroot/vhosts/xxx/docs/drupal/includes/database.inc on line 159

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'sessions' was not locked with LOCK TABLES\nquery: SELECT sid FROM sessions WHERE sid = '2ea56ecd358c1ef728d1a1c64041c63e' in /webroot/vhosts/paradise-bodies.com/docs/drupal/includes/database.mysqli.inc on line 151.', 2, '', 'http://www.paradise-bodies.com/drupal/admin/build/modules/list/confirm', 'http://www.xxx.com/drupal/admin/build/modules', '87.167.115.207', 1202714659) in /webroot/vhosts/paradise-bodies.com/docs/drupal/includes/database.mysqli.inc on line 151

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'sessions' was not locked with LOCK TABLES\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('2ea56ecd358c1ef728d1a1c64041c63e', 1, 0, '87.167.115.207', 'form|a:37:{s:32:\\"33b01945ae647be72f4c8ec7d2852810\\";a:2:{s:9:\\"timestamp\\";i:1202654196;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\"8688b8382f9f8ec4504e163f77d00bf0\\";a:2:{s:9:\\"timestamp\\";i:1202654229;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}s:32:\\"dc9f513b7bf8aae10ccdfe in /webroot/vhosts/xxx/docs/drupal/includes/database.mysqli.inc on line 151

a couple of things

tm - February 11, 2008 - 07:46

not sure, but you may want to:
- verify that your db user has the 'lock tables' right
- bump your php memory_limit higher than 16mb; 24mb seems to be good for a modest site with a pile of modules enabled. may want to check, but that limit could also affect uploads.

good luck!

Ok, 32MB in my php.ini and

Paradise-Bodies - February 11, 2008 - 09:18

Ok, 32MB in my php.ini and everything is ok.

Thanks. I think i have to post here. In the german forum i have to wait sometimes days untill i get an answer.

________________
To The Extreme

memory_limit

suketu.topiwala - February 11, 2008 - 10:02

Increase you memory_limit in php.ini files to 32 MB
if your host now allowed you to change the php.ini files then
open your settings.php in sites/default folder

make ini_set("memory_limit","32M");

this will solve your problem

Demarlos Solutions
www.demarlos.com

I got an error when I used

benlotter - June 5, 2009 - 15:25

I got an error when I used the command above but when I removed the "make" it worked fine. So in my settings.php I added this line:
ini_set('memory_limit','64M');

    Yeah, my limit was already at 32M in php.ini and I can't change that since I'm on shared hosting, so I had to change it to 64M in the setting.php file. Here is what I know.
  1. You can find out what your memory limit is set at by following the directions at http://www.geeklog.net/faqman/index.php?op=view&t=53 which basically say to run this command on your website.
    <?php phpinfo(); ?>
    It spits out all kinds of information including your memory limit setting.
  2. I really don't know how I hit the 32M limit so fast. Perhaps just having a module installed but not enabled chews up the memory. If that's the case another fix for me would have been to unistall modules I was just trying out but am not actually using.
 
 

Drupal is a registered trademark of Dries Buytaert.