{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/766","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/766/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/766/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/766/events","html_url":"https://github.com/sysown/proxysql/issues/766","id":186024905,"number":766,"title":"Memory leak in proxysql","user":{"login":"ovaistariq","id":1632658,"avatar_url":"https://avatars.githubusercontent.com/u/1632658?v=3","gravatar_id":"","url":"https://api.github.com/users/ovaistariq","html_url":"https://github.com/ovaistariq","followers_url":"https://api.github.com/users/ovaistariq/followers","following_url":"https://api.github.com/users/ovaistariq/following{/other_user}","gists_url":"https://api.github.com/users/ovaistariq/gists{/gist_id}","starred_url":"https://api.github.com/users/ovaistariq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ovaistariq/subscriptions","organizations_url":"https://api.github.com/users/ovaistariq/orgs","repos_url":"https://api.github.com/users/ovaistariq/repos","events_url":"https://api.github.com/users/ovaistariq/events{/privacy}","received_events_url":"https://api.github.com/users/ovaistariq/received_events","type":"User","site_admin":false},"labels":[],"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":null,"comments":3,"created_at":"2016-10-28T21:21:42Z","updated_at":"2016-12-22T12:46:00Z","closed_at":null,"body":"I have found a case where proxysql starts leaking memory if the following workload is sent to it over admin channel continuously:\n\n```\n2016-10-19 02:43:05 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:08 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:08 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:08 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:08 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:13 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:13 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:13 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:13 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:18 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:18 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:18 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:18 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:23 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:23 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:23 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:23 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:28 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:28 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:28 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:28 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:33 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:33 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:33 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:33 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:38 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:38 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:38 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:38 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n2016-10-19 02:43:43 [INFO] Received command SET time_zone = \"+0:00\"\n2016-10-19 02:43:43 [INFO] Received command SET NAMES utf8\n2016-10-19 02:43:43 [INFO] Received command SET SESSION sql_mode='TRADITIONAL'\n2016-10-19 02:43:43 [INFO] Received LOAD MYSQL USERS TO RUNTIME command\n```\n"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/268792565","html_url":"https://github.com/sysown/proxysql/issues/766#issuecomment-268792565","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/766","id":268792565,"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":"2016-12-22T12:46:00Z","updated_at":"2016-12-22T12:46:00Z","body":"Cross reference to #729 "}}
{"actor":{"display_login":"renecannao"}}