Add unified database migrations troubleshooting section

What does this MR do?

MR adds a new unified database migrations section in the troubleshooting docs and expands on additional scenarios that can occur due to this area, specifically missing root users.

Author's checklist

When ready for review, the Author applies the workflowready for review label and mention @gitlab-org/software-delivery/get-maintainers:

• Merge request:
  • Corresponding Issue raised and reviewed by the GET maintainers team.
  • Merge Request Title and Description are up-to-date, accurate, and descriptive
  • MR targeting the appropriate branch
  • MR has a green pipeline
  • MR has no new security alerts in the widget from the Secret Detection and IaC Scan (SAST) jobs.
• Code:
  • Check the area changed works as expected across all expected permutations.
  • Check that the changes work across upgrades.
  • Documentation created/updated in the same MR if applicable