Hello all, I would like to ask regarding the Cassandra error as shown below:
It seems that the DMA has trouble offloading files to Cassandra cluster due to the database being in locked.
When I checked the offload folder on the server, there is still the issue of sqlite data not being offloaded due to the database being locked.
Using a 3rd party tool like DB Browser still shows that the sqlite file created by DataMiner is indeed locked:
Is there any procedure am I missing to fix this error? Thank you for the help.
In this context locked means that some other process is using the database, and locking it to prevent other processes from interfering with the data. Could you please verify that no other process is connecting to this database? There could be some leftover connection from other processes, easiest way to make sure no one is connecting would be to restart the machine, although if the connection is being made on startup it might not help in your case. Another thing that you could do is change the port of Cassandra in cassandra.yaml and in db.xml in DataMiner. This way even if connection exists, it will stop working since you "moved the location" of Cassandra and you should be able to connect to it.
This concept is not present in Cassandra, but is present in SQLite which is the source of your error. You could try stopping all DMA processes and then trying to access the database using 3rd party software, to verify if DMA is in fact source of the lock.