[
https://issues.apache.org/jira/browse/SOLR-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexandre Sompheng resolved SOLR-2711.
--------------------------------------
Resolution: Fixed
Fix Version/s: 3.3
This is just crazy !
I finally found why it did not work... And kind of surprised that DIH does not
tell why nothing is updated, but knows that there are modified documents.
Anyway, the issue was located in the DIH config file (data/data-config.xml),
and it was 2 lowercase characters that did not allow DIH to commit.
instead of :
deltaImportQuery="select * from EVENT where ID='${dataimporter.delta.id}'"
I wrote :
deltaImportQuery="select * from EVENT where ID='${dataimporter.delta.ID}'"
to make it work !
And this is probably related to the column definition "ID" instead of "id":
<field column="ID" name="id" />
Regards,
Alexandre
> DIH does not commit after delta-import task
> -------------------------------------------
>
> Key: SOLR-2711
> URL: https://issues.apache.org/jira/browse/SOLR-2711
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 3.3
> Reporter: Alexandre Sompheng
> Fix For: 3.3
>
>
> I kind of have the same issue as SOLR-2492 but with "delta-import" that never
> commits its updates...
> I'm using "solr-dataimporthandler-3.3.0.jar".
> My log below says that there were 3 updates, but results data did not changed
> in refreshed search results :
> INFO: [] webapp=/apache-solr-3.3.0 path=/select
> params={explainOther=&indent=on&hl.fl=&wt=&hl=on&version=2.2&rows=100&debugQuery=on&fl=*,score&start=0&q=*:*&qt=&fq=}
> hits=3 status=0 QTime=0
> Aug 14, 2011 1:00:03 AM org.apache.solr.handler.dataimport.DataImporter
> doDeltaImport
> INFO: Starting Delta Import
> Aug 14, 2011 1:00:03 AM org.apache.solr.core.SolrCore execute
> INFO: [] webapp=/apache-solr-3.3.0 path=/select
> params={clean=false&commit=true&command=delta-import&qt=/dataimport} status=0
> QTime=0
> Aug 14, 2011 1:00:03 AM org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
> INFO: Read dataimport.properties
> Aug 14, 2011 1:00:03 AM org.apache.solr.handler.dataimport.DocBuilder doDelta
> INFO: Starting delta collection.
> Aug 14, 2011 1:00:03 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Running ModifiedRowKey() for Entity: event
> Aug 14, 2011 1:00:03 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Creating a connection for entity event with URL:
> jdbc:mysql://85.168.123.207:3306/AGENDA
> Aug 14, 2011 1:00:04 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Time taken for getConnection(): 563
> Aug 14, 2011 1:00:04 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed ModifiedRowKey for Entity: event rows obtained : 3
> Aug 14, 2011 1:00:04 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed DeletedRowKey for Entity: event rows obtained : 0
> Aug 14, 2011 1:00:04 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed parentDeltaQuery for Entity: event
> Aug 14, 2011 1:00:04 AM org.apache.solr.handler.dataimport.DocBuilder doDelta
> INFO: Delta Import completed successfully
> Aug 14, 2011 1:00:04 AM org.apache.solr.update.processor.LogUpdateProcessor
> finish
> INFO: {} 0 0
> Aug 14, 2011 1:00:04 AM org.apache.solr.handler.dataimport.DocBuilder execute
> INFO: Time taken = 0:0:0.745
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
