Guest User

Untitled

a guest
Apr 13th, 2017
43
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [root@tvr1-pgm-svp-01 ~]# ss -tenp | grep 18216
  2. ESTAB 0 0 10.69.64.164:5432 10.69.64.118:63458 timer:(keepalive,1.634ms,0) users:(("postgres",18216,11)) uid:26 ino:1372166028 sk:ffff880253ff2580 <->
  3.  
  4. postgres=# select * from pg_stat_activity where pid = 18216;
  5. -[ RECORD 1 ]----+--------------------------------------------------------------------------------------------------------------------------
  6. datid | 26014
  7. datname | svp
  8. pid | 18216
  9. usesysid | 17822
  10. usename | svp
  11. application_name | Passenger RubyApp: /var/www/rc-simple-print/current/public
  12. client_addr | 10.69.64.118
  13. client_hostname |
  14. client_port | 63458
  15. backend_start | 2017-04-12 22:02:03.274406+00
  16. xact_start | 2017-04-12 22:02:03.341284+00
  17. query_start | 2017-04-12 22:03:19.092631+00
  18. state_change | 2017-04-12 22:03:19.092632+00
  19. waiting | f
  20. state | active
  21. backend_xid |
  22. backend_xmin |
  23. query | SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = to_regclass('"route_card_points"') AND c.relpersistence = 'u'
  24.  
  25. postgres=# \q
  26.  
  27. [root@tvr1-pgm-svp-01 etc]# gdb -p 18216 /usr/pgsql-9.4/bin/postgres
  28. GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-80.el7
  29. Copyright (C) 2013 Free Software Foundation, Inc.
  30. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
  31. This is free software: you are free to change and redistribute it.
  32. There is NO WARRANTY, to the extent permitted by law. Type "show copying"
  33. and "show warranty" for details.
  34. This GDB was configured as "x86_64-redhat-linux-gnu".
  35. For bug reporting instructions, please see:
  36. <http://www.gnu.org/software/gdb/bugs/>...
  37. Reading symbols from /usr/pgsql-9.4/bin/postgres...
  38.  
  39.  
  40. Missing separate debuginfos, use: debuginfo-install postgresql94-server-9.4.5-2PGDG.rhel7.x86_64
  41. (gdb)
  42. (gdb)
  43. (gdb) bt
  44. #0 0x00007fa0155f006d in recv () from /lib64/libc.so.6
  45. #1 0x00000000005b9f74 in secure_read ()
  46. #2 0x00000000005c2c1b in pq_recvbuf ()
  47. #3 0x00000000005c3815 in pq_getbyte ()
  48. #4 0x000000000067d9e5 in PostgresMain ()
  49. #5 0x00000000004629c1 in ServerLoop ()
  50. #6 0x000000000062db46 in PostmasterMain ()
  51. #7 0x0000000000463609 in main ()
  52. (gdb) q
  53. A debugging session is active.
  54.  
  55. Inferior 1 [process 18216] will be detached.
  56.  
  57. [root@tvr1-pgm-svp-01 etc]# ls /proc/18216/fd/ -la
  58. total 0
  59. dr-x------ 2 postgres postgres 0 Apr 13 10:18 .
  60. dr-xr-xr-x 8 postgres postgres 0 Apr 13 01:02 ..
  61. lr-x------ 1 postgres postgres 64 Apr 13 10:18 0 -> /dev/null
  62. l-wx------ 1 postgres postgres 64 Apr 13 10:18 1 -> pipe:[164143434]
  63. lrwx------ 1 postgres postgres 64 Apr 13 10:18 10 -> socket:[164143436]
  64. lrwx------ 1 postgres postgres 64 Apr 13 10:18 11 -> socket:[1372166028]
  65. lrwx------ 1 postgres postgres 64 Apr 13 10:18 12 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11950060
  66. lrwx------ 1 postgres postgres 64 Apr 13 10:18 13 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11947958_vm
  67. lrwx------ 1 postgres postgres 64 Apr 13 10:18 19 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11947837
  68. l-wx------ 1 postgres postgres 64 Apr 13 10:18 2 -> pipe:[164143434]
  69. lrwx------ 1 postgres postgres 64 Apr 13 10:18 20 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11950002
  70. lrwx------ 1 postgres postgres 64 Apr 13 10:18 21 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11950003
  71. lr-x------ 1 postgres postgres 64 Apr 13 10:18 3 -> pipe:[1372167704]
  72. l-wx------ 1 postgres postgres 64 Apr 13 10:18 4 -> pipe:[1372167704]
  73. lrwx------ 1 postgres postgres 64 Apr 13 10:18 5 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/16897493
  74. lrwx------ 1 postgres postgres 64 Apr 13 10:18 6 -> /var/lib/pgsql/9.4/data/global/43011
  75. lr-x------ 1 postgres postgres 64 Apr 13 10:18 7 -> pipe:[164143433]
  76. lrwx------ 1 postgres postgres 64 Apr 13 10:18 8 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11947958
  77. lrwx------ 1 postgres postgres 64 Apr 13 10:18 9 -> /pg/pgdata/tbsdata/PG_9.4_201409291/26014/11950059
  78. [root@tvr1-pgm-svp-01 etc]# strace -p 18216
  79. Process 18216 attached
  80. recvfrom(11, ^CProcess 18216 detached
  81. <detached ...>
RAW Paste Data