[prev in list] [next in list] [prev in thread] [next in thread]
List: cassandra-user
Subject: Re: Cassandra 2.2.7 Compaction after Truncate issue
From: James Shaw <jxyshaw () gmail ! com>
Date: 2018-08-24 1:52:05
Message-ID: CAD4bXUrApBFx6+tZOPcPOq4HKvszDWYx8eMdBsx7q0UzuaNuTQ () mail ! gmail ! com
[Download RAW message or body]
you may go OS level to delete the files.That's what I did before. Truncate
action is frequently failed on some remote nodes in a heavy transactions
env.
Thanks,
James
On Thu, Aug 23, 2018 at 8:54 PM, Rahul Singh <rahul.xavier.singh@gmail.com>
wrote:
> David ,
>
> What CL do you set when running this command?
>
> Rahul Singh
> Chief Executive Officer
> m 202.905.2818
>
> Anant Corporation
> 1010 Wisconsin Ave NW, Suite 250
> <https://maps.google.com/?q=1010+Wisconsin+Ave+NW,+Suite+250+%0D%0AWashington,+D.C.+20007&entry=gmail&source=g>
> Washington, D.C. 20007
>
> We build and manage digital business technology platforms.
> On Aug 14, 2018, 11:49 AM -0500, David Payne <davidp@cqg.com>, wrote:
>
> Scenario: Cassandra 2.2.7, 3 nodes, RF=3 keyspace.
>
>
>
> Truncate a table.
>
> More than 24 hours later… FileCacheService is still reporting cold readers
> for sstables of truncated data for node 2 and 3, but not node 1.
>
> The output of nodeool compactionstats shows stuck compaction for the
> truncated table for node 2 and 3, but not node 1.
>
>
>
> This appears to be a defect that was fixed in 2.1.0.
> https://issues.apache.org/jira/browse/CASSANDRA-7803
>
>
>
> Any ideas?
>
>
>
> Thanks,
>
> David Payne
>
> >  ̄ ̄|
> _☆☆☆_
> ( ´_⊃`)
>
> c. 303-717-0548
>
> davidp@cqg.com
>
>
>
>
[Attachment #3 (text/html)]
<div dir="ltr"><div>you may go OS level to delete the files.That's what I did \
before. Truncate action is frequently failed on some remote nodes in a heavy \
transactions env. <br></div><div><br></div><div>Thanks,</div><div><br></div><div>James<br></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Thu, Aug 23, 2018 at 8:54 PM, \
Rahul Singh <span dir="ltr"><<a href="mailto:rahul.xavier.singh@gmail.com" \
target="_blank">rahul.xavier.singh@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">
<div>
<div name="messageBodySection">David ,<br>
<br>
What CL do you set when running this command?</div>
<div name="messageSignatureSection"><br>
Rahul Singh<br>
Chief Executive Officer<br>
m 202.905.2818<br>
<br>
Anant Corporation<br>
<a href="https://maps.google.com/?q=1010+Wisconsin+Ave+NW,+Suite+250+%0D%0AWashington,+D.C.+20007&entry=gmail&source=g">1010 \
Wisconsin Ave NW, Suite 250</a><br> Washington, D.C. 20007<br>
<br>
We build and manage digital business technology platforms.</div>
<div name="messageReplySection"><span class="">On Aug 14, 2018, 11:49 AM -0500, David \
Payne <<a href="mailto:davidp@cqg.com" target="_blank">davidp@cqg.com</a>>, \
wrote:<br> </span><blockquote type="cite">
<div class="m_-6756438067081479462WordSection1"><span class="">
<p class="MsoNormal">Scenario: Cassandra 2.2.7, 3 nodes, RF=3 keyspace.</p>
<p class="MsoNormal"> </p>
</span><p class="m_-6756438067081479462MsoListParagraph">Truncate a table.</p><span \
class=""> <p class="m_-6756438067081479462MsoListParagraph">More than 24 hours \
later… FileCacheService is still reporting cold readers for sstables of truncated \
data for node 2 and 3, but not node 1.</p> </span><p \
class="m_-6756438067081479462MsoListParagraph">The output of nodeool compactionstats \
shows stuck compaction for the truncated table for node 2 and 3, but not node \
1.</p><span class=""> <p class="MsoNormal"> </p>
<p class="MsoNormal">This appears to be a defect that was fixed in 2.1.0. <a \
href="https://issues.apache.org/jira/browse/CASSANDRA-7803" \
target="_blank">https://issues.apache.org/<wbr>jira/browse/CASSANDRA-7803</a></p> <p \
class="MsoNormal"> </p> <p class="MsoNormal">Any ideas?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal"><span \
style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#585858">David \
Payne</span></p> <p class="MsoNormal"><span \
style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#222222;background:#f8f9fa"> \
|</span><span style="font-size:8.0pt;font-family:"MS \
Mincho";color:#222222;background:#f8f9fa"> ̄ ̄</span><span \
style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#222222;background:#f8f9fa">|</span><span \
style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#222222"><br></span> \
<span style="font-size:8.0pt;font-family:"MS \
Mincho";color:#222222;background:#f8f9fa">_</span><span \
style="font-size:8.0pt;font-family:"Segoe UI \
Symbol",sans-serif;color:#222222;background:#f8f9fa">☆☆☆</span><span \
style="font-size:8.0pt;font-family:"MS \
Mincho";color:#222222;background:#f8f9fa">_</span><span \
style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#222222"><br></span> \
<span style="font-size:8.0pt;font-family:"MS \
Mincho";color:#222222;background:#f8f9fa">(</span> <span \
style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#222222;background:#f8f9fa"> \
´_</span><span style="font-size:8.0pt;font-family:"Cambria \
Math",serif;color:#222222;background:#f8f9fa">⊃</span><span \
style="font-size:8.0pt;font-family:"MS \
Mincho";color:#222222;background:#f8f9fa">ï½€</span><span \
style="font-size:8.0pt;font-family:"MS \
Gothic";color:#222222;background:#f8f9fa">)</span><span \
style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:#585858"></span></p>
<p class="MsoNormal"><span \
style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#999999;background:white">c. \
<a dir="ltr" href="tel:303-717-0548" target="_blank">303-717-0548</a></span></p> <p \
class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New \
Roman",serif"><a href="mailto:davidp@cqg.com" target="_blank"><span \
style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#5a7fbc;background:white">davidp@cqg.com</span></a></span><span \
style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#585858"></span></p>
<p class="MsoNormal"> </p>
</span></div>
</blockquote>
</div>
</div>
</blockquote></div><br></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic