I have text fields in a number of tables in ony of my databases on the cluster. I cannot get normal operation out of them. Follow the example below, this is a small table, with only 5 or so rows, which text fields;

This is the diagnose process I took, this surely is a problem. Since I can no longer select the text within the record without selecting only that column with the use of a primary key;

mysql> desc AdminMessage; +-------------+------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------+------+-----+---------------------+----------------+ | MessageID | int(11) | NO | PRI | NULL | auto_increment | | Body | text | NO | | | | | Status | tinyint(4) | NO | | 0 | | | MessageDate | datetime | NO | | 0000-00-00 00:00:00 | | +-------------+------------+------+-----+---------------------+----------------+ 4 rows in set (0.01 sec)

mysql> select MessageID, Status, MessageDate from AdminMessage; +-----------+--------+---------------------+ | MessageID | Status | MessageDate | +-----------+--------+---------------------+ | 1 | 2 | 2000-12-01 12:20:23 | | 2 | 2 | 2000-12-15 20:53:41 | | 4 | 2 | 2002-07-23 17:21:33 | | 3 | 2 | 2001-08-09 09:17:53 | | 5 | 2 | 2002-10-30 15:36:06 | +-----------+--------+---------------------+ 5 rows in set (0.01 sec)

mysql> select MessageID, Body, Status, MessageDate from AdminMessage; ERROR 1032 (HY000): Can't find record in 'AdminMessage'

mysql> show warnings; +-------+------+-------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------+ | Error | 1032 | Can't find record in 'AdminMessage' | | Error | 1105 | Unknown error | +-------+------+-------------------------------------+ 2 rows in set (0.00 sec)

select Body from AdminMessage where MessageID=4;

Works fine. I thought length might be an issue so on another copy of the data used length() to figure that out;

length( Body ) 163 998 903 381 1227

This is a problem as I cant use mysqldump on a few tables which I would like to.... Is this a bug!? or is this a configuration issue?

Adam