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 output for 2 such instance.
Regards, Sandhya From: Craig Ringer [mailto:cr...@2ndquadrant.com] Sent: Friday, July 07, 2017 12:55 PM To: K S, Sandhya (Nokia - IN/Bangalore) <sandhya....@nokia.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 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_command. This all makes sense then. PostgreSQL sends SIGQUIT for immediate shutdown to its children. So the restore_command would get signalled too. Can't immediately explain the exit code, and SIGQUIT should _not_ generate a core file. Can you show the result of attaching 'gdb' to the core file and running 'bt full' ? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
GDB of first instance of corefile. # gdb /bin/bash CFPU-1-7919-595e59a9-sh-QUIT.core GNU gdb (Wind River Linux G++ 4.4a-470) 7.2.50.20100908-cvs Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "mips64-wrs-linux-gnu". For bug reporting instructions, please see: <supp...@windriver.com>... Reading symbols from /bin/bash...(no debugging symbols found)...done. warning: core file may not match specified executable file. [New LWP 7919] Reading symbols from /lib64/libreadline.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libreadline.so.5 Reading symbols from /lib64/libhistory.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libhistory.so.5 Reading symbols from /lib64/libncurses.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libncurses.so.5 Reading symbols from /lib64/libdl.so.2...Reading symbols from /mnt/sysimg/usr/lib/debug/lib64/libdl-2.11.1.so.debug...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libc.so.6...Reading symbols from /mnt/sysimg/usr/lib/debug/lib64/libc-2.11.1.so.debug...done. done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/libtinfo.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libtinfo.so.5 Reading symbols from /lib64/ld.so.1...Reading symbols from /mnt/sysimg/usr/lib/debug/lib64/ld-2.11.1.so.debug...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/ld.so.1 Core was generated by `sh -c exit 1'. Program terminated with signal 3, Quit. #0 0x0000005558246a80 in _dl_lookup_symbol_x () from /lib64/ld.so.1 (gdb) bt full #0 0x0000005558246a80 in _dl_lookup_symbol_x () from /lib64/ld.so.1 No symbol table info available. #1 0x000000555824816c in _dl_relocate_object () from /lib64/ld.so.1 No symbol table info available. #2 0x000000555823fb6c in dl_main () from /lib64/ld.so.1 No symbol table info available. #3 0x0000005558254214 in _dl_sysdep_start () from /lib64/ld.so.1 No symbol table info available. #4 0x000000555823d1b0 in _dl_start_final () from /lib64/ld.so.1 No symbol table info available. #5 0x000000555823d3f0 in _dl_start () from /lib64/ld.so.1 No symbol table info available. #6 0x000000555823cc10 in __start () from /lib64/ld.so.1 No symbol table info available. Backtrace stopped: frame did not save the PC GDB of second instance of corefile. # gdb /bin/bash CFPU-1-15638-595e5efb-sh-QUIT.core GNU gdb (Wind River Linux G++ 4.4a-470) 7.2.50.20100908-cvs Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html> This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "mips64-wrs-linux-gnu". For bug reporting instructions, please see: <supp...@windriver.com>... Reading symbols from /bin/bash...(no debugging symbols found)...done. warning: core file may not match specified executable file. [New LWP 15638] Reading symbols from /lib64/libreadline.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libreadline.so.5 Reading symbols from /lib64/libhistory.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libhistory.so.5 Reading symbols from /lib64/libncurses.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libncurses.so.5 Reading symbols from /lib64/libdl.so.2...Reading symbols from /mnt/sysimg/usr/lib/debug/lib64/libdl-2.11.1.so.debug...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libc.so.6...Reading symbols from /mnt/sysimg/usr/lib/debug/lib64/libc-2.11.1.so.debug...done. done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/libtinfo.so.5...(no debugging symbols found)...done. Loaded symbols for /lib64/libtinfo.so.5 Reading symbols from /lib64/ld.so.1...Reading symbols from /mnt/sysimg/usr/lib/debug/lib64/ld-2.11.1.so.debug...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/ld.so.1 Core was generated by `sh -c exit 1'. Program terminated with signal 3, Quit. #0 0x000000555f18518c in _IO_file_read () from /lib64/libc.so.6 (gdb) bt full #0 0x000000555f18518c in _IO_file_read () from /lib64/libc.so.6 No symbol table info available. #1 0x000000555f185b0c in _IO_file_underflow () from /lib64/libc.so.6 No symbol table info available. #2 0x000000555f1869ec in _IO_default_uflow () from /lib64/libc.so.6 No symbol table info available. #3 0x000000555f178988 in _IO_getline_info () from /lib64/libc.so.6 No symbol table info available. #4 0x000000555f17e624 in fgets_unlocked () from /lib64/libc.so.6 No symbol table info available. #5 0x000000555f1f694c in phys_pages_info () from /lib64/libc.so.6 No symbol table info available. #6 0x000000555f1c17d8 in sysconf () from /lib64/libc.so.6 No symbol table info available. #7 0x000000555f1482a8 in qsort_r () from /lib64/libc.so.6 No symbol table info available. #8 0x0000000120013e18 in ?? () No symbol table info available. warning: GDB can't find the start of the function at 0x120013e17. GDB is unable to find the start of the function at 0x120013e17 and thus can't determine the size of that function's stack frame. This means that GDB may be unable to access that stack frame, or the frames below it. This problem is most likely caused by an invalid program counter or stack pointer. However, if you think GDB should simply search farther back from 0x120013e17 for code which looks like the beginning of a function, you can increase the range of the search using the `set heuristic-fence-post' command.
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
