Guest User

Untitled

a guest
Apr 13th, 2017
109
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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 ...>
RAW Paste Data