It is not fetching
Requests: 1 , Fetched: 0 , Skipped: 0 , Processed: 0
On Thu, 29 Apr 2021 at 18:35, Anuj Bhargava <anujb...@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 <anujb...@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 <
>> 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
>>>
>>
