gitlab mysql连接失败_GitLab数据库引起的502错误问题及解决方案

1.打开GitLab的主页地址http://192.168.1.123:8888报错：

2.重启或检查状态发现都正常。

[root@localhost unicorn]# sudo gitlab-ctl status

run: alertmanager: (pid 98218) 1895s; run: log: (pid 66884) 2683s

run: gitaly: (pid 98231) 1895s; run: log: (pid 66906) 2683s

run: gitlab-monitor: (pid 98242) 1894s; run: log: (pid 66888) 2683s

run: gitlab-workhorse: (pid 98250) 1894s; run: log: (pid 66900) 2683s

run: logrotate: (pid 98263) 1893s; run: log: (pid 66904) 2683s

run: nginx: (pid 98269) 1893s; run: log: (pid 66902) 2683s

run: node-exporter: (pid 98281) 1893s; run: log: (pid 66890) 2683s

run: postgres-exporter: (pid 98291) 1892s; run: log: (pid 66892) 2683s

run: postgresql: (pid 98299) 1892s; run: log: (pid 66894) 2683s

run: prometheus: (pid 98308) 1891s; run: log: (pid 66882) 2683s

run: redis: (pid 98315) 1891s; run: log: (pid 66880) 2683s

run: redis-exporter: (pid 98319) 1891s; run: log: (pid 66886) 2683s

run: sidekiq: (pid 98325) 1890s; run: log: (pid 66898) 2683s

run: unicorn: (pid 98332) 1890s; run: log: (pid 66896) 2683s

3.检查端口号：

[root@localhost unicorn]# netstat -anp |grep 8888

tcp 0 0 0.0.0.0:8888 0.0.0.0:* LISTEN 98269/nginx: master

发现端口没有被占用。

4.检查刷新配置：

gitlab-ctl reconfigure

终于发现错误信息：

Running handlers:

There was an error running gitlab-ctl reconfigure:

bash[migrate gitlab-rails database] (gitlab::database_migrations line 51) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received '1'

---- Begin output of "bash" "/tmp/chef-script20190308-65247-12ck9rp" ----

STDOUT: rake aborted!

PG::ConnectionBad: could not connect to server: No such file or directory

Is the server running locally and accepting

connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?

/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:52:in `block (3 levels) in '

/opt/gitlab/embedded/bin/bundle:23:in `load'

/opt/gitlab/embedded/bin/bundle:23:in `'

Tasks: TOP => gitlab:db:configure

(See full trace by running task with --trace)

STDERR:

---- End output of "bash" "/tmp/chef-script20190308-65247-12ck9rp" ----

Ran "bash" "/tmp/chef-script20190308-65247-12ck9rp" returned 1

6.解决了以后再次检查端口号：

[root@localhost unicorn]# netstat -anp |grep 8888

tcp 0 0 0.0.0.0:8888 0.0.0.0:* LISTEN 98269/nginx: master

unix 3 [ ] STREAM CONNECTED 83131258 98888/postgres: git /var/opt/gitlab/postgresql/.s.PGSQL.5432