http://www.datastax.com/support-forums/topic/solr-facet-pivot-query-only-works-on-one-node-out-of-a-3-node-cluster Software, Support, and Training for Apache Cassandra en-US Tue, 21 May 2013 21:48:36 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/solr-facet-pivot-query-only-works-on-one-node-out-of-a-3-node-cluster#post-6749 Tue, 02 Oct 2012 20:18:55 +0000 alexliu 6749@http://www.datastax.com/support-forums/ <p>Pivot faceting currently only supports undistributed mode. Distributed pivot faceting needs to be implemented.</p> <p><a href="https://issues.apache.org/jira/browse/SOLR-2894" rel="nofollow">https://issues.apache.org/jira/browse/SOLR-2894</a></p> <p>DSE internally uses solr distributed search, so it's not supported for now. We will update DSE once that ticket is in Solr4.1 </p> http://www.datastax.com/support-forums/topic/solr-facet-pivot-query-only-works-on-one-node-out-of-a-3-node-cluster#post-6687 Wed, 26 Sep 2012 18:10:52 +0000 Larry.Yu 6687@http://www.datastax.com/support-forums/ <p>Here are list of index files of same column family from all nodes. Files under solr.data/ks.cf/index folder.</p> <p>Node1:<br /> total 44<br /> -rw-r--r-- 1 cassandra cassandra 464 Sep 20 10:39 1.fnx<br /> -rw-r--r-- 1 cassandra cassandra 965 Sep 26 11:47 _3_0.frq<br /> -rw-r--r-- 1 cassandra cassandra 884 Sep 26 11:47 _3_0.prx<br /> -rw-r--r-- 1 cassandra cassandra 3783 Sep 26 11:47 _3_0.tim<br /> -rw-r--r-- 1 cassandra cassandra 1014 Sep 26 11:47 _3_0.tip<br /> -rw-r--r-- 1 cassandra cassandra 990 Sep 26 11:47 _3.fdt<br /> -rw-r--r-- 1 cassandra cassandra 212 Sep 26 11:47 _3.fdx<br /> -rw-r--r-- 1 cassandra cassandra 750 Sep 26 11:47 _3.fnm<br /> -rw-r--r-- 1 cassandra cassandra 368 Sep 26 11:47 _3.nrm<br /> -rw-r--r-- 1 cassandra cassandra 279 Sep 26 11:47 segments_5<br /> -rw-r--r-- 1 cassandra cassandra 20 Sep 26 11:47 segments.gen<br /> -rw-r--r-- 1 cassandra cassandra 0 Sep 26 11:47 write.lock</p> <p>Node 2:<br /> total 44<br /> -rw-r--r-- 1 cassandra cassandra 464 Sep 24 11:05 1.fnx<br /> -rw-r--r-- 1 cassandra cassandra 965 Sep 26 11:47 _2_0.frq<br /> -rw-r--r-- 1 cassandra cassandra 884 Sep 26 11:47 _2_0.prx<br /> -rw-r--r-- 1 cassandra cassandra 3783 Sep 26 11:47 _2_0.tim<br /> -rw-r--r-- 1 cassandra cassandra 1014 Sep 26 11:47 _2_0.tip<br /> -rw-r--r-- 1 cassandra cassandra 990 Sep 26 11:47 _2.fdt<br /> -rw-r--r-- 1 cassandra cassandra 212 Sep 26 11:47 _2.fdx<br /> -rw-r--r-- 1 cassandra cassandra 750 Sep 26 11:47 _2.fnm<br /> -rw-r--r-- 1 cassandra cassandra 368 Sep 26 11:47 _2.nrm<br /> -rw-r--r-- 1 cassandra cassandra 279 Sep 26 11:47 segments_4<br /> -rw-r--r-- 1 cassandra cassandra 20 Sep 26 11:47 segments.gen<br /> -rw-r--r-- 1 cassandra cassandra 0 Sep 26 11:47 write.lock</p> <p>Node 3:<br /> total 44<br /> -rw-r--r-- 1 cassandra cassandra 464 Sep 24 11:05 1.fnx<br /> -rw-r--r-- 1 cassandra cassandra 965 Sep 26 11:47 _2_0.frq<br /> -rw-r--r-- 1 cassandra cassandra 884 Sep 26 11:47 _2_0.prx<br /> -rw-r--r-- 1 cassandra cassandra 3783 Sep 26 11:47 _2_0.tim<br /> -rw-r--r-- 1 cassandra cassandra 1014 Sep 26 11:47 _2_0.tip<br /> -rw-r--r-- 1 cassandra cassandra 990 Sep 26 11:47 _2.fdt<br /> -rw-r--r-- 1 cassandra cassandra 212 Sep 26 11:47 _2.fdx<br /> -rw-r--r-- 1 cassandra cassandra 750 Sep 26 11:47 _2.fnm<br /> -rw-r--r-- 1 cassandra cassandra 368 Sep 26 11:47 _2.nrm<br /> -rw-r--r-- 1 cassandra cassandra 279 Sep 26 11:47 segments_4<br /> -rw-r--r-- 1 cassandra cassandra 20 Sep 26 11:47 segments.gen<br /> -rw-r--r-- 1 cassandra cassandra 0 Sep 26 11:47 write.lock </p> http://www.datastax.com/support-forums/topic/solr-facet-pivot-query-only-works-on-one-node-out-of-a-3-node-cluster#post-6686 Wed, 26 Sep 2012 17:57:02 +0000 Larry.Yu 6686@http://www.datastax.com/support-forums/ <p>Thanks for the advise. I already tried that option. It does not work.</p> <p>I checked the index files across all nodes. There are same number of index files and each file's size is the same across cluster nodes.</p> <p>Just FYI, the rebuild_indexes command is on dsetool command (running dse 2.1):<br /> dsetool -h hostIP rebuild_indexes ks cf</p> <p>I could not find that option on nodetool command. </p> http://www.datastax.com/support-forums/topic/solr-facet-pivot-query-only-works-on-one-node-out-of-a-3-node-cluster#post-6652 Mon, 24 Sep 2012 21:43:30 +0000 alexliu 6652@http://www.datastax.com/support-forums/ <p>it looks like some solr index data are missing. Can you delete all data from /var/lib/cassandra/data/solr.data, then restart all nodes to check whether all the indexes are rebuilt and then test it again.</p> <p>The nodetool rebuild_index rebuilds native secondry index for a given column family. Run nodetool rebuild command, specifying host name, key space, column family and indexes.</p> <p> $ nodetool -h localhost rebuild_index [keyspace] [idx1,idx1...]<br /> Solr index name: [keyspace].<br /> Example: nodetool -h localhost rebuild_index ks cf ks.cf</p> <p>Follow the below steps to rebuild your solr indexes.</p> <p> Stop DSE node<br /> Delete all sub-directories under /var/lib/cassandra/data/solr.data/directory.<br /> Start DSE in search mode.<br /> Run nodetool rebuild_index for each column family. </p> http://www.datastax.com/support-forums/topic/solr-facet-pivot-query-only-works-on-one-node-out-of-a-3-node-cluster#post-6603 Fri, 21 Sep 2012 00:52:00 +0000 Larry.Yu 6603@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>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.</p> <p>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:<br /> q=*:*&amp;facet=true&amp;facet.pivot=day,cid,name</p> <p>Any idea what caused this problem?</p> <p>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?</p> <p>Here is the output from nodetool command:<br /> Address DC Rack Status State Load Owns Token<br /> 113427455640312821154458202477256070494<br /> 192.168.210.93 Solr rack1 Up Normal 2.03 GB 33.33% 10<br /> 192.168.210.94 Solr rack1 Up Normal 2.34 GB 33.33% 56713727820156410577229101238628035252<br /> 192.168.210.92 Solr rack1 Up Normal 2.22 GB 33.33% 113427455640312821154458202477256070494</p> <p>The node will return pivot query results has token: 113427455640312821154458202477256070494 </p>