duhow opened a new issue, #7203: URL: https://github.com/apache/incubator-devlake/issues/7203
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened Split from #7198 , as this issue affects table `commit_files`. Commit File is named `arch/arm/include/stm32l4\x80stm32l4x6xx_irq.h` and causes issues to import. ``` time="2024-03-21 11:37:06" level=error msg=" [pipeline service] [pipeline #91] [task #4728] [cloneGitRepo] CommitFiles error\n\tcaused by: Error 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98 (500)\n\tWraps: (2) Error 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98\n\tError types: (1) *hintdetail.withDetail (2) *mysql.MySQLError" time="2024-03-21 11:37:06" level=error msg=" [pipeline service] [pipeline #91] [task #4728] [cloneGitRepo] CommitFiles error\n\tcaused by: add slot failed due to previous err (500)\n\tWraps: (2) Error 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98 (500)\n\tWraps: (3) Error 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98\n\tError types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *mysql.MySQLError" time="2024-03-21 11:37:06" level=error msg=" [pipeline service] [pipeline #91] [task #4728] subtask collectGitCommits ended unexpectedly\n\tWraps: (2) add slot failed due to previous err (500)\n\tWraps: (3) Error 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98 (500)\n\tWraps: (4) Error 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98\n\tError types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *hintdetail.withDetail (4) *mysql.MySQLError" time="2024-03-21 11:37:06" level=info msg="\x1b[31;1m/app/impls/dalgorm/dalgorm.go:251 \x1b[35;1mError 1366 (HY000): Incorrect string value: '\\x80stm32...' for column 'file_path' at row 98\n\x1b[0m\x1b[33m[23.956ms] \x1b[34;1m[rows:0]\x1b[0m INSERT INTO `commit_files` (`id`,`created_at`,`updated_at`,`_raw_data_params`,`_raw_data_table`,`_raw_data_id`,`_raw_data_remark`,`commit_sha`,`file_path`,`additions`,`deletions`) VALUES ('721512c83aebd5ca22744284c7c0637413c2982c:193841aac7e172c2c7825dff6e9f7e579ec1d6bfdbad21e0bc41ba4784814c76','2024-03-21 11:37:05.553','2024-03-21 11:37:05.553','bitbucket_server:BitbucketServerRepo:2:IMX500/repos/incubator-nuttx','gitextractor',0,'','721512c83aebd5ca22744284c7c0637413c2982c','configs/z8encore000zco/README.txt',5,7), ('f1b71e3ae7b8c0fba8707f6d4ffc46fd038c7d12:51b5c77a530fb52aaafb65e3fa76eeb7462fd95c4348aba6185d99f7500ffab9','2024-03-21 11:37:05.553','2024-03-21 11:37:05.553','bitbucket_server:BitbucketServerRepo:2:IMX500/repos/incubator-nuttx','gitextractor',0,'','f1b71e3ae7b8c0fba8707f6d4ffc46fd038c7d12','arch/arm/include/stm32l4\x80stm32l4x6xx_irq.h',0,202), ('8a6662c95751b9a109c6cef5225db635ba814cd4:b4357c932aa247bb76a425fc0aa3f6e762daba302f24cdb7892baca203b70cff','2024-03-21 11:37:05.553','2024-03-21 11:37:05.553','bitbucket_server:BitbucketServerRepo:2:IMX500/repos/incubator-nuttx','gitextractor',0,'','8a6662c95751b9a109c6cef5225db635ba814cd4','arch/arm/include/stm32l4/chip.h',3,1), ('8a6662c95751b9a109c6cef5225db635ba814cd4:51b5c77a530fb52aaafb65e3fa76eeb7462fd95c4348aba6185d99f7500ffab9','2024-03-21 11:37:05.553','2024-03-21 11:37:05.553','bitbucket_server:BitbucketServerRepo:2:IMX500/repos/incubator-nuttx','gitextractor',0,'','8a6662c95751b9a109c6cef5225db635ba814cd4','arch/arm/include/stm32l4\x80stm32l4x6xx_irq.h',202,0) ON DUPLICATE KEY UPDATE `updated_at`='2024-03-21 11:37:06.623',`_raw_data_params`=VALUES(`_raw_data_params`),`_raw_data_table`=VALUES(`_raw_data_table`),`_raw_data_id`=VALUES(`_raw_data_id`),`_raw_data_remark`=VALUES(`_raw_data_remark`),`commit_sha`=VALUES(`commit_sha`),`file_path`=VALUES(`file_path`),`additions`=VALUES(`additions`),`deletions`=VALUES(`deletions`)" ``` ### What do you expect to happen Import the commit_files without crashing the whole task. ### How to reproduce See above notes. ### Anything else _No response_ ### Version 555264c ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
