Re: Getting TemporaryLockingException: No lock columns found for KeyColumn for mgmt.commit()
padmasr...@...
Hi Jason,
Thank You..I have changed the values as you said..still getting same exception..
cassandra keyspace:
CREATE KEYSPACE keyspaceName WITH replication = {'class': 'NetworkTopologyStrategy', 'dc1': '2', 'dc2': '1', 'dc3': '1'} AND durable_writes = true;
also checked that cassandra nodes are sync and running properly..
On Thursday, 31 August 2017 18:48:40 UTC+5:30, pad...@... wrote:
Using janusgraph-0.1.0-hadoop2 with backend cassandra-3.0.14:This is the configuration file:storage.backend=cassandrathrift storage.hostname=hostName1storage.cassandra.keyspace=keyspaceName storage.batch-loading=falsecache.db-cache=truecache.db-cache-time = 180000cache.db-cache-size = 0.25storage.lock.wait-time=300000storage.lock.retries=10storage.lock.clean-expired=true storage.buffer-size=512ids.block-size=300000storage.cassandra.compression=false storage.lock.expiry-time=100index.search.backend=elasticsearch index.search.hostname=es-hostName index.search.elasticsearch.client-only=true storage.connection-timeout=300000 Tried to create a new label with new cassandra keyspace(empty keyspace)..but getting below exception:graph = JanusGraphFactory.open('janus.properties') mgmt= graph.openManagement()labelName = mgmt.makeVertexLabel('labelName').make() mgmt.commit()Could not commit transaction due to exception during persistenceType ':help' or ':h' for help.Display stack trace? [yN]yorg.janusgraph.core.JanusGraphException: Could not commit transaction due to exception during persistence at org.janusgraph.graphdb.transaction. StandardJanusGraphTx.commit( StandardJanusGraphTx.java: 1374) at org.janusgraph.graphdb.database.management. ManagementSystem.commit( ManagementSystem.java:235) at org.janusgraph.core.schema.JanusGraphManagement$commit. call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray. defaultCall(CallSiteArray. java:48) at org.codehaus.groovy.runtime.callsite.AbstractCallSite. call(AbstractCallSite.java: 113) at org.codehaus.groovy.runtime.callsite.AbstractCallSite. call(AbstractCallSite.java: 117) at groovysh_evaluate.run(groovysh_evaluate:3) at org.codehaus.groovy.vmplugin.v7.IndyInterface.selectMethod( IndyInterface.java:232) at org.codehaus.groovy.tools.shell.Interpreter.evaluate( Interpreter.groovy:70) at org.codehaus.groovy.tools.shell.Groovysh.execute( Groovysh.groovy:190) at org.apache.tinkerpop.gremlin.console.GremlinGroovysh.super$ 3$execute(GremlinGroovysh. groovy) at sun.reflect.GeneratedMethodAccessor14. invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.reflection.CachedMethod. invoke(CachedMethod.java:93) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod. java:325) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl. java:1215) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter. invokeMethodOnSuperN( ScriptBytecodeAdapter.java: 132) at org.apache.tinkerpop.gremlin.console.GremlinGroovysh. execute(GremlinGroovysh. groovy:72) at org.codehaus.groovy.tools.shell.Shell.leftShift(Shell. groovy:122) at org.codehaus.groovy.tools.shell.InteractiveShellRunner. super$2$work( InteractiveShellRunner.groovy) at sun.reflect.NativeMethodAccessorImpl. invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl. invoke( NativeMethodAccessorImpl.java: 62) at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.reflection.CachedMethod. invoke(CachedMethod.java:93) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod. java:325) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl. java:1215) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter. invokeMethodOnSuperN( ScriptBytecodeAdapter.java: 132) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter. invokeMethodOnSuper0( ScriptBytecodeAdapter.java: 152) at org.codehaus.groovy.tools.shell.ShellRunner.run( ShellRunner.groovy:59) at org.codehaus.groovy.tools.shell.InteractiveShellRunner. super$2$run( InteractiveShellRunner.groovy) at sun.reflect.NativeMethodAccessorImpl. invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl. invoke( NativeMethodAccessorImpl.java: 62) at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.reflection.CachedMethod. invoke(CachedMethod.java:93) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod. java:325) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl. java:1215) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter. invokeMethodOnSuperN( ScriptBytecodeAdapter.java: 132) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter. invokeMethodOnSuper0( ScriptBytecodeAdapter.java: 152) at org.codehaus.groovy.tools.shell.InteractiveShellRunner. run(InteractiveShellRunner. groovy:83) at org.codehaus.groovy.vmplugin.v7.IndyInterface.selectMethod( IndyInterface.java:232) at org.apache.tinkerpop.gremlin.console.Console.<init>( Console.groovy:152) at org.codehaus.groovy.vmplugin.v7.IndyInterface.selectMethod( IndyInterface.java:232) at org.apache.tinkerpop.gremlin.console.Console.main(Console. groovy:455) Caused by: org.janusgraph.core.JanusGraphException: Could not execute operation due to backend exception at org.janusgraph.diskstorage.util.BackendOperation.execute( BackendOperation.java:57) at org.janusgraph.diskstorage.keycolumnvalue.cache. CacheTransaction.persist( CacheTransaction.java:95) at org.janusgraph.diskstorage.keycolumnvalue.cache. CacheTransaction. flushInternal( CacheTransaction.java:143) at org.janusgraph.diskstorage.keycolumnvalue.cache. CacheTransaction.commit( CacheTransaction.java:200) at org.janusgraph.diskstorage.BackendTransaction.commit( BackendTransaction.java:150) at org.janusgraph.graphdb.database.StandardJanusGraph. commit(StandardJanusGraph. java:703) at org.janusgraph.graphdb.transaction. StandardJanusGraphTx.commit( StandardJanusGraphTx.java: 1363) ... 47 moreCaused by: org.janusgraph.diskstorage.TemporaryBackendException: Could not successfully complete backend operation due to repeated temporary exceptions after PT3M20S at org.janusgraph.diskstorage.util.BackendOperation. executeDirect( BackendOperation.java:101) at org.janusgraph.diskstorage.util.BackendOperation.execute( BackendOperation.java:55) ... 53 moreCaused by: org.janusgraph.diskstorage.locking. TemporaryLockingException: No lock columns found for KeyColumn [k=0x 16-165-160-118-108- 30-114-101-113-117-101-115- 116- 95-106-111-226, c=0x 0] at org.janusgraph.diskstorage.locking.consistentkey. ConsistentKeyLocker. checkSeniority( ConsistentKeyLocker.java:519) at org.janusgraph.diskstorage.locking.consistentkey. ConsistentKeyLocker. checkSingleLock( ConsistentKeyLocker.java:454) at org.janusgraph.diskstorage.locking.consistentkey. ConsistentKeyLocker. checkSingleLock( ConsistentKeyLocker.java:123) at org.janusgraph.diskstorage.locking.AbstractLocker. checkLocks(AbstractLocker. java:351) at org.janusgraph.diskstorage.locking.consistentkey. ExpectedValueCheckingTransacti on.checkAllLocks( ExpectedValueCheckingTransacti on.java:178) at org.janusgraph.diskstorage.locking.consistentkey. ExpectedValueCheckingTransacti on.prepareForMutations( ExpectedValueCheckingTransacti on.java:157) at org.janusgraph.diskstorage.locking.consistentkey. ExpectedValueCheckingStoreMana ger.mutateMany( ExpectedValueCheckingStoreMana ger.java:72) at org.janusgraph.diskstorage.keycolumnvalue.cache. CacheTransaction$1.call( CacheTransaction.java:98) at org.janusgraph.diskstorage.keycolumnvalue.cache. CacheTransaction$1.call( CacheTransaction.java:95) at org.janusgraph.diskstorage.util.BackendOperation. executeDirect( BackendOperation.java:69) ...54 more