{"action":"created","issue":{"url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/issues/418","repository_url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ","labels_url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/issues/418/labels{/name}","comments_url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/issues/418/comments","events_url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/issues/418/events","html_url":"https://github.com/ElasticHQ/elasticsearch-HQ/issues/418","id":347368120,"node_id":"MDU6SXNzdWUzNDczNjgxMjA=","number":418,"title":"EHQ is spewing a LOT of sqlalchemy.engine.base.Engine logs in INFO","user":{"login":"jakubgs","id":2212681,"node_id":"MDQ6VXNlcjIyMTI2ODE=","avatar_url":"https://avatars2.githubusercontent.com/u/2212681?v=4","gravatar_id":"","url":"https://api.github.com/users/jakubgs","html_url":"https://github.com/jakubgs","followers_url":"https://api.github.com/users/jakubgs/followers","following_url":"https://api.github.com/users/jakubgs/following{/other_user}","gists_url":"https://api.github.com/users/jakubgs/gists{/gist_id}","starred_url":"https://api.github.com/users/jakubgs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakubgs/subscriptions","organizations_url":"https://api.github.com/users/jakubgs/orgs","repos_url":"https://api.github.com/users/jakubgs/repos","events_url":"https://api.github.com/users/jakubgs/events{/privacy}","received_events_url":"https://api.github.com/users/jakubgs/received_events","type":"User","site_admin":false},"labels":[{"id":38076550,"node_id":"MDU6TGFiZWwzODA3NjU1MA==","url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/labels/question","name":"question","color":"cc317c","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-08-03T11:55:47Z","updated_at":"2018-08-05T03:57:36Z","closed_at":null,"author_association":"NONE","body":"### Issue Description\r\nI'm seeing a LOT of logs that start with `sqlalchemy.engine.base.Engine` and are just SQL statements. Why is that?\r\n1. I'm not using the UI constantly, so why am I seeing so many sql statements? I'm seeing ~5k logs per hour like that constantly.\r\n2. Why is this in `INFO` rather than in `DEBUG` log level?\r\n\r\n### Source Code / Logs\r\n```\r\nINFO #011 sqlalchemy.engine.base.Engine #011 base._execute_context:1151 #011 SELECT cluster.cluster_name AS cluster_cluster_name, cluster.cluster_ip AS cluster_cluster_ip, cluster.cluster_port AS cluster_cluster_port, cluster.cluster_scheme AS cluster_cluster_scheme, cluster.cluster_version AS cluster_cluster_version, cluster.cluster_username AS cluster_cluster_username, cluster.cluster_password AS cluster_cluster_password\r\nINFO #011 sqlalchemy.engine.base.Engine #011 base._begin_impl:682 #011 BEGIN (implicit)\r\nINFO #011 sqlalchemy.engine.base.Engine #011 base._rollback_impl:702 #011 ROLLBACK\r\nINFO #011 sqlalchemy.engine.base.Engine #011 base._execute_context:1154 #011 ()\r\nINFO #011 sqlalchemy.engine.base.Engine #011 base._begin_impl:682 #011 BEGIN (implicit)\r\nINFO #011 sqlalchemy.engine.base.Engine #011 base._execute_context:1151 #011 SELECT cluster.cluster_name AS cluster_cluster_name, cluster.cluster_ip AS cluster_cluster_ip, cluster.cluster_port AS cluster_cluster_port, cluster.cluster_scheme AS cluster_cluster_scheme, cluster.cluster_version AS cluster_cluster_version, cluster.cluster_username AS cluster_cluster_username, cluster.cluster_password AS cluster_cluster_password\r\n```"},"comment":{"url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/issues/comments/410493920","html_url":"https://github.com/ElasticHQ/elasticsearch-HQ/issues/418#issuecomment-410493920","issue_url":"https://api.github.com/repos/ElasticHQ/elasticsearch-HQ/issues/418","id":410493920,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMDQ5MzkyMA==","user":{"login":"royrusso","id":654238,"node_id":"MDQ6VXNlcjY1NDIzOA==","avatar_url":"https://avatars3.githubusercontent.com/u/654238?v=4","gravatar_id":"","url":"https://api.github.com/users/royrusso","html_url":"https://github.com/royrusso","followers_url":"https://api.github.com/users/royrusso/followers","following_url":"https://api.github.com/users/royrusso/following{/other_user}","gists_url":"https://api.github.com/users/royrusso/gists{/gist_id}","starred_url":"https://api.github.com/users/royrusso/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/royrusso/subscriptions","organizations_url":"https://api.github.com/users/royrusso/orgs","repos_url":"https://api.github.com/users/royrusso/repos","events_url":"https://api.github.com/users/royrusso/events{/privacy}","received_events_url":"https://api.github.com/users/royrusso/received_events","type":"User","site_admin":false},"created_at":"2018-08-05T03:57:36Z","updated_at":"2018-08-05T03:57:36Z","author_association":"MEMBER","body":"I can't control that they are in `INFO`, that's up to SQLAlchemy. You can set it to ERROR in the config, if it bothers you. \r\n\r\nIf this is the only query being executed repeatedly, it looks like the one from the homepage, so something must be pinging it."}}
{"actor":{"display_login":"royrusso"}}