Hi, I am tried the following after seeing it somewhere here: OGlobalConfiguration.STORAGE_LOCK_TIMEOUT.setValue(5 * 60 * 1000); but the same issue occurs.
How and where to set storage.record.lockTimeout? Do I have to do it in <properties> inside the orientdb-server-config.xml? On Friday, February 20, 2015 at 9:44:58 AM UTC+4, Andrey Lomakin wrote: > > 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 <karee...@gmail.com > <javascript:>> 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-databa...@googlegroups.com <javascript:>. >> 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.