BUG #15021: Postgres crashes unexpectedly

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15021: Postgres crashes unexpectedly
Дата
Msg-id 20180119214744.3623.2508@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15021: Postgres crashes unexpectedly  (Merlin Moncure <mmoncure@gmail.com>)
Re: BUG #15021: Postgres crashes unexpectedly  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15021
Logged by:          Wallace Baggaley
Email address:      wally.baggaley@gmail.com
PostgreSQL version: 9.6.5
Operating system:   Debian GNU Linux 8 container on CentOS 7.2.1511
Description:

Postgres crashes unexpectedly and indicates that it received a signal to end
based on the following logs. But checking user history and journald show
nothing has terminated the application. Is it possible the log "LOG:
received smart shutdown request" could be caused by something other than a
signal. What signals could be associated with this log or is this possibly
related to a crash?

Thanks!
Wally

        January 19th 2018, 11:26:14.710 LOG:  autovacuum launcher started
    January 19th 2018, 11:26:14.706    LOG:  database system is ready to accept
connections
    January 19th 2018, 11:26:14.704    LOG:  MultiXact member wraparound
protections are now enabled
    January 19th 2018, 11:26:14.690    LOG:  invalid record length at 0/88D9C00:
wanted 24, got 0
    January 19th 2018, 11:26:14.690    LOG:  redo is not required
    January 19th 2018, 11:26:14.689    LOG:  database system was not properly shut
down; automatic recovery in progress
    January 19th 2018, 11:26:14.677    LOG:  database system was interrupted; last
known up at 2018-01-19 19:26:04 UTC
    January 19th 2018, 11:26:04.710    LOG:  autovacuum launcher started
    January 19th 2018, 11:26:04.709    LOG:  database system is ready to accept
connections
    January 19th 2018, 11:26:04.707    LOG:  MultiXact member wraparound
protections are now enabled
    January 19th 2018, 11:26:04.698    LOG:  redo done at 0/88D9B68
    January 19th 2018, 11:26:04.698    LOG:  last completed transaction was at log
time 2018-01-19 18:33:58.443636+00
    January 19th 2018, 11:26:04.698    LOG:  invalid record length at 0/88D9B90:
wanted 24, got 0
    January 19th 2018, 11:26:04.694    LOG:  redo starts at 0/88D2B70
    January 19th 2018, 11:26:04.692    LOG:  database system was not properly shut
down; automatic recovery in progress
    January 19th 2018, 11:26:04.678    LOG:  database system was interrupted; last
known up at 2018-01-19 16:41:01 UTC
    January 19th 2018, 10:34:07.436    DETAIL:  Key ("code")=(ABC123) already
exists.
    January 19th 2018, 10:34:07.436    STATEMENT:  insert into "TableName"
("code","subcode")  values ($1,$2)
    January 19th 2018, 10:34:07.436    ERROR:  duplicate key value violates unique
constraint "INDEX_NAME"
    January 19th 2018, 10:34:03.807    STATEMENT:  insert into "TableName"
("code","subcode")  values ($1,$2)
    January 19th 2018, 10:34:03.806    DETAIL:  Key ("code")=(ABC123) already
exists.
    January 19th 2018, 10:34:03.806    ERROR:  duplicate key value violates unique
constraint "INDEX_NAME"
    January 19th 2018, 10:33:58.533    LOG:  autovacuum launcher shutting down
    January 19th 2018, 10:33:58.526    LOG:  received smart shutdown request
    January 19th 2018, 10:33:58.452    DETAIL:  Key ("code")=(ABC123) already
exists.
    January 19th 2018, 10:33:58.452    STATEMENT:  insert into "TableName"
("code","subcode")  values ($1,$2)
    January 19th 2018, 10:33:58.451    ERROR:  duplicate key value violates unique
constraint "INDEX_NAME"



В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15020: download to CSV button does nothing
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: BUG #15021: Postgres crashes unexpectedly