Re: Parallel SQL - column not found intermittent error

Created JIRA https://issues.apache.org/jira/browse/SOLR-10890 Thank you. On Wed, Jun 14, 2017 at 1:59 PM, Joel Bernstein wrote: > Let's create a jira for this. > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Wed, Jun 14, 2017 at 12:26 PM, Susheel Kumar

Re: Parallel SQL - column not found intermittent error

Let's create a jira for this. Joel Bernstein http://joelsolr.blogspot.com/ On Wed, Jun 14, 2017 at 12:26 PM, Susheel Kumar wrote: > Thanks, Yury. Indeed that is the issue. > > Joel, is that something expected behavior or should i create a JIRA? > > Thanks, > Susheel >

Re: Parallel SQL - column not found intermittent error

Thanks, Yury. Indeed that is the issue. Joel, is that something expected behavior or should i create a JIRA? Thanks, Susheel On Wed, Jun 14, 2017 at 12:16 PM, Yury Kats wrote: > I have seen this with very few indexed documents and multiple shards. > In such a

Re: Parallel SQL - column not found intermittent error

I have seen this with very few indexed documents and multiple shards. In such a case, some shards may not have any documents, and when the query happens to hit such a shard, it does not find the fields it's looking for and turns this into "column not found". If you resubmit the query and hit a

Re: Parallel SQL - column not found intermittent error

Also i tried with both docValues and non docValue fields/column. On Wed, Jun 14, 2017 at 11:42 AM, Susheel Kumar wrote: > Yes, Joel. Kind of every other command runs into this issue. I just > executed below queries and 3 of them failed while 1 succeeded. I just > have

Re: Parallel SQL - column not found intermittent error

Yes, Joel. Kind of every other command runs into this issue. I just executed below queries and 3 of them failed while 1 succeeded. I just have 6 documents ingested and no further indexing going on. Let me know what else to look for the state of index. ➜ solr-6.6.0 curl --data-urlencode

Re: Parallel SQL - column not found intermittent error

Are you able to reproduce the error, or is it just appearing in the logs? Do you know the state of index when it's occurring? Joel Bernstein http://joelsolr.blogspot.com/ On Wed, Jun 14, 2017 at 11:09 AM, Susheel Kumar wrote: > I have setup Solr-6.6-0 on local (local ZK

Parallel SQL - column not found intermittent error

I have setup Solr-6.6-0 on local (local ZK and Solr) and then on servers (3 ZK and 2 machines, 2 shards) and on both the env, i see this intermittent error "column not found". The same query works sometime and other time fails. Is that a bug or am I missing something... Console === ->