Google Git
Sign in
apache / cassandra-website / 6d522089c5327a655b259124e598e26ab44d759a / . / src / doc / 4.0-rc2 / tools / sstable / sstableupgrade.html
blob: ad569a0e14006ed9ac2e22a524d8ff7ec8b8fa43 [file] [log] [blame]
<!DOCTYPE html>
<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>sstableupgrade &mdash; Apache Cassandra Documentation v4.0-rc2</title>
<script type="text/javascript" src="../../_static/js/modernizr.min.js"></script>
<script type="text/javascript" id="documentation_options" data-url_root="../../" src="../../_static/documentation_options.js"></script>
<script type="text/javascript" src="../../_static/jquery.js"></script>
<script type="text/javascript" src="../../_static/underscore.js"></script>
<script type="text/javascript" src="../../_static/doctools.js"></script>
<script type="text/javascript" src="../../_static/language_data.js"></script>
<script async="async" type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/latest.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/javascript" src="../../_static/js/theme.js"></script>
<link rel="stylesheet" href="../../_static/css/theme.css" type="text/css" />
<link rel="stylesheet" href="../../_static/pygments.css" type="text/css" />
<link rel="stylesheet" href="../../_static/extra.css" type="text/css" />
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
<link rel="next" title="sstableutil" href="sstableutil.html" />
<link rel="prev" title="sstablesplit" href="sstablesplit.html" />
</head>
<body class="wy-body-for-nav">
<div class="wy-grid-for-nav">
<nav data-toggle="wy-nav-shift" class="wy-nav-side">
<div class="wy-side-scroll">
<div class="wy-side-nav-search" >
<a href="../../index.html" class="icon icon-home"> Apache Cassandra
</a>
<div class="version">
4.0-rc2
</div>
<div role="search">
<form id="rtd-search-form" class="wy-form" action="../../search.html" method="get">
<input type="text" name="q" placeholder="Search docs" />
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
</div>
<div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
<ul class="current">
<li class="toctree-l1"><a class="reference internal" href="../../getting_started/index.html">Getting Started</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../new/index.html">New Features in Apache Cassandra 4.0</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../architecture/index.html">Architecture</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../cql/index.html">The Cassandra Query Language (CQL)</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../data_modeling/index.html">Data Modeling</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../configuration/index.html">Configuring Cassandra</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../operating/index.html">Operating Cassandra</a></li>
<li class="toctree-l1 current"><a class="reference internal" href="../index.html">Cassandra Tools</a><ul class="current">
<li class="toctree-l2"><a class="reference internal" href="../cqlsh.html">cqlsh: the CQL shell</a></li>
<li class="toctree-l2"><a class="reference internal" href="../generatetokens.html">generatetokens</a></li>
<li class="toctree-l2"><a class="reference internal" href="../nodetool/nodetool.html">Nodetool</a></li>
<li class="toctree-l2"><a class="reference internal" href="../nodetool/nodetool.html#usage">Usage</a></li>
<li class="toctree-l2 current"><a class="reference internal" href="index.html">SSTable Tools</a><ul class="current">
<li class="toctree-l3"><a class="reference internal" href="sstabledump.html">sstabledump</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstableexpiredblockers.html">sstableexpiredblockers</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstablelevelreset.html">sstablelevelreset</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstableloader.html">sstableloader</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstablemetadata.html">sstablemetadata</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstableofflinerelevel.html">sstableofflinerelevel</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstablerepairedset.html">sstablerepairedset</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstablescrub.html">sstablescrub</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstablesplit.html">sstablesplit</a></li>
<li class="toctree-l3 current"><a class="current reference internal" href="#">sstableupgrade</a><ul>
<li class="toctree-l4"><a class="reference internal" href="#usage">Usage</a></li>
<li class="toctree-l4"><a class="reference internal" href="#rewrite-tables-to-the-current-cassandra-version">Rewrite tables to the current Cassandra version</a></li>
<li class="toctree-l4"><a class="reference internal" href="#rewrite-tables-to-the-current-cassandra-version-and-keep-tables-in-old-version">Rewrite tables to the current Cassandra version, and keep tables in old version</a></li>
<li class="toctree-l4"><a class="reference internal" href="#rewrite-a-snapshot-to-the-current-cassandra-version">Rewrite a snapshot to the current Cassandra version</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="sstableutil.html">sstableutil</a></li>
<li class="toctree-l3"><a class="reference internal" href="sstableverify.html">sstableverify</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="../cassandra_stress.html">Cassandra Stress</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="../../troubleshooting/index.html">Troubleshooting</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../development/index.html">Contributing to Cassandra</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../faq/index.html">Frequently Asked Questions</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../plugins/index.html">Third-Party Plugins</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../bugs.html">Reporting Bugs</a></li>
<li class="toctree-l1"><a class="reference internal" href="../../contactus.html">Contact us</a></li>
</ul>
</div>
</div>
</nav>
<section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
<nav class="wy-nav-top" aria-label="top navigation">
<i data-toggle="wy-nav-top" class="fa fa-bars"></i>
<a href="../../index.html">Apache Cassandra</a>
</nav>
<div class="wy-nav-content">
<div class="rst-content">
<div role="navigation" aria-label="breadcrumbs navigation">
<ul class="wy-breadcrumbs">
<li><a href="../../index.html">Docs</a> &raquo;</li>
<li><a href="../index.html">Cassandra Tools</a> &raquo;</li>
<li><a href="index.html">SSTable Tools</a> &raquo;</li>
<li>sstableupgrade</li>
<li class="wy-breadcrumbs-aside">
<a href="../../_sources/tools/sstable/sstableupgrade.rst.txt" rel="nofollow"> View page source</a>
</li>
</ul>
<hr/>
</div>
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
<div class="section" id="sstableupgrade">
<h1>sstableupgrade<a class="headerlink" href="#sstableupgrade" title="Permalink to this headline"></a></h1>
<p>Upgrade the sstables in the given table (or snapshot) to the current version of Cassandra. This process is typically done after a Cassandra version upgrade. This operation will rewrite the sstables in the specified table to match the currently installed version of Cassandra. The sstableupgrade command can also be used to downgrade sstables to a previous version.</p>
<p>The snapshot option will only upgrade the specified snapshot. Upgrading snapshots is required before attempting to restore a snapshot taken in a major version older than the major version Cassandra is currently running. This will replace the files in the given snapshot as well as break any hard links to live sstables.</p>
<p>Cassandra must be stopped before this tool is executed, or unexpected results will occur. Note: the script does not verify that Cassandra is stopped.</p>
<div class="section" id="usage">
<h2>Usage<a class="headerlink" href="#usage" title="Permalink to this headline"></a></h2>
<p>sstableupgrade &lt;options&gt; &lt;keyspace&gt; &lt;table&gt; [snapshot_name]</p>
<table class="docutils align-default">
<colgroup>
<col style="width: 30%" />
<col style="width: 70%" />
</colgroup>
<tbody>
<tr class="row-odd"><td><p>–debug</p></td>
<td><p>display stack traces</p></td>
</tr>
<tr class="row-even"><td><p>-h,–help</p></td>
<td><p>display this help message</p></td>
</tr>
<tr class="row-odd"><td><p>-k,–keep-source</p></td>
<td><p>do not delete the source sstables</p></td>
</tr>
</tbody>
</table>
</div>
<div class="section" id="rewrite-tables-to-the-current-cassandra-version">
<h2>Rewrite tables to the current Cassandra version<a class="headerlink" href="#rewrite-tables-to-the-current-cassandra-version" title="Permalink to this headline"></a></h2>
<p>Start with a set of sstables in one version of Cassandra:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">ls</span> <span class="o">-</span><span class="n">al</span> <span class="o">/</span><span class="n">tmp</span><span class="o">/</span><span class="n">cassandra</span><span class="o">/</span><span class="n">data</span><span class="o">/</span><span class="n">keyspace1</span><span class="o">/</span><span class="n">standard1</span><span class="o">-</span><span class="mi">9695</span><span class="n">b790a63211e8a6fb091830ac5256</span><span class="o">/</span>
<span class="o">...</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">348</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">CRC</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">5620000</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Data</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Digest</span><span class="o">.</span><span class="n">sha1</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">25016</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Filter</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">480000</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Index</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">9895</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Statistics</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">3562</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Summary</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">79</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">45</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">TOC</span><span class="o">.</span><span class="n">txt</span>
</pre></div>
</div>
<p>After upgrading the Cassandra version, upgrade the sstables:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sstableupgrade</span> <span class="n">keyspace1</span> <span class="n">standard1</span>
<span class="n">Found</span> <span class="mi">1</span> <span class="n">sstables</span> <span class="n">that</span> <span class="n">need</span> <span class="n">upgrading</span><span class="o">.</span>
<span class="n">Upgrading</span> <span class="n">BigTableReader</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="s1">&#39;/var/lib/cassandra/data/keyspace1/standard1-9695b790a63211e8a6fb091830ac5256/keyspace1-standard1-ka-1-Data.db&#39;</span><span class="p">)</span>
<span class="n">Upgrade</span> <span class="n">of</span> <span class="n">BigTableReader</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="s1">&#39;/var/lib/cassandra/data/keyspace1/standard1-9695b790a63211e8a6fb091830ac5256/keyspace1-standard1-ka-1-Data.db&#39;</span><span class="p">)</span> <span class="n">complete</span><span class="o">.</span>
<span class="n">ls</span> <span class="o">-</span><span class="n">al</span> <span class="o">/</span><span class="n">tmp</span><span class="o">/</span><span class="n">cassandra</span><span class="o">/</span><span class="n">data</span><span class="o">/</span><span class="n">keyspace1</span><span class="o">/</span><span class="n">standard1</span><span class="o">-</span><span class="mi">9695</span><span class="n">b790a63211e8a6fb091830ac5256</span><span class="o">/</span>
<span class="o">...</span>
<span class="n">drwxr</span><span class="o">-</span><span class="n">xr</span><span class="o">-</span><span class="n">x</span> <span class="mi">2</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">64</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">backups</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">292</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">CRC</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">4599475</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Data</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Digest</span><span class="o">.</span><span class="n">crc32</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">25256</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Filter</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">330807</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Index</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10312</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Statistics</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">3506</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Summary</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">80</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">48</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">TOC</span><span class="o">.</span><span class="n">txt</span>
</pre></div>
</div>
</div>
<div class="section" id="rewrite-tables-to-the-current-cassandra-version-and-keep-tables-in-old-version">
<h2>Rewrite tables to the current Cassandra version, and keep tables in old version<a class="headerlink" href="#rewrite-tables-to-the-current-cassandra-version-and-keep-tables-in-old-version" title="Permalink to this headline"></a></h2>
<p>Again, starting with a set of sstables in one version:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">ls</span> <span class="o">-</span><span class="n">al</span> <span class="o">/</span><span class="n">tmp</span><span class="o">/</span><span class="n">cassandra</span><span class="o">/</span><span class="n">data</span><span class="o">/</span><span class="n">keyspace1</span><span class="o">/</span><span class="n">standard1</span><span class="o">-</span><span class="n">db532690a63411e8b4ae091830ac5256</span><span class="o">/</span>
<span class="o">...</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">348</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">CRC</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">5620000</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Data</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Digest</span><span class="o">.</span><span class="n">sha1</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">25016</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Filter</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">480000</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Index</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">9895</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Statistics</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">3562</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Summary</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">79</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">TOC</span><span class="o">.</span><span class="n">txt</span>
</pre></div>
</div>
<p>After upgrading the Cassandra version, upgrade the sstables, retaining the original sstables:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sstableupgrade</span> <span class="n">keyspace1</span> <span class="n">standard1</span> <span class="o">-</span><span class="n">k</span>
<span class="n">Found</span> <span class="mi">1</span> <span class="n">sstables</span> <span class="n">that</span> <span class="n">need</span> <span class="n">upgrading</span><span class="o">.</span>
<span class="n">Upgrading</span> <span class="n">BigTableReader</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="s1">&#39;/var/lib/cassandra/data/keyspace1/standard1-db532690a63411e8b4ae091830ac5256/keyspace1-standard1-ka-1-Data.db&#39;</span><span class="p">)</span>
<span class="n">Upgrade</span> <span class="n">of</span> <span class="n">BigTableReader</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="s1">&#39;/var/lib/cassandra/data/keyspace1/standard1-db532690a63411e8b4ae091830ac5256/keyspace1-standard1-ka-1-Data.db&#39;</span><span class="p">)</span> <span class="n">complete</span><span class="o">.</span>
<span class="n">ls</span> <span class="o">-</span><span class="n">al</span> <span class="o">/</span><span class="n">tmp</span><span class="o">/</span><span class="n">cassandra</span><span class="o">/</span><span class="n">data</span><span class="o">/</span><span class="n">keyspace1</span><span class="o">/</span><span class="n">standard1</span><span class="o">-</span><span class="n">db532690a63411e8b4ae091830ac5256</span><span class="o">/</span>
<span class="o">...</span>
<span class="n">drwxr</span><span class="o">-</span><span class="n">xr</span><span class="o">-</span><span class="n">x</span> <span class="mi">2</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">64</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">00</span> <span class="n">backups</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">348</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">CRC</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">5620000</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Data</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Digest</span><span class="o">.</span><span class="n">sha1</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">25016</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Filter</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">480000</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Index</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">9895</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Statistics</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">3562</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">Summary</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--@</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">79</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">13</span><span class="p">:</span><span class="mi">58</span> <span class="n">keyspace1</span><span class="o">-</span><span class="n">standard1</span><span class="o">-</span><span class="n">ka</span><span class="o">-</span><span class="mi">1</span><span class="o">-</span><span class="n">TOC</span><span class="o">.</span><span class="n">txt</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">292</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">CRC</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">4596370</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Data</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Digest</span><span class="o">.</span><span class="n">crc32</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">25256</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Filter</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">330801</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Index</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">10312</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Statistics</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">3506</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">Summary</span><span class="o">.</span><span class="n">db</span>
<span class="o">-</span><span class="n">rw</span><span class="o">-</span><span class="n">r</span><span class="o">--</span><span class="n">r</span><span class="o">--</span> <span class="mi">1</span> <span class="n">user</span> <span class="n">wheel</span> <span class="mi">80</span> <span class="n">Aug</span> <span class="mi">22</span> <span class="mi">14</span><span class="p">:</span><span class="mi">01</span> <span class="n">mc</span><span class="o">-</span><span class="mi">2</span><span class="o">-</span><span class="n">big</span><span class="o">-</span><span class="n">TOC</span><span class="o">.</span><span class="n">txt</span>
</pre></div>
</div>
</div>
<div class="section" id="rewrite-a-snapshot-to-the-current-cassandra-version">
<h2>Rewrite a snapshot to the current Cassandra version<a class="headerlink" href="#rewrite-a-snapshot-to-the-current-cassandra-version" title="Permalink to this headline"></a></h2>
<p>Find the snapshot name:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">nodetool</span> <span class="n">listsnapshots</span>
<span class="n">Snapshot</span> <span class="n">Details</span><span class="p">:</span>
<span class="n">Snapshot</span> <span class="n">name</span> <span class="n">Keyspace</span> <span class="n">name</span> <span class="n">Column</span> <span class="n">family</span> <span class="n">name</span> <span class="kc">True</span> <span class="n">size</span> <span class="n">Size</span> <span class="n">on</span> <span class="n">disk</span>
<span class="o">...</span>
<span class="mi">1534962986979</span> <span class="n">keyspace1</span> <span class="n">standard1</span> <span class="mf">5.85</span> <span class="n">MB</span> <span class="mf">5.85</span> <span class="n">MB</span>
</pre></div>
</div>
<p>Then rewrite the snapshot:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sstableupgrade</span> <span class="n">keyspace1</span> <span class="n">standard1</span> <span class="mi">1534962986979</span>
<span class="n">Found</span> <span class="mi">1</span> <span class="n">sstables</span> <span class="n">that</span> <span class="n">need</span> <span class="n">upgrading</span><span class="o">.</span>
<span class="n">Upgrading</span> <span class="n">BigTableReader</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="s1">&#39;/var/lib/cassandra/data/keyspace1/standard1-5850e9f0a63711e8a5c5091830ac5256/snapshots/1534962986979/keyspace1-standard1-ka-1-Data.db&#39;</span><span class="p">)</span>
<span class="n">Upgrade</span> <span class="n">of</span> <span class="n">BigTableReader</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="s1">&#39;/var/lib/cassandra/data/keyspace1/standard1-5850e9f0a63711e8a5c5091830ac5256/snapshots/1534962986979/keyspace1-standard1-ka-1-Data.db&#39;</span><span class="p">)</span> <span class="n">complete</span><span class="o">.</span>
</pre></div>
</div>
</div>
</div>
</div>
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
<a href="sstableutil.html" class="btn btn-neutral float-right" title="sstableutil" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
<a href="sstablesplit.html" class="btn btn-neutral float-left" title="sstablesplit" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
<hr/>
<div role="contentinfo">
<p>
&copy; Copyright 2020, The Apache Cassandra team
</p>
</div>
Built with <a href="http://sphinx-doc.org/">Sphinx</a> using a <a href="https://github.com/rtfd/sphinx_rtd_theme">theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>.
</footer>
</div>
</div>
</section>
</div>
<script type="text/javascript">
jQuery(function () {
SphinxRtdTheme.Navigation.enable(true);
});
</script>
</body>
</html>