Skip to content
Snippets Groups Projects

Upgrade Cassandra to version 4.x

    • Closed Issue created by Guilherme Arthur Gerônimo @arthur

    We are running Cassandra 3.11.13, in order to maintain the platform update and simplify future update we are plan to upgrade to version 4.1.3.

    Cassandra 5 is already in beta, so probably the 4.1.3 will be the last from the 4th branch.

    • remove dclocal_read_repair_chance and read_repair_chance from prod
    • remove dclocal_read_repair_chance and read_repair_chance from code
    • Update Cassandra docker seed
    ✓ 3 of 3 checklist items completed · Edited
    To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information

    Child items ...

    • Activity

    • Guilherme Arthur Gerônimo assigned to @arthur

      assigned to @arthur

    • Guilherme Arthur Gerônimo changed the description

      changed the description

    • Guilherme Arthur Gerônimo changed the description

      changed the description

    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer
      • compose
      version: "3.5"
services: 
  master: 
    #image: cassandra:3
    image: cassandra:4
    #network_mode: host
    ports:
      - 127.0.0.1:7199:7199
      - 127.0.0.1:9042:9042
      - 127.0.0.1:38231:38231
      - 127.0.0.1:7000:7000

    environment:
      - LOCAL_JMX=yes
      - JVM_OPTS=-Dcom.sun.management.jmxremote.authenticate=false
      - CASSANDRA_NUM_TOKENS=256
    ulimits:
        memlock: -1
        nofile: 1024000
    volumes:
      - /smartdata/cassandra:/var/lib/cassandra
      - ./cassandra.yaml:/etc/cassandra/cassandra.yaml
      Edited by Guilherme Arthur Gerônimo
    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      I've clone the sv3 server, snapshot, format to ubuntu 22.04

      Edited by Guilherme Arthur Gerônimo
    • Guilherme Arthur Gerônimo changed the description

      changed the description

    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      VM Changes

      sysctl -w vm.max_map_count=1048575
      Edited by Guilherme Arthur Gerônimo
    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      1 - Compression

      CompressionParams.java:383 - The sstable_compression option has been deprecated. You should use class instead
      • Fix: In cassandra.yml change session sstable_compression to class 
      docker exec -ti cassandra-master-1 cqlsh -k smartdata_v1 -e "describe tables;" > tables
cat tables |tr ' ' '\n' | sort | uniq > tables2
# clean some character in table2
while  read -r l ; do echo "ALTER TABLE $l WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'};"; done < tables2
      alter tables ``` ``` ALTER TABLE a2d2_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE a2d2_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE a2d2_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE a2d2_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE a2d2_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE a2d2_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_dev_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_dev_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_dev_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_dev_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_hydro_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_hydro_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_hydro_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_hydro_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE aqtech_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE auto5g_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE auto5g_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE auto5g_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE auto5g_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE auto5g_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE auto5g_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE ebus_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE ebus_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE ebus_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE ebus_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo2_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo2_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo2_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo2_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo5_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo5_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo5_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE grupo5_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE hydro_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE hydro_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE hydro_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE hydro_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE iase_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE iase_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE iase_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE iase_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE iase_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE iase_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE mafaulda_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE mafaulda_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE mafaulda_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE mafaulda_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE mafaulda_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE mafaulda_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE multicore_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE multicore_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE multicore_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE multicore_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE opencood_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE opencood_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE opencood_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE opencood_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE opencood_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE opencood_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE parma_ptr_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE parma_ptr_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE parma_ptr_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE parma_ptr_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE public_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE public_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE public_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE public_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE quadcopter_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE quadcopter_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE quadcopter_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE quadcopter_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_bc_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_bc_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_bc_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_bc_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartlisha_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartsolarbuilding_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartsolarbuilding_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartsolarbuilding_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE smartsolarbuilding_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solar_farm_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solar_farm_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solar_farm_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solar_farm_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solarstationfotovoltaica_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solarstationfotovoltaica_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solarstationfotovoltaica_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE solarstationfotovoltaica_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE tutorial_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE tutorial_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE tutorial_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE tutorial_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE tutorial_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE tutorial_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE underwater_rov_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE underwater_rov_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE underwater_rov_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE underwater_rov_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE veremi_v1_1_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE veremi_v1_1_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE veremi_v1_1_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE veremi_v1_2_digital WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE veremi_v1_2_si WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}; ALTER TABLE veremi_v1_2_si_blob WITH compression = {'class': 'org.apache.cassandra.io.compress.LZ4Compressor'};
      • final check
      SELECT table_name , compression FROM system_schema.tables;
      Edited by Guilherme Arthur Gerônimo
    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      2 - Local Read

      TableAttributes.java:167 - dclocal_read_repair_chance and read_repair_chance table options have been deprecated and will be removed in version 4.0
      • Fix: update table from dclocal_read_repair_chance to local_read_repair_chance 
      docker exec -ti cassandra-master-1 cqlsh -k smartdata_v1 -e "describe tables;" > tables
cat tables |tr ' ' '\n' | sort | uniq > tables2
# clean some character in table2
while  read -r l ; do echo "ALTER TABLE $l WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;"; done < tables2
      results 
      ALTER TABLE aqtech_dev_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_dev_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_dev_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_dev_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_hydro_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_hydro_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_hydro_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_hydro_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_v1_1_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE aqtech_v1_2_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE ebus_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE ebus_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE ebus_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE ebus_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo2_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo2_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo2_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo2_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo5_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo5_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo5_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE grupo5_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE hydro_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE hydro_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE hydro_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE hydro_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE iase_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE iase_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE iase_v1_1_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE iase_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE iase_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE iase_v1_2_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE mafaulda_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE mafaulda_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE mafaulda_v1_1_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE mafaulda_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE mafaulda_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE mafaulda_v1_2_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE multicore_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE multicore_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE multicore_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE multicore_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE parma_ptr_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE parma_ptr_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE parma_ptr_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE parma_ptr_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE public_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE public_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE public_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE public_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE quadcopter_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE quadcopter_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE quadcopter_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE quadcopter_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_bc_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_bc_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_bc_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_bc_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartlisha_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartsolarbuilding_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartsolarbuilding_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartsolarbuilding_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartsolarbuilding_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solar_farm_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solar_farm_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solar_farm_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solar_farm_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solarstationfotovoltaica_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solarstationfotovoltaica_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solarstationfotovoltaica_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE solarstationfotovoltaica_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE tutorial_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE tutorial_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE tutorial_v1_1_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE tutorial_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE tutorial_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE tutorial_v1_2_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE underwater_rov_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE underwater_rov_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE underwater_rov_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE underwater_rov_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE veremi_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE veremi_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE veremi_v1_1_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE veremi_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE veremi_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE veremi_v1_2_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE yakyakyak_v1_1_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE yakyakyak_v1_1_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE yakyakyak_v1_1_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE yakyakyak_v1_2_digital WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE yakyakyak_v1_2_si WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE yakyakyak_v1_2_si_blob WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;

ALTER TABLE kairosdb.row_key_index WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE kairosdb.string_index WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.hydro WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.hydro_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.multicore WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.multicore_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.public WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.public_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.smartlisha WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.smartlisha_bc WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.smartlisha_bc_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.smartlisha_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.smartsolarbuilding WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.smartsolarbuilding_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.substation WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.substation_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.tutorial WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.tutorial_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.underwater_rov WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
ALTER TABLE smartdata_1.underwater_rov_dig WITH read_repair_chance = 0.0 AND dclocal_read_repair_chance = 0.0;
      docker exec -ti cassandra-master-1 cqlsh -k smartdata_v1
      • Final Check
      SELECT keyspace_name, table_name , dclocal_read_repair_chance, read_repair_chance FROM system_schema.tables where dclocal_read_repair_chance > 0 ALLOW FILTERING;

SELECT keyspace_name, table_name , dclocal_read_repair_chance, read_repair_chance FROM system_schema.tables where read_repair_chance > 0 ALLOW FILTERING;
      Edited by Guilherme Arthur Gerônimo
    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer 
      # Light Repair
docker exec -ti cassandra-master-1 nodetool repair --ignore-unreplicated-keyspaces
      • I've change the replication factor of the key spaces:
      #list
SELECT * FROM system_schema.keyspaces

#change
ALTER KEYSPACE system_distributed WITH REPLICATION = {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '1'};

ALTER KEYSPACE system_traces WITH REPLICATION = {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '1'} ;
      # Full Repair
docker exec -ti cassandra-master-1 nodetool repair
      Edited by Guilherme Arthur Gerônimo
    • Guilherme Arthur Gerônimo changed the description

      changed the description

    • Guilherme Arthur Gerônimo marked the checklist item remove dclocal_read_repair_chance and read_repair_chance from code as completed

      marked the checklist item remove dclocal_read_repair_chance and read_repair_chance from code as completed

    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      Code compliance made in 52e7566b

    • Guilherme Arthur Gerônimo marked the checklist item remove dclocal_read_repair_chance and read_repair_chance from prod as completed

      marked the checklist item remove dclocal_read_repair_chance and read_repair_chance from prod as completed

    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      Added to cassandra.yml:

      # Default value for dclocal_read_repair_chance
dclocal_read_repair_chance: 0.0
    • Guilherme Arthur Gerônimo
      Guilherme Arthur Gerônimo @arthur ·
      Author Maintainer

      Check the java opts in prod to optimize performance.

      Check all errors in log file following the upgrade guidelines

    • Guilherme Arthur Gerônimo marked this issue as related to #25 (closed)

      marked this issue as related to #25 (closed)

    • Loading
    • Loading
    • Loading
    • Loading
    • Loading
    • Loading
    • Loading
    • Loading
    • Loading
    • Loading
    Please register or sign in to reply