Re: Debugging Failed Startup

Spoke too soon, Not coming back after a boot. Seems I can install, run, but
not reboot!

On Thu, May 2, 2019 at 3:18 PM Ray Cote <rgacote(at)appropriatesolutions(dot)com>
wrote:

>
>
> 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/
>
>
>

--
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/