I am building 1+1 Dataminer system and have connected Cassandra hosted on a Linux server within the network. Dataminer can connect to this dbserver but only shows that it is synchronised to the offline dma agent and unsynchronised to the online agent.
Hello Arunkrishna,
This is the result of the nodetool status :
C:Program FilesCassandrabin>nodetool status
The JAVA_HOME environment variable must be set to run this program!
Press any key to continue . . .
C:Program FilesCassandrabin>
—————-
This is also a snippet of the SLDBConnection.txt file :
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Requests.RequestExecution.d__13.MoveNext() Cassandra.InvalidQueryException: Keyspace ‘SLDMADB’ does not exist
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Connection.d__88.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Connection.d__88.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Cassandra.Requests.RequestHandler.d__41.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Requests.RequestExecution.d__13.MoveNext()
— End of inner exception stack trace —
at SLCassandraClassLibrary.DBGateway.ExceptionHandlers.ExceptionHandler.handle(DBGatewayException exception)
at SLCassandraClassLibrary.DBGateway.Cassandra.StorageManagers.SingleNode.CassandraConnection.c__DisplayClass204_0.b__0(Task`1 c)
**********
Hi Curtis,
That error is a false positive and can be safely ignored. As Danielle mentioned, this results from the fact you have just 1 node in the Cassandra cluster whilst Dataminer is expecting at least 2 nodes when you have a FO configuration.
Thank you Paulo
Hi,
normally cassandra cluster will have more than 1 node, so a synchronization will happen.
On test environments, you can have only one node, but on this way you will always have this sync error because there is nothing to be syncronized
Thank you for your help and clarification
Hi,
You need to set the JAVA_HOME environment variable; you can follow this guide : https://confluence.atlassian.com/doc/setting-the-java_home-variable-in-windows-8895.html –> this will help run nodetool status command.
From the log, I see the keyspace SLDMADB is not created. I would suggest to contact our support team for further assistance.
the SLDMADB is not created because the nodetool status was invoked locally on the DMA server when the Cassandra DB is running on a single external Linux node. So, all expected here 😉
Hi Curtis, what do you see when you type nodetool status on the online agent via cmd in the path C:Program FilesCassandrabin ?
Also, you can open the file “C:Skyline DataMinerLoggingSLDBConnection.txt” on the online agent and see if it has any errors.