{"action":"closed","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/289","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/289/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/289/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/289/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/289","id":74939212,"number":289,"title":"1.4 LOAD DATA INFILE出错","user":{"login":"ggggggggod","id":6489870,"avatar_url":"https://avatars.githubusercontent.com/u/6489870?v=3","gravatar_id":"","url":"https://api.github.com/users/ggggggggod","html_url":"https://github.com/ggggggggod","followers_url":"https://api.github.com/users/ggggggggod/followers","following_url":"https://api.github.com/users/ggggggggod/following{/other_user}","gists_url":"https://api.github.com/users/ggggggggod/gists{/gist_id}","starred_url":"https://api.github.com/users/ggggggggod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ggggggggod/subscriptions","organizations_url":"https://api.github.com/users/ggggggggod/orgs","repos_url":"https://api.github.com/users/ggggggggod/repos","events_url":"https://api.github.com/users/ggggggggod/events{/privacy}","received_events_url":"https://api.github.com/users/ggggggggod/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-05-10T15:19:46Z","updated_at":"2015-05-12T14:48:37Z","closed_at":"2015-05-12T14:48:37Z","body":"我的file内容是：\r\n964509 1426749300 698 89114767 17 152129\r\n964509 1426749300 480 106520088 13 152129\r\n964509 1426749300 2768 492330311 20 152129\r\n964509 1426749300 390 49319705 21 152129\r\n964509 1426749300 252 72952676 18 152129\r\n964509 1426749300 163 40324348 30 152129\r\n964509 1426749300 415 55857747 22 152129\r\n在load data的时候一直报错：\r\nmysql> LOAD DATA INFILE '/tmp/user.txt' IGNORE INTO TABLE table1(a,b,c,d,e,f) FIELDS TERMINATED BY '\\t';\r\nERROR 2006 (HY000): MySQL server has gone away\r\nNo connection. Trying to reconnect...\r\nConnection id: 1\r\nCurrent database: user\r\nERROR 3009 (HY000): For input string: \"09 142674\"\r\n使用空格分隔字符 为何把09 142674当成一个字符\r\n\r\n\r\n05/10 23:13:29.373 ERROR $_NIOREACTOR-12-RW -load data error\r\njava.lang.NumberFormatException: For input string: \"09 142674\"\r\nat java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)\r\nat java.lang.Integer.parseInt(Integer.java:492)\r\nat java.math.BigInteger.(BigInteger.java:327)\r\nat java.math.BigInteger.(BigInteger.java:445)\r\nat org.opencloudb.route.function.PartitionByMod.calculate(PartitionByMod.java:61)\r\nat org.opencloudb.route.util.RouterUtil.findRouteWithcConditionsForTables(RouterUtil.java:758)\r\nat org.opencloudb.route.util.RouterUtil.tryRouteForOneTable(RouterUtil.java:658)\r\nat org.opencloudb.route.util.RouterUtil.tryRouteForTables(RouterUtil.java:542)\r\nat org.opencloudb.server.handler.ServerLoadDataInfileHandler.tryDirectRoute(ServerLoadDataInfileHandler.java:349)\r\nat org.opencloudb.server.handler.ServerLoadDataInfileHandler.parseOneLine(ServerLoadDataInfileHandler.java:382)\r\nat org.opencloudb.server.handler.ServerLoadDataInfileHandler.parseFileByLine(ServerLoadDataInfileHandler.java:680)\r\nat org.opencloudb.server.handler.ServerLoadDataInfileHandler.start(ServerLoadDataInfileHandler.java:214)\r\nat org.opencloudb.net.FrontendConnection.loadDataInfileStart(FrontendConnection.java:241)\r\nat org.opencloudb.server.ServerQueryHandler.query(ServerQueryHandler.java:112)\r\nat org.opencloudb.net.FrontendConnection.query(FrontendConnection.java:319)\r\nat org.opencloudb.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71)\r\nat org.opencloudb.net.FrontendConnection.rawHandle(FrontendConnection.java:456)\r\nat org.opencloudb.net.FrontendConnection.handle(FrontendConnection.java:434)\r\nat org.opencloudb.net.AbstractConnection.onReadData(AbstractConnection.java:305)\r\nat org.opencloudb.net.NIOSocketWR.asynRead(NIOSocketWR.java:186)\r\nat org.opencloudb.net.AbstractConnection.asynRead(AbstractConnection.java:267)\r\nat org.opencloudb.net.NIOReactor$RW.run(NIOReactor.java:96)\r\nat java.lang.Thread.run(Thread.java:745)"}}