marcemv90 opened a new issue, #2073:
URL: https://github.com/apache/incubator-devlake/issues/2073

   ## Describe the bug
   Running a Github pipeline to register a repository that contains emojis on 
some of its pull request comments (and probably in other fields) the pipeline 
fails with the following error:
   
   ```
   Error 3988: Conversion from collation utf8mb4_0900_ai_ci into 
utf8_general_ci impossible for parameter
   ```
   
   ## To Reproduce
   Steps to reproduce the behavior:
   1. Go to '**Pipelines > Create Pipeline Run**'
   2. Click on '**Create Pipeline Run**'
   3. Scroll down to until '**Github**' is shown in Data Providers list
   4. **Toggle on** GitHub Data provider
   5. Enter repository owner and name for a repository **that contains emojis** 
on some of its comments, titles, etc.
   6. Click on '**Run Pipeline**'
   7. Wait for the Pipeline to run, in our case it fails at 20%.
   
   ## Expected behavior
   Github scan succeeds with no errors.
   
   ## Screenshots
   
![image](https://user-images.githubusercontent.com/16705936/171841365-f2c16067-7834-4916-93f1-9d9eeb5e718c.png)
   
   
![image](https://user-images.githubusercontent.com/16705936/171842798-4bc6e1ed-b5c8-4d01-85a0-d3b7b84298f7.png)
   
   ## Additional context
   Similar errors are shown in the lake container logs:
   ```shell
   time="2022-06-03 10:51:01" level=error msg=" [task service] task 
failed%!(EXTRA *errors.SubTaskError=Error 3988: Conversion from collation 
utf8mb4_0900_ai_ci into utf8_general_ci impossible for parameter)"
   time="2022-06-03 10:51:01" level=error msg=" [pipeline service] [pipeline 
#21] run tasks failed: %!w(*errors.errorString=&{Error 3988: Conversion from 
collation utf8mb4_0900_ai_ci into utf8_general_ci impossible for parameter})"
   ```
   
   We think it might be related to the emojis  as the log also contains those. 
Probably is related to the charset used in the Database or some of its tables 
or fields.
   
   Please let us know if further information is required.
   
   Many thanks!
   
   Regards.
   
   


-- 
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]

Reply via email to