[BUGS] Re: [HACKERS] Postgres process invoking exit resulting in sh-QUITcore

Поиск
Список
Период
Сортировка
От K S, Sandhya (Nokia - IN/Bangalore)
Тема [BUGS] Re: [HACKERS] Postgres process invoking exit resulting in sh-QUITcore
Дата
Msg-id AM5PR0701MB2642F865EFBEDF5CD415DD43D6D60@AM5PR0701MB2642.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [BUGS] [HACKERS] Postgres process invoking exit resulting in sh-QUIT core  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: [BUGS] [HACKERS] Postgres process invoking exit resulting in sh-QUIT core  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-bugs
Hi Craig,

Thanks for the response.

Scenario tried here is restart of the system multiple times. sh-QUIT core is generated when Postgres is invoking the
shellto exit and may not be due to kernel or file system issues. I will try to reproduce the issue with dmesg output
beingprinted.
 

However, is there any instance in Postgres where 'sh -c exit 1' will be invoked?

Regards,
Sandhya

-----Original Message-----
From: Craig Ringer [mailto:craig@2ndquadrant.com] 
Sent: Friday, June 30, 2017 5:40 PM
To: K S, Sandhya (Nokia - IN/Bangalore) <sandhya.k_s@nokia.com>
Cc: pgsql-hackers@postgresql.org; pgsql-bugs@postgresql.org; T, Rasna (Nokia - IN/Bangalore) <rasna.t@nokia.com>;
Itnal,Prakash (Nokia - IN/Bangalore) <prakash.itnal@nokia.com>
 
Subject: Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

On 30 June 2017 at 17:41, K S, Sandhya (Nokia - IN/Bangalore)
<sandhya.k_s@nokia.com> wrote:

> When we checked the process listing during the time of core generation, we
> found Postgres startup process is invoking “sh -c exit 1”:
> 4518      9249  0.1  0.0 155964  2036 ?        Ss   15:05   0:00 postgres:
> startup process   waiting for 0000000100000000000002EB

Looks like an archive_command or restore_command .

If 'sh' is dumping core, you probably have issues at a low level in
the kernel, file system, etc. Check dmesg.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: sbadyals@gmail.com
Дата:
Сообщение: [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 inpg_toast_2619
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14731: ERROR: missing chunk number 0 for toast value 9342315 in pg_toast_2619