{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/897","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/897/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/897/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/897/events","html_url":"https://github.com/sysown/proxysql/issues/897","id":204358945,"number":897,"title":"Crash when using more than one user","user":{"login":"geotro","id":22801126,"avatar_url":"https://avatars.githubusercontent.com/u/22801126?v=3","gravatar_id":"","url":"https://api.github.com/users/geotro","html_url":"https://github.com/geotro","followers_url":"https://api.github.com/users/geotro/followers","following_url":"https://api.github.com/users/geotro/following{/other_user}","gists_url":"https://api.github.com/users/geotro/gists{/gist_id}","starred_url":"https://api.github.com/users/geotro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/geotro/subscriptions","organizations_url":"https://api.github.com/users/geotro/orgs","repos_url":"https://api.github.com/users/geotro/repos","events_url":"https://api.github.com/users/geotro/events{/privacy}","received_events_url":"https://api.github.com/users/geotro/received_events","type":"User","site_admin":false},"labels":[{"id":152884416,"url":"https://api.github.com/repos/sysown/proxysql/labels/bug","name":"bug","color":"fc2929","default":true},{"id":156062865,"url":"https://api.github.com/repos/sysown/proxysql/labels/CONNECTION%20POOL","name":"CONNECTION POOL","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"assignees":[{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/sysown/proxysql/milestones/14","html_url":"https://github.com/sysown/proxysql/milestone/14","labels_url":"https://api.github.com/repos/sysown/proxysql/milestones/14/labels","id":2287942,"number":14,"title":"v1.3.4","description":"Bug fix release","creator":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2017-01-30T23:11:56Z","updated_at":"2017-01-31T17:03:45Z","due_on":"2017-02-12T08:00:00Z","closed_at":null},"comments":2,"created_at":"2017-01-31T17:01:59Z","updated_at":"2017-01-31T19:15:34Z","closed_at":null,"body":"We have an instance of proxysql v1.3.3 which worked very well in production, until the very moment we started using a second mysql user/db utilizing the same config.\r\n\r\nAs soon as the user was used, proxysql would crash, and this appears to be happening consistently, backtrace and associated info below:\r\n\r\n2017-01-31 16:45:55 [INFO] New mysql_replication_hostgroups table\r\nError: signal 11:\r\nproxysql(_Z13crash_handleri+0x1a)[0x439a1a]\r\n/lib/x86_64-linux-gnu/libc.so.6(+0x354b0)[0x7fd6fdbab4b0]\r\nproxysql(mysql_change_user+0x199)[0x5af0f9]\r\nproxysql[0x5b51e3]\r\nproxysql(my_context_spawn+0x41)[0x5b4491]\r\n2017-01-31 16:46:58 main.cpp:642:ProxySQL_daemonize_phase3(): [ERROR] ProxySQL crashed. Restarting!\r\n2017-01-31 16:46:58 [INFO] Angel process is waiting 1 seconds before starting a new ProxySQL process\r\n2017-01-31 16:46:59 [INFO] Angel process started ProxySQL process 6431\r\n2017-01-31 16:46:59 ProxySQL_Admin.cpp:2853:flush_admin_variables___database_to_runtime(): [ERROR] Impossible to set variable version with value \"1.3.1-2-gc762ae9\". Resetting to current \"1.3.3-0-gf2b677a\".\r\n2017-01-31 16:46:59 ProxySQL_Admin.cpp:2902:flush_mysql_variables___database_to_runtime(): [ERROR] Impossible to set not existing variable session_debug with value \"(null)\". Deleting\r\n"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/276461932","html_url":"https://github.com/sysown/proxysql/issues/897#issuecomment-276461932","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/897","id":276461932,"user":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"created_at":"2017-01-31T19:15:34Z","updated_at":"2017-01-31T19:15:34Z","body":"Hi @geotro : no problem, I think I already understood where the issue is.\r\n> at /opt/proxysql/deps/mariadb-client-library/mariadb_client/libmariadb/libmariadb.c:2242\r\n\r\nIf my guess is right, I need to patch mariadb client library.\r\nPlease do not throw away the core dump for now.\r\nI will work on a fix next week: as a temporary workaround, can you use different proxies for different users?"}}
{"actor":{"display_login":"renecannao"}}