Re: Debugging Failed Startup

On Thu, May 2, 2019 at 2:57 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 5/2/19 11:22 AM, Ray Cote wrote:
> > Does anyone have a hint on how I'd go about debugging why PostgreSQL 11
> > is not starting on CentOS 7?
> > Was running fine for several weeks then fails to come up after a reboot.
> >
> > I did change the name of the CentOS7 server, but I don't expect that to
> > have any effect on the database.
> >
> > I'm running debug5 to the logs.
>
> The log below is coming from your syslog?
>
> Is there more in the syslog?
>
Yes, that's from the syslog (messages) trimmed a little. There's nothing
further in the log.
Added the debug messages that were prior to that below.

Ended up uninstalling and installing and all's fine again. Comes back
after a reboot.

> >
> > There's nothing in the ./log directory past the database shutting down.
> > Here's what's in messages. All seems to be fine and then boom!
> >
>
>> ... systemd: Starting PostgreSQL 11 database server...
>
> ... postmaster: ... DEBUG: postmaster: PostmasterMain: initial
>> environment dump:
>
> ... postmaster: ... DEBUG: -----------------------------------------
>
> ... postmaster: ... DEBUG: #011LANG=en_US.UTF-8
>
> ... postmaster: ... DEBUG:
>> #011PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
>
> ... postmaster: ... DEBUG: #011NOTIFY_SOCKET=/run/systemd/notify
>
> ... postmaster: ... DEBUG: #011HOME=/var/lib/pgsql
>
> ... postmaster: ... DEBUG: #011LOGNAME=postgres
>
> ... postmaster: ... DEBUG: #011USER=postgres
>
> ... postmaster: ... DEBUG: #011SHELL=/bin/bash
>
> ... postmaster: ... DEBUG: #011PGDATA=/var/lib/pgsql/11/data/
>
> ... postmaster: ... DEBUG: #011PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj
>
> ... postmaster: ... DEBUG: #011PG_OOM_ADJUST_VALUE=0
>
> ... postmaster: ... DEBUG: #011PGLOCALEDIR=/usr/pgsql-11/share/locale
>
> ... postmaster: ... DEBUG: #011PGSYSCONFDIR=/etc/sysconfig/pgsql
>
> ... postmaster: ... DEBUG: #011LC_COLLATE=en_US.UTF-8
>
> ... postmaster: ... DEBUG: #011LC_CTYPE=en_US.UTF-8
>
> ... postmaster: ... DEBUG: #011LC_MESSAGES=en_US.UTF-8
>
> ... postmaster: ... DEBUG: #011LC_MONETARY=C
>
> ... postmaster: ... DEBUG: #011LC_NUMERIC=C
>
> ... postmaster: ... DEBUG: #011LC_TIME=C
>
> ... postmaster: ... DEBUG: -----------------------------------------
>
> ... postmaster: ... DEBUG: registering background worker "logical
>> replication launcher"
>
> > ... postmaster: LOG: listening on IPv6 address "::1", port 5432
> > ... postmaster: LOG: listening on IPv4 address "127.0.0.1", port 5432
> > ... postmaster: LOG: listening on Unix socket
> > "/var/run/postgresql/.s.PGSQL.5432"
> > ... postmaster: LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
> > ... postmaster: DEBUG: invoking IpcMemoryCreate(size=148553728)
> > ... postmaster: DEBUG: SlruScanDirectory invoking callback on
> > pg_notify/0000
> > ... postmaster: DEBUG: removing file "pg_notify/0000"
> > ... postmaster: DEBUG: dynamic shared memory system will support 288
> > segments
> > ... postmaster: DEBUG: created dynamic shared memory control segment
> > 1998722972 (6928 bytes)
> > ... postmaster: DEBUG: max_safe_fds = 983, usable_fds = 1000,
> > already_open = 7
> > ... postmaster: LOG: redirecting log output to logging collector process
> > ... postmaster: HINT: Future log output will appear in directory "log".
> > ... systemd: postgresql-11.service: main process exited, code=exited,
> > status=1/FAILURE
> > ... systemd: Failed to start PostgreSQL 11 database server.
> > ... systemd: Unit postgresql-11.service entered failed state.
> >
> > --Ray
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Raymond Cote, President
voice: +1.603.924.6079 email: rgacote(at)AppropriateSolutions(dot)com skype:
ray.cote
Schedule a meeting: https://calendly.com/ray_cote/60min/