narrowizard commented on issue #8452:
URL: 
https://github.com/apache/incubator-devlake/issues/8452#issuecomment-2911562271

   > Due to MySQL's InnoDB limitation where index keys can be a maximum of 3072 
bytes, the `cq_file_metrics.id` field, when using the `utf8mb4` character set, 
can only be set to `VARCHAR(767)` at its longest. To ensure SonarQube data can 
be collected correctly without hitting this field length limit, we may need to 
modify the format or handling of `cq_file_metrics.id`. This particular aspect 
of the issue will be tracked in a separate follow-up issue.
   
   Regarding the index key length limitation, we plan to address this for 
`cq_file_metrics.id` (which is derived from 
`_tool_sonarqube_file_metrics.file_metrics_key`) by **hashing the file path 
portion** of `_tool_sonarqube_file_metrics.file_metrics_key` to restrict its 
length.
   
   This approach will necessitate considering **data migration**. The simplest 
and most straightforward method would be to **clear the existing data** from 
both the `cq_file_metrics` and `_tool_sonarqube_file_metrics` tables. This way, 
subsequent data collection will use the new ID format, avoiding any conflicts 
between old and new data representations.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to