Ok. I got it. SolrCloud relies on uniqueKey (id) for merging shard results, but in your examples it doesn't work, because nested documents disables this. And you have duplicates, which make merge heap mad:
false} <http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false%7D>},response={numFound=11,start=0,maxScore=1.0,docs=[SolrDocument{id=31814269823181426982280, score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, SolrDocument{id=31814269823181426982281, score=1.0}, SolrDocument{id=31814269823181426982281, score=1.0}, SolrDocument{id=31814269823181426982281, score=1.0}, SolrDocument{id=31814269823181426982281, score=1.0}, Yago, you encounter a quite curious fact. Congratulation! You can only retrieve parent document with SolrCloud, hence use {!parent ..}.. of fq=type:parent. ccing Devs: Shouldn't it prosecute ID dupes explicitly? Is it a known feature? On Fri, Dec 11, 2015 at 5:08 PM, Yago Riveiro <yago.rive...@gmail.com> wrote: > This: > > > > > > { > > > responseHeader: { > > > status: 0, > > > QTime: 10, > > > params: { > > > q: "id:3181426982318142698228*", > > > debugQuery: "true" > > > } > > > }, > > > response: { > > > numFound: 3, > > > start: 0, > > > maxScore: 1, > > > docs: [{ > > > id: "31814269823181426982280", > > > child_type: "ecommerce_product", > > > qty: 1, > > > product_price: 49.99 > > > }, { > > > id: "31814269823181426982281", > > > child_type: "ecommerce_product", > > > qty: 1, > > > product_price: 139.9 > > > }] > > > }, > > > debug: { > > > track: { > > > rid: > "node-01-ecommerce-15_shard1_replica2-1449842438070-0", > > > EXECUTE_QUERY: { > > > http: > //node-17:8983/solr/ecommerce-15_shard2_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-17:8983/solr/ecommerce-15_shard2_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > > }, > > > http: > //node-01:8983/solr/ecommerce-15_shard1_replica2/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "11", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false}},response={numFound=11,start=0,maxScore=1.0,docs=[SolrDocument{id=31814269823181426982280, > score=1.0}, SolrDocument{id=31814269823181426982280, score=1.0}, > SolrDocument{id=31814269823181426982280, score=1.0}, > SolrDocument{id=31814269823181426982280, score=1.0}, > SolrDocument{id=31814269823181426982280, score=1.0}, > SolrDocument{id=31814269823181426982281, score=1.0}, > SolrDocument{id=31814269823181426982281, score=1.0}, > SolrDocument{id=31814269823181426982281, score=1.0}, > SolrDocument{id=31814269823181426982281, score=1.0}, > SolrDocument{id=31814269823181426982281, > score=1.0}]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > > }, > > > http: //node-14:8983/solr/ecommerce-15_shard4_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-14:8983/solr/ecommerce-15_shard4_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > > }, > > > http: //node-06:8983/solr/ecommerce-15_shard5_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-06:8983/solr/ecommerce-15_shard5_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-13:8983/solr/ecommerce-15_shard3_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-13:8983/solr/ecommerce-15_shard3_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-05:8983/solr/ecommerce-15_shard6_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-05:8983/solr/ecommerce-15_shard6_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-04:8983/solr/ecommerce-15_shard7_replica2/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-04:8983/solr/ecommerce-15_shard7_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-15:8983/solr/ecommerce-15_shard10_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-15:8983/solr/ecommerce-15_shard10_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-18:8983/solr/ecommerce-15_shard11_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-18:8983/solr/ecommerce-15_shard11_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-03:8983/solr/ecommerce-15_shard9_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-03:8983/solr/ecommerce-15_shard9_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-02:8983/solr/ecommerce-15_shard8_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-02:8983/solr/ecommerce-15_shard8_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > }, > > http: //node-16:8983/solr/ecommerce-15_shard12_replica1/: { > > > QTime: "0", > > > ElapsedTime: "2", > > > RequestPurpose: "GET_TOP_IDS", > > > NumFound: "0", > > > Response: > "{responseHeader={status=0,QTime=0,params={df=_text_,distrib=false,debug=[false, > timing, track],qt=/query,fl=[id, > score],shards.purpose=4,start=0,fsv=true,shard.url= > http://node-16:8983/solr/ecommerce-15_shard12_replica1/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,rows=10,version=2,q=id:3181426982318142698228*,requestPurpose=GET_TOP_IDS,NOW=1449842438070,isShard=true,wt=javabin,debugQuery=false} > },response={numFound=0,start=0,maxScore=0.0,docs=[]},sort_values={},debug={timing={time=0.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}}}}}" > > } > > }, > > GET_FIELDS: { > > > http: //node-01:8983/solr/ecommerce-15_shard1_replica2/: { > > > QTime: "3", > > > ElapsedTime: "4", > > > RequestPurpose: "GET_FIELDS,GET_DEBUG", > > > NumFound: "2", > > > Response: > "{responseHeader={status=0,QTime=3,params={df=_text_,distrib=false,debug=[timing, > track],qt=/query,shards.purpose=320,shard.url= > http://node-01:8983/solr/ecommerce-15_shard1_replica2/,rid=node-01-ecommerce-15_shard1_replica2-1449842438070-0,version=2,q=id:3181426982318142698228*,requestPurpose=GET_FIELDS,GET_DEBUG,NOW=1449842438070,ids=31814269823181426982281,31814269823181426982280,isShard=true,wt=javabin,debugQuery=true}},response={numFound=2,start=0,docs=[SolrDocument{id=31814269823181426982281, > child_type=ecommerce_product, ref=5545562, name=smartphone vodafone samsung > galaxy core prime branco, name_raw=Smartphone VODAFONE SAMSUNG Galaxy Core > Prime Branco, cat=vodafone, cat_raw=Vodafone, qty=1, product_price=139.9}, > SolrDocument{id=31814269823181426982280, child_type=ecommerce_product, > ref=5439705, name=liquidificadora moulinex faciclic glass lm310e1, > name_raw=Liquidificadora MOULINEX Faciclic Glass LM310E1, > cat=liquidificadores, cat_raw=Liquidificadores, qty=1, > product_price=49.99}]},debug={rawquerystring=id:3181426982318142698228*,querystring=id:3181426982318142698228*,parsedquery=id:3181426982318142698228*,parsedquery_toString=id:3181426982318142698228*,explain={31814269823181426982281= > 1.0 = id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm > ,31814269823181426982280= 1.0 = id:3181426982318142698228*, product of: 1.0 > = boost 1.0 = queryNorm > },QParser=LuceneQParser,timing={time=3.0,prepare={time=0.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=0.0}},process={time=3.0,query={time=0.0},facet={time=0.0},facet_module={time=0.0},mlt={time=0.0},highlight={time=0.0},stats={time=0.0},expand={time=0.0},debug={time=3.0}}}}}" > > } > > } > > }, > > timing: { > > > time: 3, > > > prepare: { > > > time: 0, > > > query: { > > > time: 0 > > > }, > > > facet: { > > > time: 0 > > > }, > > > facet_module: { > > > time: 0 > > > }, > > > mlt: { > > > time: 0 > > > }, > > > highlight: { > > > time: 0 > > > }, > > > stats: { > > > time: 0 > > > }, > > > expand: { > > > time: 0 > > > }, > > > debug: { > > > time: 0 > > > } > > > }, > > > process: { > > > time: 3, > > > query: { > > > time: 0 > > > }, > > > facet: { > > > time: 0 > > > }, > > > facet_module: { > > > time: 0 > > > }, > > > mlt: { > > > time: 0 > > > }, > > > highlight: { > > > time: 0 > > > }, > > > stats: { > > > time: 0 > > > }, > > > expand: { > > > time: 0 > > > }, > > > debug: { > > > time: 3 > > > } > > > } > > > }, > > > rawquerystring: "id:3181426982318142698228*", > > > querystring: "id:3181426982318142698228*", > > > parsedquery: "id:3181426982318142698228*", > > > parsedquery_toString: "id:3181426982318142698228*", > > > QParser: "LuceneQParser", > > > explain: { > > > 31814269823181426982280: " 1.0 = > id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm ", > > > 31814269823181426982281: " 1.0 = > id:3181426982318142698228*, product of: 1.0 = boost 1.0 = queryNorm " > > > } > > } > > } > > > > > —/Yago Riveiro > > On Fri, Dec 11, 2015 at 12:53 PM, Mikhail Khludnev > <mkhlud...@griddynamics.com> wrote: > > > what do you see with debugQuery=true ? > > On Fri, Dec 11, 2015 at 2:02 PM, Yago Riveiro <yago.rive...@gmail.com> > > wrote: > >> Hi, > >> > >> I'm playing with the nested documents feature and after run this query: > >> > >> > http://localhost:8983/solr/ecommerce-15/query?q=id:3181426982318142698228* > >> > >> The documents has the IDs: > >> > >> - Parent : 3181426982318142698228 > >> - Child_1 : 31814269823181426982280 > >> - Child_2 : 31814269823181426982281 > >> > >> > >> I have this return: > >> > >> { > >> responseHeader: { > >> status: 0, > >> QTime: 3, > >> params: { > >> q: "id:3181426982318142698228*" > >> } > >> }, > >> response: { > >> numFound: 3, > >> start: 0, > >> maxScore: 1, > >> docs: [{ > >> id: "31814269823181426982280", > >> child_type: "ecommerce_product", > >> qty: 1, > >> product_price: 49.99 > >> }, { > >> id: "31814269823181426982281", > >> child_type: "ecommerce_product", > >> qty: 1, > >> product_price: 139.9 > >> }] > >> } > >> } > >> > >> As you can see the numFound is 3, and I have only 2 child documents, > it's > >> not supposed to ignore the parent document? > >> > >> > >> > >> ----- > >> Best regards > >> -- > >> View this message in context: > >> > http://lucene.472066.n3.nabble.com/Nested-document-query-with-wrong-numFound-value-tp4244851.html > >> Sent from the Solr - User mailing list archive at Nabble.com. > >> > > -- > > Sincerely yours > > Mikhail Khludnev > > Principal Engineer, > > Grid Dynamics > > <http://www.griddynamics.com> > > <mkhlud...@griddynamics.com> -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
