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