You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by "mindlesscloud (via GitHub)" <gi...@apache.org> on 2023/05/19 12:34:00 UTC
[GitHub] [incubator-devlake] mindlesscloud opened a new issue, #5243: [Bug][Jira] ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
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: commits-unsubscribe@devlake.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-devlake] mindlesscloud closed issue #5243: [Bug][Jira] ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
Posted by "mindlesscloud (via GitHub)" <gi...@apache.org>.
mindlesscloud closed issue #5243: [Bug][Jira] ERROR: invalid byte sequence for encoding "UTF8": 0x00 (SQLSTATE 22021)
URL: https://github.com/apache/incubator-devlake/issues/5243
--
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: commits-unsubscribe@devlake.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org