[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2010-08-31
6
Medium Priority
?
479 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
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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 1500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses
Course of the Month18 days, 13 hours left to enroll

834 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