[
https://issues.apache.org/jira/browse/CASSANDRA-18448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713043#comment-17713043
]
Andres de la Peña commented on CASSANDRA-18448:
-----------------------------------------------
Thanks for pointing it out nevertheless, one can never be too careful spotting
compatibility issues :)
Here are the patches for all the branches:
||PR||CI||
|[3.11
|https://github.com/apache/cassandra/pull/2277]|[j8|https://app.circleci.com/pipelines/github/adelapena/cassandra/2851/workflows/c5caa6f2-a315-40a8-922a-2cb8c55f97d7]|
|[4.0
|https://github.com/apache/cassandra/pull/2278]|[j8|https://app.circleci.com/pipelines/github/adelapena/cassandra/2850/workflows/19806cf0-51b2-4030-ad21-c312471f19a1]
[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/2850/workflows/6c4a313f-0b72-427f-84b0-406803d4002f]|
|[4.1
|https://github.com/apache/cassandra/pull/2279]|[j8|https://app.circleci.com/pipelines/github/adelapena/cassandra/2852/workflows/fe8aae70-8716-4d87-9ce8-54a99fd5a283]
[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/2852/workflows/5c124db9-30e6-4919-817a-ea323eb0418d]|
|[trunk|https://github.com/apache/cassandra/pull/2275]|[j8|https://app.circleci.com/pipelines/github/adelapena/cassandra/2849/workflows/71775e33-1717-43c4-83d6-02f5a849f983]
[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/2849/workflows/e1fc878a-a63d-4651-a3b5-4ce2db2d3261]|
3.11 doesn't contain any test at all for {{{}cfstats{}}}/{{{}tablestats{}}},
beyond some sporadic usages on Python dtests meant to tests other things,
rather than the tool itself. The tests that are modified on 4.0, 4.1 and trunk
to include sstable count on json/yaml output don't exist on 3.11. It neither
exist the machinery that makes those tests work, which includes {{ToolRunner}}
and changes on {{{}CQLTester{}}}.
We can port that test machinery back to 3.11, but I'm not sure it's worth it.
It would make the changes on 3.11 quite more extensive, and that branch doesn't
seem to have a very long life expectancy. wdyt?
> Missing "SSTable Count" metric when using nodetool with "--format" option
> --------------------------------------------------------------------------
>
> Key: CASSANDRA-18448
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18448
> Project: Cassandra
> Issue Type: Bug
> Components: Tool/nodetool
> Reporter: Mohammad Aburadeh
> Assignee: Andres de la Peña
> Priority: Normal
> Fix For: 3.11.x, 4.0.x, 4.1.x, 5.x
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Hi,
> I'm using "nodetool cfstats --format json" to gather some metrics/infomation
> about our tables.
> I noticed that the "SSTable Count" is missing when using "–format" option.
> If I don't use "–format" option, I can set "SSTable Count" in the output.
> *Output of "nodetool cfstats --format json | jq":*
> {code:java}
> { "total_number_of_tables": 38, "stress_test": { "write_latency_ms":
> 0.8536725334338424, "tables": { "res1": {
> "average_tombstones_per_slice_last_five_minutes": null,
> "bloom_filter_off_heap_memory_used": "159256",
> "memtable_switch_count": 754,
> "maximum_tombstones_per_slice_last_five_minutes": 0,
> "memtable_cell_count": 0, "memtable_data_size": "0",
> "average_live_cells_per_slice_last_five_minutes": null,
> "local_read_latency_ms": "NaN", "local_write_latency_ms": "NaN",
> "pending_flushes": 0, "compacted_partition_minimum_bytes": 785940,
> "local_read_count": 0, "sstable_compression_ratio":
> 0.6294161376582798, "dropped_mutations": "52751",
> "bloom_filter_false_positives": 0, "off_heap_memory_used_total":
> "58842196", "memtable_off_heap_memory_used": "0",
> "index_summary_off_heap_memory_used": "18972",
> "bloom_filter_space_used": "159408", "sstables_in_each_level": [],
> "compacted_partition_maximum_bytes": 4055269, "space_used_total":
> "302694398635", "local_write_count": 297111,
> "compression_metadata_off_heap_memory_used": "58663968",
> "number_of_partitions_estimate": 99614,
> "maximum_live_cells_per_slice_last_five_minutes": 0,
> "space_used_live": "302694398635", "compacted_partition_mean_bytes":
> 3827283, "bloom_filter_false_ratio": "0.00000",
> "percent_repaired": 0, "space_used_by_snapshots_total": "0" }
> }, "read_latency_ms": null, "pending_flushes": 0, "write_count":
> 594308, "read_latency": null, "read_count": 0 }}
> {code}
> *Output of "nodetool cfstats":*
> {code:java}
> ----------------
> Keyspace : stress_test
> Read Count: 0
> Read Latency: NaN ms
> Write Count: 594308
> Write Latency: 0.8536725334338424 ms
> Pending Flushes: 0
> Table: res1
> SSTable count: 19
> Space used (live): 302694398635
> Space used (total): 302694398635
> Space used by snapshots (total): 0
> Off heap memory used (total): 58842196
> SSTable Compression Ratio: 0.6294161376582798
> Number of partitions (estimate): 99614
> Memtable cell count: 0
> Memtable data size: 0
> Memtable off heap memory used: 0
> Memtable switch count: 754
> Local read count: 0
> Local read latency: NaN ms
> Local write count: 297111
> Local write latency: NaN ms
> Pending flushes: 0
> Percent repaired: 0.0
> Bloom filter false positives: 0
> Bloom filter false ratio: 0.00000
> Bloom filter space used: 159408
> Bloom filter off heap memory used: 159256
> Index summary off heap memory used: 18972
> Compression metadata off heap memory used: 58663968
> Compacted partition minimum bytes: 785940
> Compacted partition maximum bytes: 4055269
> Compacted partition mean bytes: 3827283
> Average live cells per slice (last five minutes): NaN
> Maximum live cells per slice (last five minutes): 0
> Average tombstones per slice (last five minutes): NaN
> Maximum tombstones per slice (last five minutes): 0
> Dropped Mutations: 52751*
> ----------------
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
