Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-18 Thread K S, Sandhya (Nokia - IN/Bangalore)
stgreSQL Hackers <pgsql-hackers@postgresql.org>; T, Rasna (Nokia - IN/Bangalore) <rasn...@nokia.com>; Itnal, Prakash (Nokia - IN/Bangalore) <prakash.it...@nokia.com> Subject: RE: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core Hi Craig, Here is bt after instal

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-12 Thread K S, Sandhya (Nokia - IN/Bangalore)
kia.com> Cc: pgsql-bugs <pgsql-b...@postgresql.org>; PostgreSQL Hackers <pgsql-hackers@postgresql.org>; T, Rasna (Nokia - IN/Bangalore) <rasn...@nokia.com>; Itnal, Prakash (Nokia - IN/Bangalore) <prakash.it...@nokia.com> Subject: Re: [HACKERS] Postgres process invoking exit

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-07 Thread K S, Sandhya (Nokia - IN/Bangalore)
/Bangalore) <prakash.it...@nokia.com> Subject: Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core On 7 July 2017 at 15:10, K S, Sandhya (Nokia - IN/Bangalore) <sandhya@nokia.com<mailto:sandhya@nokia.com>> wrote: Hi Craig, You were right about the restore_comman

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-07 Thread Craig Ringer
On 7 July 2017 at 15:41, K S, Sandhya (Nokia - IN/Bangalore) < sandhya@nokia.com> wrote: > Hi Craig, > > > > The scenario is lock and unlock of the system for 30 times. During this > scenario 5 sh-QUIT core is generated. GDB of 5 core is pointing to > different locations. > > I have attached

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-07 Thread Craig Ringer
On 7 July 2017 at 15:10, K S, Sandhya (Nokia - IN/Bangalore) < sandhya@nokia.com> wrote: > Hi Craig, > > > > You were right about the restore_command. > This all makes sense then. PostgreSQL sends SIGQUIT for immediate shutdown to its children. So the restore_command would get signalled

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-05 Thread Craig Ringer
On 3 Jul. 2017 23:01, "K S, Sandhya (Nokia - IN/Bangalore)" < sandhya@nokia.com> wrote: 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 shell to exit and may not be due to kernel or file

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-07-03 Thread K S, Sandhya (Nokia - IN/Bangalore)
ackers@postgresql.org; pgsql-b...@postgresql.org; T, Rasna (Nokia - IN/Bangalore) <rasn...@nokia.com>; Itnal, Prakash (Nokia - IN/Bangalore) <prakash.it...@nokia.com> Subject: Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core On 30 June 2017 at 17:41, K S, Sandhya (No

Re: [HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-06-30 Thread Craig Ringer
On 30 June 2017 at 17:41, K S, Sandhya (Nokia - IN/Bangalore) 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

[HACKERS] Postgres process invoking exit resulting in sh-QUIT core

2017-06-30 Thread K S, Sandhya (Nokia - IN/Bangalore)
Hi, We are using Postgres version 9.3.14 over linux based OS and we are observing sh-QUIT core files randomly when we are restarting the system(occurrence seen once in 30 times). Backtrace is showing as below: Loaded symbols for /lib64/ld.so.1 Core was generated by `sh -c exit 1'. Program