Skip to content

Update incorrect SQL select command

Anton Starovoytov requested to merge astarovoytov-docs-jira-sql-udpate into master

What does this MR do and why?

Update documentation for Jira integration troubleshooting.

Our services table changed to integrations recently and this MR is to reflect this change in our troubleshooting section

How to set up and validate locally

  1. Install 15.9.3 SM instance
  2. Connect to the DB gitlab-psql
  3. Run query SELECT p.id FROM projects p LEFT JOIN services s ON p.id = s.project_id WHERE s.type = 'JiraService' AND s.active = true and check it failed
  4. Run query SELECT p.id FROM projects p LEFT JOIN integrations i ON p.id = i.project_id WHERE i.type_new = 'Integrations::Jira' AND i.active = true and check it passed

MR acceptance checklist

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

Merge request reports