feat(compactor): Improve PullTask strategy and reduce meta operations

[Li0k]

Background

When the task fails to execute on the compactor side or is rejected, the task will be canceled by reporting the task.
Since we introduced resource control to avoid compactor overload, Tasks may encounter frequent cancels and reissue tasks through PullTask, which will result in a large number of meta operations.

Improve

1. On the compactor side, after observing a high task failure rate, reduce the frequency of PullTask. (Prioritize implementation)
2. On the Meta side, collect compactor status information and actively reject PullTask.

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.