{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4631","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4631/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4631/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4631/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4631","id":96577518,"number":4631,"title":"Select statement against large database produce OOM in Orient Distributed server 2.0.12","user":{"login":"shlapkov","id":6439778,"avatar_url":"https://avatars.githubusercontent.com/u/6439778?v=3","gravatar_id":"","url":"https://api.github.com/users/shlapkov","html_url":"https://github.com/shlapkov","followers_url":"https://api.github.com/users/shlapkov/followers","following_url":"https://api.github.com/users/shlapkov/following{/other_user}","gists_url":"https://api.github.com/users/shlapkov/gists{/gist_id}","starred_url":"https://api.github.com/users/shlapkov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shlapkov/subscriptions","organizations_url":"https://api.github.com/users/shlapkov/orgs","repos_url":"https://api.github.com/users/shlapkov/repos","events_url":"https://api.github.com/users/shlapkov/events{/privacy}","received_events_url":"https://api.github.com/users/shlapkov/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/waiting%20reply","name":"waiting reply","color":"eb6420"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-07-22T14:09:11Z","updated_at":"2015-07-27T06:25:35Z","closed_at":null,"body":"Steps to reproduce:\n1.\tDownload Orient DB community editions 2.0.12 from : http://orientdb.com/download/\n2.\tCopy any large database 1.7.x into: orientdb-community-2.0.12/databases\n3.\tStart: dserver.bat from bin folder. Start console.bat connect to remote db. “connect remote:localhost:2424/spectrum admin admin”\n4.\tRun: “select * from platform-Version limit=50000”\n5.\tNotice OOM error on server:\n\nFetching error on record #49:3753\ncom.orientechnologies.orient.core.exception.ODatabaseException: Error on retrieving record #35:3753\n(cluster: platform-versioncontents)\n        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.executeReadRecord(ODat\nbaseDocumentTx.java:1640)\n        at com.orientechnologies.orient.core.tx.OTransactionNoTx.loadRecord(OTransactionNoTx.java:8\n)\n        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.load(ODatabaseDocument\nx.java:1452)\n        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.load(ODatabaseDocument\nx.java:118)\n        at com.orientechnologies.orient.core.record.impl.ODocument.field(ODocument.java:871)\n        at com.orientechnologies.orient.core.fetch.OFetchHelper.processRecordRidMap(OFetchHelper.ja\na:140)\n        at com.orientechnologies.orient.core.fetch.OFetchHelper.fetch(OFetchHelper.java:70)\n        at com.orientechnologies.orient.server.network.protocol.binary.OAbstractCommandResultListen\nr.fetchRecord(OAbstractCommandResultListener.java:54)\n        at com.orientechnologies.orient.server.network.protocol.binary.OSyncCommandResultListener.r\nsult(OSyncCommandResultListener.java:40)\n        at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.comma\nd(ONetworkProtocolBinary.java:1229)\n        at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execu\neRequest(ONetworkProtocolBinary.java:390)\n        at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstra\nt.execute(OBinaryNetworkProtocolAbstract.java:217)\n        at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)\nCaused by: java.lang.OutOfMemoryError: Java heap space\nFetching error on record #49:3754\ncom.orientechnologies.orient.core.exception.ODatabaseException: Error on retrieving record #35:3754\n(cluster: platform-versioncontents)\n        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.executeReadRecord(ODat\nbaseDocumentTx.java:1640)\n        at com.orientechnologies.orient.core.tx.OTransactionNoTx.loadRecord(OTransactionNoTx.java:8\n)\n        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.load(ODatabaseDocument\nx.java:1452)\n        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.load(ODatabaseDocument\nx.java:118)\n        at com.orientechnologies.orient.core.record.impl.ODocument.field(ODocument.java:871)\n        at com.orientechnologies.orient.core.fetch.OFetchHelper.processRecordRidMap(OFetchHelper.ja\na:140)\n        at com.orientechnologies.orient.core.fetch.OFetchHelper.fetch(OFetchHelper.java:70)\n        at com.orientechnologies.orient.server.network.protocol.binary.OAbstractCommandResultListen\nr.fetchRecord(OAbstractCommandResultListener.java:54)\n        at com.orientechnologies.orient.server.network.protocol.binary.OSyncCommandResultListener.r\nsult(OSyncCommandResultListener.java:40)\n        at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.comma\nd(ONetworkProtocolBinary.java:1229)\n        at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execu\neRequest(ONetworkProtocolBinary.java:390)\n        at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstra\nt.execute(OBinaryNetworkProtocolAbstract.java:217)\n        at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)\nCaused by: java.lang.OutOfMemoryError: Java heap space\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/125100959","html_url":"https://github.com/orientechnologies/orientdb/issues/4631#issuecomment-125100959","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4631","id":125100959,"user":{"login":"luigidellaquila","id":459289,"avatar_url":"https://avatars.githubusercontent.com/u/459289?v=3","gravatar_id":"","url":"https://api.github.com/users/luigidellaquila","html_url":"https://github.com/luigidellaquila","followers_url":"https://api.github.com/users/luigidellaquila/followers","following_url":"https://api.github.com/users/luigidellaquila/following{/other_user}","gists_url":"https://api.github.com/users/luigidellaquila/gists{/gist_id}","starred_url":"https://api.github.com/users/luigidellaquila/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luigidellaquila/subscriptions","organizations_url":"https://api.github.com/users/luigidellaquila/orgs","repos_url":"https://api.github.com/users/luigidellaquila/repos","events_url":"https://api.github.com/users/luigidellaquila/events{/privacy}","received_events_url":"https://api.github.com/users/luigidellaquila/received_events","type":"User","site_admin":false},"created_at":"2015-07-27T06:25:34Z","updated_at":"2015-07-27T06:25:34Z","body":"Hi @shlapkov \n\ndoes it only happen when you migrate a db from 1.7.x?"}}