[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16149892#comment-16149892
 ] 

ASF GitHub Bot commented on CASSANDRA-8727:
---

Github user cormoran commented on the issue:

https://github.com/apache/cassandra/pull/142
  
This PR was merged in 5dc79aafceb8dd1b7a985b262f128c59bedb5bf6.


> nodetool command to get the status of things that can be enable/disable'd
> -
>
> Key: CASSANDRA-8727
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
> Project: Cassandra
>  Issue Type: Improvement
>  Components: Tools
>Reporter:  Brian Hess
>Assignee: cormoran
>  Labels: lhf
> Fix For: 4.0
>
>
> It is possible to say enableautocompaction or disableautocompaction via 
> nodetool.  But it doesn't appear that there is a nodetool command to display 
> the current state of autocompaction - enabled or disabled.  
> It would be good to be able to get the status of these binary commands so 
> that you can determine the status, possibly make a change to 
> troubleshoot/experiment/etc, and return the status to the way it was when you 
> arrived.
> This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16149893#comment-16149893
 ] 

ASF GitHub Bot commented on CASSANDRA-8727:
---

Github user cormoran closed the pull request at:

https://github.com/apache/cassandra/pull/142


> nodetool command to get the status of things that can be enable/disable'd
> -
>
> Key: CASSANDRA-8727
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
> Project: Cassandra
>  Issue Type: Improvement
>  Components: Tools
>Reporter:  Brian Hess
>Assignee: cormoran
>  Labels: lhf
> Fix For: 4.0
>
>
> It is possible to say enableautocompaction or disableautocompaction via 
> nodetool.  But it doesn't appear that there is a nodetool command to display 
> the current state of autocompaction - enabled or disabled.  
> It would be good to be able to get the status of these binary commands so 
> that you can determine the status, possibly make a change to 
> troubleshoot/experiment/etc, and return the status to the way it was when you 
> arrived.
> This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[Jason Brown (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16147989#comment-16147989
 ] 

Jason Brown commented on CASSANDRA-8727:


Patch looks largely fine to me. I've [pushed a 
branch|https://circleci.com/gh/jasobrown/cassandra/tree/8727] to circleci to 
run the utests. Will commit if all looks reasonable.



> nodetool command to get the status of things that can be enable/disable'd
> -
>
> Key: CASSANDRA-8727
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
> Project: Cassandra
>  Issue Type: Improvement
>  Components: Tools
>Reporter:  Brian Hess
>Assignee: cormoran
>  Labels: lhf
>
> It is possible to say enableautocompaction or disableautocompaction via 
> nodetool.  But it doesn't appear that there is a nodetool command to display 
> the current state of autocompaction - enabled or disabled.  
> It would be good to be able to get the status of these binary commands so 
> that you can determine the status, possibly make a change to 
> troubleshoot/experiment/etc, and return the status to the way it was when you 
> arrived.
> This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[Jeff Jirsa (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16146628#comment-16146628
 ] 

Jeff Jirsa commented on CASSANDRA-8727:
---

Thanks for the patch [~cormoran]! I've marked this as patch-available, 
hopefully a committer gets some time to review it in the near future.


> nodetool command to get the status of things that can be enable/disable'd
> -
>
> Key: CASSANDRA-8727
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
> Project: Cassandra
>  Issue Type: Improvement
>  Components: Tools
>Reporter:  Brian Hess
>Assignee: cormoran
>  Labels: lhf
>
> It is possible to say enableautocompaction or disableautocompaction via 
> nodetool.  But it doesn't appear that there is a nodetool command to display 
> the current state of autocompaction - enabled or disabled.  
> It would be good to be able to get the status of these binary commands so 
> that you can determine the status, possibly make a change to 
> troubleshoot/experiment/etc, and return the status to the way it was when you 
> arrived.
> This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[Kenya Ukai (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16143382#comment-16143382
 ] 

Kenya Ukai commented on CASSANDRA-8727:
---

I submitted PR https://github.com/apache/cassandra/pull/142
Please review.

> nodetool command to get the status of things that can be enable/disable'd
> -
>
> Key: CASSANDRA-8727
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
> Project: Cassandra
>  Issue Type: Improvement
>  Components: Tools
>Reporter:  Brian Hess
>  Labels: lhf
>
> It is possible to say enableautocompaction or disableautocompaction via 
> nodetool.  But it doesn't appear that there is a nodetool command to display 
> the current state of autocompaction - enabled or disabled.  
> It would be good to be able to get the status of these binary commands so 
> that you can determine the status, possibly make a change to 
> troubleshoot/experiment/etc, and return the status to the way it was when you 
> arrived.
> This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[ASF GitHub Bot (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16143379#comment-16143379
 ] 

ASF GitHub Bot commented on CASSANDRA-8727:
---

GitHub user cormoran opened a pull request:

https://github.com/apache/cassandra/pull/142

CASSANDRA-8727 add command 'statusautocompaction'

Added nodetool command 'statusautocompaction'
By default, the status is summarized: running, not running or partially 
running (some of the specified tables have it enabled, some don't).
```
$ nodetool statusautocompaction
partially running
```
The `--all` option can be used to see a detailed status output.
```
$ nodetool statusautocompaction -a
Keyspace   Table  Status
system_schema  dropped_columnsnot running
system_schema  tables not running
...
system built_viewsrunning
system sstable_activity   running
...
test   test2  not running
test   test_cfnot running
system_authrole_permissions   not running
system_authresource_role_permissons_index not running
```

You can specify keyspace (and table).
```
$ nodetool statusautocompaction test test2 -a
Keyspace Table Status
test test2 not running
```


You can merge this pull request into a Git repository by running:

$ git pull https://github.com/cormoran/cassandra CASSANDRA-8727

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/cassandra/pull/142.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #142


commit 9bd85f7402f566fb7bd6bcbd969486446f08a21b
Author: cormoran 
Date:   2017-08-28T04:18:57Z

CASSANDRA-8727 add command 'statusautocompaction'




> nodetool command to get the status of things that can be enable/disable'd
> -
>
> Key: CASSANDRA-8727
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
> Project: Cassandra
>  Issue Type: Improvement
>  Components: Tools
>Reporter:  Brian Hess
>  Labels: lhf
>
> It is possible to say enableautocompaction or disableautocompaction via 
> nodetool.  But it doesn't appear that there is a nodetool command to display 
> the current state of autocompaction - enabled or disabled.  
> It would be good to be able to get the status of these binary commands so 
> that you can determine the status, possibly make a change to 
> troubleshoot/experiment/etc, and return the status to the way it was when you 
> arrived.
> This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[Prajakta Bhosale (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14352953#comment-14352953
 ] 

Prajakta Bhosale commented on CASSANDRA-8727:
-

We can update the Compaction using two ways though “Alter table  nodetool 
[en/dis]ableautocompcation” commands.
Below are my observations regarding preferences :
-   Compaction Status set through Alter table command is Enabled : High 
preference is given to nodetool command
- If we do nodetool enableautocompaction : compaction status will be 
enabled
- If we do nodetool disableautocompaction : compaction status will be 
disabled
-   Compaction Status set through Alter table command is disabled : High 
preference is given to Alter table command.
- nodetool command will not update the compaction status.

 nodetool command to get the status of things that can be enable/disable'd
 -

 Key: CASSANDRA-8727
 URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
 Project: Cassandra
  Issue Type: Improvement
  Components: Tools
Reporter:  Brian Hess

 It is possible to say enableautocompaction or disableautocompaction via 
 nodetool.  But it doesn't appear that there is a nodetool command to display 
 the current state of autocompaction - enabled or disabled.  
 It would be good to be able to get the status of these binary commands so 
 that you can determine the status, possibly make a change to 
 troubleshoot/experiment/etc, and return the status to the way it was when you 
 arrived.
 This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[Prajakta Bhosale (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14348156#comment-14348156
 ] 

Prajakta Bhosale commented on CASSANDRA-8727:
-

While investigating the [en/dis]abledautocompactionfound flag, found below 
behavior : 
Setup : 
Apache Cassandra 2.1.3
Created keyspace k1 which contains two columnfamily : enabledcomp  
disabledcomp having compaction enabled  disabled respectively. Disabled the 
compaction using below command :
ALTER TABLE disabledcomp WITH COMPACTION = {'class': 
'SizeTieredCompactionStrategy', 'enabled': 'false'};

Steps used : 
-   Added data into above 2 columnfamilies : Compaction is working as 
expected.
-   Ran below commands :
./nodetool enableautocompaction k1 disabledcomp
./nodetool disableautocompaction k1 enabledcomp
[**Even after enabling  disabling the auto compaction “describe table” command 
not showing the correct status of “enable flag in compaction map”]
-   Added data into 2 columnfamilies : 
o   Compaction is not running on “disabledcomp” columnfamily even though we 
enabled the compaction using  “nodetool enableautocompaction” command.
o   Compaction is working as expected on “enabledcomp” columnfamily, when 
we set it through  “nodetool [en/dis]ableautocompaction” command.

Queries : 

-   Cant we modify the compaction of columnfamily using “nodetool 
[en/dis]ableautocompaction” command, when it set through “ALTER TABLE” command.
-   “Describe table” command only shows the compaction enabled status if it 
is set through “ALTER TABLE” and not when it is set through “nodetool 
[en/dis]ableautocompaction” command. Is it correct behavior ?
-   If I am setting the compaction enable status using both the “Alter 
table  nodetool” commands, which command is having higher preference?


 nodetool command to get the status of things that can be enable/disable'd
 -

 Key: CASSANDRA-8727
 URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
 Project: Cassandra
  Issue Type: Improvement
  Components: Tools
Reporter:  Brian Hess

 It is possible to say enableautocompaction or disableautocompaction via 
 nodetool.  But it doesn't appear that there is a nodetool command to display 
 the current state of autocompaction - enabled or disabled.  
 It would be good to be able to get the status of these binary commands so 
 that you can determine the status, possibly make a change to 
 troubleshoot/experiment/etc, and return the status to the way it was when you 
 arrived.
 This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (CASSANDRA-8727) nodetool command to get the status of things that can be enable/disable'd

[Prajakta Bhosale (JIRA)]

[ 
https://issues.apache.org/jira/browse/CASSANDRA-8727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14343020#comment-14343020
 ] 

Prajakta Bhosale commented on CASSANDRA-8727:
-

Out of 6 binary commands, below 3 are already implemented in Apache Cassandra 
2.1:
-   statusbinary
-   statusthrift
-   statusgossip
For below commands code is ready from my side : 
-   statusbackup
-   statushandoff

And I am currently working on statusautocompaction.

 nodetool command to get the status of things that can be enable/disable'd
 -

 Key: CASSANDRA-8727
 URL: https://issues.apache.org/jira/browse/CASSANDRA-8727
 Project: Cassandra
  Issue Type: Improvement
  Components: Tools
Reporter:  Brian Hess

 It is possible to say enableautocompaction or disableautocompaction via 
 nodetool.  But it doesn't appear that there is a nodetool command to display 
 the current state of autocompaction - enabled or disabled.  
 It would be good to be able to get the status of these binary commands so 
 that you can determine the status, possibly make a change to 
 troubleshoot/experiment/etc, and return the status to the way it was when you 
 arrived.
 This applies for autocompaction, backup, binary, gossip, handoff, and thrift.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)