{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6499","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6499/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6499/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6499/events","html_url":"https://github.com/orientechnologies/orientdb/issues/6499","id":168946844,"number":6499,"title":"OutOfMemory due to hanging client(?)","user":{"login":"smil2k","id":2590036,"avatar_url":"https://avatars.githubusercontent.com/u/2590036?v=3","gravatar_id":"","url":"https://api.github.com/users/smil2k","html_url":"https://github.com/smil2k","followers_url":"https://api.github.com/users/smil2k/followers","following_url":"https://api.github.com/users/smil2k/following{/other_user}","gists_url":"https://api.github.com/users/smil2k/gists{/gist_id}","starred_url":"https://api.github.com/users/smil2k/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smil2k/subscriptions","organizations_url":"https://api.github.com/users/smil2k/orgs","repos_url":"https://api.github.com/users/smil2k/repos","events_url":"https://api.github.com/users/smil2k/events{/privacy}","received_events_url":"https://api.github.com/users/smil2k/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/bug","name":"bug","color":"ededed"},{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/resolved","name":"resolved","color":"bfe5bf"}],"state":"open","locked":false,"assignee":{"login":"tglman","id":424369,"avatar_url":"https://avatars.githubusercontent.com/u/424369?v=3","gravatar_id":"","url":"https://api.github.com/users/tglman","html_url":"https://github.com/tglman","followers_url":"https://api.github.com/users/tglman/followers","following_url":"https://api.github.com/users/tglman/following{/other_user}","gists_url":"https://api.github.com/users/tglman/gists{/gist_id}","starred_url":"https://api.github.com/users/tglman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tglman/subscriptions","organizations_url":"https://api.github.com/users/tglman/orgs","repos_url":"https://api.github.com/users/tglman/repos","events_url":"https://api.github.com/users/tglman/events{/privacy}","received_events_url":"https://api.github.com/users/tglman/received_events","type":"User","site_admin":false},"assignees":[{"login":"tglman","id":424369,"avatar_url":"https://avatars.githubusercontent.com/u/424369?v=3","gravatar_id":"","url":"https://api.github.com/users/tglman","html_url":"https://github.com/tglman","followers_url":"https://api.github.com/users/tglman/followers","following_url":"https://api.github.com/users/tglman/following{/other_user}","gists_url":"https://api.github.com/users/tglman/gists{/gist_id}","starred_url":"https://api.github.com/users/tglman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tglman/subscriptions","organizations_url":"https://api.github.com/users/tglman/orgs","repos_url":"https://api.github.com/users/tglman/repos","events_url":"https://api.github.com/users/tglman/events{/privacy}","received_events_url":"https://api.github.com/users/tglman/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/96","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.2.7","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/96/labels","id":1917485,"number":96,"title":"2.2.7","description":"","creator":{"login":"robfrank","id":413587,"avatar_url":"https://avatars.githubusercontent.com/u/413587?v=3","gravatar_id":"","url":"https://api.github.com/users/robfrank","html_url":"https://github.com/robfrank","followers_url":"https://api.github.com/users/robfrank/followers","following_url":"https://api.github.com/users/robfrank/following{/other_user}","gists_url":"https://api.github.com/users/robfrank/gists{/gist_id}","starred_url":"https://api.github.com/users/robfrank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robfrank/subscriptions","organizations_url":"https://api.github.com/users/robfrank/orgs","repos_url":"https://api.github.com/users/robfrank/repos","events_url":"https://api.github.com/users/robfrank/events{/privacy}","received_events_url":"https://api.github.com/users/robfrank/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":19,"state":"closed","created_at":"2016-08-02T06:59:20Z","updated_at":"2016-08-25T12:56:29Z","due_on":"2016-08-10T05:00:00Z","closed_at":"2016-08-11T15:31:07Z"},"comments":20,"created_at":"2016-08-02T17:50:25Z","updated_at":"2016-09-06T12:12:24Z","closed_at":null,"body":"## OrientDB Version, operating system, or hardware.\r\n- v2.2.5, 2.2.7\r\n\r\n## Operating System\r\n- [x] Linux\r\n- [ ] MacOSX\r\n- [ ] Windows\r\n- [ ] Other Unix\r\n- [ ] Other, name? \r\n\r\n## Expected behavior and actual behavior\r\n\r\nWe experienced a memory leak / out-of-memory error. Looking at the heap dump a bufferedoutputstream took all the memory:\r\n[big.zip](https://github.com/orientechnologies/orientdb/files/397737/big.zip)\r\n\r\nHeapdump is available on request.\r\n\r\nMost likely the client was disconnected or blocked or simply very slow, and orient stored the data in memory.\r\n\r\nSide node:\r\nHow can I figure out which query needed  500mb data to be transferred?\r\n\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/244931331","html_url":"https://github.com/orientechnologies/orientdb/issues/6499#issuecomment-244931331","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/6499","id":244931331,"user":{"login":"mikayeln","id":5030123,"avatar_url":"https://avatars.githubusercontent.com/u/5030123?v=3","gravatar_id":"","url":"https://api.github.com/users/mikayeln","html_url":"https://github.com/mikayeln","followers_url":"https://api.github.com/users/mikayeln/followers","following_url":"https://api.github.com/users/mikayeln/following{/other_user}","gists_url":"https://api.github.com/users/mikayeln/gists{/gist_id}","starred_url":"https://api.github.com/users/mikayeln/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikayeln/subscriptions","organizations_url":"https://api.github.com/users/mikayeln/orgs","repos_url":"https://api.github.com/users/mikayeln/repos","events_url":"https://api.github.com/users/mikayeln/events{/privacy}","received_events_url":"https://api.github.com/users/mikayeln/received_events","type":"User","site_admin":false},"created_at":"2016-09-06T12:12:24Z","updated_at":"2016-09-06T12:12:24Z","body":"Hi @tglman, \n\nYes I did. \n\nexecuting following script\n\nvar server = com.orientechnologies.orient.server.OServerMain.server();\nif(server != null) {    \n    var cm = server.getClientConnectionManager();\n    if(cm != null) {        \n        cm.cleanExpiredConnections();\n        var conns = cm.getConnections().toArray();\n        var arr = [];\n        arr.push(\"Connections:\" + conns.length);\n        for(var i = 0;i < conns.length;i++){\n          \n          var tokens = conns[i].getStats().lastCommandInfo + \";\" +conns[i].getStats().lastCommandDetail + \";\" + (conns[i].getToken()===null?\"\":conns[i].getToken().getDatabase() + \";\" + conns[i].getToken().getDatabaseType() + \";\" + new Date(conns[i].getToken().getExpiry()) + \";\" + conns[i].getToken().isNowValid() + \";\" + conns[i].getToken().getIsValid());\n          arr.push(tokens);          \n          \n        }\n      conns = cm.getConnections().toArray();        \t\n        \tarr.push(\"Connections After:\" + conns.length);\n        return arr;\n    } else {\n        print('cannot get cm from server');\n    }\n} else {\n    print('cannot get server');\n}\n\ni'm getting interesing output. There are a lot of following \"connections\"\n\n\"Retrieve ceiling positions;-;ws1;plocal;Tue Sep 06 2016 18:01:38 GMT+0600 (NOVT);false;true\",\n\"Count cluster elements;-;ws1;plocal;Tue Sep 06 2016 18:08:51 GMT+0600 (NOVT);true;true\",\n \"Get the begin/end range of data in cluster;-;ws1;plocal;Tue Sep 06 2016 18:01:38 GMT+0600 (NOVT);false;true\"\n\nnetwork.maxConcurrentSessions is set to 200. And now for idle application I have 98 \"connections\"."}}
{"actor":{"display_login":"mikayeln"}}