Thanks Felipe and Erick, Yes, your comment helped a lot, I was able to resolve that by: ALTER KEYSPACE dse_system WITH replication = {'class': 'SimpleStrategy', 'replication_factor':'1'};
Another problem I had was with CentOS release 6.7 (Final) I was getting glibc 2.14 not found. Based on this <https://issues.apache.org/jira/browse/CASSANDRA-13072> I switched jna-4.4.0.jar with jna-4.2.2.jar and it worked. I just started COSS for the first time successfully, I am able to connect and work on the DB. It would be a perfect success if it was not for an exception that bugs me every time I start Cassandra: DEBUG [SSTableBatchOpen:1] 2017-08-17 14:36:50,477 SSTableReader.java:506 - Opening /cassandra/disk01/system/local-7ad54392bcdd35a684174e047860b377/mc-217-big (0.598KiB) DEBUG [SSTableBatchOpen:2] 2017-08-17 14:36:50,477 SSTableReader.java:506 - Opening /cassandra/disk01/system/local-7ad54392bcdd35a684174e047860b377/mc-155-big (0.139KiB) ERROR [SSTableBatchOpen:2] 2017-08-17 14:36:50,489 DebuggableThreadPoolExecutor.java:239 - Error in ThreadPoolExecutor java.lang.RuntimeException: Unknown column server_id during deserialization at org.apache.cassandra.db.SerializationHeader$Component.toHeader(SerializationHeader.java:309) ~[apache-cassandra-3.11.0.jar:3.11.0] at org.apache.cassandra.io.sstable.format.SSTableReader.open(SSTableReader.java:513) ~[apache-cassandra-3.11.0.jar:3.11.0] at org.apache.cassandra.io.sstable.format.SSTableReader.open(SSTableReader.java:396) ~[apache-cassandra-3.11.0.jar:3.11.0] at org.apache.cassandra.io.sstable.format.SSTableReader$5.run(SSTableReader.java:561) ~[apache-cassandra-3.11.0.jar:3.11.0] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_65] at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_65] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_65] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_65] at org.apache.cassandra.concurrent.NamedThreadFactory.lambda$threadLocalDeallocator$0(NamedThreadFactory.java:81) [apache-cassandra-3.11.0.jar:3.11.0] at java.lang.Thread.run(Thread.java:745) ~[na:1.8.0_65] I looked at another DSE installation and system.local table has indeed a 'server_id' column. On my COSS testbed this column disappeared from the table as soon as I started for the first time COSS. I tried to sstablescrub, sstableupgrade but it didn't go away. I don't know if I should worry or how to fix it, any ideas? On Wed, Aug 16, 2017 at 1:38 PM, Felipe Esteves < felipe.este...@b2wdigital.com> wrote: > Ioannis, > As some people already said, there's one or two keyspaces that uses > EverywhereStrategy, dse_system is one of them, if I'm not wrong. > You must remember to change them to a community strategy or it will fail. > > > > >