mindlesscloud opened a new issue, #5243: URL: https://github.com/apache/incubator-devlake/issues/5243
### 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 I'm using Postgres as database, and when I try to collect data from Jira, the pipeline failed with an error, the following are the logs ``` time="2023-05-16 05:54:21" level=error msg=" [pipeline service] [pipeline #29579] [task #29808] subtask extractIssues ended unexpectedly Wraps: (2) error adding result to batch Wraps: (3) ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021) Wraps: (4) ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021) Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *hintdetail.withDetail (4) *pgconn.PgError" time="2023-05-16 05:54:21" level=error msg=" [task service] task failed caused by: Error running task 29808. Wraps: (2) subtask extractIssues ended unexpectedly Wraps: (3) error adding result to batch Wraps: (4) ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021) Wraps: (5) ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021) Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *hintdetail.withDetail (4) *hintdetail.withDetail (5) *pgconn.PgError" time="2023-05-16 05:54:21" level=error msg=" [pipeline service] [pipeline #29579] run tasks failed caused by: Error running task 29808. Wraps: (2) subtask extractIssues ended unexpectedly Wraps: (3) error adding result to batch Wraps: (4) ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021) Wraps: (5) ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021) Error types: (1) *hintdetail.withDetail (2) *hintdetail.withDetail (3) *hintdetail.withDetail (4) *hintdetail.withDetail (5) *pgconn.PgError " time="2023-05-16 05:54:21" level=info msg=" [pipeline service] [pipeline #29579] return error" ``` ### What do you expect to happen There should be no errors when extracting issues. ### How to reproduce - create an issue, make sure there is an `\u0000` in the summary - config DevLake using Postgres as database - create a blueprint to collect the issue we just created - run the blueprint ### Anything else _No response_ ### Version main 4f9b42a4592e3530125047765568c5e21c35ce6e ### Are you willing to submit PR? - [X] 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]
