MySQL Forums
Forum List  »  InnoDB

Re: Got error 139 from storage engine
Posted by: Mohammad Ashraful Anam
Date: August 06, 2007 04:18AM

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;

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). 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

Options: ReplyQuote


Subject
Views
Written By
Posted
15521
January 11, 2006 08:55AM
9313
January 12, 2006 01:13PM
15168
January 17, 2006 01:45AM
6746
January 17, 2006 06:19AM
Re: Got error 139 from storage engine
10179
August 06, 2007 04:18AM
10633
August 08, 2007 05:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.