MySQL Forums
Forum List  »  InnoDB

mysql 5.6.30 - InnoDB: Warning: using a partial-field key prefix in search.
Posted by: Yosif Peev
Date: November 29, 2018 08:54AM

Hello, in my mysql-error.log have following error:

2018-11-29 15:51:43 7f8da7fff700 InnoDB: Warning: using a partial-field key prefix in search.
InnoDB: index `index_project_authorizations_on_project_id` of table `gitlabhq_production`.`project_authorizations`. Last data field length 6 bytes,
InnoDB: key ptr now exceeds key end by 2 bytes.
InnoDB: Key value in the MySQL format:
len 8; hex fe030000a3000000; asc ;
2018-11-29 15:51:43 7f8da7fff700 InnoDB: Warning: using a partial-field key prefix in search.
InnoDB: index `index_project_authorizations_on_project_id` of table `gitlabhq_production`.`project_authorizations`. Last data field length 6 bytes,
InnoDB: key ptr now exceeds key end by 2 bytes.
InnoDB: Key value in the MySQL format:
len 8; hex fe030000a3000000; asc ;

Any idea how to fix that.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql 5.6.30 - InnoDB: Warning: using a partial-field key prefix in search.
43
November 29, 2018 08:54AM


Sorry, only registered users may post in this forum.

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.