{"action":"created","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/211","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/211/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/211/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/211/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/211","id":66842053,"number":211,"title":"按照mycat _in_action 第一次插入 insert into orders(id,customer_id) values(2,2); 报错","user":{"login":"luotianwen","id":3388191,"avatar_url":"https://avatars.githubusercontent.com/u/3388191?v=3","gravatar_id":"","url":"https://api.github.com/users/luotianwen","html_url":"https://github.com/luotianwen","followers_url":"https://api.github.com/users/luotianwen/followers","following_url":"https://api.github.com/users/luotianwen/following{/other_user}","gists_url":"https://api.github.com/users/luotianwen/gists{/gist_id}","starred_url":"https://api.github.com/users/luotianwen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luotianwen/subscriptions","organizations_url":"https://api.github.com/users/luotianwen/orgs","repos_url":"https://api.github.com/users/luotianwen/repos","events_url":"https://api.github.com/users/luotianwen/events{/privacy}","received_events_url":"https://api.github.com/users/luotianwen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-04-07T09:52:55Z","updated_at":"2015-04-08T03:43:16Z","closed_at":null,"body":"04/07 17:40:45.112   WARN [$_NIOREACTOR-2-RW] (ServerConnection.java:170) -ServerConnection [id=7, schema=TESTDB, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=TESTDB]insert into orders(id,customer_id) values(2,2) err:java.sql.SQLNonTransientException: can't find (root) parent sharding node for sql:INSERT INTO orders (id, customer_id)\r\nVALUES (2, 2)\r\njava.sql.SQLNonTransientException: can't find (root) parent sharding node for sql:INSERT INTO orders (id, customer_id)\r\nVALUES (2, 2)\r\n\tat org.opencloudb.parser.druid.impl.DruidInsertParser.parserChildTable(DruidInsertParser.java:138)\r\n\tat org.opencloudb.parser.druid.impl.DruidInsertParser.statementParse(DruidInsertParser.java:50)\r\n\tat org.opencloudb.parser.druid.impl.DefaultDruidParser.parser(DefaultDruidParser.java:60)\r\n\tat org.opencloudb.route.impl.DruidMysqlRouteStrategy.routeNormalSqlWithAST(DruidMysqlRouteStrategy.java:40)\r\n\tat org.opencloudb.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:52)\r\n\tat org.opencloudb.route.RouteService.route(RouteService.java:118)\r\n\tat org.opencloudb.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:162)\r\n\tat org.opencloudb.server.ServerConnection.execute(ServerConnection.java:154)\r\n\tat org.opencloudb.server.ServerQueryHandler.query(ServerQueryHandler.java:125)\r\n\tat org.opencloudb.net.FrontendConnection.query(FrontendConnection.java:263)\r\n\tat org.opencloudb.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:56)\r\n\tat org.opencloudb.net.FrontendConnection.handle(FrontendConnection.java:370)\r\n\tat org.opencloudb.net.AbstractConnection.onReadData(AbstractConnection.java:264)\r\n\tat org.opencloudb.net.NIOSocketWR.asynRead(NIOSocketWR.java:186)\r\n\tat org.opencloudb.net.AbstractConnection.asynRead(AbstractConnection.java:226)\r\n\tat org.opencloudb.net.NIOReactor$RW.run(NIOReactor.java:97)\r\n\tat java.lang.Thread.run(Thread.java:722)\r\n04/07 17:40:45.114   WARN [$_NIOREACTOR-2-RW] (NIOReactor.java:157) -register error \r\njava.nio.channels.ClosedChannelException\r\n\tat java.nio.channels.spi.AbstractSelectableChannel.register(AbstractSelectableChannel.java:194)\r\n\tat org.opencloudb.net.NIOSocketWR.register(NIOSocketWR.java:27)\r\n\tat org.opencloudb.net.NIOReactor$RW.register(NIOReactor.java:154)\r\n\tat org.opencloudb.net.NIOReactor$RW.run(NIOReactor.java:86)\r\n\tat java.lang.Thread.run(Thread.java:722)"},"comment":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/comments/90795098","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/211#issuecomment-90795098","issue_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/211","id":90795098,"user":{"login":"waj89757","id":8022435,"avatar_url":"https://avatars.githubusercontent.com/u/8022435?v=3","gravatar_id":"","url":"https://api.github.com/users/waj89757","html_url":"https://github.com/waj89757","followers_url":"https://api.github.com/users/waj89757/followers","following_url":"https://api.github.com/users/waj89757/following{/other_user}","gists_url":"https://api.github.com/users/waj89757/gists{/gist_id}","starred_url":"https://api.github.com/users/waj89757/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/waj89757/subscriptions","organizations_url":"https://api.github.com/users/waj89757/orgs","repos_url":"https://api.github.com/users/waj89757/repos","events_url":"https://api.github.com/users/waj89757/events{/privacy}","received_events_url":"https://api.github.com/users/waj89757/received_events","type":"User","site_admin":false},"created_at":"2015-04-08T03:43:16Z","updated_at":"2015-04-08T03:43:16Z","body":"这个原因应该是customer表没有customer_id=2这条记录～"}}