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
>>
>
