Bug #44402 Not enough memory for blob at 23640916 (need 2054662725)

• Submitted: 22 Apr 2009 9:00
• Modified: 29 Apr 2009 10:08
• Reporter: chaitanya yanamadala
• Status: Can't repeat
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.0.51b
• OS: Windows (2003)
• CPU Architecture: Any
• Tags: Not enough memory

[22 Apr 2009 9:00] chaitanya yanamadala

Description:
hi 
 when i am running a repair option for a table it is giving the following error and saying unable to repair the table.
Can anyone explain me why i am getting this error.

Thanks in advance

How to repeat:
when using repair option in that with the extended and the use frm options being enabled

[22 Apr 2009 9:09] Valeriy Kravchuk

Please, send the results of SHOW CREATE TABLE and SHOW TABLE STATUS for the table used. How much RAM do you have? Send your my.ini file also. What exact version of MySQL server do you use?

[22 Apr 2009 9:25] chaitanya yanamadala

the version of mysql is 5.0.51b and the tables were created long back so i dont have the results up now with me...

the tables were fine running up all this time but today suddenly it got crashed when i repaired some other tables which are not all corresponded to that table

[29 Apr 2009 9:55] Sveta Smirnova

Thank you for the feedback.

It is not needed to know how table created: just run statement SHOW CREATE TABLE table_name and SHOW TABLE STATUS LIKE 'table_name'. Also did you run mysql_upgrade on this table?

[29 Apr 2009 10:01] chaitanya yanamadala

the problem was resolved it was due to the version incompatibility.Thank you for all the replies...
Kindly close this bug as resolved

[29 Apr 2009 10:08] Sveta Smirnova

Thank you for the feedback.

Closed as "Can't repeat"

[11 Mar 2010 9:50] roberto ongkiko

i also had the same problem..i havent upgraded my mysql version
my table crashed..is there a way to fix this?

here is the error.

Not enough memory for blob at 1101665348 (need 1074263676)