Mr_Zlover 2017-12-01 05:19
浏览 1949

Mycat load data infile总是失败,不知道什么原因,求大神解答

mycat采用load data infile方法数据迁移,过程中报错,日志如下:
2017-12-01 11:48:39.919 WARN $_NIOREACTOR-2-RW) - caught err:
java.lang.NullPointerException
at io.mycat.net.AbstractConnection.checkWriteBuffer(AbstractConnection.java:456) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.mysql.BinaryPacket.write(BinaryPacket.java:68) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.LoadDataUtil.writeToBackConnection(LoadDataUtil.java:94) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.LoadDataUtil.requestFileDataResponse(LoadDataUtil.java:50) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler.requestDataResponse(MultiNodeQueryHandler.java:734) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleRequestPacket(MySQLConnectionHandler.java:179) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleData(MySQLConnectionHandler.java:101) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.handler.BackendAsyncHandler.offerData(BackendAsyncHandler.java:36) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handle(MySQLConnectionHandler.java:80) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.handle(AbstractConnection.java:263) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102) ~[Mycat-server-1.6-RELEASE.jar:?]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_80]
2017-12-01 11:48:39.948 INFO $_NIOREACTOR-2-RW) - close connection,reason:program err:java.lang.NullPointerException ,MySQLConnection [id=6, lastTime=1512100119275, user=root, schema=log_db_2017-11, old shema=log_db_2017-11, borrowed=true, fromSlaveDB=false, threadId=58, charset=gbk, txIsolation=3, autocommit=true, attachment=dn8{LOAD DATA LOCAL INFILE 'C:\Users\User\Desktop\log_file_manage_4-9.txt' INTO TABLE log_file_manage CHARACTER SET 'utf8' COLUMNS ESCAPED BY '%' (uuid, client_number, customer_id, decode_flag, analysis_flag, file_name, file_path, upload_time, sys_number, sys_name, sys_path, sys_version, result, operate_time, line_begin, line_end, vdi_info)}, respHandler=io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler@4c156b4b, host=localhost, port=3306, statusSync=io.mycat.backend.mysql.nio.MySQLConnection$StatusSync@12372ff3, writeQueue=0, modifiedSQLExecuted=true]
2017-12-01 11:48:40.254 WARN $_NIOREACTOR-2-RW) - caught err:
java.lang.NullPointerException
at io.mycat.net.AbstractConnection.writeToBuffer(AbstractConnection.java:475) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.write(AbstractConnection.java:417) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.LoadDataUtil.requestFileDataResponse(LoadDataUtil.java:62) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler.requestDataResponse(MultiNodeQueryHandler.java:734) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleRequestPacket(MySQLConnectionHandler.java:179) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleData(MySQLConnectionHandler.java:101) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.handler.BackendAsyncHandler.offerData(BackendAsyncHandler.java:36) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handle(MySQLConnectionHandler.java:80) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.handle(AbstractConnection.java:263) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273) ~[Mycat-server-1.6-RELEASE.jar:?]
at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102) ~[Mycat-server-1.6-RELEASE.jar:?]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_80]

哪位大神能帮忙看看,不尽感谢。
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 基于卷积神经网络的声纹识别
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 stm32开发clion时遇到的编译问题