API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 13th, 2017
174
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.09 KB | None | 0 0
raw download clone embed print report
  1. [root@svp-pgpool-03 ~]# ss -tenp | grep 63458
  2. ESTAB 0 0 10.69.64.118:63458 10.69.64.164:5432 users:(("pgpool",27928,8)) ino:165249694 sk:ffff8803d5f64b00 <->
  3. [root@svp-pgpool-03 ~]# s^C
  4. [root@svp-pgpool-03 ~]# ss -tenp | grep 27928
  5. ESTAB 0 0 10.69.64.118:5432 10.69.76.184:13159 timer:(keepalive,5min17sec,0) users:(("pgpool",27928,7)) ino:165244851 sk:ffff8803d5f62580 <->
  6. ESTAB 0 0 10.69.64.118:19044 10.69.64.235:5432 users:(("pgpool",27928,12)) ino:165249697 sk:ffff8800acacda00 <->
  7. ESTAB 0 0 10.69.64.118:63458 10.69.64.164:5432 users:(("pgpool",27928,8)) ino:165249694 sk:ffff8803d5f64b00 <->
  8.  
  9. [root@svp-pgpool-03 ~]# pcp_proc_info --verbose -U postgres 27928
  10. Password:
  11. Database : svp
  12. Username : svp
  13. Start time : 2017-04-13 01:00:26
  14. Creation time: 2017-04-13 01:02:03
  15. Major : 3
  16. Minor : 0
  17. Counter : 1
  18. Backend PID : 18216
  19. Connected : 1
  20. Database : svp
  21. Username : svp
  22. Start time : 2017-04-13 01:00:26
  23. Creation time: 2017-04-13 01:02:03
  24. Major : 3
  25. Minor : 0
  26. Counter : 1
  27. Backend PID : 18306
  28. Connected : 1
  29.  
  30.  
  31. [root@svp-pgpool-03 ~]# ls /proc/27928/fd -la
  32. total 0
  33. dr-x------ 2 root root 0 Apr 13 09:54 .
  34. dr-xr-xr-x 8 root root 0 Apr 13 01:00 ..
  35. lr-x------ 1 root root 64 Apr 13 09:54 0 -> /dev/null
  36. lrwx------ 1 root root 64 Apr 13 09:54 1 -> socket:[151701582]
  37. lrwx------ 1 root root 64 Apr 13 09:54 10 -> socket:[151693058]
  38. lrwx------ 1 root root 64 Apr 13 09:54 11 -> socket:[165052505]
  39. lrwx------ 1 root root 64 Apr 13 09:54 12 -> socket:[165249697]
  40. lrwx------ 1 root root 64 Apr 13 09:54 2 -> socket:[151701582]
  41. lr-x------ 1 root root 64 Apr 13 09:54 3 -> /etc/pgpool-II/pool_passwd
  42. lrwx------ 1 root root 64 Apr 13 09:54 4 -> socket:[151693048]
  43. lrwx------ 1 root root 64 Apr 13 09:54 5 -> socket:[151693053]
  44. lrwx------ 1 root root 64 Apr 13 09:54 6 -> socket:[151693054]
  45. lrwx------ 1 root root 64 Apr 13 09:54 7 -> socket:[165244851]
  46. lrwx------ 1 root root 64 Apr 13 09:54 8 -> socket:[165249694]
  47. lrwx------ 1 root root 64 Apr 13 09:54 9 -> socket:[151693056]
  48. You have new mail in /var/spool/mail/root
  49. [root@svp-pgpool-03 ~]# strace -p 27928
  50. Process 27928 attached
  51. select(13, [7 8 12], [], [7 8 12], {0, 955408}) = 0 (Timeout)
  52. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  53. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  54. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  55. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 1 (in [7], left {0, 633317})
  56. select(8, [7], NULL, [7], NULL) = 1 (in [7])
  57. read(7, "Q\0\0\0\rSELECT 1\0", 1024) = 14
  58. stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1502, ...}) = 0
  59. sendto(11, "<134>Apr 13 10:12:36 [27928]: [8"..., 129, MSG_NOSIGNAL, NULL, 0) = 129
  60. write(12, "Q\0\0\0\rSELECT 1\0", 14) = 14
  61. select(13, [12], NULL, [12], {30, 0}) = 1 (in [12], left {29, 999593})
  62. select(13, [12], NULL, [12], NULL) = 1 (in [12])
  63. read(12, "T\0\0\0!\0\1?column?\0\0\0\0\0\0\0\0\0\0\27\0\4\377\377\377\377"..., 1024) = 66
  64. write(7, "T\0\0\0!\0\1?column?\0\0\0\0\0\0\0\0\0\0\27\0\4\377\377\377\377"..., 34) = 34
  65. write(7, "D\0\0\0\v\0\1\0\0\0\0011C\0\0\0\rSELECT 1\0", 26) = 26
  66. rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], [], 8) = 0
  67. rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
  68. write(7, "Z\0\0\0\5I", 6) = 6
  69. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 1 (in [7], left {0, 998241})
  70. select(8, [7], NULL, [7], NULL) = 1 (in [7])
  71. read(7, "P\0\0\0o\0SELECT \"inf_sec_module_set"..., 1024) = 149
  72. stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1502, ...}) = 0
  73. sendto(11, "<134>Apr 13 10:12:36 [27928]: [8"..., 231, MSG_NOSIGNAL, NULL, 0) = 231
  74. write(12, "P\0\0\0o\0SELECT \"inf_sec_module_set"..., 112) = 112
  75. stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1502, ...}) = 0
  76. sendto(11, "<134>Apr 13 10:12:36 [27928]: [8"..., 130, MSG_NOSIGNAL, NULL, 0) = 130
  77. write(12, "B\0\0\0\16\0\0\0\0\0\0\0\1\0\0", 15) = 15
  78. stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1502, ...}) = 0
  79. sendto(11, "<134>Apr 13 10:12:36 [27928]: [8"..., 130, MSG_NOSIGNAL, NULL, 0) = 130
  80. write(12, "D\0\0\0\6P\0", 7) = 7
  81. stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1502, ...}) = 0
  82. sendto(11, "<134>Apr 13 10:12:36 [27928]: [8"..., 233, MSG_NOSIGNAL, NULL, 0) = 233
  83. write(12, "E\0\0\0\t\0\0\0\0\0", 10) = 10
  84. write(12, "H\0\0\0\4", 5) = 5
  85. select(13, [12], NULL, [12], NULL) = 1 (in [12])
  86. read(12, "1\0\0\0\0042\0\0\0\4T\0\0\0003\0\2code\0\0\0q\23\0\3\0\0\4\23"..., 1024) = 995
  87. write(7, "1\0\0\0\4", 5) = 5
  88. write(7, "2\0\0\0\4", 5) = 5
  89. write(7, "T\0\0\0003\0\2code\0\0\0q\23\0\3\0\0\4\23\377\377\0\0\0006\0\0va"..., 52) = 52
  90. write(7, "D\0\0\0006\0\2\0\0\0'session.consecutive_f"..., 933) = 933
  91. write(12, "S\0\0\0\4", 5) = 5
  92. select(13, [12], NULL, [12], NULL) = 1 (in [12])
  93. read(12, "Z\0\0\0\5I", 1024) = 6
  94. rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN RT_1], [], 8) = 0
  95. rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
  96. write(7, "Z\0\0\0\5I", 6) = 6
  97. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  98. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  99. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  100. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  101. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  102. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  103. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  104. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  105. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  106. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  107. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  108. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  109. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  110. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  111. select(13, [7 8 12], [], [7 8 12], {1, 0}) = 0 (Timeout)
  112. select(13, [7 8 12], [], [7 8 12], {1, 0}^CProcess 27928 detached
  113. <detached ...>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!