Im using object api not the graph. And it happens when i clear multiple lists of nested objects, like, match.getGoals.clear then I call match.getGoals.addAll(newGoalsList) i see in the errors log orientdb exception regarding not found records #27.6765 some id. And then the timeout exception lock. I will post the thread dump when the exception occurs to get a clear idea about the error.
Thanks On Mar 2, 2015 11:46 PM, "alexander anguiano" <[email protected]> wrote: > i also was getting this. It seems when you do thing using the graphdb it > cause problems > > My queries and updates where like this > > select * from groups where @rid = #12:3 > > I change them to this > > select * from #12:3 > > I had updates like this > > update table set mfield = 12 where @rid = #14:4 > > i changed the to this > > > UPDATE (select expand(in('Target')) from #14:4) set tags = 'mytag' > > Also, i don't think you can parameterize that so you have to do this' > > UPDATE (select expand(in('Target')) from #%s) set tags = '%s' > > > > On Thursday, February 19, 2015 at 5:08:59 PM UTC-6, Kareem Jabr wrote: >> >> I am facing this exception a lot now, >> >> in context with path [/aa-sport] threw exception >> [com.orientechnologies.orient.core.exception.ODatabaseException: Error >> on retrieving record #27:165831 (cluster: event)] with root cause >> com.orientechnologies.common.concur.OTimeoutException: Can not lock >> record for 2000 ms. seems record is deadlocked by other record >> at com.orientechnologies.orient.core.storage.impl.local. >> OAbstractPaginatedStorage.acquireReadLock(OAbstractPaginatedStorage. >> java:1308) >> at com.orientechnologies.orient.core.tx.OTransactionAbstract. >> lockRecord(OTransactionAbstract.java:120) >> at com.orientechnologies.orient.core.id.ORecordId.lock( >> ORecordId.java:282) >> at com.orientechnologies.orient.core.storage.impl.local. >> OAbstractPaginatedStorage.lockRecord(OAbstractPaginatedStorage.java:1784) >> at com.orientechnologies.orient.core.storage.impl.local. >> OAbstractPaginatedStorage.readRecord(OAbstractPaginatedStorage.java:1424) >> at com.orientechnologies.orient.core.storage.impl.local. >> OAbstractPaginatedStorage.readRecord(OAbstractPaginatedStorage.java:697) >> at com.orientechnologies.orient.core.db.document. >> ODatabaseDocumentTx.executeReadRecord(ODatabaseDocumentTx.java:1572) >> at com.orientechnologies.orient.core.tx.OTransactionNoTx. >> loadRecord(OTransactionNoTx.java:80) >> at com.orientechnologies.orient.core.db.document. >> ODatabaseDocumentTx.load(ODatabaseDocumentTx.java:1437) >> at com.orientechnologies.orient.server.network.protocol. >> binary.ONetworkProtocolBinary.readRecord(ONetworkProtocolBinary.java: >> 1453) >> at com.orientechnologies.orient.server.network.protocol. >> binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java: >> 346) >> at com.orientechnologies.orient.server.network.protocol.binary. >> OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract >> .java:216) >> at com.orientechnologies.common.thread.OSoftThread.run( >> OSoftThread.java:65) >> >> I have a web app running on tomcat 7.0.59 and 2.0.2 OrientDB. >> >> I am initializing the DB once tomcat starts >> db = getOObjectDatabaseTx(); >> db.setAutomaticSchemaGeneration(true); >> db.getEntityManager().registerEntityClasses("com.sport.server.model"); >> >> >> public OObjectDatabaseTx getOObjectDatabaseTx() { >> return OObjectDatabasePool.global().acquire(PropertiesManager. >> getInstance().getProperty(ENDPOINT_URL), PropertiesManager.getInstance( >> ).getProperty(DB_USERNAME), >> PropertiesManager.getInstance().getProperty(DB_PASSWORD)); >> } >> >> Please help me in this.. And let me know if I am doing something wrong >> here. I have a scheduler running to update the DB every couple of secs. >> This exception happens when I try to read from the DB while writing is >> occurring. I believe.. >> >> >> >> -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/INf_ennAN7o/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
