[PROFRAME] TPERROR 13 해결 과정

단건 조회 서비스 호출시 webT timeout 에러가 떨어졌다.  

tmax 서비스 카운트 조회 결과  cnt값이 0.  즉 호출이 되지 않았다는 것이다. 
DB 세션이 끊겨 WEBT 에러가 호출되는 원인은 네트웍 문제가 가장 크다.  
1.195 서버에서 179.161에 있는 DB에 붙어 가져 오려하니 세션이 끊기는 현상 발생. 

도메인이 달라서 그렇다.   pfm5c 계정은 10G를 사용하는데   1.86  즉 ,  같은 도메인에 존재하기 때문에 세션이 끊기는 현상은 발생하지 않았다는 것이다. 

이런 현상을 제거 하기 위해선  1.XXX 서버에 오라클 12C를 설치를 해줘서 DB 를 바꿔주어야 해결이 되는 부분이다. 

$echo st -p TPFMIPPR | tmadmin  

tmadmin에서  해당 서비스의 상태를 확인한다.    


   ---------------------------------------------------------------------------
   svr_name     svgname     spr_no     status      count        avg        svc

   ---------------------------------------------------------------------------
   TPFMIPPR     svg1            37        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            38        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            39        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            40        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            41        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            42        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            43        RUN          0      0.000   SPFMIPPR

   TPFMIPPR     svg1            44        RDY          0      0.000         -1

   TPFMIPPR     svg1            45        RDY          0      0.000         -1

   TPFMIPPR     svg1            46        RDY          0      0.000         -1
   
매번 timeout이 떨어져 블록타임이 지났음에도 불구하고 서비스들의 상태가 RUN인 모습. 


$echo st -p TPFMIPPR -x | tmadmin 

CLH 0: 
   ---------------------------------------------------------------------------
   svr_name     svgname     spr_no     status      count        avg        svc
                    PID   fail_cnt    err_cnt   min_time   max_time
                  utime  umin_time  umax_time      stime  smin_time  smax_time

   ---------------------------------------------------------------------------
   TPFMIPPR     svg1            37        RDY          0      0.000         -1
                   3693          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            38        RUN          0      0.000   SPFMIPPR
                  25975          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            39        RUN          0      0.000   SPFMIPPR
                  25976          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            40        RUN          0      0.000   SPFMIPPR
                  25974          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            41        RUN          0      0.000   SPFMIPPR
                  25973          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            42        RUN          0      0.000   SPFMIPPR
                  25977          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            43        RUN          0      0.000   SPFMIPPR
                  25979          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            44        RDY          0      0.000         -1
                  25972          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            45        RDY          0      0.000         -1
                  25978          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   TPFMIPPR     svg1            46        RDY          0      0.000         -1
                  25971          0          0      0.000      0.000
                     0.000      0.000      0.000      0.000      0.000      0.000

   ---------------------------------------------------------------------------
   
   
   상태가 RUN인 IPPR 녀석들중 마지막놈의 PID를 확인해 보아야 했다.  
   
   $strace -p 25979
    Process 25979 attached
read(8, 
   
   8번에서 원인 발생 
   
   $lsof -p 25979

TPFMIPPR 25979  8u  IPv4           92673440       0t0       TCP FWDEV:40091->192.168.179.161:ncube-lm (ESTABLISHED)

TMAX의 문제 인줄 알고 생각했지만 , 
확인 결과 DB에 붙는 과정에서 문제가 됨을 확인하였다.