Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-9687

Wrong partitioner after upgrading sstables (secondary indexes are not handled correctly after CASSANDRA-6962)



    • Critical


      After upgrading one of 15 nodes from 2.1.7 to 2.2.0.rc1, C* upgrades automatic sstables. After restart of C*, some of these new generated sstables are not accepted anymore and C* crashes. If I delete the affected sstables, C* starts again.

      ERROR [SSTableBatchOpen:1] 2015-06-30 13:08:54,861 SSTableReader.java:432 - Cannot open D:\Programme\Cassandra\data\data\nieste\niesteinverters\la-540-big; partitioner org.apache.cassandra.dht.LocalPartitioner does not match system partitioner org.apache.cassandra.dht.Murmur3Partitioner.  Note that the default partitioner starting with Cassandra 1.2 is Murmur3Partitioner, so you will need to edit that to match your old partitioner if upgrading.
      CREATE TABLE niesteinverters (
        id bigint,
        comment map<timestamp, text>,
        creation_time timestamp,
        fk_ncom bigint,
        last_event timestamp,
        last_filesize int,
        last_onl_data timestamp,
        last_time timestamp,
        ncom_hist map<timestamp, bigint>,
        version int,
        PRIMARY KEY ((id))
      ) WITH
        bloom_filter_fp_chance=0.010000 AND
        caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND
        comment='Table for niesteinverters (niesteplants->niestecoms->niesteinverters)' AND
        dclocal_read_repair_chance=0.000000 AND
        gc_grace_seconds=864000 AND
        read_repair_chance=0.100000 AND
        default_time_to_live=0 AND
        speculative_retry='NONE' AND
        memtable_flush_period_in_ms=0 AND
        compaction={'class': 'LeveledCompactionStrategy'} AND
        compression={'sstable_compression': 'LZ4Compressor'};
      CREATE INDEX niesteinvertersniestecomsIndex ON niesteinverters (fk_ncom);


        1. system.zip
          47 kB
          Andreas Schnitzerling
        2. system.log
          47 kB
          Andreas Schnitzerling
        3. nieste-niesteinverters-jb-540-TOC.txt
          0.1 kB
          Andreas Schnitzerling
        4. nieste-niesteinverters-jb-540-Summary.db
          0.1 kB
          Andreas Schnitzerling
        5. nieste-niesteinverters-jb-540-Statistics.db
          5 kB
          Andreas Schnitzerling
        6. nieste-niesteinverters-jb-540-Index.db
          0.4 kB
          Andreas Schnitzerling
        7. nieste-niesteinverters-jb-540-Filter.db
          0.0 kB
          Andreas Schnitzerling
        8. nieste-niesteinverters-jb-540-Data.db
          2 kB
          Andreas Schnitzerling
        9. nieste-niesteinverters-jb-540-CompressionInfo.db
          0.0 kB
          Andreas Schnitzerling
        10. la-540-big-TOC.txt
          0.1 kB
          Andreas Schnitzerling
        11. la-540-big-Summary.db
          0.1 kB
          Andreas Schnitzerling
        12. la-540-big-Statistics.db
          5 kB
          Andreas Schnitzerling
        13. la-540-big-Index.db
          7 kB
          Andreas Schnitzerling
        14. la-540-big-Filter.db
          0.5 kB
          Andreas Schnitzerling
        15. la-540-big-Digest.adler32
          0.0 kB
          Andreas Schnitzerling
        16. la-540-big-Data.db
          15 kB
          Andreas Schnitzerling
        17. la-540-big-CompressionInfo.db
          0.0 kB
          Andreas Schnitzerling
        18. la-1-big.zip
          3 kB
          Andreas Schnitzerling

        Issue Links



              yukim Yuki Morishita
              Andie78 Andreas Schnitzerling
              Yuki Morishita
              Sam Tunnicliffe
              0 Vote for this issue
              4 Start watching this issue