HI,

I' working with Drupal 7.23 in a new website (http://consensus-forecasts.com/d7), i have installed some contributes modules and a little part of my content and now i have a fatal error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 19564961 bytes) in /home2/consent0/public_html/d7/includes/database/database.inc on line 2168

How is possible if i don´t have all my real content yet, i just have the modules installed and i had change my old provider for the same problem thinking it was a bad service from them. I have memory_limit = 1000M

Can you tell me if now are problem with Drupal core or modules, please?

Modules installed:
Administration
Build a Module
Chaos tool suite
Charting
Context
Core
Data
Database
Date/Time
Development
Display Suite
Features
Feeds
Fields
Media
Migrate Examples
Multilingual - Internationalization
Other
Panels
Path breadcrumbs
Rules
SEO
Sharing
Statistics
Taxonomy
Ubercart - core
Ubercart - core (optional)
Ubercart - extra
Ubercart - fulfillment
Ubercart - payment
User interface
Views
Webform

Comments

John_B’s picture

I have seen this many times and in every case the error message meant what it said: that you do not have enough memory. Whether you have content is not the point because content will require memory allocated to mysql and data caching, whereas the problem here is that you have insufficient memory for executing php. Best open a ticket with Bluehost (if that is where the site is) or move to a Drupal specialist host.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

luis_mejia’s picture

Thanks for you replay, but i have memory_limit = 1000M in php.ini is this becouse i don´t understand the error here

luis_mejia’s picture

Thanks for your reply, now i will open a new ticket in bluehost, but i have
memory_limit = 1000M in php.ini
This is the reason because i don´t understand that error...

John_B’s picture

No point in putting a memory limit of 1G in php.ini, there is no way Bluehost will allow it, and even if they say they allow a 1G limit of which you can use part - not all - for php, (given that there are over 1300 sites on your IP address - I did look) there is no way the server will have enough memory to go round all those sites: for a 1G php limit to work on every site on that server you would need RAM in the region of 1.5TB RAM on each server, which is not realistic.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

Jaypan’s picture

Exactly. You may be setting your memory limit to 1000M, but that doesn't mean that your server is accepting that setting.

Create a file called phpinfo.php in your root, and add this code:

phpinfo();

Then access that file. You will be able to see your actual memory limit there.

pixelsweatshop’s picture

@Jaypan, just a heads up. Drupal already contains the phpinfo. A user can just go to the following URL to get the info. /admin/reports/status/php

Jaypan’s picture

Thanks for the info!

luis_mejia’s picture

Now i had talking to my bluehost support, until i had changed my "memory_limit = 1000M" in status report from drupal just display "php limit 128M", them i told to support and their fixed, now i can see 1000M in status report and my web is working again

rooby’s picture

Unless you have a ridiculously overpowered server setup (and even if you do) 1000M is extremely high for your php memory limit.

This means that if you have a few users who all end up using 1000M of memory at the same time you can easily use up all your memory and bad things will result.

You really should keep the memory limit at a sensible level and then fix any scripts that are using excess memory so that they do not.

If it is not possible to make the script use less memory then consider raising the memory limit for that page only or changing the website functionality so you don't need the script (if possible).

I am making assumptions on your server stats but the servers most people run would not cope well with a memory limit that high.

If bluehost didn't question you on why you want the limit that high I say that is bad form on their part.

zaid173’s picture

just instal the module " Role memory limit " and configure it 512 for admin. Send me email if it is works

SergFromSD’s picture

I ran in to this problem today, although in my case the message was being generated in /modules/field/field.multilingual.inc or /modules/field/field.info.inc. Turned out this only occurred when I was clicking on a taxonomy term with a '/' in the name. I replaced the '/' with a '-' and the problem went away. I hope this saves some of you out there some time if you come across this issue.

dibyadel’s picture

I changed the memory limit ..both in php.in and settings.php

d dutta

Justincletus’s picture

can you please explain to me how you setup/configured the memory limit error.

John_B’s picture

Googling returns the instructions for increasing the php limit. There are several methods, all of which are likely to work equally well on most servers, although on shared hosting obviously increasing the limit above any hard limit imposed by the hosting company will have no effect.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

dotmundo’s picture

You can override what is in php.ini by setting the memory in settings.php. This should be helpful:

https://www.drupal.org/node/207036