Solved

Mysql [localhost] Error 5: Out of memory (Needed 4278190063)

Posted on 2010-08-31
6
463 Views
Last Modified: 2012-05-10
Hi
I am running WAMP: PHP5.3, Mysql 5.1.36 and Apache 2.0.58
We had a server crash but managed to recover data from our virtual server

I have now created a new virtual server and are importing the databases again.
There where alot of corrupted tables etc, but fixed most of them with myisamchk

I have one fault left and that is in a Joomla table called jos_plugins.
When trying to run mysql repair it says:
the table jos_plugins (joomla) will not repair.
It says [localhost] Error 5: Out of memory (Needed 4278190063)

I read another question here and downgraded to PHP 5.1.6 but that did not do the difference
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/Apache/Q_24083017.html?sfQueryTermInfo=1+10+30+5+error+memori+mysql+out

Does anyone know what to do to clear this mysql error

0
Comment
Question by:morten444
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 34

Expert Comment

by:Beverley Portlock
ID: 33565294
That's 4.3GB of memory. Just how big is this table?
0
 

Author Comment

by:morten444
ID: 33565738
Hi
The file is very small

jos_plugin.frm   9KB
jos_plugin.MYD 3KB
jos_plugin.MYI   5KB

So it must be corrupt i guess. Any good way to try to repair it/replace it?

I am quite new to mysql so having problems reading very tech documentation :)


0
 
LVL 34

Expert Comment

by:Beverley Portlock
ID: 33565891
I would delete/rename the table and copy a fresh one from a similar joomla installation. You've nothing to lose because the current table doesn't work anyway. If it's corrupt beyond repair, then it is corrupt beyond repair.

I suspect I know the answer to the next question..... did you have a backup of this database?
0
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 

Author Comment

by:morten444
ID: 33566342
Hi
thanks for your answer
Yes I had a backup of it thats 1 month old. Tried to only copy over this 3 files but same result.
I was wondering if there where a mysql bug as i find it strange that old backup have same fault.

I will try to empty it and try again
You can now the page nearly recovered on http://new.plastikkirurgi-glostrup.dk/
The error at the top.. wonder if thats related as its in the plugin folder.

0
 
LVL 34

Accepted Solution

by:
Beverley Portlock earned 500 total points
ID: 33566802
"Yes I had a backup of it thats 1 month old. Tried to only copy over this 3 files but same result. I was wondering if there where a mysql bug as i find it strange that old backup have same fault."

That is strange. Are there a lot of indexes on this table? If so, note them down, delete them, add the data to the table then put the indexes back one at a time.

The other trick to try is to create a database with a new name and load the old backup into that and see if it all builds correctly.


What is on \joomla\plugin\helper.php on lines 54 and 95? The error "Trying to get property of non-object" means that the bit to the left of the -> has not been created correctly. So let us say that the line in question looks like this

$someObject->someProperty = 1234;

Then it would be the $someObject part that was wrong so trace it backwards until you come to where it was instantiated

$someObject = new ObjectClassOfSomeSort();

and then see where the class definition is kept. That will head you in the right general direction.
0
 

Author Closing Comment

by:morten444
ID: 33587991
Created new database
Copied the 3 files from new to old and it now works.
files only have list of plugins, so makde sure same template was installed in the new
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question