断电后gitlab报500错误启动出错

最新推荐文章于 2024-12-11 16:05:57 发布

转载最新推荐文章于 2024-12-11 16:05:57 发布 · 333 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/legendjslc/p/6949788.html

文章标签：

#数据库

本文记录了一次GitLab服务器遇到异常断电后出现500错误的问题及解决过程。通过检查日志文件和执行特定命令，最终定位到数据库连接问题，并通过删除postmaster.pid文件成功恢复GitLab服务。

异常断电后，gitlab报500错误，重启无效

通过sudo gitlab-ctl reconfigure启动时, 提示 [execute] pgsql:could not connect to server:

 1 Recipe: gitlab::postgresql
 2   * template[/opt/gitlab/etc/gitlab-psql-rc] action create (up to date)
 3   * execute[create gitlab database user] action run
 4     [execute] psql: could not connect to server: Connection refused
 5                   Is the server running locally and accepting
 6                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
 7     [execute] psql: could not connect to server: Connection refused
 8                   Is the server running locally and accepting
 9                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
10     [execute] psql: could not connect to server: Connection refused
11                   Is the server running locally and accepting
12                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
13     [execute] psql: could not connect to server: Connection refused
14                   Is the server running locally and accepting
15                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
16     [execute] psql: could not connect to server: Connection refused
17                   Is the server running locally and accepting
18                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
19     [execute] psql: could not connect to server: Connection refused
20                   Is the server running locally and accepting
21                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
22     [execute] psql: could not connect to server: Connection refused
23                   Is the server running locally and accepting
24                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?
25     [execute] psql: could not connect to server: Connection refused

通过sudo gitlab-ctl start启动时, 提示 timeout:down:postgresql:ls, normally up, want up

查看/var/log/gitlab/postgres/current日志发现,

2017-06-05_07:49:01.37753 FATAL:  pre-existing shared memory block (key 5432001, ID 0) is still in use
2017-06-05_07:49:01.37754 HINT:  If you're sure there are no old server processes still running, remove the shared memory block or just delete the file "postmaster.pid".

按照提示，删除"postmaster.pid"

root@ubuntu-70:/var/opt/gitlab/postgresql/data#  rm postmaster.pid

重新执行sudo gitlab-ctl reconfigure gitlab可以正常启动了

转载于:https://www.cnblogs.com/legendjslc/p/6949788.html