Hi all - I have a table where I've needed to delete a number of rows.
I've run repair, but I still can't select from the table.
select * from doc.indexorganize limit 10;
OperationTimedOut: errors={'172.16.100.37:9042': 'Client request
timeout. See Session.execute[_async](timeout)'},
last_host=172.16.100.37:9042
Info on the table:
nodetool tablestats doc.indexorganize
Total number of tables: 97
----------------
Keyspace : doc
Read Count: 170275408
Read Latency: 1.6486837044783356 ms
Write Count: 6821769404
Write Latency: 0.08147347268570909 ms
Pending Flushes: 0
Table: indexorganize
SSTable count: 21
Old SSTable count: 0
Space used (live): 1536557040
Space used (total): 1536557040
Space used by snapshots (total): 1728378992
Off heap memory used (total): 46251932
SSTable Compression Ratio: 0.5218383898575761
Number of partitions (estimate): 17365415
Memtable cell count: 0
Memtable data size: 0
Memtable off heap memory used: 0
Memtable switch count: 12
Local read count: 17346304
Local read latency: NaN ms
Local write count: 31340451
Local write latency: NaN ms
Pending flushes: 0
Percent repaired: 100.0
Bytes repaired: 1.084GiB
Bytes unrepaired: 0.000KiB
Bytes pending repair: 0.000KiB
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 38030728
Bloom filter off heap memory used: 38030560
Index summary off heap memory used: 7653060
Compression metadata off heap memory used: 568312
Compacted partition minimum bytes: 51
Compacted partition maximum bytes: 86
Compacted partition mean bytes: 67
Average live cells per slice (last five minutes):
73.53164556962025
Maximum live cells per slice (last five minutes): 5722
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
Dropped Mutations: 0
nodetool tablehistograms doc.indexorganize
doc/indexorganize histograms
Percentile Read Latency Write Latency SSTables Partition
Size Cell Count
(micros) (micros) (bytes)
50% 0.00 0.00 0.00
60 1
75% 0.00 0.00 0.00
86 2
95% 0.00 0.00 0.00
86 2
98% 0.00 0.00 0.00
86 2
99% 0.00 0.00 0.00
86 2
Min 0.00 0.00 0.00
51 0
Max 0.00 0.00 0.00
86 2
Any ideas on what I can do? Thank you!
-Joe
