{"action":"created","issue":{"url":"https://api.github.com/repos/awslabs/amazon-redshift-utils/issues/224","repository_url":"https://api.github.com/repos/awslabs/amazon-redshift-utils","labels_url":"https://api.github.com/repos/awslabs/amazon-redshift-utils/issues/224/labels{/name}","comments_url":"https://api.github.com/repos/awslabs/amazon-redshift-utils/issues/224/comments","events_url":"https://api.github.com/repos/awslabs/amazon-redshift-utils/issues/224/events","html_url":"https://github.com/awslabs/amazon-redshift-utils/issues/224","id":282714167,"number":224,"title":"ColumnEncodingUtility not using TCP keepalive","user":{"login":"rpaterson","id":6112804,"avatar_url":"https://avatars3.githubusercontent.com/u/6112804?v=4","gravatar_id":"","url":"https://api.github.com/users/rpaterson","html_url":"https://github.com/rpaterson","followers_url":"https://api.github.com/users/rpaterson/followers","following_url":"https://api.github.com/users/rpaterson/following{/other_user}","gists_url":"https://api.github.com/users/rpaterson/gists{/gist_id}","starred_url":"https://api.github.com/users/rpaterson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rpaterson/subscriptions","organizations_url":"https://api.github.com/users/rpaterson/orgs","repos_url":"https://api.github.com/users/rpaterson/repos","events_url":"https://api.github.com/users/rpaterson/events{/privacy}","received_events_url":"https://api.github.com/users/rpaterson/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":11,"created_at":"2017-12-17T18:41:05Z","updated_at":"2018-02-04T08:43:38Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"The Column Encoding Utility is not using TCP keepalive.  It tries to configure pg8000 to do it: https://github.com/awslabs/amazon-redshift-utils/blob/b5b24a747cd6f3ff29182675384554e7c30bfb2c/src/ColumnEncodingUtility/analyze-schema-compression.py#L172-L174\r\n\r\n... but it doesn't actually work.  I can see that running `netstat -to`:\r\n```Shell\r\ntcp        0      0 192.168.1.5:38990       ec2-52-205-239-16:11439 ESTABLISHED off (0.00/0/0)\r\n```\r\n(if keepalive were enabled it would say \"keepalive\" instead of \"off\").\r\n\r\nLooking at the pg8000 docs, it doesn't mention those keepalive options: http://pythonhosted.org/pg8000/dbapi.html?highlight=connec#pg8000.connect\r\n\r\nWe need to enable KeepAlive - the utility keeps \"hanging\" trying to analyze large tables."},"comment":{"url":"https://api.github.com/repos/awslabs/amazon-redshift-utils/issues/comments/362890689","html_url":"https://github.com/awslabs/amazon-redshift-utils/issues/224#issuecomment-362890689","issue_url":"https://api.github.com/repos/awslabs/amazon-redshift-utils/issues/224","id":362890689,"user":{"login":"rpaterson","id":6112804,"avatar_url":"https://avatars3.githubusercontent.com/u/6112804?v=4","gravatar_id":"","url":"https://api.github.com/users/rpaterson","html_url":"https://github.com/rpaterson","followers_url":"https://api.github.com/users/rpaterson/followers","following_url":"https://api.github.com/users/rpaterson/following{/other_user}","gists_url":"https://api.github.com/users/rpaterson/gists{/gist_id}","starred_url":"https://api.github.com/users/rpaterson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rpaterson/subscriptions","organizations_url":"https://api.github.com/users/rpaterson/orgs","repos_url":"https://api.github.com/users/rpaterson/repos","events_url":"https://api.github.com/users/rpaterson/events{/privacy}","received_events_url":"https://api.github.com/users/rpaterson/received_events","type":"User","site_admin":false},"created_at":"2018-02-04T08:43:38Z","updated_at":"2018-02-04T08:43:38Z","author_association":"CONTRIBUTOR","body":"@pvbouwel fantastic thank you!  I'll give it a go tomorrow and report back."}}
{"actor":{"display_login":"rpaterson"}}