{"action":"created","issue":{"url":"https://api.github.com/repos/actiontech/dble/issues/698","repository_url":"https://api.github.com/repos/actiontech/dble","labels_url":"https://api.github.com/repos/actiontech/dble/issues/698/labels{/name}","comments_url":"https://api.github.com/repos/actiontech/dble/issues/698/comments","events_url":"https://api.github.com/repos/actiontech/dble/issues/698/events","html_url":"https://github.com/actiontech/dble/issues/698","id":359295578,"node_id":"MDU6SXNzdWUzNTkyOTU1Nzg=","number":698,"title":"Hang hint when call procedure","user":{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false},"labels":[{"id":1038981828,"node_id":"MDU6TGFiZWwxMDM4OTgxODI4","url":"https://api.github.com/repos/actiontech/dble/labels/hint","name":"hint","color":"1bc7e5","default":false},{"id":943060629,"node_id":"MDU6TGFiZWw5NDMwNjA2Mjk=","url":"https://api.github.com/repos/actiontech/dble/labels/resolve","name":"resolve","color":"fbca04","default":false}],"state":"closed","locked":false,"assignee":{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false},"assignees":[{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/actiontech/dble/milestones/13","html_url":"https://github.com/actiontech/dble/milestone/13","labels_url":"https://api.github.com/repos/actiontech/dble/milestones/13/labels","id":3603552,"node_id":"MDk6TWlsZXN0b25lMzYwMzU1Mg==","number":13,"title":"2.18.10.0","description":"","creator":{"login":"yanhuqing666","id":16715575,"node_id":"MDQ6VXNlcjE2NzE1NTc1","avatar_url":"https://avatars1.githubusercontent.com/u/16715575?v=4","gravatar_id":"","url":"https://api.github.com/users/yanhuqing666","html_url":"https://github.com/yanhuqing666","followers_url":"https://api.github.com/users/yanhuqing666/followers","following_url":"https://api.github.com/users/yanhuqing666/following{/other_user}","gists_url":"https://api.github.com/users/yanhuqing666/gists{/gist_id}","starred_url":"https://api.github.com/users/yanhuqing666/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanhuqing666/subscriptions","organizations_url":"https://api.github.com/users/yanhuqing666/orgs","repos_url":"https://api.github.com/users/yanhuqing666/repos","events_url":"https://api.github.com/users/yanhuqing666/events{/privacy}","received_events_url":"https://api.github.com/users/yanhuqing666/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":16,"state":"open","created_at":"2018-08-28T10:10:07Z","updated_at":"2018-09-20T07:35:53Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2018-09-12T02:51:12Z","updated_at":"2018-09-20T07:35:53Z","closed_at":"2018-09-20T07:35:53Z","author_association":"COLLABORATOR","body":"* **dble version：5.6.29-dble-9.9.9.9-4ecbd6a-20180907104021 dble**  \r\n\r\n* **configs：** \r\n\r\n**schema.xml**  \r\n\r\n```\r\n<schema name=\"testdb\" dataNode=\"dn1\">\r\n     <table name=\"test\" dataNode=\"dn1,dn2,dn3,dn4\" rule=\"sharding-by-mod\" /> \r\n</schema>\r\n<dataNode name=\"dn1\" dataHost=\"localhost1\" database=\"db1\"/>\r\n<dataNode name=\"dn2\" dataHost=\"localhost1\" database=\"db2\"/>\r\n<dataNode name=\"dn3\" dataHost=\"localhost1\" database=\"db3\"/>\r\n<dataNode name=\"dn4\" dataHost=\"localhost1\" database=\"db4\"/>\r\n<dataHost balance=\"0\" maxCon=\"1000\" minCon=\"10\" name=\"localhost1\" switchType=\"-1\" slaveThreshold=\"100\">\r\n          <heartbeat>select user()</heartbeat>\r\n          <writeHost host=\"hostM1\" url=\"10.186.19.75:3306\" password=\"123\" user=\"root\">\r\n                       <readHost host=\"hostS1\" url=\"10.186.30.159:3306\" password=\"123\" user=\"root\"/\r\n          </writeHost>\r\n</dataHost>\r\n\r\n\r\n```\r\n\r\n* **steps：**    \r\n1 create procedure in backend mysql (10.186.19.75:3306)\r\n```\r\nMySQL [db1]> delimiter //\r\nMySQL [db1]> create procedure select_name() begin select name from test_sp where id =1;end//\r\nMySQL [db1]> delimiter ;\r\n```\r\n2.call procedure in dble \r\n```\r\nMySQL [testdb]> /*#dble:datanode=dn1*/call select_name();  -hang after return result\r\n+----------+\r\n| name     |\r\n+----------+\r\n| test_sp1 |\r\n+----------+\r\n1 row in set (0.01 sec)\r\n\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/actiontech/dble/issues/comments/423073595","html_url":"https://github.com/actiontech/dble/issues/698#issuecomment-423073595","issue_url":"https://api.github.com/repos/actiontech/dble/issues/698","id":423073595,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMzA3MzU5NQ==","user":{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false},"created_at":"2018-09-20T07:35:53Z","updated_at":"2018-09-20T07:35:53Z","author_association":"COLLABORATOR","body":"verified on version: 5.6.29-dble-9.9.9.9-77289c4-20180920071818 "}}
{"actor":{"display_login":"yexiaoli88"}}