What directory was the data and commit logs stored on the original working node. You can look up your cassandra.yaml to figure this out. Its good to confirm.
Was the rm -rf run on the original working node? Cheers, Akhil > On 30/08/2017, at 9:37 AM, Amir Shahinpour <a...@holisticlabs.net> wrote: > > Yes both of the nodes are down. > > On Aug 29, 2017 2:30 PM, "Akhil Mehra" <akhilme...@gmail.com > <mailto:akhilme...@gmail.com>> wrote: > Cassandra is doing a health check when it is starting up and failing due to > being unable to ready files in the system key space. Here is the comment in > the segment of the code that threw the exception. > > https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/SystemKeyspace.java#L804-L810 > > <https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/SystemKeyspace.java#L804-L810> > /** > * One of three things will happen if you try to read the system keyspace: > * 1. files are present and you can read them: great > * 2. no files are there: great (new node is assumed) > * 3. files are present but you can't read them: bad > * @throws ConfigurationException > */ > > Removing files for bootstrapping (adding a new node) a node sounds incorrect. > Depending on your configuration the /var/lib/cassandar by default houses > table data, commit logs, hints and cache. An rm -rf on it sounds ominous. > > Are both your nodes down i.e. you cannot cqlsh in any of your nodes? > > Regards, > Akhil > > > > >> On 30/08/2017, at 9:01 AM, Amir Shahinpour <a...@holisticlabs.net >> <mailto:a...@holisticlabs.net>> wrote: >> >> Hi Lucas, >> >> Thanks for your response. So I checked the system.log and I found the >> following error at the end which I think is causing the problem. >> >> Fatal exception during initialization >> org.apache.cassandra.exceptions.ConfigurationException: Found system >> keyspace files, but they couldn't be loaded! >> >> It could be due to removing some of the data. I ran the following command to >> remove some data. sudo rm -rf /var/lib/cassandra/* >> >> I am new to Cassandra and I think I made a mistake. So I had only one node >> which was working fine with my tables that I had. I wanted to add a second >> node and start using the real power of Cassandra. So I follow one of post >> that I found, there were some changes in cassandra.yaml file and afterwards >> I had to remove the files and that's why I run the remove command. So right >> now neither of CQLSH and nodetool works. Please let me know if you need any >> other information. >> >> Here is a screenshot of the system.log. Thanks a lot for your help. >> >> Best, >> Amir >> >> <image.png> >> >> On Tue, Aug 29, 2017 at 7:17 AM, Lucas Benevides >> <lu...@maurobenevides.com.br <mailto:lu...@maurobenevides.com.br>> wrote: >> Hello Amir, >> >> You should see the log. If it was installed by the apt-get tool, it should >> be in /var/log/cassandra/system.log. >> It can occur when the schema of the node you are trying to connect is out of >> date with the cluster. >> How many nodes are there in you cluster? >> What is the output of "nodetool describecluster"? >> >> Best regards, >> Lucas Benevides >> >> 2017-08-28 19:45 GMT-03:00 Amir Shahinpour <a...@holisticlabs.net >> <mailto:a...@holisticlabs.net>>: >> Hi, >> >> I am getting an error connecting to cqlsh. I am getting the following error. >> >> Connection error: ('Unable to connect to any servers', {'127.0.0.1': >> error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error: >> Connection refused")}) >> >> I change the Cassandra.yaml file setting for rpc_address to my ip address >> and listen_address to localhost. >> >> >> listen_address: localhost >> rpc_address: my_IP >> >> I also tried to change the cassandra-env.sh to add my IP address but still >> same error. >> >> JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=my_IP" >> Any suggestion? >> >> >> >> >> >
