From: | robert <robert(at)redcor(dot)ch> |
---|---|
To: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: container restarted -> postgresql dead but pid file exists |
Date: | 2020-01-12 11:41:44 |
Message-ID: | bee8846a-f902-c7fe-33f5-24aa187e256b@redcor.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
could it be, that this pid exist from "before" the update?
you can "enter" a running container as user root executing:
docker exec YOURCONTAINERNAME bash
then ls -l /run/postgresql
when I do that "outside" of a container (in a running ununtu box) I get:
robert(at)lappi:~/projects/fernuni13/fernuni13/fernuni$ ll /run/postgresql/
total 8
drwxrwsr-x 3 postgres postgres 120 Jan 8 10:57 ./
drwxr-xr-x 37 root root 1240 Jan 12 11:50 ../
drwxr-s--- 2 postgres postgres 200 Jan 12 12:35 11-main.pg_stat_tmp/
-rw-r--r-- 1 postgres postgres 5 Jan 8 10:57 11-main.pid
srwxrwxrwx 1 postgres postgres 0 Jan 12 11:50 .s.PGSQL.5432=
-rw------- 1 postgres postgres 69 Jan 12 11:50 .s.PGSQL.5432.lock
when I do that in a container, that runs nothing but postgres:
root(at)8fc7b375416b:/# ls -l /run
total 16
drwxr-x--- 2 Debian-exim Debian-exim 4096 Nov 4 2017 exim4
drwxrwxrwt 2 root root 4096 Oct 9 2017 lock
drwxr-xr-x 2 root root 4096 Oct 9 2017 mount
drwxrwsr-x 1 postgres postgres 4096 Jan 11 06:35 postgresql
-rw-rw-r-- 1 root utmp 0 Oct 9 2017 utmp
and
root(at)8fc7b375416b:/# ls -l /run/postgresql/
total 0
robert
On 12/01/2020 09:29, Mariel Cherkassky wrote:
> Hey,
> I have a container that runs centos image with a few changes and
> postgresql installed on it.
> Whenever I start my container or restart it, the postgresql(12) starts
> in the following state :
> postgresql dead but pid file exists
>
> For example :
>
> [root(at)my_container_id /]# service postgresql status
> postgresql (pid 128) is running...
> [root@ my_container_id /]# exit
> exit
> [root(at)docker-node]# docker restart my_container_id
> my_container_id
> [root@ docker-node ]#
> [root@ docker-node ]#
> [root@ docker-node ]# docker exec -it my_container_id /bin/bash
> [root(at)my_container_id /]# service postgresql status
> postgresql dead but pid file exists
>
>
> It happens since I upgraded my postgresql to version 12.
> Does anyone else suffer from the same issue ?
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Wells Oliver | 2020-01-13 17:21:54 | Declarative partitioning, UUIDs, index issues. |
Previous Message | robert | 2020-01-12 11:41:05 | Re: container restarted -> postgresql dead but pid file exists |