我很难将数据从mysql导入到solr . 当我尝试创建/ dataimport时,它给了我这样的响应:

{
  "responseHeader": {
    "status": 0,
    "QTime": 1
  },
  "initArgs": [
    "defaults",
    [
      "config",
      "data-config.xml"
    ]
  ],
  "command": "status",
  "status": "idle",
  "importResponse": "",
  "statusMessages": {
    "Total Requests made to DataSource": "1",
    "Total Rows Fetched": "50",
    "Total Documents Skipped": "0",
    "Full Dump Started": "2014-08-04 14:25:48",
    "": "Indexing completed. Added/Updated: 0 documents. Deleted 0 documents.",
    "Committed": "2014-08-04 14:25:48",
    "Total Documents Processed": "0",
    "Total Documents Failed": "50",
    "Time taken": "0:0:0.87"
  },
  "WARNING": "This response format is experimental.  It is likely to change in the future."
}

运行命令后没有错误,但它也不处理任何文档 . 我还检查了solr接口的commit复选框,并尝试访问url,并将“commit”参数设置为true,但没有任何运气 .

我的data-config.xml文件看起来像这样:

<dataConfig>
    <dataSource 
            name="mysql"
            driver="com.mysql.jdbc.Driver" 
            url="jdbc:mysql://localhost:3306/database" 
            user="root" 
            password=""/>

        <document name="id">

            <entity name="process" query="SELECT id, name, description, step_order, slug, is_private FROM Process WHERE `is_deleted`=false">
           <field column="id" name="id" />
                <field column="name" name="name" />
            <field column="description" name="description" />
            <field column="step_order" name="step_order" />
            <field column="slug" name="slug" />
            <field column="is_private" name="is_private"/>
            </entity>

        </document>

</dataConfig>

另外,我的schema.xml字段部分看起来像这样:

<fields>

   <field name="_version_" type="long" indexed="true" stored="true"/>

   <field name="id" type="int" indexed="true" stored="true" multiValued="false" /> 
   <field name="name" type="string" indexed="true" stored="true" /> 
   <field name="description" type="string" indexed="true" stored="true" /> 
   <field name="step_order" type="string" indexed="true" stored="true" /> 
   <field name="is_deleted" type="boolean" indexed="true" stored="true" /> 
   <field name="is_private" type="boolean" indexed="true" stored="true" /> 
   <field name="slug" type="string" indexed="true" stored="true"/> 

   <dynamicField name="*_i"  type="int"    indexed="true"  stored="true"/>
   <dynamicField name="*_is" type="int"    indexed="true"  stored="true"  multiValued="true"/>
   <dynamicField name="*_s"  type="string"  indexed="true"  stored="true" />
   <dynamicField name="*_ss" type="string"  indexed="true"  stored="true" multiValued="true"/>
   <dynamicField name="*_l"  type="long"   indexed="true"  stored="true"/>
   <dynamicField name="*_ls" type="long"   indexed="true"  stored="true"  multiValued="true"/>
   <dynamicField name="*_t"  type="text_general"    indexed="true"  stored="true"/>
   <dynamicField name="*_txt" type="text_general"   indexed="true"  stored="true" multiValued="true"/>
   <dynamicField name="*_en"  type="text_en"    indexed="true"  stored="true" multiValued="true"/>
   <dynamicField name="*_b"  type="boolean" indexed="true" stored="true"/>
   <dynamicField name="*_bs" type="boolean" indexed="true" stored="true"  multiValued="true"/>
   <dynamicField name="*_f"  type="float"  indexed="true"  stored="true"/>
   <dynamicField name="*_fs" type="float"  indexed="true"  stored="true"  multiValued="true"/>
   <dynamicField name="*_d"  type="double" indexed="true"  stored="true"/>
   <dynamicField name="*_ds" type="double" indexed="true"  stored="true"  multiValued="true"/>

   <!-- Type used to index the lat and lon components for the "location" FieldType -->
   <dynamicField name="*_coordinate"  type="tdouble" indexed="true"  stored="false" />

   <dynamicField name="*_dt"  type="date"    indexed="true"  stored="true"/>
   <dynamicField name="*_dts" type="date"    indexed="true"  stored="true" multiValued="true"/>
   <dynamicField name="*_p"  type="location" indexed="true" stored="true"/>

   <!-- some trie-coded dynamic fields for faster range queries -->
   <dynamicField name="*_ti" type="tint"    indexed="true"  stored="true"/>
   <dynamicField name="*_tl" type="tlong"   indexed="true"  stored="true"/>
   <dynamicField name="*_tf" type="tfloat"  indexed="true"  stored="true"/>
   <dynamicField name="*_td" type="tdouble" indexed="true"  stored="true"/>
   <dynamicField name="*_tdt" type="tdate"  indexed="true"  stored="true"/>

   <dynamicField name="*_pi"  type="pint"    indexed="true"  stored="true"/>
   <dynamicField name="*_c"   type="currency" indexed="true"  stored="true"/>

   <dynamicField name="ignored_*" type="ignored" multiValued="true"/>
   <dynamicField name="attr_*" type="text_general" indexed="true" stored="true" multiValued="true"/>

   <dynamicField name="random_*" type="random" />

   <!-- uncomment the following to ignore any fields that don't already match an existing 
        field name or dynamic field, rather than reporting them as an error. 
        alternately, change the type="ignored" to some other type e.g. "text" if you want 
        unknown fields indexed and/or stored by default --> 
   <dynamicField name="*" type="ignored" multiValued="true" />

 </fields>


 <!-- Field to use to determine and enforce document uniqueness. 
      Unless this field is marked with required="false", it will be a required field
   -->
 <uniqueKey>id</uniqueKey>

你能看一看,告诉我我做错了什么吗?

谢谢 .