Skip to content

Add sub-section about the error "cannot drop view pg_stat_statements because extension pg_stat_statements requires it" to the chart troubleshooting page

Alexandr Tanayno requested to merge docs-chart-restoration-issue into master

What does this MR do?

Restoration of a GitLab backup may fail with the error like:

ActiveRecord::StatementInvalid: PG::DependentObjectsStillExist: ERROR:
cannot drop view pg_stat_statements because extension pg_stat_statements requires it
HINT:  You can drop extension pg_stat_statements instead.

As suggested in this comment, creating the MR to the chart troubleshooting section to describe the error and available workaround.

Related issues

#2469 (closed)

Checklist

See Definition of done.

For anything in this list which will not be completed, please provide a reason in the MR discussion.

Required

  • Merge Request Title and Description are up to date, accurate, and descriptive
  • MR targeting the appropriate branch
  • MR has a green pipeline on GitLab.com

Expected (please provide an explanation if not completing)

  • Test plan indicating conditions for success has been posted and passes
  • Documentation created/updated
  • Tests added
  • Integration tests added to GitLab QA
  • Equivalent MR/issue for omnibus-gitlab opened

Merge request reports