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

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

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Critical

    Description

      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.

      system.log
      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.
      
      schema
      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);
      

      Attachments

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

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            yukim Yuki Morishita Assign to me
            Andie78 Andreas Schnitzerling
            Yuki Morishita
            Sam Tunnicliffe
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment