{"action":"opened","issue":{"url":"https://api.github.com/repos/actiontech/dble/issues/356","repository_url":"https://api.github.com/repos/actiontech/dble","labels_url":"https://api.github.com/repos/actiontech/dble/issues/356/labels{/name}","comments_url":"https://api.github.com/repos/actiontech/dble/issues/356/comments","events_url":"https://api.github.com/repos/actiontech/dble/issues/356/events","html_url":"https://github.com/actiontech/dble/issues/356","id":278367365,"number":356,"title":"When the value of sharding key is out of boundary,the value lower than the boundary or higher than the boundary make the messages varies","user":{"login":"zhunina","id":31301178,"avatar_url":"https://avatars0.githubusercontent.com/u/31301178?v=4","gravatar_id":"","url":"https://api.github.com/users/zhunina","html_url":"https://github.com/zhunina","followers_url":"https://api.github.com/users/zhunina/followers","following_url":"https://api.github.com/users/zhunina/following{/other_user}","gists_url":"https://api.github.com/users/zhunina/gists{/gist_id}","starred_url":"https://api.github.com/users/zhunina/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhunina/subscriptions","organizations_url":"https://api.github.com/users/zhunina/orgs","repos_url":"https://api.github.com/users/zhunina/repos","events_url":"https://api.github.com/users/zhunina/events{/privacy}","received_events_url":"https://api.github.com/users/zhunina/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-12-01T06:06:57Z","updated_at":"2017-12-01T06:06:57Z","closed_at":null,"author_association":"COLLABORATOR","body":"1.rule.xml\r\n```\r\n    <tableRule name=\"auto-sharding-long4\">\r\n        <rule>\r\n            <columns>current</columns>\r\n            <algorithm>sharding-date-alg</algorithm>\r\n        </rule>\r\n    </tableRule>\r\n    <function name=\"sharding-date-alg\" class=\"Date\">\r\n        <property name=\"dateFormat\">yyyy-MM-dd</property>\r\n        <property name=\"sBeginDate\">2000-01-01</property>\r\n        <property name=\"sPartionDay\">15</property>\r\n        <property name=\"defaultNode\">-1</property>\r\n    </function>\r\n```\r\n2.\r\n```\r\nmysql> insert into history values('1999-02-14',1,'aa');\r\nERROR 1064 (HY000): can't find any valid data node :history -> CURRENT -> 1999-02-14\r\nmysql> insert into history values('2999-02-14',1,'aa');\r\nERROR 1064 (HY000): Index: 24328, Size: 2\r\n```\r\n3.\r\n```\r\n2017-12-01 13:31:05.001  INFO [$_NIOREACTOR-0-RW] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:359)) - ServerConnection [id=1, schema=testdb, host=127.0.0.1, user=test,txIsolation=2, autocommit=true, schema=testdb]insert into history values('1999-02-14',1,'aa') err:can't find any valid data node :history -> CURRENT -> 1999-02-14\r\n2017-12-01 13:31:10.584  WARN [$_NIOREACTOR-0-RW] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:367)) - ServerConnection [id=1, schema=testdb, host=127.0.0.1, user=test,txIsolation=2, autocommit=true, schema=testdb]insert into history values('2999-02-14',1,'aa') err:java.lang.IndexOutOfBoundsException: Index: 24328, Size: 2\r\njava.lang.IndexOutOfBoundsException: Index: 24328, Size: 2\r\n        at java.util.ArrayList.rangeCheck(ArrayList.java:657) ~[?:1.8.0_151]\r\n        at java.util.ArrayList.get(ArrayList.java:433) ~[?:1.8.0_151]\r\n        at com.actiontech.dble.route.parser.druid.impl.DruidInsertParser.parserSingleInsert(DruidInsertParser.java:205) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.route.parser.druid.impl.DruidInsertParser.visitorParse(DruidInsertParser.java:102) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.route.parser.druid.impl.DefaultDruidParser.parser(DefaultDruidParser.java:47) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.route.util.RouterUtil.routeFromParser(RouterUtil.java:119) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:59) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:60) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.route.RouteService.route(RouteService.java:108) ~[dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:306) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:250) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:137) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:314) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:332) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:51) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:40) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.FrontendConnection.rawHandle(FrontendConnection.java:469) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.FrontendConnection.handle(FrontendConnection.java:451) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.AbstractConnection.onReadData(AbstractConnection.java:297) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.NIOSocketWR.asyncRead(NIOSocketWR.java:175) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.AbstractConnection.asyncRead(AbstractConnection.java:256) [dble-2.17.11.0-dev.jar:?]\r\n        at com.actiontech.dble.net.NIOReactor$RW.run(NIOReactor.java:73) [dble-2.17.11.0-dev.jar:?]\r\n        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]\r\n```\r\n\r\nSuggestions:the messages should be uniformity\r\n"}}
{"actor":{"display_login":"zhunina"}}