You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@solr.apache.org by Anuj Bhargava <an...@gmail.com> on 2021/04/29 11:08:06 UTC

Solr 8.6 Indexing Issue

Ever since installing 8.6 a couple of months ago, the indexing was working
fine. All of a sudden getting the following error -

4/29/2021, 12:01:59 PM
ERROR false
DocBuilder
Exception while processing: hotels document : SolrInputDocument(fields:
[]):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK'
OR country ='MV' OR country ='BT' Processing Document # 1

4/29/2021, 12:01:59 PM
ERROR false
DataImporter
Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: SELECT * FROM hotels WHERE country = 'IN' OR country ='PK'
OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
country ='MV' OR country ='BT' Processing Document # 1

Please help

Re: Solr 8.6 Indexing Issue

Posted by Anuj Bhargava <an...@gmail.com>.
It is not fetching

Requests: 1 , Fetched: 0 , Skipped: 0 , Processed: 0


On Thu, 29 Apr 2021 at 18:35, Anuj Bhargava <an...@gmail.com> wrote:

> Saw the following in the logs -
>
> *2021-04-29 11:19:58.330 INFO  (main) [   ] o.e.j.s.Server
> jetty-9.4.27.v20200227; built: 2020-02-27T18:37:21.340Z; git:
> a304fd9f351f337e7c0e2a7c28878dd536149c6c; jvm 1.8.0_292-b10*
> *2021-04-29 11:19:58.352 INFO  (main) [   ] o.e.j.d.p.ScanningAppProvider
> Deployment monitor [file:///opt/solr-8.6.2/server/contexts/] at interval 0*
> *2021-04-29 11:19:58.559 INFO  (main) [   ]
> o.e.j.w.StandardDescriptorProcessor NO JSP Support for /solr, did not find
> org.apache.jasper.ser.servlet.JspServlet*
> *2021-04-29 11:19:58.568 INFO  (main) [   ] o.e.j.s.session
> DefaultSessionIdManager workerName=node0*
> *2021-04-29 11:19:58.568 INFO  (main) [   ] o.e.j.s.session No
> SessionScavenger set, using defaults*
> *2021-04-29 11:19:58.570 INFO  (main) [   ] o.e.j.s.session node0
> Scavenging every 660000ms*
> *2021-04-29 11:19:58.693 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter
> Using logger factory org.apache.logging.slf4j.Log4jLoggerFactory*
> *2021-04-29 11:19:58.698 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter
> ___      _       Welcome to Apache Solr™ version 8.6.2*
> *2021-04-29 11:19:58.698 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter /
> __| ___| |_ _   Starting in standalone mode on port 8983*
> *2021-04-29 11:19:58.698 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter \__
> \/ _ \ | '_|  Install dir: /opt/solr*
> *2021-04-29 11:19:58.699 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter
> |___/\___/_|_|    Start time: 2021-04-29T11:19:58.699Z*
> *Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver
> class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered
> via the SPI and manual loading of the driver class is generally unnecessary*
>
> Changed *com.mysql.jdbc.Drive*r with com.*mysql.cj.jdbc.Driver * in
> datacofig.xml
>
>     <dataSource type="JdbcDataSource"
>             driver="com.mysql.cj.jdbc.Driver"
>             batchSize="-1"
>
> and also uploaded latest version - mysql-connector-java-8.0.24.jar
>
> On Thu, 29 Apr 2021 at 18:30, Anuj Bhargava <an...@gmail.com> wrote:
>
>> { "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
>> "1619701169621"}}, "response":{"numFound":179573,"start":0,"numFoundExact
>> ":true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",
>>
>> On Thu, 29 Apr 2021 at 17:18, Charlie Hull <
>> chull@opensourceconnections.com> wrote:
>>
>>> What happens if you run exactly that SELECT query on your source
>>> database?
>>>
>>> Charlie
>>>
>>> On 29/04/2021 12:08, Anuj Bhargava wrote:
>>> > Ever since installing 8.6 a couple of months ago, the indexing was
>>> working
>>> > fine. All of a sudden getting the following error -
>>> >
>>> > 4/29/2021, 12:01:59 PM
>>> > ERROR false
>>> > DocBuilder
>>> > Exception while processing: hotels document : SolrInputDocument(fields:
>>> > []):org.apache.solr.handler.dataimport.DataImportHandlerException:
>>> Unable
>>> > to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
>>> > ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country
>>> ='LK'
>>> > OR country ='MV' OR country ='BT' Processing Document # 1
>>> >
>>> > 4/29/2021, 12:01:59 PM
>>> > ERROR false
>>> > DataImporter
>>> > Full Import failed:java.lang.RuntimeException:
>>> java.lang.RuntimeException:
>>> > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
>>> to
>>> > execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
>>> ='PK'
>>> > OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
>>> > country ='MV' OR country ='BT' Processing Document # 1
>>> >
>>> > Please help
>>> >
>>>
>>> --
>>> Charlie Hull - Managing Consultant at OpenSource Connections Limited
>>> <www.o19s.com>
>>> Founding member of The Search Network <https://thesearchnetwork.com/>
>>> and co-author of Searching the Enterprise
>>> <https://opensourceconnections.com/about-us/books-resources/>
>>> tel/fax: +44 (0)8700 118334
>>> mobile: +44 (0)7767 825828
>>>
>>

Re: Solr 8.6 Indexing Issue

Posted by Anuj Bhargava <an...@gmail.com>.
Saw the following in the logs -

*2021-04-29 11:19:58.330 INFO  (main) [   ] o.e.j.s.Server
jetty-9.4.27.v20200227; built: 2020-02-27T18:37:21.340Z; git:
a304fd9f351f337e7c0e2a7c28878dd536149c6c; jvm 1.8.0_292-b10*
*2021-04-29 11:19:58.352 INFO  (main) [   ] o.e.j.d.p.ScanningAppProvider
Deployment monitor [file:///opt/solr-8.6.2/server/contexts/] at interval 0*
*2021-04-29 11:19:58.559 INFO  (main) [   ]
o.e.j.w.StandardDescriptorProcessor NO JSP Support for /solr, did not find
org.apache.jasper.ser.servlet.JspServlet*
*2021-04-29 11:19:58.568 INFO  (main) [   ] o.e.j.s.session
DefaultSessionIdManager workerName=node0*
*2021-04-29 11:19:58.568 INFO  (main) [   ] o.e.j.s.session No
SessionScavenger set, using defaults*
*2021-04-29 11:19:58.570 INFO  (main) [   ] o.e.j.s.session node0
Scavenging every 660000ms*
*2021-04-29 11:19:58.693 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter
Using logger factory org.apache.logging.slf4j.Log4jLoggerFactory*
*2021-04-29 11:19:58.698 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter
___      _       Welcome to Apache Solr™ version 8.6.2*
*2021-04-29 11:19:58.698 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter /
__| ___| |_ _   Starting in standalone mode on port 8983*
*2021-04-29 11:19:58.698 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter \__
\/ _ \ | '_|  Install dir: /opt/solr*
*2021-04-29 11:19:58.699 INFO  (main) [   ] o.a.s.s.SolrDispatchFilter
|___/\___/_|_|    Start time: 2021-04-29T11:19:58.699Z*
*Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver
class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered
via the SPI and manual loading of the driver class is generally unnecessary*

Changed *com.mysql.jdbc.Drive*r with com.*mysql.cj.jdbc.Driver * in
datacofig.xml

    <dataSource type="JdbcDataSource"
            driver="com.mysql.cj.jdbc.Driver"
            batchSize="-1"

and also uploaded latest version - mysql-connector-java-8.0.24.jar

On Thu, 29 Apr 2021 at 18:30, Anuj Bhargava <an...@gmail.com> wrote:

> { "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
> "1619701169621"}}, "response":{"numFound":179573,"start":0,"numFoundExact
> ":true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",
>
> On Thu, 29 Apr 2021 at 17:18, Charlie Hull <
> chull@opensourceconnections.com> wrote:
>
>> What happens if you run exactly that SELECT query on your source database?
>>
>> Charlie
>>
>> On 29/04/2021 12:08, Anuj Bhargava wrote:
>> > Ever since installing 8.6 a couple of months ago, the indexing was
>> working
>> > fine. All of a sudden getting the following error -
>> >
>> > 4/29/2021, 12:01:59 PM
>> > ERROR false
>> > DocBuilder
>> > Exception while processing: hotels document : SolrInputDocument(fields:
>> > []):org.apache.solr.handler.dataimport.DataImportHandlerException:
>> Unable
>> > to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
>> > ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country
>> ='LK'
>> > OR country ='MV' OR country ='BT' Processing Document # 1
>> >
>> > 4/29/2021, 12:01:59 PM
>> > ERROR false
>> > DataImporter
>> > Full Import failed:java.lang.RuntimeException:
>> java.lang.RuntimeException:
>> > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
>> > execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
>> ='PK'
>> > OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
>> > country ='MV' OR country ='BT' Processing Document # 1
>> >
>> > Please help
>> >
>>
>> --
>> Charlie Hull - Managing Consultant at OpenSource Connections Limited
>> <www.o19s.com>
>> Founding member of The Search Network <https://thesearchnetwork.com/>
>> and co-author of Searching the Enterprise
>> <https://opensourceconnections.com/about-us/books-resources/>
>> tel/fax: +44 (0)8700 118334
>> mobile: +44 (0)7767 825828
>>
>

Re: Solr 8.6 Indexing Issue

Posted by Anuj Bhargava <an...@gmail.com>.
Just added the following line and it started indexing again.

*useSSL="false"*

<dataConfig>
    <dataSource type="JdbcDataSource"
            driver="com.mysql.jdbc.Driver"
            batchSize="-1"
            autoReconnect="true"
            *useSSL="false"*
            socketTimeout="0"
            connectTimeout="0"
            encoding="UTF-8"

url="jdbc:mysql://xxx:3306/xx?zeroDateTimeBehavior=convertToNull"
            user="xxxx"
            password="xxxx"/>

On Thu, 29 Apr 2021 at 21:40, Charlie Hull <ch...@opensourceconnections.com>
wrote:

> I meant can you run it on the database directly, without Solr, and what
> happens?
>
> Best
>
> Charlie
>
> On 29/04/2021 14:00, Anuj Bhargava wrote:
> > { "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
> > "1619701169621"}},
> "response":{"numFound":179573,"start":0,"numFoundExact":
> > true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",
> >
> > On Thu, 29 Apr 2021 at 17:18, Charlie Hull <
> chull@opensourceconnections.com>
> > wrote:
> >
> >> What happens if you run exactly that SELECT query on your source
> database?
> >>
> >> Charlie
> >>
> >> On 29/04/2021 12:08, Anuj Bhargava wrote:
> >>> Ever since installing 8.6 a couple of months ago, the indexing was
> >> working
> >>> fine. All of a sudden getting the following error -
> >>>
> >>> 4/29/2021, 12:01:59 PM
> >>> ERROR false
> >>> DocBuilder
> >>> Exception while processing: hotels document : SolrInputDocument(fields:
> >>> []):org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable
> >>> to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
> >>> ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country
> ='LK'
> >>> OR country ='MV' OR country ='BT' Processing Document # 1
> >>>
> >>> 4/29/2021, 12:01:59 PM
> >>> ERROR false
> >>> DataImporter
> >>> Full Import failed:java.lang.RuntimeException:
> >> java.lang.RuntimeException:
> >>> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
> to
> >>> execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
> ='PK'
> >>> OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
> >>> country ='MV' OR country ='BT' Processing Document # 1
> >>>
> >>> Please help
> >>>
> >> --
> >> Charlie Hull - Managing Consultant at OpenSource Connections Limited
> >> <www.o19s.com>
> >> Founding member of The Search Network <https://thesearchnetwork.com/>
> >> and co-author of Searching the Enterprise
> >> <https://opensourceconnections.com/about-us/books-resources/>
> >> tel/fax: +44 (0)8700 118334
> >> mobile: +44 (0)7767 825828
> >>
>
> --
> Charlie Hull - Managing Consultant at OpenSource Connections Limited
> <www.o19s.com>
> Founding member of The Search Network <https://thesearchnetwork.com/>
> and co-author of Searching the Enterprise
> <https://opensourceconnections.com/about-us/books-resources/>
> tel/fax: +44 (0)8700 118334
> mobile: +44 (0)7767 825828
>

Re: Solr 8.6 Indexing Issue

Posted by Anuj Bhargava <an...@gmail.com>.
Without solr, directly is also working.

Only it is not indexing any longer

On Thu, 29 Apr 2021 at 21:40, Charlie Hull <ch...@opensourceconnections.com>
wrote:

> I meant can you run it on the database directly, without Solr, and what
> happens?
>
> Best
>
> Charlie
>
> On 29/04/2021 14:00, Anuj Bhargava wrote:
> > { "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
> > "1619701169621"}},
> "response":{"numFound":179573,"start":0,"numFoundExact":
> > true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",
> >
> > On Thu, 29 Apr 2021 at 17:18, Charlie Hull <
> chull@opensourceconnections.com>
> > wrote:
> >
> >> What happens if you run exactly that SELECT query on your source
> database?
> >>
> >> Charlie
> >>
> >> On 29/04/2021 12:08, Anuj Bhargava wrote:
> >>> Ever since installing 8.6 a couple of months ago, the indexing was
> >> working
> >>> fine. All of a sudden getting the following error -
> >>>
> >>> 4/29/2021, 12:01:59 PM
> >>> ERROR false
> >>> DocBuilder
> >>> Exception while processing: hotels document : SolrInputDocument(fields:
> >>> []):org.apache.solr.handler.dataimport.DataImportHandlerException:
> Unable
> >>> to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
> >>> ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country
> ='LK'
> >>> OR country ='MV' OR country ='BT' Processing Document # 1
> >>>
> >>> 4/29/2021, 12:01:59 PM
> >>> ERROR false
> >>> DataImporter
> >>> Full Import failed:java.lang.RuntimeException:
> >> java.lang.RuntimeException:
> >>> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
> to
> >>> execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
> ='PK'
> >>> OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
> >>> country ='MV' OR country ='BT' Processing Document # 1
> >>>
> >>> Please help
> >>>
> >> --
> >> Charlie Hull - Managing Consultant at OpenSource Connections Limited
> >> <www.o19s.com>
> >> Founding member of The Search Network <https://thesearchnetwork.com/>
> >> and co-author of Searching the Enterprise
> >> <https://opensourceconnections.com/about-us/books-resources/>
> >> tel/fax: +44 (0)8700 118334
> >> mobile: +44 (0)7767 825828
> >>
>
> --
> Charlie Hull - Managing Consultant at OpenSource Connections Limited
> <www.o19s.com>
> Founding member of The Search Network <https://thesearchnetwork.com/>
> and co-author of Searching the Enterprise
> <https://opensourceconnections.com/about-us/books-resources/>
> tel/fax: +44 (0)8700 118334
> mobile: +44 (0)7767 825828
>

Re: Solr 8.6 Indexing Issue

Posted by Charlie Hull <ch...@opensourceconnections.com>.
I meant can you run it on the database directly, without Solr, and what 
happens?

Best

Charlie

On 29/04/2021 14:00, Anuj Bhargava wrote:
> { "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
> "1619701169621"}}, "response":{"numFound":179573,"start":0,"numFoundExact":
> true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",
>
> On Thu, 29 Apr 2021 at 17:18, Charlie Hull <ch...@opensourceconnections.com>
> wrote:
>
>> What happens if you run exactly that SELECT query on your source database?
>>
>> Charlie
>>
>> On 29/04/2021 12:08, Anuj Bhargava wrote:
>>> Ever since installing 8.6 a couple of months ago, the indexing was
>> working
>>> fine. All of a sudden getting the following error -
>>>
>>> 4/29/2021, 12:01:59 PM
>>> ERROR false
>>> DocBuilder
>>> Exception while processing: hotels document : SolrInputDocument(fields:
>>> []):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
>>> to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
>>> ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK'
>>> OR country ='MV' OR country ='BT' Processing Document # 1
>>>
>>> 4/29/2021, 12:01:59 PM
>>> ERROR false
>>> DataImporter
>>> Full Import failed:java.lang.RuntimeException:
>> java.lang.RuntimeException:
>>> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
>>> execute query: SELECT * FROM hotels WHERE country = 'IN' OR country ='PK'
>>> OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
>>> country ='MV' OR country ='BT' Processing Document # 1
>>>
>>> Please help
>>>
>> --
>> Charlie Hull - Managing Consultant at OpenSource Connections Limited
>> <www.o19s.com>
>> Founding member of The Search Network <https://thesearchnetwork.com/>
>> and co-author of Searching the Enterprise
>> <https://opensourceconnections.com/about-us/books-resources/>
>> tel/fax: +44 (0)8700 118334
>> mobile: +44 (0)7767 825828
>>

-- 
Charlie Hull - Managing Consultant at OpenSource Connections Limited 
<www.o19s.com>
Founding member of The Search Network <https://thesearchnetwork.com/> 
and co-author of Searching the Enterprise 
<https://opensourceconnections.com/about-us/books-resources/>
tel/fax: +44 (0)8700 118334
mobile: +44 (0)7767 825828

Re: Solr 8.6 Indexing Issue

Posted by Anuj Bhargava <an...@gmail.com>.
{ "responseHeader":{ "status":0, "QTime":11, "params":{ "q":"*:*", "_":
"1619701169621"}}, "response":{"numFound":179573,"start":0,"numFoundExact":
true,"docs":[ { "country":["AU"], "date_c":"2019-03-14T18:30:00Z",

On Thu, 29 Apr 2021 at 17:18, Charlie Hull <ch...@opensourceconnections.com>
wrote:

> What happens if you run exactly that SELECT query on your source database?
>
> Charlie
>
> On 29/04/2021 12:08, Anuj Bhargava wrote:
> > Ever since installing 8.6 a couple of months ago, the indexing was
> working
> > fine. All of a sudden getting the following error -
> >
> > 4/29/2021, 12:01:59 PM
> > ERROR false
> > DocBuilder
> > Exception while processing: hotels document : SolrInputDocument(fields:
> > []):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
> > to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
> > ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK'
> > OR country ='MV' OR country ='BT' Processing Document # 1
> >
> > 4/29/2021, 12:01:59 PM
> > ERROR false
> > DataImporter
> > Full Import failed:java.lang.RuntimeException:
> java.lang.RuntimeException:
> > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> > execute query: SELECT * FROM hotels WHERE country = 'IN' OR country ='PK'
> > OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
> > country ='MV' OR country ='BT' Processing Document # 1
> >
> > Please help
> >
>
> --
> Charlie Hull - Managing Consultant at OpenSource Connections Limited
> <www.o19s.com>
> Founding member of The Search Network <https://thesearchnetwork.com/>
> and co-author of Searching the Enterprise
> <https://opensourceconnections.com/about-us/books-resources/>
> tel/fax: +44 (0)8700 118334
> mobile: +44 (0)7767 825828
>

Re: Solr 8.6 Indexing Issue

Posted by Charlie Hull <ch...@opensourceconnections.com>.
What happens if you run exactly that SELECT query on your source database?

Charlie

On 29/04/2021 12:08, Anuj Bhargava wrote:
> Ever since installing 8.6 a couple of months ago, the indexing was working
> fine. All of a sudden getting the following error -
>
> 4/29/2021, 12:01:59 PM
> ERROR false
> DocBuilder
> Exception while processing: hotels document : SolrInputDocument(fields:
> []):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable
> to execute query: SELECT * FROM hotels WHERE country = 'IN' OR country
> ='PK' OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK'
> OR country ='MV' OR country ='BT' Processing Document # 1
>
> 4/29/2021, 12:01:59 PM
> ERROR false
> DataImporter
> Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException:
> org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
> execute query: SELECT * FROM hotels WHERE country = 'IN' OR country ='PK'
> OR country ='BD' OR country ='AF' OR country ='NP' OR country ='LK' OR
> country ='MV' OR country ='BT' Processing Document # 1
>
> Please help
>

-- 
Charlie Hull - Managing Consultant at OpenSource Connections Limited 
<www.o19s.com>
Founding member of The Search Network <https://thesearchnetwork.com/> 
and co-author of Searching the Enterprise 
<https://opensourceconnections.com/about-us/books-resources/>
tel/fax: +44 (0)8700 118334
mobile: +44 (0)7767 825828

Re: Solr 8.6 Indexing Issue

Posted by Shawn Heisey <ap...@elyograg.org>.
On 4/29/2021 5:08 AM, Anuj Bhargava wrote:
> Ever since installing 8.6 a couple of months ago, the indexing was working
> fine. All of a sudden getting the following error -

Can you use a file sharing site to provide us with links to the following?

* The solrconfig.xml file for the problem index.
* The dataimport handler config file that is referenced in solrconfig.xml.
* A copy of the solr.log file that contains the moment of failure.
* A count of how many in mysql match that SELECT statement.

For the last one, you can simply replace "*" in the query to "COUNT(*)" 
and run it manually as Charlie suggested.

The DIH config probably contains a password.  Feel free to redact 
sensitive data from the file, but do not change it in any other way.

The reason that I have asked you to use a file sharing site is because 
the mailing list tends to eat all attachments.  That is a very 
unreliable way to send us files.

Thanks,
Shawn