Solved

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

Posted on 2010-08-31
6
454 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Creating and Managing Databases with phpMyAdmin in cPanel.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

785 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