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,
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 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.