RE: SolrCloud DIH (Data Import Handler) MySQL 404

[msaunier]

Hello Shawn,
Thanks for your answers. 

#############################################################################
So, indexation_events.xml file is:

<dataConfig>

        <dataSource name="Gesloc"  type="JdbcDataSource" 
driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://srv-gesloc-sql/TRANSACTIONCITYANEWLOCATION" user="user" 
password="mypassword" />

        <document>
                <entity name="events_Gesloc" dataSource="Gesloc" 
transformer="TemplateTransformer" query="SELECT 
id,origine,base_name,document_date,document_type,writer,recipient,solver,solution_date,personality,building,management_mandate,lease,coowner,property,title,data
 from view_indexation_events" >

                        <field column="id" name="id"/>

                        <field column="origine" name="origine"/>

                        <field column="base_name" name="base_name"/>

                        <field column="document_date" name="document_date"/>

                        <field column="document_type" name="document_type"/>

                        <field column="writer" name="writer"/>

                        <field column="recipient" name="recipient"/>

                        <field column="solver" name="solver"/>

                        <field column="solution_date" name="solution_date"/>

                        <field column="personality" name="personality"/>

                        <field column="building" name="building"/>

                        <field column="management_mandate" 
names="management_mandate"/>

                        <field column="lease" names="lease"/>

                        <field column="coowner" names="coowner"/>

                        <field column="property" name="properties"/>

                        <field column="title" name="subject"/>

                        <field column="data" name="data"/>
                </entity>
        </document>

</dataConfig>

#############################################################################
And the config file is the configoverlay.xml, it's in cloud:

{
  "updateProcessor":{},

  "runtimeLib":{
    "mysql-connector-java":{
      "name":"mysql-connector-java",
      "version":1},

    "data-import-handler":{
      "name":"data-import-handler",
      "version":1}},

  "requestHandler":{"/test_dih":{
      "name":"/test_dih",
      "class":"org.apache.solr.handler.dataimport.DataImportHandler",
      "runtimeLib":true,
      "version":1,
      "defaults":{"config":"DIH/indexation_events.xml"}}}
}

I go to regard the solr.log

Thanks,
Maxence





-----Message d'origine-----
De : Shawn Heisey [mailto:apa...@elyograg.org] 
Envoyé : lundi 23 avril 2018 18:28
À : solr-user@lucene.apache.org
Objet : Re: SolrCloud DIH (Data Import Handler) MySQL 404

On 4/23/2018 8:30 AM, msaunier wrote:
> I have add debug:
>
> curl
> "http://srv-formation-solr:8983/solr/arguments_test/test_dih?command=f
> ull-im
> port&commit=true&debug=true"
> <?xml version="1.0" encoding="UTF-8"?> <response> <lst 
> name="responseHeader"><int name="status">500</int><int 
> name="QTime">588</int></lst><lst name="initArgs"><bool 
> name="runtimeLib">true</bool><long name="version">1</long><lst 
> name="defaults"><str 
> name="config">DIH/indexation_events.xml</str></lst></lst><str

This is looking like a really nasty error that I cannot understand, possibly 
caused by an error in configuration.

Can you share your dataimport handler config (will likely be in
solrconfig.xml) and the contents of DIH/indexation_events.xml?  There is 
probably a database password in that file, you'll want to redact that.

You should look at solr.log and see if there are other errors happening that 
didn't make it into the response.

Thanks,
Shawn