lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexandre Sompheng (Resolved) (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SOLR-2711) DIH does not commit after delta-import task
Date Sun, 16 Oct 2011 20:12:11 GMT

     [ 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-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message