Three collection tool for Greenplum:pstack, Strace, Gcore.
[Email protected] ~]$ Ps-ef | grep postgres|grep data|grep master|grep-v grep
Gpadmin 3653 1 0 May21? 00:00:00/usr/local/greenplum-db-4.2.5.2/bin/postgres-d/data/master/gpseg-1-P 5432-b 1-z 2--silent-mode=true-i m Aster-c -1-x 0-E
[Email protected] ~]$ Pstack 3653
#0 0x00000034104ce183 in __select_nocancel () from/lib64/libc.so.6
#1 0x000000000087a63b in Postmastermain ()
#2 0x000000000077ff3a in Main ()
Copy the output to a file,or usage:pstack 3653 >pstack-gp.txt.
[Email protected] ~]$ strace-p 3653
Process 3653 Attached-interrupt to quit
Select (5, [3 4], NULL, NULL, {7, 897000}) = 0 (Timeout)
Rt_sigprocmask (Sig_setmask, ~[ill TRAP ABRT BUS FPE SEGV CONT SYS rtmin rt_1], NULL, 8) = 0
Rt_sigprocmask (Sig_setmask, [], NULL, 8) = 0
Select (5, [3 4], NULL, NULL, {0} <unfinished ...>
Process 3653 Detached
You must hole for at least-seconds and use "Ctrl + C" to terminate. Copy the output to a file.
[Email protected] ~]$ Gcore 3653
' Import site ' failed; Use-v for Traceback
Traceback (most recent):
File "<string>", line +, in?
Importerror:no module named Os.path
[Thread debugging using libthread_db enabled]
Warning:no loadable sections found in added Symbol-file system-supplied DSO at 0x7fffea126000
0x00000034104ce183 in __select_nocancel () from/lib64/libc.so.6
Saved Corefile core.3653
-eof-
Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.
About Greenplum Collection Tool
