Hi Team,
Seems there is an improper index defination in Search addon :
CREATE INDEX IDX_SEARCH_IDXNG_QUEUE_E_NAME ON rs.SEARCH_INDEXING_QUEUE(ENTITY_NAME)]
When initializing the database ,will throws follow exception:
Specified key was too long; max key length is 3072 bytes [Failed SQL: (1071) CREATE INDEX IDX_SEARCH_IDXNG_QUEUE_E_NAME ON rs.SEARCH_INDEXING_QUEUE(ENTITY_NAME)]
I guess the cause is :
The ENTIFY_NAME field length is 1000, my database encoding is utf8mb4 ,so ,the max length of the field is 4000 bytes, greater than 3072.
If create the database manually and chose utf8mb3 encoding, the problem will disappear.
But encoding of DB created by Studio is utf8mb4 , the problem will occur.
Please check if it’s a bug.
Regards,
Ray