At a guess, you're not getting as many rows as you think, and commit has
nothing to do with it. But that's just a guess.
So the very first thing I'd do is be sure the SQL is doing what you
think. There's
a little-known data import debugging page that might help:
blahblahblah...../solr/admin/dataimport.jsp
Best
Erick
On Sat, Aug 20, 2011 at 4:30 PM, Alexandre Sompheng <asomph...@gmail.com> wrote:
> Actually I requested .../dataimport?command=delta-import&commit=true
> And DIH in delta-import mode does not commit, you can se log below. My index
> is quite empty, maybe 10 data rows max... It's just the beginning.
>
>
> INFO: Starting Delta Import
>
> Aug 14, 2011 1:42:02 AM org.apache.solr.core.SolrCore execute
>
> INFO: [] webapp=/apache-solr-3.3.0 path=/dataimport
> params={commit=true&command=delta-import} status=0 QTime=0
>
> Aug 14, 2011 1:42:02 AM org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
>
> INFO: Read dataimport.properties
>
> Aug 14, 2011 1:42:02 AM org.apache.solr.handler.dataimport.DocBuilder
> doDelta
>
> INFO: Starting delta collection.
>
> Aug 14, 2011 1:42:02 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
>
> INFO: Running ModifiedRowKey() for Entity: event
>
> Aug 14, 2011 1:42:02 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:42:03 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
>
> INFO: Time taken for getConnection(): 865
>
> Aug 14, 2011 1:42:03 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
>
> INFO: Completed ModifiedRowKey for Entity: event rows obtained : 3
>
> Aug 14, 2011 1:42:03 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
>
> INFO: Completed DeletedRowKey for Entity: event rows obtained : 0
>
> Aug 14, 2011 1:42:03 AM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
>
> INFO: Completed parentDeltaQuery for Entity: event
>
> Aug 14, 2011 1:42:03 AM org.apache.solr.handler.dataimport.DocBuilder
> doDelta
>
> INFO: Delta Import completed successfully
>
> Aug 14, 2011 1:42:03 AM org.apache.solr.update.processor.LogUpdateProcessor
> finish
>
> INFO: {} 0 0
>
> Aug 14, 2011 1:42:03 AM org.apache.solr.handler.dataimport.DocBuilder
> execute
>
> INFO: Time taken = 0:0:1.282
>
>
> On 19 août 2011, at 10:39, Gora Mohanty <g...@mimirtech.com> wrote:
>
> On Fri, Aug 19, 2011 at 5:32 AM, Alexandre Sompheng <asomph...@gmail.com>
> wrote:
>
> Hi guys, i try the delta import, i got logs saying that it found delta
>
> data to update. But it seems that the index is not updated. Amy guess
>
> why this happens ? Did i miss something? I'm on solr 3.3 with no
>
> patch.
>
> [...]
>
> Please show us the following:
> * The exact URL you loaded for delta-import
> * The Solr response which shows the delta documents that it found,
> and the status of the delta-import.
> If your index is large, and if you are running an optimise after the
> delta-import (the default is to optimise), it can take some time.
> Check the status: It will say "busy" if the optimise is still running.
>
> Regards,
> Gora
>
