Error 1206: The total number of locks exceeds the lock table size

[pplam]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

Subtask collectApiPullRequestReviews ended unexpectedly when running a gitee pipeline.

What do you expect to happen

Expect the task to complete successfully.

How to reproduce

Create a pipeline with the following plan:

{
  "name": "openharmony",
  "plan": [[
      {
        "plugin": "gitee",
        "options": {
          "connectionId": 1,
          "repo": "arkui_ace_engine",
          "owner": "openharmony"
        }
      }
    ]]
}

And POST to the api path /pipelines.

The task fails after running for about 1.5h with the error message "subtask collectApiPullRequestReviews ended unexpectedly\ncaused by: error deleting data from collector\ncaused by: Error 1206: The total number of locks exceeds the lock table size".

Anything else

No response

Version

main

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[klesh]

Thanks for the report.
Seems like the MySQL InnoDb engine would create a row lock for each and every row that met the condition which would cause memory to exceed when targeting a large number of rows.
In this case, deleting huge amount pr reviews belongs to a specific repo.

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.