Unable to run any gitlab-rake commands and 502 message
CentOs 6.8 GitLab CE 9.0.5
After attempting to restore from backup, I can't access any repos and i keep getting a 502 message. I have done a gitlab-ctl reconfigure and after running I would get:
Running handlers:
Running handlers complete
Chef Client finished, 4/389 resources updated in 11 seconds
gitlab Reconfigured!
Then, when I run gitlab-ctl start I get:
ok: run: gitaly: 996s
ok: run: gitlab-monitor: 1240s, got TERM
ok: run: gitlab-workhorse: 965s
ok: run: logrotate: 964s
ok: run: nginx: 963s
ok: run: node-exporter: 962s
ok: run: postgres-exporter: 961s
ok: run: postgresql: 959s
ok: run: prometheus: 960s
ok: run: redis: 958s
ok: run: redis-exporter: 958s
ok: run: sidekiq: 7s
ok: run: unicorn: 8s```
But when I go check my login page I get a 502 message and then when I run a gitlab-rake command I would get:
sudo gitlab-rake gitlab:env:info DEBUG -- sentry: ** [Raven] PG::SyntaxError: ERROR: zero-length delimited identifier at or near """" LINE 1: ...cation_settings" ORDER BY "application_settings"."" DESC LI... ^ : SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."" DESC LIMIT 1 e xcluded from capture due to environment or should_capture callback rake aborted!
I checked /var/log/gitlab/postgresql/current and I saw the same error:
LOG: database system was shut down at 2017-05-03 14:20:46 GMT LOG: database system is ready to accept connections LOG: autovacuum launcher started ERROR: zero-length delimited identifier at or near """" at character 95 STATEMENT: SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."" DESC LIMIT 1 ERROR: zero-length delimited identifier at or near """" at character 95 STATEMENT: SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."" DESC LIMIT 1 ERROR: zero-length delimited identifier at or near """" at character 95 STATEMENT: SELECT "application_settings".* FROM "application_settings" ORDER BY "application_settings"."" DESC LIMIT 1 ERROR: zero-length delimited identifier at or near """" at character 95
Any ideas on how to solve this issue? I would really appreciate the help!