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 the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
