MySQL Forums
Forum List  »  InnoDB

"Warning: using a partial-field key prefix in search."
Posted by: Richard Harms
Date: May 10, 2005 01:35PM

When doing some testing with 5.0.4-beta, I'm ending up with thousands of messages like:

050510 13:40:19 InnoDB: Warning: using a partial-field key prefix in search.
InnoDB: index `sequencedetails_index4_idx` of table `darkrealms/sequencedetails`. Last data field length 8 bytes,
InnoDB: key ptr now exceeds key end by 4 bytes.
InnoDB: Key value in the MySQL format:
len 16; hex 0c00000000000000010000009a999999; asc ;

...across all tables, in the server's error log. Is this a bug, or is there something I need to change to prevent these from occuring? It seems like it is only in tables that have varchar columns, using the utf8 character set.

-rh

Options: ReplyQuote


Subject
Views
Written By
Posted
"Warning: using a partial-field key prefix in search."
3098
May 10, 2005 01:35PM


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.