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]
哪位大神能帮忙看看,不尽感谢。