{"action":"created","issue":{"url":"https://api.github.com/repos/alibaba/canal/issues/675","repository_url":"https://api.github.com/repos/alibaba/canal","labels_url":"https://api.github.com/repos/alibaba/canal/issues/675/labels{/name}","comments_url":"https://api.github.com/repos/alibaba/canal/issues/675/comments","events_url":"https://api.github.com/repos/alibaba/canal/issues/675/events","html_url":"https://github.com/alibaba/canal/issues/675","id":329940254,"node_id":"MDU6SXNzdWUzMjk5NDAyNTQ=","number":675,"title":"server多个instance同时启动，每次只能最多5个工作","user":{"login":"nbqyqx","id":14268143,"node_id":"MDQ6VXNlcjE0MjY4MTQz","avatar_url":"https://avatars1.githubusercontent.com/u/14268143?v=4","gravatar_id":"","url":"https://api.github.com/users/nbqyqx","html_url":"https://github.com/nbqyqx","followers_url":"https://api.github.com/users/nbqyqx/followers","following_url":"https://api.github.com/users/nbqyqx/following{/other_user}","gists_url":"https://api.github.com/users/nbqyqx/gists{/gist_id}","starred_url":"https://api.github.com/users/nbqyqx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nbqyqx/subscriptions","organizations_url":"https://api.github.com/users/nbqyqx/orgs","repos_url":"https://api.github.com/users/nbqyqx/repos","events_url":"https://api.github.com/users/nbqyqx/events{/privacy}","received_events_url":"https://api.github.com/users/nbqyqx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-06-06T16:20:56Z","updated_at":"2018-06-07T02:46:34Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"一台canal server 部署了15个instance，每次起来只有5个instance能获取到位点信息。而且重启这五个不固定。\r\n有其中一个报SHOW VIEW command没权限，需要给账号开这个权限？\r\n文档里只提到select，replication slave，replication client权限\r\n\r\n\r\n2018-06-06 19:18:22.458 [destination = mysql.05.upanb.cn , address = mysql.05.upanb.cn/192.168.250.214:3306 , EventParser] ERROR c.a.otter.canal.parse.inbound.mysql.MysqlEventParser - dump address mysql.05.upanb.cn/192.168.250.214:3306 has an error, retrying. caused by\r\ncom.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW VIEW command denied to user 'canal'@'192.168.249.54' for table 'taglist', sqlState=42000, sqlStateMarker=#]\r\nwith command: show create table `pointstore`.`admin`;show create table `pointstore`.`blacklist`;show create table `pointstore`.`clearuk`;show create table `pointstore`.`duibaorder`;show create table `pointstore`.`point_detail_description`;show create table `pointstore`.`returnpoint`;show create table `pointstore`.`s_admin`;show create table `pointstore`.`t_adminlog`;show create table `pointstore`.`t_broker`;show create table `pointstore`.`t_broker_copy`;show create table `pointstore`.`t_brokercompany`;show create table `pointstore`.`t_exchangerule`;show create table `pointstore`.`t_luckproduct`;show create table `pointstore`.`t_luckrecord`;show create table `pointstore`.`t_luckrecord2`;show create table `pointstore`.`t_luckrecord3`;show create table `pointstore`.`t_luckrecord4`;show create table `pointstore`.`t_oauthinfo`;show create table `pointstore`.`t_oauthinfo_bak1`;show create table `pointstore`.`t_oauthinfo_copy`;show create table `pointstore`.`t_pointactivity`;show create table `pointstore`.`t_pointdetail_new`;show create table `pointstore`.`t_pointmain_new`;show create table `pointstore`.`t_pointmain_new_20180212`;show create table `pointstore`.`t_pointmain_new_bak`;show create table `pointstore`.`t_pointmain_new_copy`;show create table `pointstore`.`t_pointproduct`;show create table `pointstore`.`t_pointrule`;show create table `pointstore`.`t_pointsetting`;show create table `pointstore`.`t_pointstoreadminauthority`;show create table `pointstore`.`t_pointstoreinvoice`;show create table `pointstore`.`t_pointstorevisitlog`;show create table `pointstore`.`t_productinventory`;show create table `pointstore`.`t_productpic`;show create table `pointstore`.`t_productscategory`;show create table `pointstore`.`t_productsexchange_new`;show create table `pointstore`.`t_productsexpand`;show create table `pointstore`.`t_productshow`;show create table `pointstore`.`t_provincecityarea`;show create table `pointstore`.`t_ruletocity`;show create table `pointstore`.`taglist`;show create table `pointstore`.`test`;show create table `pointstore`.`timelist`;show create table `pointstore`.`v_brokerpoint`;show create table `pointstore`.`v_luckrecord`;show create table `pointstore`.`v_pointstoreinvoicetotal`;show create table `pointstore`.`v_pointstoreinvoicetotal_a`;show create table `pointstore`.`v_productshow`;show create table `pointstore`.`v_productshowlist`;show create table `pointstore`.`v_productwarehouse`;show create table `pointstore`.`yearlist`;\r\nCaused by: java.io.IOException: ErrorPacket [errorNumber=1142, fieldCount=-1, message=SHOW VIEW command denied to user 'canal'@'192.168.249.54' for table 'taglist', sqlState=42000, sqlStateMarker=#]\r\n\r\n2018-06-06 19:18:22.459 [destination = mysql.05.upanb.cn , address = mysql.05.upanb.cn/192.168.250.214:3306 , EventParser] INFO c.alibaba.otter.canal.parse.driver.mysql.MysqlConnector - disConnect MysqlConnection to mysql.05.upanb.cn/192.168.250.214:3306...\r\n2018-06-06 19:18:22.459 [destination = mysql.05.upanb.cn , address = mysql.05.upanb.cn/192.168.250.214:3306 , EventParser] INFO c.alibaba.otter.canal.parse.driver.mysql.MysqlConnector - disConnect MysqlConnection to mysql.05.upanb.cn/192.168.250.214:3306.."},"comment":{"url":"https://api.github.com/repos/alibaba/canal/issues/comments/395275363","html_url":"https://github.com/alibaba/canal/issues/675#issuecomment-395275363","issue_url":"https://api.github.com/repos/alibaba/canal/issues/675","id":395275363,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NTI3NTM2Mw==","user":{"login":"agapple","id":834743,"node_id":"MDQ6VXNlcjgzNDc0Mw==","avatar_url":"https://avatars0.githubusercontent.com/u/834743?v=4","gravatar_id":"","url":"https://api.github.com/users/agapple","html_url":"https://github.com/agapple","followers_url":"https://api.github.com/users/agapple/followers","following_url":"https://api.github.com/users/agapple/following{/other_user}","gists_url":"https://api.github.com/users/agapple/gists{/gist_id}","starred_url":"https://api.github.com/users/agapple/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agapple/subscriptions","organizations_url":"https://api.github.com/users/agapple/orgs","repos_url":"https://api.github.com/users/agapple/repos","events_url":"https://api.github.com/users/agapple/events{/privacy}","received_events_url":"https://api.github.com/users/agapple/received_events","type":"User","site_admin":false},"created_at":"2018-06-07T02:46:34Z","updated_at":"2018-06-07T02:46:34Z","author_association":"MEMBER","body":"使用最新的1.0.26"}}
{"actor":{"display_login":"agapple"}}