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)}, respHandler=com.bonc.ads.backend.mysql.nio.handler.MultiNodeQueryHandler@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)

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

程序员lm

感谢您的支持,后续分享更多知识

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值