janusgraph-users@lists.lfaidata.foundation | Janusgraph upgrade 0.5.2 --> 0.6.0 | CQL issue

Home Messages Hashtags Subgroups Calendar

Date Date 1 - 6 of 6

Janusgraph upgrade 0.5.2 --> 0.6.0 | CQL issue

Pawan Shriwas #6196 Hi Everyone, I am facing one issue with janusgraph version 0.6.0 where I am upgrading my janusgraph console/server/embedded from 0.5.2 to 0.6.0 version. Please see below stacktrace for the same. Please note that the same graph configuration was working on 0.5.2 version. Suggest how can i recover it. Stacktrack - 5858 [main] WARN org.apache.tinkerpop.gremlin.server.util.DefaultGraphManager - Graph [graph] configured at [/etc/opt/janusgraph/janusgraph.properties] could not be instantiated and will not be available in Gremlin Server. GraphFactory message: GraphFactory could not instantiate this Graph implementation [class org.janusgraph.core.JanusGraphFactory] java.lang.RuntimeException: GraphFactory could not instantiate this Graph implementation [class org.janusgraph.core.JanusGraphFactory] at org.apache.tinkerpop.gremlin.structure.util.GraphFactory.open(GraphFactory.java:84) at org.apache.tinkerpop.gremlin.structure.util.GraphFactory.open(GraphFactory.java:72) at org.apache.tinkerpop.gremlin.structure.util.GraphFactory.open(GraphFactory.java:106) at org.apache.tinkerpop.gremlin.server.util.DefaultGraphManager.addGraph(DefaultGraphManager.java:63) at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) at org.apache.tinkerpop.gremlin.server.util.DefaultGraphManager.<init>(DefaultGraphManager.java:58) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.apache.tinkerpop.gremlin.server.util.ServerGremlinExecutor.<init>(ServerGremlinExecutor.java:84) at org.apache.tinkerpop.gremlin.server.GremlinServer.<init>(GremlinServer.java:124) at org.apache.tinkerpop.gremlin.server.GremlinServer.<init>(GremlinServer.java:87) at org.janusgraph.graphdb.server.JanusGraphServer.start(JanusGraphServer.java:85) at org.janusgraph.graphdb.server.JanusGraphServer.main(JanusGraphServer.java:53) Caused by: java.lang.reflect.InvocationTargetException 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.apache.tinkerpop.gremlin.structure.util.GraphFactory.open(GraphFactory.java:80) ... 14 more Caused by: java.lang.IllegalArgumentException: Could not instantiate implementation: org.janusgraph.diskstorage.cql.CQLStoreManager at org.janusgraph.util.system.ConfigurationUtil.instantiate(ConfigurationUtil.java:79) at org.janusgraph.diskstorage.Backend.getImplementationClass(Backend.java:525) at org.janusgraph.diskstorage.Backend.getStorageManager(Backend.java:489) at org.janusgraph.graphdb.configuration.builder.GraphDatabaseConfigurationBuilder.build(GraphDatabaseConfigurationBuilder.java:64) at org.janusgraph.core.JanusGraphFactory.open(JanusGraphFactory.java:176) at org.janusgraph.core.JanusGraphFactory.open(JanusGraphFactory.java:147) at org.janusgraph.core.JanusGraphFactory.open(JanusGraphFactory.java:127) ... 19 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.janusgraph.util.system.ConfigurationUtil.instantiate(ConfigurationUtil.java:73) ... 25 more Caused by: org.janusgraph.diskstorage.PermanentBackendException: Couldn't initialize CQLStoreManager at org.janusgraph.diskstorage.cql.CQLStoreManager.<init>(CQLStoreManager.java:155) at org.janusgraph.diskstorage.cql.CQLStoreManager.<init>(CQLStoreManager.java:116) ... 30 more Caused by: com.datastax.oss.driver.api.core.servererrors.UnauthorizedException: Unauthorized. User graph_user has no CREATE permission on <all keyspaces> or any of its parents CREATE KEYSPACE IF NOT EXISTS graphDataTable WITH replication={'replication_factor':1,'class':'SimpleStrategy'} ^^^^^^ (ql error -4) at com.datastax.oss.driver.api.core.servererrors.UnauthorizedException.copy(UnauthorizedException.java:49) at com.datastax.oss.driver.internal.core.util.concurrent.CompletableFutures.getUninterruptibly(CompletableFutures.java:149) at com.datastax.oss.driver.internal.core.cql.CqlRequestSyncProcessor.process(CqlRequestSyncProcessor.java:53) at com.datastax.oss.driver.internal.core.cql.CqlRequestSyncProcessor.process(CqlRequestSyncProcessor.java:30) at com.datastax.oss.driver.internal.core.session.DefaultSession.execute(DefaultSession.java:230) at com.datastax.oss.driver.api.core.cql.SyncCqlSession.execute(SyncCqlSession.java:54) at org.janusgraph.diskstorage.cql.CQLStoreManager.initializeKeyspace(CQLStoreManager.java:191) at org.janusgraph.diskstorage.cql.CQLStoreManager.<init>(CQLStoreManager.java:142) ... 31 more Thanks, Pawan
More All Messages By This Member
hadoopmarc@... #6199 Hi Pawan, Caused by: com.datastax.oss.driver.api.core.servererrors.UnauthorizedException: Unauthorized. User graph_user has no CREATE permission on <all keyspaces> or any of its parents CREATE KEYSPACE IF NOT EXISTS graphDataTable WITH replication={'replication_factor':1,'class':'SimpleStrategy'} This part of your stacktrace suggests that something changed on your Cassandra cluster or with the graph_user. So, check the CREATE permission, with your admin or try to create a keyspace with nodetool. Also note that a few changes in cql properties had to be made (but probably not related): https://docs.janusgraph.org/v0.6/changelog/ Best wishes, Marc
More All Messages By This Member
Pawan Shriwas #6200 Hi Marc, Thanks for your reply, But nothing was changed on the cassandra cluster part, Keyspace is already there with graph data and it was working before the janusgraph version upgrade. I don't know but it seems new version(0.6.0) creates a keyspace again while that keyspace is already there and available in DB and has access to that user. Thanks, Pawan toggle quoted message Show quoted text On Fri, Oct 8, 2021 at 12:07 PM <hadoopmarc@...> wrote: Hi Pawan, Caused by: com.datastax.oss.driver.api.core.servererrors.UnauthorizedException: Unauthorized. User graph_user has no CREATE permission on <all keyspaces> or any of its parents CREATE KEYSPACE IF NOT EXISTS graphDataTable WITH replication={'replication_factor':1,'class':'SimpleStrategy'} This part of your stacktrace suggests that something changed on your Cassandra cluster or with the graph_user. So, check the CREATE permission, with your admin or try to create a keyspace with nodetool. Also note that a few changes in cql properties had to be made (but probably not related): https://docs.janusgraph.org/v0.6/changelog/ Best wishes, Marc -- Thanks & Regard PAWAN SHRIWAS
More All Messages By This Member
hadoopmarc@... #6201 Hi Pawan, It seems I miss the practical experience, but it seems you have to set graph.allow-upgrade=true (although it is not clear whether this applies to all version changes or only to "storage version" changes) https://docs.janusgraph.org/v0.6/configs/configuration-reference/ If this is the solution, the error message is certainly not helpful and the upgrade docs incomplete. Best wishes, Marc
More All Messages By This Member
Pawan Shriwas #6202 Hi Marc, I have also tried with "graph.allow-upgrade=true" and added "storage.cql.request-timeout" as well but am still facing the same issue. Please check the attached janusgraph server log for your reference. janusgraph version 0.6.0 Cassandra details - Cassandra 3.9 Snapshot \| CQL 3.4.2 Thanks, Pawan toggle quoted message Show quoted text On Fri, Oct 8, 2021 at 8:52 PM <hadoopmarc@...> wrote: Hi Pawan, It seems I miss the practical experience, but it seems you have to set graph.allow-upgrade=true (although it is not clear whether this applies to all version changes or only to "storage version" changes) https://docs.janusgraph.org/v0.6/configs/configuration-reference/ If this is the solution, the error message is certainly not helpful and the upgrade docs incomplete. Best wishes, Marc -- Thanks & Regard PAWAN SHRIWAS error-gremlin error-gremlin
More All Messages By This Member
hadoopmarc@... #6205 Hi Pawan, OK, I did a small upgrade session myself and did not encounter any issues (apart from having to set numTokens: 4 in conf/cassandra.yaml). This is what I did: Start from a fresh janusgraph-full-0.5.3 distribution (so, with an empty db folder) Run bin/janusgraph.sh start Run bin/gremlin.sh and graph = JanusGraphFactory.open('conf/janusgraph-cql-es.properties') GraphOfTheGodsFactory.load(graph) :q Run bin/janusgraph.sh stop Start from a fresh janusgraph-full-0.6.0 distribution (so, with an empty db folder) Copy the db folder from janusgraph-full-0.5.3/db to janusgraph-full-0.6.0 Set set numTokens: 4 in conf/cassandra.yaml Run bin/janusgraph.sh start Run bin/gremlin.sh and graph = JanusGraphFactory.open('conf/janusgraph-cql-es.properties') graph.traversal().V() Can you reproduce your issue in a similar way? Best wishes, Marc
More All Messages By This Member

1 - 6 of 6

1

Previous Topic Next Topic

Home Hashtags Subgroups Calendar Terms