ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

MySQLError Number 5, Out of memory

February 24, 2009 12:09pm

Subscribe [6]
  • #1 / Feb 24, 2009 12:09pm

    adamrobo

    9 posts

    Hi everyone,

    I’m getting the following error while trying to login to the admin area of EE:

    MySQL ERROR:

    Error Number: 5

    Description: Out of memory (Needed 2091136 bytes)

    Query: SELECT exp_weblog_titles.weblog_id, exp_weblog_titles.author_id, exp_weblog_titles.entry_id, exp_weblog_titles.title, exp_weblog_titles.comment_total, exp_weblog_titles.trackback_total FROM exp_weblog_titles, exp_weblogs WHERE exp_weblogs.weblog_id = exp_weblog_titles.weblog_id AND is_user_blog = ‘n’ AND exp_weblog_titles.site_id = ‘1’ ORDER BY entry_date desc LIMIT 10

    The site is hosted on MediaTemple grid server.

    The front end of the site is still up and working.

    I really don’t have any idea how to fix this problem. Any help would be greatly appreciated.

    Thanks!

  • #2 / Feb 24, 2009 12:35pm

    Lisa Wess

    20502 posts

    This looks like one for MediaTemple to me.  I’d ask them what is going on. =)

  • #3 / Feb 24, 2009 12:51pm

    adamrobo

    9 posts

    Ok, I thought that might be your answer. 😉

    Thanks.

  • #4 / Feb 24, 2009 3:42pm

    Ingmar

    29245 posts

    Let us know what they say 😊

  • #5 / Mar 08, 2009 5:26pm

    Eric Snyder

    202 posts

    Hey folks. I’m having the same problem with MT also Grid server. Clearly it is a MT problem. I am sure they will get it fixed eventually.

    My question. I always feel exposed when the backend starts spewing this kind of detail. Is there any why that when this happens it could be replaced with a more general error message rather than the query?

  • #6 / Mar 08, 2009 5:52pm

    Eric Snyder

    202 posts

    BTW adamrobo…what did the problem end up being? I have checked my tables for errors and there were none.

  • #7 / Mar 08, 2009 8:58pm

    Sue Crocker

    26054 posts

    Eric, there have been some issues in the past few days with some MT servers, but not sure if you were effected.

    The error messages you are seeing can be set to only display to SuperUsers at:

    Admin ›  System Preferences ›  Output and Debugging Preferences

    Debug Preference
    Enables the display of error messages, which are valuable during site development

  • #8 / Mar 09, 2009 9:38am

    Eric Snyder

    202 posts

    Thanks Sue…

    Yes they are. Here is a link to an article they just posted:

    http://weblog.mediatemple.net/weblog/2009/03/06/anatomy-of-storage-on-the-grid/

    The Grid has been nothing but expensive trouble from my perspective but most new technologies have problems when they first roll out.

    I have been looking for a while for a better hosting solution. I just placed a new site in a Expression Engine hosted account. So far…HATE the control panel. You can do very little yourself. We’ll see how stable and fast it is. I doubt I will use it going forward because submitting changes as simple as a new email address to a service tech in the backend somewhere and waiting for them to set it up is major bush league. It’s like we are hosted out of Expression Engines Media Temple account or something!

  • #9 / Mar 09, 2009 10:47am

    Nevin Lyne

    370 posts

    Eric,

    At least from the e-mail side that is only a legacy option, once you request the first email address(es) setup you will gain self-administration over your own email.  As not all users use web hosting account emails now (ie: Google Apps, in-house mail servers, etc.) in many cases clients want to simply have their MX records pointed elsewhere, OR, are simply pointing their A records for their web site to our servers.

    There have been a number of threads I have posted to in these forums about how/why our services are a little different.  Some people hate our model, many others love it.  MediaTemple put great effort into their pretty hosting control panel up front, and you have seen the results of the back-end infrastructure they put in place, this is needed if you are pushing to a bulk hosting market.  We have taken the opposite approach, we have focused on the back-end infrastructure, less interest in the eye-candy, more interested in supplying our client base with a stable platform to work from.  This is likely one of the reasons we have an ever increasing amount of enterprise, government, higher education institutions, and well as not only web developers using ExpressionEngine for their clients, but other popular CMS/blogging systems moving to our services. 

    While I would love to please the needs of 100% of the people that use our services, the reality is no product or service can provide a 100% satisfaction rating for 100% of the population.

    So far this year though we have rolled out a number of new changes and services, and working with a number of developer and partners on everything from a refresh of our web site that is coming soon, to a staged roll-out of a smoother, more advanced controls for clients looking for self-administration. Part of this has been on hold until EE 2.0 is released, and our own development group at EngineHosting can better focus on the development of features we directly hear our hosting clients would most like to see.

    Thank you for your thoughts on this subject, we do take notice.

  • #10 / Mar 09, 2009 12:49pm

    Sue Crocker

    26054 posts

    Nevin, thanks for the assist.

    Eric, have we answered the technical questions you had?

  • #11 / Mar 09, 2009 8:09pm

    Eric Snyder

    202 posts

    Sue:

    As always, you guys have done an awesome job answering my questions. I am still hoping to hear from adamrobo on what was wrong at Media Temple when they had their problem.

  • #12 / Mar 10, 2009 4:55am

    John Henry Donovan

    12339 posts

    Eric,

    Glad you are now sorted. This thread has been pretty informative. Feel free to ask post again if you have any more questions

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases