Skip to content

InvalidQueryException: table system_properties does not exist #4011

Closed

Description

@xiaodizi

The source code I built is the source code of the master branch. I set up a three-node cassandra cluster using virtual machines. When configuring the graph to store in the cassandra cluster, the following error occurred:

image

But the table has actually been created in cassandra. It already exists.

Full error log

gremlin> graph = JanusGraphFactory.open('../config/janusgraph-cql-opensearch.properties'); 19:49:10 INFO org.apache.commons.beanutils.FluentPropertyBeanIntrospector.introspect - Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 19:49:10 INFO com.datastax.oss.driver.internal.core.DefaultMavenCoordinates.buildFromResourceAndPrint - DataStax Java driver for Apache Cassandra(R) (com.datastax.oss:java-driver-core) version 4.15.0 19:49:11 INFO com.datastax.oss.driver.internal.core.time.Clock.getInstance - Could not access native clock (see debug logs for details), falling back to Java system clock 19:49:11 INFO org.janusgraph.diskstorage.configuration.ExecutorServiceBuilder.buildFixedExecutorService - Initiated fixed thread pool of size 32 table system_properties does not exist Type ':help' or ':h' for help. Display stack trace? [yN]y com.datastax.oss.driver.api.core.servererrors.InvalidQueryException: table system_properties does not exist at com.datastax.oss.driver.api.core.servererrors.InvalidQueryException.copy(InvalidQueryException.java:48) at com.datastax.oss.driver.internal.core.util.concurrent.CompletableFutures.getUninterruptibly(CompletableFutures.java:149) at com.datastax.oss.driver.internal.core.cql.CqlPrepareSyncProcessor.process(CqlPrepareSyncProcessor.java:59) at com.datastax.oss.driver.internal.core.cql.CqlPrepareSyncProcessor.process(CqlPrepareSyncProcessor.java:31) at com.datastax.oss.driver.internal.core.session.DefaultSession.execute(DefaultSession.java:230) at com.datastax.oss.driver.api.core.cql.SyncCqlSession.prepare(SyncCqlSession.java:206) at org.janusgraph.diskstorage.cql.CQLKeyColumnValueStore.<init>(CQLKeyColumnValueStore.java:217) at org.janusgraph.diskstorage.cql.CQLStoreManager.lambda$openDatabase$7(CQLStoreManager.java:309) at java.base/java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1705) at org.janusgraph.diskstorage.cql.CQLStoreManager.openDatabase(CQLStoreManager.java:309) at org.janusgraph.diskstorage.keycolumnvalue.KeyColumnValueStoreManager.openDatabase(KeyColumnValueStoreManager.java:43) at org.janusgraph.diskstorage.configuration.backend.builder.KCVSConfigurationBuilder.buildStandaloneGlobalConfiguration(KCVSConfigurationBuilder.java:51) at org.janusgraph.diskstorage.configuration.builder.ReadConfigurationBuilder.buildGlobalConfiguration(ReadConfigurationBuilder.java:71) at org.janusgraph.graphdb.configuration.builder.GraphDatabaseConfigurationBuilder.build(GraphDatabaseConfigurationBuilder.java:67) 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:94) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at groovysh_evaluate.run(groovysh_evaluate:3) at org.codehaus.groovy.vmplugin.v8.IndyInterface.selectMethod(IndyInterface.java:355) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at org.apache.groovy.groovysh.Interpreter.evaluate(Interpreter.groovy:82) at org.apache.groovy.groovysh.Groovysh.execute(Groovysh.groovy:209) at org.apache.tinkerpop.gremlin.console.GremlinGroovysh.super$3$execute(GremlinGroovysh.groovy) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:343) at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:328) at groovy.lang.MetaClassImpl.doInvokeMethod(MetaClassImpl.java:1336) at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1091) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodOnSuperN(ScriptBytecodeAdapter.java:146) at org.apache.tinkerpop.gremlin.console.GremlinGroovysh.execute(GremlinGroovysh.groovy:85) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at org.apache.groovy.groovysh.Shell.leftShift(Shell.groovy:121) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at org.apache.groovy.groovysh.ShellRunner.work(ShellRunner.groovy:93) at org.apache.groovy.groovysh.InteractiveShellRunner.work(InteractiveShellRunner.groovy:124) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at org.apache.groovy.groovysh.ShellRunner.run(ShellRunner.groovy:57) at org.apache.groovy.groovysh.InteractiveShellRunner.run(InteractiveShellRunner.groovy:96) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at org.apache.tinkerpop.gremlin.console.Console.<init>(Console.groovy:175) at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321) at org.apache.tinkerpop.gremlin.console.Console.main(Console.groovy:574)

janusgraph-cql-opensearch.properties The contents of the configuration file。

`
gremlin.graph=org.janusgraph.core.JanusGraphFactory

storage.backend=cql
storage.hostname=192.168.184.31,192.168.184.32,192.168.184.33
storage.cql.keyspace=ratudb

storage.cql.local-datacenter=datacenter1
cache.db-cache = true
cache.db-cache-clean-wait = 20
cache.db-cache-time = 180000

cache.db-cache-size = 0.25

storage.cql.metadata-schema-enabled=false
storage.cql.metadata-token-map-enabled=false
storage.cql.partitioner-name=Murmur3Partitioner

index.search.backend=opensearch

index.search.hostname=192.168.184.31,192.168.184.32,192.168.184.33

`

After frequent investigation, I found that the problem is here, as shown in the picture:

image

The first place is to initialize the creation of the table, but it seems that the second place is to query the table before it succeeds, so it doesn't succeed, and the query fails, causing the program to fail.

So I was in the middle of them, and I put the program to sleep for five seconds. It solves the problem.The following image:

image

But I don't think this is an optimal solution. I wonder if this is a bug of its own, or is there another better solution?

I also tried replacing them (com.datastax.oss:java-driver-core) Version of,4.17.0 Change to 4.15.0 ,But it doesn't solve the problem。

Activity

  1. locked and limited conversation to collaborators on Sep 28, 2023
  2. converted this issue into a discussion #4012 on Sep 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions