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