Ok I found the problem.
In debug mode, DataImportHandler does not commit documents since it is meant
for debugging only. If you want to do a commit, add commit=true as a request
parameter.
On Fri, Nov 14, 2008 at 7:56 PM, Marc Sturlese <[EMAIL PROTECTED]>wrote:
>
> Hey,
> That's the weird thing... in the log everything seems to work fine:
>
> Nov 14, 2008 3:12:46 PM
> org.apache.solr.handler.dataimport.DataImportHandler
> processConfiguration
> INFO: Processing configuration from solrconfig.xml:
>
> {config=/opt/netbeans-5.5.1/enterprise3/apache-tomcat-5.5.17/bin/solr/conf/data-config.xml}
> Nov 14, 2008 3:12:46 PM org.apache.solr.handler.dataimport.DataImporter
> loadDataConfig
> INFO: Data Configuration loaded successfully
> Nov 14, 2008 3:12:46 PM org.apache.solr.handler.dataimport.DataImporter
> doDeltaImport
> INFO: Starting Delta Import
> Nov 14, 2008 3:12:46 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Creating a connection for entity homes_tbl_ads with URL:
> jdbc:mysql://localhost/path_db
> Nov 14, 2008 3:12:46 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Time taken for getConnection(): 11
> Nov 14, 2008 3:12:46 PM org.apache.solr.handler.dataimport.DocBuilder
> execute
> INFO: Time taken = 0:0:0.47
> Nov 14, 2008 3:12:46 PM org.apache.solr.core.SolrCore execute
> INFO: [] webapp=/solr_web path=/dataimport
> params={verbose=true&command=delta-import&debug=on} status=0 QTime=130
> Nov 14, 2008 3:12:46 PM org.apache.solr.core.SolrCore execute
> INFO: [] webapp=/solr_web path=/dataimport params={command=show-config}
> status=0 QTime=0
>
> I am calling the dataimport this way:
> http://...dataimport?command=full-import&debug=on&verbose=true
> http://...dataimport?command=delta-import&debug=on&verbose=true
>
> In delta-import I am getting this aoutput with the verbose debug:
>
> ...
> <str name="command">delta-import</str>
> <str name="mode">debug</str>
> <arr name="documents">
> ...
> lst name="statusMessages">
> <str name="Total Requests made to DataSource">1</str>
> <str name="Total Rows Fetched">10</str>
> <str name="Total Documents Skipped">0</str>
> <str name="Full Dump Started">2008-11-14 15:12:46</str>
> <str name="Time taken ">0:0:0.47</str>
> </lst>
>
> It also shows the changes in the rows in the output of the verbose debug
> but
> nothing change in the index when I check it with Luke.
> I keep thinking that something is wrong coz the import.properties it is not
> being created... but can't find why :(
>
> solrconfig.xml:
> <requestHandler name="/dataimport"
> class="org.apache.solr.handler.dataimport.DataImportHandler"
> default="false">
> <lst name="defaults">
> <!-- <str name="update.processor">dedupe</str> -->
> <str
>
> name="config">/opt/netbeans-5.5.1/enterprise3/apache-tomcat-5.5.17/bin/solr/conf/data-config.xml</str>
> </lst>
> </requestHandler>
>
> data-config.xml:
>
> <dataConfig>
> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost/trovit_es" user="root" password=""/>
> <document name="item">
> <entity name="tables" pk="id" query="select id,field1 from table by
> id
> limit 1000" deltaQuery="select id from table where dt_last_modified >
> '${dataimporter.last_index_time}' order by id" >
> <field name="id" column="id" />
> <field name="field1" column="field1" />
> </entity>
> </document>
> </dataConfig>
>
> Thanks a lot
>
>
>
> --
> View this message in context:
> http://www.nabble.com/troubles-with-delta-import-tp20498449p20501450.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
Regards,
Shalin Shekhar Mangar.
