Facet Double Counting

[harish singh]

Hi,

I am noticing a strange behavior with solr facet searching:

This is my facet query:


   - params:
   {
      - facet: "true",
      - sort: "startTimeISO desc",
      - debugQuery: "true",
      - facet.mincount: "1",
      - facet.sort: "count",
      - start: "0",
      - q: "requestType:(*login* or *LOGIN*) AND (user:(blabla*))",
      - facet.limit: "100",
      - facet.field: "loginUserName",
      - wt: "json",
      - fq: "startTimeISO:[2015-01-22T00:00:00.000Z TO
      2015-01-23T00:00:00.000Z]",
      - rows: "0"
      }


The result I am getting is:

facet_counts:
{

   - facet_queries: { },
   - facet_fields:
   {
      - loginUserName:
      [
         - "harry",
         - 36,
         - "larry",
         - 10,
         - "Carey"
         ]
      },
   - facet_dates: { },
   - facet_ranges: { }

}



As you see, the result is showing Facet-Count for "loginUserName= harry" is
36.

So when I do a Solr Search for logs, I should get 36 logs.
But I am getting 18.
This happening for all the searches now.


For some reason, I see double counting.

Either Facetting is Double counting or Search is half-counting ?


This is my Solr Search Query:



   - params:
   {
      - sort: "startTimeISO desc",
      - debugQuery: "true",
      - start: "0",
      - q: "requestType:(*login* or *LOGIN*) AND (user:(blabla*)) AND (
      loginUserName:("harry"))",
      - wt: "json",
      - fq: "startTimeISO:["2015-01-22T00:00:00.000Z" TO
      "2015-01-23T00:00:00.000Z"]",
      - rows: "200"
      }



This query gives only 18 logs. But Solr Facet Query gave 36.


Is there something incorrect in any of my (or both) queries?
I am trying to debug but it I think I am missing something silly.