{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4666","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4666/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4666/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4666/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4666","id":97738187,"number":4666,"title":"Exception:  \"com.orientechnologies.orient.core.index.sbtree.local.OSBTreeException: Null keys are not supported.\" when using Orient DB build 2.0.13 with 1.7.x database.","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/in%20progress","name":"in progress","color":"CCCCCC"}],"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},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/58","html_url":"https://github.com/orientechnologies/orientdb/milestones/2.0.14","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/milestones/58/labels","id":1221150,"number":58,"title":"2.0.14","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2015-07-22T22:07:22Z","updated_at":"2015-07-28T16:11:31Z","due_on":"2015-08-04T22:00:00Z","closed_at":null},"comments":5,"created_at":"2015-07-28T15:41:56Z","updated_at":"2015-07-29T09:48:35Z","closed_at":null,"body":"jvm 1    | ERROR [OCommandExecutorSQLSelect] {db=spectrum} Error on using index IndexChain{platform-\nDataflowStage0_idx, platform-Dataflow_pk} in query 'select @class, id, serverId, stageLabel, stageNa\nme, stageId, dataflow, versions from platform-DataflowStage WHERE (dataflow.id = \"Microflow_Sort_sf\"\n AND versions CONTAINS \"LatestSaved\") SKIP 0 LIMIT 2147483647'. Probably you need to rebuild indexes\n. Now executing query using cluster scan\njvm 1    | com.orientechnologies.orient.core.index.sbtree.local.OSBTreeException: Null keys are not\nsupported.\njvm 1    |      at com.orientechnologies.orient.core.index.sbtree.local.OSBTree.checkNullSupport(OSB\nTree.java:789) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.index.sbtree.local.OSBTree.get(OSBTree.java:176\n) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.index.engine.OSBTreeIndexEngine.get(OSBTreeInde\nxEngine.java:224) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.index.OIndexMultiValues$1.nextEntry(OIndexMulti\nValues.java:398) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OChainedIndexProxy.cursorToList(OChainedInd\nexProxy.java:367) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OChainedIndexProxy.applyFirstIndex(OChained\nIndexProxy.java:351) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OChainedIndexProxy.applyTailIndexes(OChaine\ndIndexProxy.java:338) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OChainedIndexProxy.get(OChainedIndexProxy.j\nava:293) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.operator.OQueryOperatorEquals.executeIndexQ\nuery(OQueryOperatorEquals.java:129) ~[orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.searchForIndexes(\nOCommandExecutorSQLSelect.java:1509) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.searchInClasses(O\nCommandExecutorSQLSelect.java:740) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLResultsetAbstract.assign\nTarget(OCommandExecutorSQLResultsetAbstract.java:194) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.assignTarget(OCom\nmandExecutorSQLSelect.java:420) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.executeSearch(OCo\nmmandExecutorSQLSelect.java:402) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.execute(OCommandE\nxecutorSQLSelect.java:373) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OComman\ndExecutorSQLDelegate.java:64) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.ex\necuteCommand(OAbstractPaginatedStorage.java:1191) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.co\nmmand(OAbstractPaginatedStorage.java:1180) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.query.OSQLQuery.run(OSQLQuery.java:71) [ori\nentdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.sql.query.OSQLSynchQuery.run(OSQLSynchQuery.jav\na:85) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.core.query.OQueryAbstract.execute(OQueryAbstract.jav\na:33) [orientdb-core-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinar\ny.command(ONetworkProtocolBinary.java:1183) [orientdb-server-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinar\ny.executeRequest(ONetworkProtocolBinary.java:390) [orientdb-server-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtoco\nlAbstract.execute(OBinaryNetworkProtocolAbstract.java:217) [orientdb-server-2.0.13.jar:2.0.13]\njvm 1    |      at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69) [orientd\nb-core-2.0.13.jar:2.0.13]"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/125899016","html_url":"https://github.com/orientechnologies/orientdb/issues/4666#issuecomment-125899016","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4666","id":125899016,"user":{"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},"created_at":"2015-07-29T09:48:35Z","updated_at":"2015-07-29T09:48:35Z","body":"hi @shlapkov,\n\nI wrote a test case for try to reproduce your issue here it is: https://gist.github.com/tglman/cf82e0e47978fd175733, but i couldn't, can you check it or can you send us the database with the platform-DataflowStage and platform-Dataflow classes with relative data and indexes.\n\nthank you "}}