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.
783
November 29, 2018 08:54AM


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.