Solved

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

Posted on 2010-08-31
6
447 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
Comment Utility
That's 4.3GB of memory. Just how big is this table?
0
 

Author Comment

by:morten444
Comment Utility
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
Comment Utility
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:morten444
Comment Utility
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
Comment Utility
"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
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now