139 -
http://forums.mysql.com/read.php?22,404783 (Got error 139 from storage engine)
Your table is awfully bulky. Let's tackle that...
> `HOTEL_ID` varchar(10) NOT NULL DEFAULT '',
> DEFAULT CHARSET=utf8;
> HOTEL_ID IN('0000000010');
If a column is definitely ascii, use ascii or latin1, not utf8 for the column.
> `LANG_ID` varchar(2) NOT NULL DEFAULT '',
Aren't all LANG_IDs 2 chars? If so, use CHAR(2) (and ascii)
> `TEMP_TYPE_4` varchar(3) DEFAULT NULL,
> `PLAN_IMG5_CAPTION` varchar(100) DEFAULT NULL,
> `PLAN_PC_IMG5_CAPTION` varchar(150) DEFAULT NULL,
Don't spread "arrays" into multiple columns. Instead, have another table(s) for such info. That table would have (`HOTEL_ID`,`PLAN_ID`,`LANG_ID`) for JOINing. For plan captions, it would have up to 5 rows, and you could probably put both of these field in that one extra table. In that extra table they could be NOT NULL.
Use NOT NULL where appropriate.
You have _lots_ of TEXT fields. Suggest you "vertically partition" some of those into other tables. Consider, for example, moving all the MAIL related fields to a new `PLAN_MAIL` table.