SiliconSatchel commented on issue #7752:
URL:
https://github.com/apache/incubator-devlake/issues/7752#issuecomment-2234111559
After rerunning collection (on a small repo, it was pretty quick) the
`largest files with lowest number of authors` and `[total]files with most
modifications` panels are populated, but `files with maximum number of authors`
and `files with most modifications` are not. Looking more closely at `largest
files with lowest number of authors`, the SQLite query
```
SELECT file_path,
count(distinct sha) AS modified_num
FROM commits
JOIN commit_files
JOIN repo_commits rc
ON commit_files.commit_sha = rc.commit_sha
AND sha=commit_files.commit_sha
AND $__timeFilter(commits.authored_date)
WHERE repo_id IN (${repo_id}) and file_path REGEXP
'(${selected_path:regex})'
AND $__timeFilter(commits.authored_date)
GROUP BY file_path
ORDER BY modified_num desc
LIMIT 15;
```
is causing this error in the Grafana pod:
```
logger=tsdb.mysql endpoint=queryData pluginId=mysql dsName=mysql
dsUID=P430005175C4C7810 uname=admin t=2024-07-17T19:44:17.454747932Z
level=error msg="Query error" error="Error 3995 (HY000): Character set 'binary'
cannot be used in conjunction with 'utf8mb4_unicode_ci' in call to regexp_like."
```
Removing the line `WHERE repo_id IN (${repo_id}) and file_path REGEXP
'(${selected_path:regex})'` causes the query to succeed. I'm a little unclear
on what `selected_path` should be set to, the query fails when I set it to the
empty string, `.`, or the name of a top-level directory in the repo.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
