[
https://issues.apache.org/jira/browse/CASSANDRA-8028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14174385#comment-14174385
]
Cameron Hatfield commented on CASSANDRA-8028:
---------------------------------------------
Looks like this doesn't fully resolve the issue. According to running
sstablemetadata on a 2.1.0 sstable file, as well as MetadataCollector.java:
https://github.com/apache/cassandra/blob/8d8fed52242c34b477d0384ba1d1ce3978efbbe8/src/java/org/apache/cassandra/io/sstable/metadata/MetadataCollector.java#L59
the sstable metadata persisted for these histograms are actually stored with a
larger number of buckets then 90. The issue seems to be both the nodetool,
https://github.com/apache/cassandra/blob/810c2d5fe64333c0bcfe0b2ed3ea2c8f6aaf89b7/src/java/org/apache/cassandra/tools/NodeTool.java#L892,
as well as ColumnFamilyMetrics
https://github.com/apache/cassandra/blob/ed1f39480606c95ff6595aad0aad9c1af7460f74/src/java/org/apache/cassandra/metrics/ColumnFamilyMetrics.java#L220
have a hardcoded value of 90. If that was raised, then we would be able to
display the non-overflowed histograms stored in the metadata.
Example output from sstablemetadata (notice that number of rows is 115 and 150,
not 90 and 90) :
[cameron@cass-db01 <removed>]$ sstablemetadata <removed>-<removed>-ka-33-Data.db
SSTable: ./<removed>-<removed>-ka-33
Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
Bloom Filter FP chance: 0.010000
Minimum timestamp: 1413408134518716
Maximum timestamp: 1413410874004562
SSTable max local deletion time: 2147483647
Compression ratio: 0.2157516194949938
Estimated droppable tombstones: 0.026257982293749805
SSTable Level: 0
Repaired at: 0
ReplayPosition(segmentId=1413409259260, position=15051162)
Estimated tombstone drop times:%n
1413408139: 1647
1413408151: 2451
1413408165: 3151
1413408180: 3400
1413408199: 3027
1413408214: 2769
1413408228: 2064
1413408244: 1779
1413408261: 3817
1413408280: 7265
1413408302: 1911
1413408319: 1512
1413408337: 1582
1413408354: 1712
1413408375: 1577
1413408393: 2507
1413408411: 1410
1413408431: 761
1413408447: 507
1413408466: 2593
1413408483: 3840
1413408503: 1557
1413408523: 819
1413409632: 742
1413409646: 641
1413409662: 473
1413409684: 704
1413409700: 762
1413409716: 601
1413409728: 125
1413409744: 1190
1413409763: 1181
1413409783: 1768
1413409800: 1730
1413409820: 1326
1413409837: 1273
1413409856: 1299
1413409871: 2663
1413409887: 2197
1413409901: 1776
1413409917: 871
1413409934: 1449
1413409952: 1700
1413409969: 1301
1413409984: 2100
1413410002: 2103
1413410021: 1208
1413410039: 923
1413410052: 1425
1413410068: 1796
1413410081: 2263
1413410095: 2664
1413410110: 3019
1413410128: 2823
1413410146: 3801
1413410160: 3864
1413410175: 3252
1413410188: 8337
1413410204: 9375
1413410219: 6125
1413410235: 7954
1413410254: 11019
1413410271: 12703
1413410287: 12274
1413410303: 12199
1413410317: 10751
1413410330: 11369
1413410343: 10552
1413410355: 8157
1413410369: 8776
1413410384: 7504
1413410400: 7312
1413410418: 7472
1413410434: 7032
1413410448: 6338
1413410465: 5335
1413410484: 6427
1413410504: 7897
1413410523: 8515
1413410539: 4886
1413410557: 4847
1413410576: 4987
1413410591: 7630
1413410611: 8553
1413410628: 12157
1413410645: 12740
1413410663: 13756
1413410679: 19249
1413410695: 19374
1413410713: 15390
1413410732: 13493
1413410746: 13793
1413410760: 16937
1413410775: 19841
1413410791: 16595
1413410808: 19050
1413410823: 18450
1413410840: 22497
1413410861: 34027
1413410872: 16
Count Row Size Cell Count
1 0 0
2 0 0
3 0 0
4 0 16
5 0 0
6 0 0
7 0 0
8 0 35
10 0 0
12 0 17
14 0 0
17 0 29
20 0 14
24 0 21
29 0 12
35 0 13
42 0 40
50 0 19
60 0 30
72 0 32
86 0 39
103 0 32
124 0 53
149 0 40
179 0 55
215 0 62
258 0 71
310 0 107
372 0 148
446 5 185
535 4 211
642 2 182
770 0 130
924 12 180
1109 4 201
1331 14 172
1597 9 201
1916 15 182
2299 30 204
2759 12 197
3311 14 315
3973 20 203
4768 24 122
5722 13 155
6866 18 197
8239 23 115
9887 30 133
11864 22 102
14237 40 59
17084 39 62
20501 51 78
24601 32 49
29521 55 46
35425 67 58
42510 87 27
51012 166 26
61214 140 11
73457 127 9
88148 124 0
105778 125 0
126934 173 0
152321 225 0
182785 174 0
219342 200 0
263210 215 0
315852 216 0
379022 204 0
454826 206 0
545791 181 0
654949 187 0
785939 230 0
943127 184 0
1131752 122 0
1358102 103 0
1629722 135 0
1955666 53 0
2346799 83 0
2816159 45 0
3379391 67 0
4055269 56 0
4866323 60 0
5839588 67 0
7007506 36 0
8409007 60 0
10090808 38 0
12108970 28 0
14530764 14 0
17436917 7 0
20924300 4 0
25109160 0 0
30130992 0 0
36157190 0 0
43388628 0 0
52066354 0 0
62479625 0 0
74975550 0 0
89970660 0 0
107964792 0 0
129557750 0 0
155469300 0 0
186563160 0 0
223875792 0 0
268650950 0 0
322381140 0 0
386857368 0 0
464228842 0 0
557074610 0 0
668489532 0 0
802187438 0 0
962624926 0 0
1155149911 0 0
1386179893 0 0
1663415872 0 0
1996099046 0 0
2395318855 0 0
2874382626 0
3449259151 0
4139110981 0
4966933177 0
5960319812 0
7152383774 0
8582860529 0
10299432635 0
12359319162 0
14831182994 0
17797419593 0
21356903512 0
25628284214 0
30753941057 0
36904729268 0
44285675122 0
53142810146 0
63771372175 0
76525646610 0
91830775932 0
110196931118 0
132236317342 0
158683580810 0
190420296972 0
228504356366 0
274205227639 0
329046273167 0
394855527800 0
473826633360 0
568591960032 0
682310352038 0
818772422446 0
982526906935 0
1179032288322 0
1414838745986 0
Ancestors: [237, 222, 227, 201, 243, 174]
Estimated cardinality: 4696
> Unable to compute when histogram overflowed
> -------------------------------------------
>
> Key: CASSANDRA-8028
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8028
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Environment: Linux
> Reporter: Gianluca Borello
> Assignee: Carl Yeksigian
> Fix For: 2.1.2
>
> Attachments: 8028-2.1.txt
>
>
> It seems like with 2.1.0 histograms can't be computed most of the times:
> $ nodetool cfhistograms draios top_files_by_agent1
> nodetool: Unable to compute when histogram overflowed
> See 'nodetool help' or 'nodetool help <command>'.
> I can probably find a way to attach a .cql script to reproduce it, but I
> suspect it must be obvious to replicate it as it happens on more than 50% of
> my column families.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
