GitHub Personal Pipeline Error

[ShiinaRinne]

Describe the bug Run workflow, jobs "GitHub Personal Pipeline" get an error: https://github.com/ShiinaRinne/ossinsight-lite/actions/runs/5406964912/jobs/9824428075

To Reproduce Steps to reproduce the behavior:

1. Create a TiDB Serverless cluster
2. Set Github repos secret DATABASE_URL like mysql://<user>:<password>@<host>:<port>
3. Run workflow
4. See error

Screenshots

• Repos Secrets
• Workflow error

Desktop (please complete the following information):

• OS: Windows 10
• Browser: Edge Canary
• Version: 117.0.1948.0

Additional context It may be similar to https://github.com/pingcap/ossinsight-lite/issues/103#issuecomment-1600644376, I tried to delete the existing cluster in Tidbcloud and created a new one, then updated the secret, but got the same result

[hooopo]

This is an issue with Github's GraphQL. You can choose to manually rerun the workflow, or wait for the scheduled task to trigger next time. Since the pipeline is crash-safe, it will not affect data accuracy. The next run will still ensure data integrity.

[ShiinaRinne]

Thank you for your reply~ As I have been running multiple times and this issue has occurred, I suspect it may be due to my config error or other problems

[hooopo]

This error message is response from github API, it is github api issue which I also encounter from time to time. However, it usually disappears after a few retries 😄

See similar issue in github discussion: https://github.com/orgs/community/discussions/24631

[hooopo]

@ShiinaRinne I noticed that your GitHub action has been executed successfully. What was the reason for the previous failures?

[ShiinaRinne]

May be caused by the info of my issue being too long

I have tried to restart it many times, but there will be errors when sync the issue

So I changed the request code , and it can work properly https://github.com/ShiinaRinne/oh-my-github-pipeline/commit/097fd0b9231d7f01cf483aa33cc770f77eb60b25

[hooopo]

我注意到您的 GitHub 操作已成功执行。之前失败的原因是什么？

May be caused by the info of my issue being too long

I have tried to restart it many times, but there will be errors when sync the issue So I changed the request code , and it can work properly ShiinaRinne/oh-my-github-pipeline@097fd0b

Currently, for the sake of retrieval speed, we are fetching 100 issues each time. I think I can adjust it to 50 each time, which would decrease the likelihood of Github API timeouts and errors. I sincerely apologize for any inconvenience caused to you.

[hooopo]

@ShiinaRinne I changed batch size to 50, can you try it and check if the error exist? https://github.com/hooopo/oh-my-github-pipeline/commit/120868439b950e640cd36a5c5333ef0ad2d93e61

[ShiinaRinne]

Actually, I don't think I have posted that many issues. At most, it shouldn't exceed 50, so I'm not sure if this problem is caused by the high number of issues

[ShiinaRinne]

@ShiinaRinne I changed batch size to 50, can you try it and check if the error exist? hooopo/oh-my-github-pipeline@1208684

https://github.com/ShiinaRinne/ossinsight-lite/actions/runs/5408900984/jobs/9828426848

don't work

[hooopo]

Alright, I'll test your account data locally to see whether it's an API issue or something else. I'll notify you once I've sorted this out.

[ShiinaRinne]

Thank you for your assistance~

---

Although I may have unsubscribed from some, the actual number of issues shouldn't be that high And I changed the batch size to 10, it still have the same error

Sorry I can't provide more useful information or debug it myself.

[hooopo]

@ShiinaRinne https://github.com/orgs/community/discussions/59629

I make sure it is a github API issue.

[ShiinaRinne]

Thank you very much! I think there might be an issue with my account XD. For now, I'll simply delete the Issue part to continue using it and wait for fix~

[ShiinaRinne]

btw, I found that now we can directly see the issues posted by each user through URL. In reality, I have posted 17 issues. https://github.com/issues?q=is%3Aissue+author%3AShiinaRinne+archived%3Afalse+is%3Aclosed

Is it possible to query issue data by making requests to this API?