List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 2 2001 9:10pm
Subject:Re: [Got error 139 from table handler using InnoDB]
View as plain text  
In the last episode (Aug 02), bmpittma@stripped said:
> I'm new to the list so please forgive me if this problem has already
> been solved.
> 
> I've been using MySQL for development for sometime. Up until now I've
> been using MyISAM tables. I've decided to switch to InnoDB because
> some table files (*.MYD) are approaching the OS limit.

You can use the special RAID table type to overcome that.
 
> I get the above error (139) when trying to enter a moderately sized
> (~ 23k) into a text column. This error also occurs on sparc running
> Solaris 2.5.

InnodDB currently has an ~8k size limit on rows.

> Has anyone else experienced this? Is there a workaround?

It will be fixed eventually, but for now you might have to put your
TEXT fields in a separate MYISAM table.

-- 
	Dan Nelson
	dnelson@stripped
Thread
[Got error 139 from table handler using InnoDB]bmpittma2 Aug
  • Re: [Got error 139 from table handler using InnoDB]Dan Nelson2 Aug
Re: [Got error 139 from table handler using InnoDB]Heikki Tuuri2 Aug
  • Re: [Got error 139 from table handler using InnoDB]Brian Pittman3 Aug
  • Re: [Got error 139 from table handler using InnoDB]Brian3 Aug