{"action":"opened","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/965","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/965/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/965/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/965/events","html_url":"https://github.com/sysown/proxysql/issues/965","id":216390101,"number":965,"title":"proxysql return \"General error: 2057\" when the table column changed","user":{"login":"jkklee","id":11570771,"avatar_url":"https://avatars3.githubusercontent.com/u/11570771?v=3","gravatar_id":"","url":"https://api.github.com/users/jkklee","html_url":"https://github.com/jkklee","followers_url":"https://api.github.com/users/jkklee/followers","following_url":"https://api.github.com/users/jkklee/following{/other_user}","gists_url":"https://api.github.com/users/jkklee/gists{/gist_id}","starred_url":"https://api.github.com/users/jkklee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jkklee/subscriptions","organizations_url":"https://api.github.com/users/jkklee/orgs","repos_url":"https://api.github.com/users/jkklee/repos","events_url":"https://api.github.com/users/jkklee/events{/privacy}","received_events_url":"https://api.github.com/users/jkklee/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-03-23T11:01:16Z","updated_at":"2017-03-23T11:01:16Z","closed_at":null,"body":"My environment:\r\n\r\n- proxysql    1.3.4-0-gd158707\r\n- mysql        5.6.24-72.2-log Percona Server\r\n- php           5.6\r\n- laravel(php framework)       5.1.45\r\n\r\nEverything goes well before today.\r\nToday morning, I add a column to a table, then my app show errors like that:\r\n```\r\nSQLSTATE[HY000]: General error: 2057 A stored procedure returning result sets of different size was called. This is not supported by libmysql (SQL: select * from `user` where `uid` = 229 limit 1)\r\n```\r\nI tried some effort to analyse this error(include analyse the network traffic), but nothing can explain this error. At last I tried restart my MySQL, Proxysql, and php-fpm. I found only when I restart the Proxysql, this error disappeared.\r\n\r\nAnother point confuse me is the error message \"A stored procedure returning result sets...\", there is no stored procedure in my app.\r\n\r\nIn the other hand, I simulate the same scenario(use proxysql and modify the table's column) with mysql-cli and prepare statment, it's ok;\r\nalso the pure php script(no framework) using PDO and prepare statment, it's ok too.\r\n\r\nSo, what do you think may cause this error? If you need some additional information, I will show you."}}
{"actor":{"display_login":"jkklee"}}