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.
Subject
Views
Written By
Posted
mysql 5.6.30 - InnoDB: Warning: using a partial-field key prefix in search.
1226
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.