Re: Why I can't take an full-import with entity name?

[Pulkit Singhal <pu...@gmail.com>]

Can you monitor the DB side to see what results it returned for that query?

2011/8/30 于浩 <yu...@gmail.com>:
> I am using solr1.3,I updated solr index throgh solr delta import every two
> hours. but the delta import is database connection wasteful.
> So i want to use full-import with entity name instead of delta import.
>
> my db-data-config.xml  file:
> <entity name="article" pk="Article_ID"  query="select
> Article_ID,Article_Title,Article_Abstract from Article_Detail">
>                <field name="Article_ID" column="Article_ID" />
> </entity>
> <entity name="delta_article" pk="Article_ID"  rootEngity="false"
>  query="select Article_ID,Article_Title,Article_Abstract from Article_Detail
> where Article_ID&gt;'${dataimporter.request.minID}' and Article_ID
> &lt;='{dataimporter.request.maxID}'
> ">
>                <field name="Article_ID" column="Article_ID" />
> </entity>
>
>
> then I uses
> http://192.168.1.98:8081/solr/db_article/dataimport?command=full-import&entity=delta_article&commit=true&clean=false&maxID=1000&minID=10
> but the solr will finish nearyly instant,and there is no any record
> imported. but what the fact is there are many records meets the condtion of
> maxID and minID.
>
>
> the tomcat log:
> 信息: [db_article] webapp=/solr path=/dataimport
> params={maxID=6737277&clean=false&commit=true&entity=delta_article&command=full-import&minID=6736841}
> status=0 QTime=0
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.DataImporter
> doFullImport
> 信息: Starting Full Import
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
> 信息: Read dataimport.properties
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.SolrWriter
> persistStartTime
> 信息: Wrote last indexed time to dataimport.properties
> 2011-8-29 19:00:03 org.apache.solr.handler.dataimport.DocBuilder commit
> 信息: Full Import completed successfully
>
>
> some body who can help or some advices?
>