InvalidQueryException: table system_properties does not exist

[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:

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:

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：

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。

[li-boxuan]

This is likely either a Cassandra problem, or a Cassandra driver problem. I've seen this with Amazon Keyspace too - the initializeTable call returns even if the table is still being created/initialized. There's not much JanusGraph could do. Sleeping could be an option. Another option is to keep probing until the table exists.

Anyways, this is a transient error. If you retry JanusGraphFactory.open, you would see that error goes away. You might see a similar error with a different table, but you can still retry... You may need to retry a few times until all tables are created.

[xiaodizi]

That's true. I adjusted it and it doesn't appear anymore.