On 14 December 2011 13:02, <igor@4friends.od.ua> wrote:

Do you use randompartitiner? What nodetool getendpoints show for several random keys

Yes, randompartitioner it is.

Thanks for hint re 'nodetool getendpoints'.  I have queried few, and to my surprise, 192.168.82.2 (node1) is showing up as a endpoint for few of them:

bart@node1:~$ nodetool -h localhost getendpoints A UserDetails 4547246
192.168.81.3
192.168.81.4
192.168.81.5
bart@node1:~$ nodetool -h localhost getendpoints A UserDetails 4549279
192.168.81.5
192.168.81.2
192.168.81.3
bart@node1:~$ nodetool -h localhost getendpoints A UserDetails 4549749
192.168.81.2
192.168.81.3
192.168.81.4
bart@node1:~$ nodetool -h localhost getendpoints A UserDetails 4545027
192.168.81.5
192.168.81.2
192.168.81.3

Any idea why the hell those are not stored on node1, though?

bart@node1:~$ nodetool -h localhost cfstats
[…]
Column Family: UserDetails
SSTable count: 0
Space used (live): 0
Space used (total): 0
Number of Keys (estimate): 0
Memtable Columns Count: 0
Memtable Data Size: 0
Memtable Switch Count: 0
Read Count: 0
Read Latency: NaN ms.
Write Count: 0
Write Latency: NaN ms.
Pending Tasks: 0
Key cache capacity: 200000
Key cache size: 0
Key cache hit rate: NaN
Row cache: disabled
Compacted row minimum size: 0
Compacted row maximum size: 0
Compacted row mean size: 0