{"id":649,"date":"2015-04-05T22:30:02","date_gmt":"2015-04-06T07:30:02","guid":{"rendered":"http:\/\/blog.box.kr\/?p=649"},"modified":"2015-04-05T22:30:02","modified_gmt":"2015-04-06T07:30:02","slug":"%ed%8e%8ctomcat7-tomcat-jdbc-%ec%84%a4%ec%a0%95-broken-pipe-%ec%97%90%eb%9f%ac-%ed%9a%8c%ed%94%bc","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=649","title":{"rendered":"[\ud38c]Tomcat7 tomcat-jdbc \uc124\uc815 – Broken pipe \uc5d0\ub7ec \ud68c\ud53c"},"content":{"rendered":"

tomcat-jdbc\ub85c MySQL\uc5d0 \uc5f0\uacb0\ud55c \uacbd\uc6b0 “java.net.SocketException: Broken pipe” \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\ub97c \uac00\ub054 \ubcfc \uc218 \uc788\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 connection idle time\uc774 MySQL\uc5d0 \uc124\uc815\ub41c wait_timeout\uc744 \uc9c0\ub098\uc11c DB\uc5d0\uc11c \uc5f0\uacb0\uc744 \ub04a\uc740 \uac83\uc774\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\ub824\uba74 connection\uc774 \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 close\ub418\ub3c4\ub85d \uc124\uc815\ud558\uac70\ub098 connection \ub300\uc5ec\uc2dc\uc5d0 connection\uc744 \uccb4\ud06c\ud558\ub3c4\ub85d \ud558\uba74 \ub41c\ub2e4.<\/p>\n

\uc124\uc815 1<\/b> – \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 connection\uc744 \ud14c\uc2a4\ud2b8<\/p>\n

validationQuery=”SELECT 1″<\/p>\n

testWhileIdle=”true”<\/p>\n

minEvictableIdleTimeMillis=”3600000″<\/p>\n

timeBetweenEvictionRunsMillis=”60000″<\/p>\n

(*) DB\uc5d0 \ucffc\ub9ac\ub97c \ud558\uae30 \ub54c\ubb38\uc5d0 \uc774 \ub54c\ub9c8\ub2e4 DB\uc758 session idle time\uc774 \uac31\uc2e0\ub41c\ub2e4. \ub9cc\uc57d connection\uc774 \uc774\ubbf8 \ub04a\uacbc\ub2e4\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud560\ud14c\uace0 \ud574\ub2f9 connection\uc740 pool\uc5d0\uc11c \uc81c\uac70\ub41c\ub2e4.<\/p>\n

(*) timeBetweenEvictionRunsMillis\uc758 \uae30\ubcf8\uac12\uc740 5000 (5\ucd08)\uc774\uace0,\u00a0minEvictableIdleTimeMillis\uc758 \uae30\ubcf8\uac12\uc740\u00a060000 (60\ucd08)\uc774\ub2e4.\u00a0minEvictableIdleTimeMillis \uac12\uc740 MySQL\uc5d0 \uc124\uc815\ub41c wait_timeout\uc774\ub098 \ubc29\ud654\ubcbd\uc5d0 \uc124\uc815\ub41c session timeout \uac12\ubcf4\ub2e4 \uc791\uc544\uc57c \ud55c\ub2e4.<\/p>\n

\uc124\uc815 2<\/b> – connection \ub300\uc5ec \uc2dc \ud14c\uc2a4\ud2b8<\/p>\n

validationQuery=”SELECT 1″<\/p>\n

testOnBorrow=”true”<\/p>\n

(*) \ub9e4\ubc88 connection \ub300\uc5ec \uc2dc \ub9c8\ub2e4 \uccb4\ud06c\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ub2e4. \uccb4\ud06c \ud55c connection\uc740 validationInterval \uae30\uac04 \uc548\uc5d0\ub294 \ub2e4\uc2dc \uccb4\ud06c\ud558\uc9c0 \uc54a\ub294\ub2e4. validationInterval\uc758 \uae30\ubcf8\uac12\uc740 30000 (30\ucd08).<\/p>\n

\uc124\uc815 3<\/b> – \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 connection\uc744 close<\/p>\n

minIdle=”0″<\/p>\n

\uc124\uc815 1\uc744 \uc0ac\uc6a9\ud55c JDBC Resource \uc124\uc815 \uc608<\/p>\n\n\n\n\n
\u00a0context.xml<\/td>\n<\/tr>\n
\u00a0<?xml version=”1.0″ encoding=”UTF-8″?><Context>\n

<Resource name=”jdbc\/testDB” auth=”Container” type=”javax.sql.DataSource”<\/p>\n

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”<\/p>\n

driverClassName=”com.mysql.jdbc.Driver”<\/p>\n

url=”jdbc:mysql:\/\/localhost\/smartconnect?useUnicode=true&amp;characterEncoding=utf8″<\/p>\n

username=”username”<\/p>\n

password=”password”<\/p>\n

initialSize=”10″<\/p>\n

minIdle=”10″<\/p>\n

maxIdle=”50″<\/p>\n

maxActive=”50″<\/p>\n

maxWait=”5000″<\/p>\n

validationQuery=”SELECT 1″<\/p>\n

validationInterval=”30000″<\/p>\n

testWhileIdle=”true” \/><\/p>\n

<\/Context><\/p><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

tomcat-jdbc PoolCleaner \ub3d9\uc791<\/b><\/p>\n

PoolCleaner thread\ub294\u00a0timeBetweenEvictionRunsMillis \ub9cc\ud07c sleep\ud558\ub2e4 idle\/abandoned connection\uc744 \uccb4\ud06c\ud55c\ub2e4.<\/p>\n