Bug #55541 ERROR 1030 (HY000): Got error 139 from storage engine

• Submitted: 26 Jul 2010 1:10
• Modified: 28 Feb 2012 9:30
• Reporter: Roel Van de Paar
• Status: Can't repeat
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.1.49
• OS: Any
• Assigned to: Kevin Lewis
• CPU Architecture: Any

[26 Jul 2010 1:10] Roel Van de Paar

Description:
Run attached sql file. Result on built-in InnoDB:

mysql> source /randgen/4.txt
ERROR 1030 (HY000): Got error 139 from storage engine

Result on InnoDB plugin (one that comes with 5.1.49):

mysql> source /randgen/4.txt
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs

How to repeat:
Load attached source sql file.

Suggested fix:
o Check why error is different/happening.
o Improve error message for built-in InnoDB.

[26 Jul 2010 1:49] Roel Van de Paar

ftp://ftp.mysql.com/pub/mysql/upload/bug55541.zip

[1 Nov 2010 8:46] Roel Van de Paar

I can repeat this error using RQG, but seems the testcase above doesn't fail anymore on my system. Possibly related to settings in my.cnf. Need to do some more testing.