WAS ¿¡¼ DB·Î Á¢¼Ó ºÒ°¡ java.sql.SQLRecoverableException: IO Error: Connection reset
WAS¿¡¼ java.sql.SQLRecoverableException: IO Error: Connection reset °¡ ¹ß»ýÇÑ´Ù
Àå¾Ö»óȲ
WAS1, WAS2°¡ Àִµ¥
WAS2¿¡¼´Â batchÀÛ¾÷ÀÌ ºü¸£°Ô Àßµ¹°í
WAS1¿¡¼´Â batchÀÛ¾÷ÀÌ ´À¸®°í
JEUS¿¡¼ Ä¿³Ø¼ÇÇ® ÃʱâȽà Á¢¼Ó ¹®Á¦°¡ °£ÇæÀûÀ¸·Î ¹ß»ýÇÕ´Ï´Ù (Á¢¼ÓºÒ°¡ Çö»ó)
¿øÀκм®
sqlplusÀÌ¿ëÇÑ Á¢¼Ó connection loss´Â ¹ß»ýÇÏÁö ¾ÊÀ½
tnsping ÀÌ¿ë½Ã ping¿¡ ¹®Á¦´Â ¾øÀ½
JEUS¿£Áö´Ï¾î¿Í ÅëÈ, DB¿¡¼ Á¢¼ÓÀ» ²÷´Â °Í °°´Ù´Â ÀÇ°ß°ú ÇÔ²² ¾Æ·¡ ¿À·ù¸Þ½ÃÁö È®ÀÎ
¿À·ù³»¿ë java.sql.SQLRecoverableException: IO Error: Connection reset
¹®Á¦ÇØ°á
java.sql.SQLRecoverableException: IO Error: Connection reset
±âº»ÀûÀ¸·Î´Â DB¿Í Á¢¼ÓÀÌ ¹®Á¦°¡ ÀÖÀ»¶§ ¹ß»ýÇϳª À̹øÀå¾ÖÀÇ ¹®Á¦Á¡Àº ¾Æ·¡¿Í °°¾Ò´Ù
11g JDBC µå¶óÀ̹ö´Â »ç¿ë½Ã connect stringÀ» ¾ÏÈ£ÈÇϱâ À§Çؼ /dev/randomÀ» ÀÌ¿ë 40bytesÀÇ ³¼ö¸¦ »ý¼ºÇÏ¿© connect stringÀ» ¾ÏÈ£È Çϴµ¥ /dev/randomÀº º¯µ¿(noise)ÀÌ ÀûÀº ½Ã½ºÅÛ¿¡¼´Â ³¼ö »ý¼ºÀÌ Áß´Ü(block)µÈ´Ù ´Â ¹®Á¦Á¡ÀÌ ¹ß»ý (ÂüÁ¶ 2.1, 2.2) /dev/randomÀÇ OS level¹®Á¦ ¶§¹®¿¡ ½Ã½ºÅÛÀÌ Á¶¿ëÇϸé /dev/randomÀÌ¿ëÇÑ ³¼ö »ý¼ºÀÌ ¿øÈ°ÇÏÁö ¾Ê°í, ³¼ö»ý¼ºÀÌ ¾ÈµÇ¾î 11g JDBC»ç¿ëÀ» ÇÊ¿ä·Î ÇÒ¶§ noise°¡ Àû¾î /dev/randomÀ¸·ÎºÎÅÍ 40byteÀÇ ³¼ö¸¦ ¾òÁö ¸øÇÑ JDBC´Â connect stringÀ» ¾ÏÈ£È ÇÏÁö ¸øÇÏ°í ¾ÏȣȰ¡ µÇÁö ¾Ê¾Æ µðºñÁ¢¼ÓÀ» ¸øÇؼ JDBC»ç¿ë½Ã Á¢¼ÓºÒ°¡ Àå¾Ö°¡ ¹ß»ýÇÑ °ÍÀ¸·Î È®ÀÎÀÌ µÊ.
urandomÀº random°ú ´Þ¸® entropy pool »óȲ¿¡ »ó°ü¾øÀÌ ³¼ö»ý¼ºÀÌ µÇ¹Ç·Î JDBCµå¶óÀ̹ö »ç¿ë½Ã ȤÀº WAS ±¸µ¿½Ã ¸í½ÃÀûÀ¸·Î -Djava.security.egd=file:///dev/urandom À̶ó´Â ÀڹٿɼÇÀ» ºÎ¿©ÇÏ¿© (ÂüÁ¶ 1.1)
/dev/random ´ë½Å /dev/urandomÀ» °Á¦ÀûÀ¸·Î »ç¿ëÀ» ÇÏ¸é ½Ã½ºÅÛ noise°¡ ¾ø¾îµµ Ç×»ó ³¼ö »ý¼ºÀÌ µÇ¾î JDBC¸¦ ÀÌ¿ëÇÑ Á¢¼Ó½Ã ¹®Á¦°¡ ¹ß»ýÇÏÁö ¾ÊÀ½
ÂüÁ¶
1.1 http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs-blocked-by-devrandom-entropy-pool-empty/
2.1 http://www.cl.cam.ac.uk/cgi-bin/manpage?4+random // when read ºÎÅÍ instead ±îÁö
2.2 http://www.joinc.co.kr/modules/moniwiki/wiki.php/Site/system_programing/Unix_Env/random // 2.3.1Àý
Ãâó: http://opendatabase.tistory.com/entry/WAS-¿¡¼-DB·Î-Á¢¼Ó-ºÒ°¡-javasqlSQLRecoverableException-IO-Error-Connection-reset [Opendatabase]