Hello Oded and Carlos,
Many thanks for your tips. I modified the consistency level in cqlsh, but
with no success:
cqlsh> consistency ALL
Consistency level set to ALL.
cqlsh> select * from mls.te where period=62013120356 and tnt_id=5;
Tracing session: ef0e6590-91e3-11e5-8c24-6783eab735d4
activity
| timestamp | source | source_elapsed
------------------------------------------------------------
---------------------+--------------+---------------+----------------
execute_cql3_query | 14:13:05,898 | 192.168.0.210 | 0
Parsing select * from mls.te where period=62013120356 and tnt_id=5 LIMIT
10000; | 14:13:05,898 | 192.168.0.210 | 40
Message received from /
192.168.0.210 | 14:13:05,898 | 192.168.0.211 | 13
Preparing
statement | 14:13:05,898 | 192.168.0.210 | 276
Executing single-partition query
on te | 14:13:05,898 | 192.168.0.211 | 259
Enqueuing data request to /
192.168.0.211 | 14:13:05,898 | 192.168.0.210 | 526
Acquiring sstable
references | 14:13:05,898 | 192.168.0.211 | 272
Enqueuing digest request to /
192.168.0.212 | 14:13:05,898 | 192.168.0.210 | 565
Merging memtable
tombstones | 14:13:05,898 | 192.168.0.211 | 301
Sending message to /
192.168.0.211 | 14:13:05,898 | 192.168.0.210 | 792
Bloom filter allows skipping sstable
1638 | 14:13:05,898 | 192.168.0.211 | 322
Bloom filter allows skipping
sstable 10 | 14:13:05,898 | 192.168.0.211 | 330
Merging data from memtables and 0
sstables | 14:13:05,898 | 192.168.0.211 | 336
Read 0 live and 0 tombstoned
cells | 14:13:05,898 | 192.168.0.211 | 355
Sending message to /
192.168.0.212 | 14:13:05,899 | 192.168.0.210 | 1011
Enqueuing response to /
192.168.0.210 | 14:13:05,899 | 192.168.0.211 | 417
Sending message to /
192.168.0.210 | 14:13:05,899 | 192.168.0.211 | 1314
Message received from /
192.168.0.212 | 14:13:05,901 | 192.168.0.210 | 2950
Processing response from /
192.168.0.212 | 14:13:05,901 | 192.168.0.210 | 3014
Message received from /
192.168.0.211 | 14:13:05,901 | 192.168.0.210 | 3598
Processing response from /
192.168.0.211 | 14:13:05,901 | 192.168.0.210 | 3638
Message received from /
192.168.0.210 | 14:13:05,909 | 192.168.0.212 | 28
Executing single-partition query
on te | 14:13:05,909 | 192.168.0.212 | 276
Acquiring sstable
references | 14:13:05,909 | 192.168.0.212 | 297
Merging memtable
tombstones | 14:13:05,909 | 192.168.0.212 | 317
Bloom filter allows skipping sstable
1648 | 14:13:05,909 | 192.168.0.212 | 335
Bloom filter allows skipping
sstable 5 | 14:13:05,909 | 192.168.0.212 | 347
Merging data from memtables and 0
sstables | 14:13:05,909 | 192.168.0.212 | 352
Read 0 live and 0 tombstoned
cells | 14:13:05,909 | 192.168.0.212 | 367
Enqueuing response to /
192.168.0.210 | 14:13:05,909 | 192.168.0.212 | 413
Sending message to /
192.168.0.210 | 14:13:05,909 | 192.168.0.212 | 695
Request
complete | 14:13:05,901 | 192.168.0.210 | 3785
As you can see all the hosts of this cluster are accessed. I also repaired
the *mls* keyspace on all the 3 hosts.
No luck though.
Maybe some other suggestions? Thanks!
Regards,
Ramon
