[SOLVED] Error 139 from storage engine

[anam]

Hi. I am using MySQL 5.0.45 on Windows XP.

 

Here is my data structure

 

CREATE TABLE `bioinfo` (

`pin` varchar(17) NOT NULL default '',

`photo` longblob,

`photo_original` longblob,

`photostatus` tinyint(1) NOT NULL default '0',

`signature` longblob,

`signaturestatus` tinyint(1) NOT NULL default '0',

`lfingert` longblob,

`lfingerstatust` tinyint(1) NOT NULL default '0',

`lfingeri` longblob,

`lfingerstatusi` tinyint(1) NOT NULL default '0',

`rfingeri` longblob,

`rfingerstatusi` tinyint(1) NOT NULL default '0',

`rfingert` longblob,

`rfingerstatust` tinyint(1) NOT NULL default '0',

`lfingertemplatet` blob,

`lfingertemplatei` blob,

`rfingertemplatet` blob,

`rfingertemplatei` blob,

`lfingerbarcodeitext` longtext NOT NULL,

PRIMARY KEY (`pin`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

 

I have a row with pin='19442695047100023' and about 22K each in the 7 longblob fields and around 450bytes in 4 blob fields.

 

As you can see almost all fields are blobs and there should not be any restriction on any size limit of 768 (or something like that) for INNODB. But when I try the following query it give 139 error:

 

UPDATE bioinfo SET lfingerbarcodeitext='TkZSI+QCFvQBJgL0AfQBAAD/YwABAAb/dAZxYqATBGD4dUAPCF8GeeAWDlh6mQAXDVnknWAFIFhazSAIH1jfIoEFDFhaPSEJFGROSeEJGGPoVkELcWHQ5eEDE16oBkItHVvfJsIFClguLqItEV/ydYIMCVZ0jWINCFMslkIqGFssquInHmIQviIgC1fs2SIPBVGq3QIsFF8h8SIsF1+u/eIpFWWpBoMvI2ZrCiMPB1D6RaMUDF8eRkMqCWDtSmMLBU93ykMUBlrwzgMGElugzsMnA1Ny/YMHCl8t/mMpEFkcCqQiB1TxDsQJB2MwNiQvC2mxRmQtDW+eZuQlBli0gkQxFV7yjuQQClFQzoQIBln/0sQRDVy91mQwHmpm2qQOIVZl3sQMQlvh4qQKJF848UQtEGdI9gQDDFWn9gQqB25QCkUKBWevEWUsCmswPQUiEGm+SaUwDm8uVgUkDWihaQUgC2klekUeBl+CjqUWElzgnoUNDWOyqUUjDWspsmUmEWaztqUvF2tZvYUOD2TRyaUFCW4nyqUgB2WsycUiE2ms4WUuCWcv5iUqB3E48YUlEGfT9sUGCGnoBkYQGmK+FYYkDGJSImYGCWmwIaYhBGeqLsYoBmenMQYfBmdgNmYSEVUoOkYgAmlXagYDCGklauYuB1nUbeYGCmircmYnA1qxeoYqCF3TfQYOBWPWlmYEBGpWnoYMBGOlvgYmCWCp6uYgA2Qn6gYnCGasAUcjBWUoBockA2TbGscJDGBBGucVImTZRecPBmCoVmcpAmBdWucKFF9ZZscUG2AkeQcYJFikfmcnBWOjgeccEFSnlscfCl3TnWcNEF/anQcRCF0asgcdDFVftgcPClvdzscEAmTnzgcWH1zg0mcHBmLb2ocBCWZf5WcJBmXpAugRD2CfBqgkCVSYDogcC1onGoghFFU2TqgfDmJeXkgNDVvjZggGC2QAAAAABAEHAKgnF////wAEAAA=' WHERE pin='19442695047100023'

 

MySQL said:

#1030 - Got error 139 from storage engine

 

Can anyone help?

[AndyB]

http://bugs.mysql.com/bug.php?id=10035

[anam]

Thanks a lot for pointing me to that direction. But if you notice my table structure, you will see that I have only 1 varchar and 1 text column and their total combined size is less than 2000 bytes which is well below the 8000 byte limit.

[anam]

My problem has been accepted as a new bug in the mysql bug tracker.

 

http://bugs.mysql.com/bug.php?id=30295