Project cannot be deleted due to SQL backend issue.

Summary

Project cannot be deleted due to error in backend SQL with hosting.

Steps to reproduce

Delete project

Example Project

https://gitlab.com/heritage-cu/analytics3

What is the current bug behavior?

It produces the following error message.

This project was scheduled for deletion, but failed with the following message: PG::SyntaxError: ERROR: each UNION query must have the same number of columns LINE 3: ...group_links"."shared_group_id" = 12730642) SELECT "members".... ^

What is the expected correct behavior?

The project should be deleted.

Relevant logs and/or screenshots

This project was scheduled for deletion, but failed with the following message: PG::SyntaxError: ERROR: each UNION query must have the same number of columns LINE 3: ...group_links"."shared_group_id" = 12730642) SELECT "members".... ^

Output of checks

Results of GitLab environment info

Expand for output related to GitLab environment info

(For installations with omnibus-gitlab package run and paste the output of:
`sudo gitlab-rake gitlab:env:info`)

(For installations from source run and paste the output of:
`sudo -u git -H bundle exec rake gitlab:env:info RAILS_ENV=production`)

Results of GitLab application Check

Expand for output related to the GitLab application check

(For installations with omnibus-gitlab package run and paste the output of:
sudo gitlab-rake gitlab:check SANITIZE=true)
(For installations from source run and paste the output of:
sudo -u git -H bundle exec rake gitlab:check RAILS_ENV=production SANITIZE=true)
(we will only investigate if the tests are passing)

Possible fixes

Unable to delete as well. Showing this error message on the project after attempting to delete - This project was scheduled for deletion, but failed with the following message: PG::SyntaxError: ERROR: each UNION query must have the same number of columns LINE 7: ...ROM "base_and_ancestors" AS "namespaces")) SELECT "members".... ^

Also saw this error when attempting to export a project.

Having the same issue. When I tried deleting a project I got the meesage: "This project was scheduled for deletion, but failed with the following message: PG::SyntaxError: ERROR: each UNION query must have the same number of columns LINE 7: ...ROM "base_and_ancestors" AS "namespaces")) SELECT "members".... ^"

Can someone try to fix this?

May be related to an open issue - gitlab-com/gl-infra/production#5174 (closed)

I get both the runner error as well as the delete error.

Can you try again?

Now it works! Thanks!

Works for me as well! Thank you!

This seems to have been fixed. Closing

closed