{"action":"created","issue":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/860","repository_url":"https://api.github.com/repos/serge-rider/dbeaver","labels_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/860/labels{/name}","comments_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/860/comments","events_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/860/events","html_url":"https://github.com/serge-rider/dbeaver/issues/860","id":183914866,"number":860,"title":"Keep-alive is not working properly","user":{"login":"dimitriadisg","id":14919500,"avatar_url":"https://avatars.githubusercontent.com/u/14919500?v=3","gravatar_id":"","url":"https://api.github.com/users/dimitriadisg","html_url":"https://github.com/dimitriadisg","followers_url":"https://api.github.com/users/dimitriadisg/followers","following_url":"https://api.github.com/users/dimitriadisg/following{/other_user}","gists_url":"https://api.github.com/users/dimitriadisg/gists{/gist_id}","starred_url":"https://api.github.com/users/dimitriadisg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimitriadisg/subscriptions","organizations_url":"https://api.github.com/users/dimitriadisg/orgs","repos_url":"https://api.github.com/users/dimitriadisg/repos","events_url":"https://api.github.com/users/dimitriadisg/events{/privacy}","received_events_url":"https://api.github.com/users/dimitriadisg/received_events","type":"User","site_admin":false},"labels":[{"id":275893723,"url":"https://api.github.com/repos/serge-rider/dbeaver/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"closed","locked":false,"assignee":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"assignees":[{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/serge-rider/dbeaver/milestones/26","html_url":"https://github.com/serge-rider/dbeaver/milestones/3.8","labels_url":"https://api.github.com/repos/serge-rider/dbeaver/milestones/26/labels","id":2049263,"number":26,"title":"3.8","description":"Migrate to Eclipse Neon.","creator":{"login":"serge-rider","id":6398845,"avatar_url":"https://avatars.githubusercontent.com/u/6398845?v=3","gravatar_id":"","url":"https://api.github.com/users/serge-rider","html_url":"https://github.com/serge-rider","followers_url":"https://api.github.com/users/serge-rider/followers","following_url":"https://api.github.com/users/serge-rider/following{/other_user}","gists_url":"https://api.github.com/users/serge-rider/gists{/gist_id}","starred_url":"https://api.github.com/users/serge-rider/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/serge-rider/subscriptions","organizations_url":"https://api.github.com/users/serge-rider/orgs","repos_url":"https://api.github.com/users/serge-rider/repos","events_url":"https://api.github.com/users/serge-rider/events{/privacy}","received_events_url":"https://api.github.com/users/serge-rider/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":30,"state":"closed","created_at":"2016-10-05T10:25:15Z","updated_at":"2016-11-21T12:50:18Z","due_on":"2016-11-21T00:00:00Z","closed_at":"2016-11-21T12:50:18Z"},"comments":16,"created_at":"2016-10-19T09:48:11Z","updated_at":"2016-11-24T15:35:19Z","closed_at":"2016-10-25T18:43:04Z","body":"Hello,\n\nI am trying to get the keep-alive to work, but probably I am missing something.\n\nI am using a MySQL connection with SSH Tunnel, with public key, passphrase and save password enabled.\n\nI'll describe my steps in Database Navigator :\nIf I use Keep-Alive interval 30 seconds - I can initialize the connection, but if I explore to Connection -> Databases -> mydbname -> Tables I am getting a connection error immediately.\n   Connection with [myhost] lost\n   Reason:\n   SQL: Error [08S01]: Communications link failure\n   The last packet successfully received from the server was 3,048 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.\n\nIf I use Keep-Alive interval 120 seconds (as shown in the keep-alives feature request), I can navigate in my database normally, but after 2 minutes, I am getting a similar error to the first case.\n\nIf I don't use Keep-Alive interval (set to 0), everything works normally and obviously I get timed out after a few minutes.\n\nIn all cases if I click \"Test connection ...\" before applying the changes, the connection is established successfully.\n\nI tried figuring out what error 08S01 means, but it seems like a general connection error.\n\nDBeaver version: 3.7.6 (current latest) - and earlier\n\nThanks in advance, let me know if I can provide more details !\n"},"comment":{"url":"https://api.github.com/repos/serge-rider/dbeaver/issues/comments/262802178","html_url":"https://github.com/serge-rider/dbeaver/issues/860#issuecomment-262802178","issue_url":"https://api.github.com/repos/serge-rider/dbeaver/issues/860","id":262802178,"user":{"login":"dimitriadisg","id":14919500,"avatar_url":"https://avatars.githubusercontent.com/u/14919500?v=3","gravatar_id":"","url":"https://api.github.com/users/dimitriadisg","html_url":"https://github.com/dimitriadisg","followers_url":"https://api.github.com/users/dimitriadisg/followers","following_url":"https://api.github.com/users/dimitriadisg/following{/other_user}","gists_url":"https://api.github.com/users/dimitriadisg/gists{/gist_id}","starred_url":"https://api.github.com/users/dimitriadisg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimitriadisg/subscriptions","organizations_url":"https://api.github.com/users/dimitriadisg/orgs","repos_url":"https://api.github.com/users/dimitriadisg/repos","events_url":"https://api.github.com/users/dimitriadisg/events{/privacy}","received_events_url":"https://api.github.com/users/dimitriadisg/received_events","type":"User","site_admin":false},"created_at":"2016-11-24T15:35:19Z","updated_at":"2016-11-24T15:35:19Z","body":"Here is something interesting, if I set the keep-alive to 10000 everything works smooth ! My connection is not timed-out.\r\n\r\nCould it be that the keep-alive should be specified in milliseconds instead of seconds ?"}}
{"actor":{"display_login":"dimitriadisg"}}