Got Error 139 From Storage
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about barracuda format hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Innodb Row Size Too LargeAsk Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. mysql got error 139 from storage engine Join them; it only takes a minute: Sign up Increasing MySql Innodb Row length to avoid Error 139 up vote 1 down vote favorite I'm creating a table in MySql (Innodb engine) with more than 15 TEXT datatype columns.
Mysql Max Row SizeAfter table creation, I'm trying to insert a row in to this table with more than 500 characters in all the columns. While doing so, mysql returns the following error, [Error Code: 1030, SQL State: HY000] Got error 139 from storage engine Upon searching, I found that there is a row length limitation of 8000 bytes in mysql. I wanted to know if this limit can be configured (by a parameter or even compiling the code) to the mysql row size too large desired level. I see some links talking about innodb plugin where this is resolved but I couldn't get a clear idea on that. I'm trying this in windows. Any help on this is greatly appreciated. Thanks, Ashok. mysql innodb mysql-error-1030 share|improve this question edited Sep 4 '13 at 15:36 Will 96.2k41233337 asked Jan 14 '11 at 7:18 Ashok 612 Can you show your CREATE TABLE statement? –Riedsio Jan 14 '11 at 13:20 The create query is , CREATE TABLE testtext ( ID INTEGER , TEXT1 TEXT, TEXT2 TEXT, TEXT3 TEXT, TEXT4 TEXT, TEXT5 TEXT, TEXT6 TEXT, TEXT7 TEXT, TEXT8 TEXT, TEXT9 TEXT, TEXT10 TEXT, TEXT11 TEXT, TEXT12 TEXT, TEXT13 TEXT, TEXT14 TEXT, TEXT15 TEXT, TEXT16 TEXT, TEXT17 TEXT, TEXT18 TEXT, TEXT19 TEXT, TEXT20 TEXT, TEXT21 TEXT, PRIMARY KEY (ID) ) Engine=InnoDB; I had also tried using the ROW_FORMAT to set it as DYNAMIC. But that doesn't help either.. the table status still shows the table is in Compact format. –Ashok Jan 17 '11 at 7:13 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote It looks like there are multiple possible solutions to this type of problem. I found this link provided both good information and some good tangible options: http://www.mysqlperformanceblog.com/2011/04/07/innodb-row-size-limitation/. However, if you know from the outset that you are going to be creating a structure like this, you should re-think you
Cluster and HA SupportTokuMX SupportMongoDB SupportContact SupportPercona Emergency SupportSupport PoliciesSupport TiersRead MoreConsultingPerformance OptimizationInfrastructure
Row Size Too Large (> 8126)Architecture and DesignHigh AvailabilityUpgrades & MigrationsServer & Database AutomationConsulting PoliciesRead
Innodb_file_format=barracudaMorePercona Care Software MySQL Database SoftwarePercona ServerPercona XtraDB ClusterPercona XtraBackupPercona TokuDBMySQL Software DocumentationSoftware RepositoriesRead MoreMongoDB Database mysql row limit SoftwarePercona Server for MongoDBMongoDB Software DocumentationPercona TokuMXRead MoreOpen Source Database ToolsPercona Monitoring and ManagementPercona ToolkitPercona Monitoring PluginsDatabase Tools DocumentationRead MoreDocumentation LibraryFind all the documentation you http://stackoverflow.com/questions/4688786/increasing-mysql-innodb-row-length-to-avoid-error-139 need to set up and manage all our products.Read MoreDownloadsRead More Solutions BuildHighly Scalable Data InfrastructureHighly Available Data InfrastructureData Infrastructure AutomationCloud Data StorageDatabase and Infrastructure Architecture and DesignRead MoreFixPerformance Audit, Tuning and OptimizationServer Audit and StabilizationDatabase Server Outage Restoration24 x 7 ExpertiseData RecoveryRead MoreOptimizeDatabase MonitoringApplication and Server Performance OptimizationInfrastructure Review https://www.percona.com/blog/2011/04/07/innodb-row-size-limitation/ and Design ServicesExpertise On DemandRead MoreManageRemote Managed ServicesProject Management and AdvisorsTrusted Data AdvisorsDatabase BackupRead More Community Data Performance BlogRead from leading data performance experts in Percona's Official blog.Read MoreEventsView all the information about upcoming events and shows where we can meet up!Read MoreForumsAsk Percona database experts for performance help now in our support forums!Read MoreLet's Get SocialTwitterLinkedInGoogle GroupsFacebookRead MoreMySQL 101 Sessions Resources WebinarsPercona offers free webinars about MySQL®, MongoDB®, OpenStack, NoSQL, Percona Toolkit, DBA best practices and more.Read MoreEbooksImportant literature for getting specialized on database management and administration.Read MoreTechnical PresentationsBrowse our library of nearly 300 technical presentations from webinars and events.Read MoreVideosAll the information you need in videos for easy understandingRead MoreWhite PapersInformation including in-depth analyses and recommendations, benchmarking tests and best practice recommendations.Read More About Percona About PerconaTeamCustomersPartnersContact UsCase StudiesCareersRead MoreNewsroomIn The NewsPress ReleasesAwards and Industry RecognitionNewslettersRead More Percona Database Performance Blog Innodb row size limitation Fernando Ipar |
Status: Closed Impact on me: None Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious) Version:5.0.45 OS:Any (Linux, Windows) Assigned to: Heikki Tuuri Tags: error 139, innodb View Add Comment Files Developer Edit Submission View Progress Log Contributions [8 Aug 2007 8:11] Mohammad Ashraful Anam Description: 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 8000 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+CjqUWElzgnoUNDWOyqU