Skip to content

First iteration of schema checker page

What does this MR do and why?

This adds a schema checker diagnostic in addition to the collation checker diagnostic in /admin/database_diagnostics.

This is the frontend part. The backend has been split off to !200156 (merged).

References

#467544.

Screenshots or screen recordings

image

How to set up and validate locally

  1. Checkout this branch.
  2. Navigate to /admin/database_diagnostics.
  3. Click on Run Schema Check.
  4. You should see no issues.
  5. If you want to create an issue, you can run gdk psql and drop an index:
DROP INDEX index_abuse_events_on_user_id;
  1. Now click on Run Schema Check again.
  2. You should see now a missing index.
  3. Add back the index in gdk psql:
CREATE INDEX index_abuse_events_on_user_id ON abuse_events USING btree (user_id);

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Stan Hu

Merge request reports

Loading