I am running a 3-node DSE cluster with all nodes being Solr and replication factor is 3. All basic query and facet work fine on any of those 3 nodes.
However, when try to run a facet pivot query, only one node will return results; the other 2 nodes return nothing about the pivot results. Here is one sample pivot query string:
Any idea what caused this problem?
Also, it seems that I could only rebuild Solr index from that node could return pivot query results. Try to clean and rebuild Solr index on the other 2 nodes does not work. Is there a configuration issue?
Here is the output from nodetool command:
Address DC Rack Status State Load Owns Token
192.168.210.93 Solr rack1 Up Normal 2.03 GB 33.33% 10
192.168.210.94 Solr rack1 Up Normal 2.34 GB 33.33% 56713727820156410577229101238628035252
192.168.210.92 Solr rack1 Up Normal 2.22 GB 33.33% 113427455640312821154458202477256070494
The node will return pivot query results has token: 113427455640312821154458202477256070494