{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/1533","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/1533/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/1533/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/1533/events","html_url":"https://github.com/sysown/proxysql/issues/1533","id":328237179,"node_id":"MDU6SXNzdWUzMjgyMzcxNzk=","number":1533,"title":"Important issue (our live system is down!)","user":{"login":"mstenz","id":7984329,"node_id":"MDQ6VXNlcjc5ODQzMjk=","avatar_url":"https://avatars3.githubusercontent.com/u/7984329?v=4","gravatar_id":"","url":"https://api.github.com/users/mstenz","html_url":"https://github.com/mstenz","followers_url":"https://api.github.com/users/mstenz/followers","following_url":"https://api.github.com/users/mstenz/following{/other_user}","gists_url":"https://api.github.com/users/mstenz/gists{/gist_id}","starred_url":"https://api.github.com/users/mstenz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mstenz/subscriptions","organizations_url":"https://api.github.com/users/mstenz/orgs","repos_url":"https://api.github.com/users/mstenz/repos","events_url":"https://api.github.com/users/mstenz/events{/privacy}","received_events_url":"https://api.github.com/users/mstenz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-31T17:53:54Z","updated_at":"2018-05-31T18:39:21Z","closed_at":null,"author_association":"NONE","body":"Hi, proxysql was running in a Percona XtraDB 3 node master/master cluster now for several weeks without any issue. Just today all my connections from proxysql to the db servers failed. I have removed the automatic galera-script already and manually made all nodes in mysql_servers table ONLINE, but still it does not work. I receive this error in proysql.log file:\r\n`proxysql.1.wbpla9ud59dr@cl01-n04    | 2018-05-31 17:46:30 MySQL_Monitor.cpp:858:monitor_group_replication_thread(): [ERROR] Incorrect number of rows, please report a bug`\r\nOn all three nodes `SELECT * FROM 'gr_member_routing_candidate_status'` is empty.\r\nSo I assume the issue is that i need to fix the view, but i don't know how to do it. Any idea or hints? We are in big trouble. "},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/393634027","html_url":"https://github.com/sysown/proxysql/issues/1533#issuecomment-393634027","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/1533","id":393634027,"node_id":"MDEyOklzc3VlQ29tbWVudDM5MzYzNDAyNw==","user":{"login":"mstenz","id":7984329,"node_id":"MDQ6VXNlcjc5ODQzMjk=","avatar_url":"https://avatars3.githubusercontent.com/u/7984329?v=4","gravatar_id":"","url":"https://api.github.com/users/mstenz","html_url":"https://github.com/mstenz","followers_url":"https://api.github.com/users/mstenz/followers","following_url":"https://api.github.com/users/mstenz/following{/other_user}","gists_url":"https://api.github.com/users/mstenz/gists{/gist_id}","starred_url":"https://api.github.com/users/mstenz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mstenz/subscriptions","organizations_url":"https://api.github.com/users/mstenz/orgs","repos_url":"https://api.github.com/users/mstenz/repos","events_url":"https://api.github.com/users/mstenz/events{/privacy}","received_events_url":"https://api.github.com/users/mstenz/received_events","type":"User","site_admin":false},"created_at":"2018-05-31T18:39:21Z","updated_at":"2018-05-31T18:39:21Z","author_association":"NONE","body":"In Addition to this i am wondering why proxysql is trying to access this view as Percona doesnt use this table by XtraDB replication?\r\nI have checked further and found out that performance_schema.replication_group_members tabale is empty as well. "}}
{"actor":{"display_login":"mstenz"}}