Hi, I do not think that it is deadlock, it is timeout exception could you set storage.record.lockTimeout property to 200000 to double check ?
On Fri, Feb 20, 2015 at 1:08 AM, Kareem Jabr <[email protected]> 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Best regards, Andrey Lomakin. -- --- 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.
