고객지원

기술지원 문의

  • 솔인시스템의 전문적인 지원을 받아보실 수 있습니다.

soket을 연결하지 못하는 오류가 발생합니다.
최병희 / 2003-03-18 00:00

jdbc 드라이버를 통하여 MSSQL 서버에 접속한다던지.
다른 곳에 접속하는 과정에 소켓에러가 발생합니다.
ex)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

javax.naming.CommunicationException: 127.0.0.1:389.  Root exception is java.net.BindException

지속적으로 발생하는것은 아니고 순간적으로 발생했다가 안했다가 합니다.
MSSQL은 레진과 같은 머신에 있습니다.

그리고 netstat  결과 
  Proto  Local Address          Foreign Address        State
  TCP    10.170.130.68:80       10.170.130.155:1094    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.130.208:1182    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.130.218:1068    TIME_WAIT
  TCP    10.170.130.68:80       10.170.131.28:3749     FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.131.132:1078    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.131.238:1077    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.131.251:3977    ESTABLISHED
  TCP    10.170.130.68:80       10.170.132.154:1641    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.132.177:1644    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.132.215:1073    ESTABLISHED
  TCP    10.170.130.68:80       10.170.132.228:4811    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.132.251:1098    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.133.239:1048    ESTABLISHED
  TCP    10.170.130.68:80       10.170.133.249:2059    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.135.81:1606     ESTABLISHED
  TCP    10.170.130.68:80       10.170.135.233:1331    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.135.237:1050    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.135.243:1134    FIN_WAIT_2

처럼 FIN_WAIT_2와 TIME_WAIT상태가 상당히 빈번합니다.

해결방안 부탁드립니다.
급하니 꼭 답변해 주세요~~

Re:soket을 연결하지 못하는 오류가 발생합니다.
관리자 / 2003-03-18 00:00

FIN_WAIT2가 netstat -an 과 같은 명령을 실행했을 때
나타나는 것 자체가 문제는 아니라고 생각합니다.
그것은 TCP session이 끊어지는 과정 중의 한 상태에
지나지 않으니까요.
다만 동일한 놈이 오랫동안 지속된다면 문제가 있는 거죠.

MSSQL쪽은 단순히 연결을 못한다는 메세지가지고는
잘 모르겠네요. 다만 FIN_WAIT2와 관계가 있을 수 있다는
정도의 유추정도 이외는...

389번 포트가 메세지에 나타나는 것을 보면
LDAP을 이용하고 계신가요?



--최병희 님의 글 [2003-03-18 09:47:30]
>jdbc 드라이버를 통하여 MSSQL 서버에 접속한다던지.
다른 곳에 접속하는 과정에 소켓에러가 발생합니다.
ex)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

javax.naming.CommunicationException: 127.0.0.1:389.  Root exception is java.net.BindException

지속적으로 발생하는것은 아니고 순간적으로 발생했다가 안했다가 합니다.
MSSQL은 레진과 같은 머신에 있습니다.

그리고 netstat  결과 
  Proto  Local Address          Foreign Address        State
  TCP    10.170.130.68:80       10.170.130.155:1094    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.130.208:1182    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.130.218:1068    TIME_WAIT
  TCP    10.170.130.68:80       10.170.131.28:3749     FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.131.132:1078    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.131.238:1077    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.131.251:3977    ESTABLISHED
  TCP    10.170.130.68:80       10.170.132.154:1641    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.132.177:1644    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.132.215:1073    ESTABLISHED
  TCP    10.170.130.68:80       10.170.132.228:4811    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.132.251:1098    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.133.239:1048    ESTABLISHED
  TCP    10.170.130.68:80       10.170.133.249:2059    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.135.81:1606     ESTABLISHED
  TCP    10.170.130.68:80       10.170.135.233:1331    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.135.237:1050    FIN_WAIT_2
  TCP    10.170.130.68:80       10.170.135.243:1134    FIN_WAIT_2

처럼 FIN_WAIT_2와 TIME_WAIT상태가 상당히 빈번합니다.

해결방안 부탁드립니다.
급하니 꼭 답변해 주세요~~