天天看点

java.sql.SQLException: closed connection:program err:java.io.IOException: Connection reset by peer

java.sql.SQLException: closed connection:program err:java.io.IOException: Connection reset by peer con:MySQLConnection [id=8929, lastTime=1555412798809,  fromSlaveDB=false, threadId=1050, charset=utf8, txIsolation=3, autocommit=true, attachment=dn-zb071{LOAD DATA LOCAL INFILE '/mnt/dataasyn/user_label_temp_uni099_10934.csv' IGNORE  INTO TABLE PLT_USER_LABEL_0 CHARACTER SET 'UTF8' COLUMNS TERMINATED BY '' LINES TERMINATED BY '

' (ACCT_FEE, ACTIVITY_TYPE, AREA_NO, BA_N_01, BA_N_11, CHR_14, CHR_46, CH_C_03, CITY_ID, CUST_NAME, DATA_TYPE, DATE_ID, DEVICE_NUMBER, EXPIRE_SCORE, EXP_DATE, JIAZHI_FLAG, KD_ADDR_SIX_NAME, KD_BALANCE_FEE, KD_COMB_START_DATE, KD_DQ_MONTH, KD_IS_IPTV, KD_IS_KDDQXQ, KD_MANAGER_NAME, KD_PRODUCT_ID, KD_SERVICE_SUB_TYPE, KD_XQ_DATE, NUM_1, NUM_21, NUM_22, ONLINE_DUR_LVL, OWE_FEE, PAY_MODE, PRODUCT_BASE_CLASS, PRODUCT_NAME, PROV_ID, PR_B_05, RENT_FEE, SCORE_VALUE, SERVICE_TYPE, TENANT_ID, USER_ID, W3_PROD_ID_1, WENDING_FLAG, ZBPROV_ID)}, respHandl[email protected]6e3070af, statusSync=null, writeQueue=0, modifiedSQLExecuted=true]

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)

    at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:3781)

    at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3038)

    at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2288)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2681)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)

    at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)

    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)

    at com.bonc.busi.task.base.BusiTools.loadDataInMysql(BusiTools.java:556)

    at com.bonc.busi.task.base.BusiTools$$FastClassBySpringCGLIB$$1e5be478.invoke(<generated>)

    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)

    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)

    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)

    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)

    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)

    at com.bonc.busi.task.base.BusiTools$$EnhancerBySpringCGLIB$$6670cde3.loadDataInMysql(<generated>)

    at com.bonc.busi.service.func.AsynUserLabel.batchInMycat(AsynUserLabel.java:583)

    at com.bonc.busi.service.func.AsynUserLabel.handleData(AsynUserLabel.java:412)

    at com.bonc.busi.service.func.EntryThread.run(EntryThread.java:22)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

    at java.lang.Thread.run(Thread.java:722)

此异常通常为应用连接数据库时,数据库关闭或者重启导致,客户端连接关闭,待数据库恢复访问后,重新发起连接即可

继续阅读