Drop ci_runner_machines_archived table

What does this MR do and why?

Describe in detail what merge request is being backported and why

This MR backports !189308 (merged) to drop the ci_runner_machines_archived table, since it has become out of sync with ci_runner_machines and is causing 404 errors as witnessed in #543351 (comment 2510840293).

Changelog: other

References

• Drop ci_runner_machines_archived table (!189308 - merged)
• https://gitlab.com/gitlab-org/release/tasks/-/issues/19499+
• Drop ci_runners_archived and ci_runner_machines... (#516060 - closed)
• Runner not picking up jobs after upgrade to 17.... (#543351 - closed)
• https://gitlab.com/gitlab-com/request-for-help/-/issues/2838+

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• This MR is backporting a bug fix, documentation update, or spec fix, previously merged in the default branch.
• The MR that fixed the bug on the default branch has been deployed to GitLab.com (not applicable for documentation or spec changes).
• This MR has a severity label assigned (if applicable).
• Set the milestone of the merge request to match the target backport branch version.
• This MR has been approved by a maintainer (only one approval is required).
• Ensure the e2e:test-on-omnibus-ee job has either succeeded or been approved by a Software Engineer in Test.

Note to the merge request author and maintainer

If you have questions about the patch release process, please:

• Refer to the patch release runbook for engineers and maintainers for guidance.
• Ask questions on the #releases Slack channel (internal only).