same response .. <str name="command">delta-import</str> <str name="status">idle</str> <str name="importResponse"/> − <lst name="statusMessages"> <str name="Total Requests made to DataSource">3</str> <str name="Total Rows Fetched">2</str> <str name="Total Documents Skipped">0</str> <str name="Delta Dump started">2009-09-17 11:58:13</str> <str name="Identifying Delta">2009-09-17 11:58:13</str> <str name="Deltas Obtained">2009-09-17 11:58:13</str> <str name="Building documents">2009-09-17 11:58:13</str> <str name="Total Changed Documents">2</str> <str name="Time taken ">0:0:0.156</str>
used http://localhost:8080/solr/dataimport?command=delta-import&commit=true Noble Paul നോബിള് नोब्ळ्-2 wrote: > > can you try the same command a commit=true ? > > On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <kirst...@gmail.com> wrote: >> >> No, I don't see any commit... >> >> I ran with this command >> http://localhost:8080/solr/dataimport?command=delta-import >> and these are the results >> >> <str name="command">delta-import</str> >> <str name="status">idle</str> >> <str name="importResponse"/> >> − >> <lst name="statusMessages"> >> <str name="Total Requests made to DataSource">3</str> >> <str name="Total Rows Fetched">2</str> >> <str name="Total Documents Skipped">0</str> >> <str name="Delta Dump started">2009-09-17 11:42:14</str> >> <str name="Identifying Delta">2009-09-17 11:42:14</str> >> <str name="Deltas Obtained">2009-09-17 11:42:14</str> >> <str name="Building documents">2009-09-17 11:42:14</str> >> <str name="Total Changed Documents">2</str> >> <str name="Time taken ">0:0:0.172</str> >> </lst> >> − >> <str name="WARNING"> >> This response format is experimental. It is likely to change in the >> future. >> </str> >> >> Is it not supposed to default to commit? >> >> Noble Paul നോബിള് नोब्ळ्-2 wrote: >>> >>> What does the status command say after delta-import? does it say >>> committed? >>> >>> On Thu, Sep 17, 2009 at 2:50 PM, KirstyS <kirst...@gmail.com> wrote: >>>> >>>> Hi! thanks so much, I have the latest release. >>>> Now, it shows that the delta import is successful but when I query for >>>> the >>>> updated article I am expecting, it has not updated. It's like the index >>>> is >>>> not being updated with the changes...Any ideas? >>>> thanks >>>> Kirsty >>>> >>>> Noble Paul നോബിള് नोब्ळ्-2 wrote: >>>>> >>>>> http://people.apache.org/builds/lucene/solr/nightly/ >>>>> >>>>> On Wed, Sep 16, 2009 at 6:42 PM, KirstyS <kirst...@gmail.com> wrote: >>>>>> >>>>>> mmm..can't seem to find the link..could you help? >>>>>> >>>>>> >>>>>> Noble Paul നോബിള് नोब्ळ्-2 wrote: >>>>>>> >>>>>>> yeah, not yet released but going to be released pretty soon >>>>>>> >>>>>>> On Wed, Sep 16, 2009 at 6:32 PM, KirstyS <kirst...@gmail.com> wrote: >>>>>>>> >>>>>>>> I thought 1.4 was not released yet? >>>>>>>> >>>>>>>> >>>>>>>> Noble Paul നോബിള് नोब्ळ्-2 wrote: >>>>>>>>> >>>>>>>>> I vaguely remember there was an issue with delta-import in 1.3. >>>>>>>>> could >>>>>>>>> you try it out with Solr1.4 >>>>>>>>> >>>>>>>>> On Wed, Sep 16, 2009 at 6:14 PM, KirstyS <kirst...@gmail.com> >>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> I hope this is the correct place to post this issue and if so, >>>>>>>>>> that >>>>>>>>>> someone >>>>>>>>>> can help. >>>>>>>>>> I am using the DIH with Solr 1.3 >>>>>>>>>> My data-config.xml file looks like this: >>>>>>>>>> <dataSource >>>>>>>>>> driver="net.sourceforge.jtds.jdbc.Driver" >>>>>>>>>> url="jdbc:jtds:sqlserver:{taken out for >>>>>>>>>> posting} >>>>>>>>>> user={taken out for posting} >>>>>>>>>> password={taken out for posting} /> >>>>>>>>>> >>>>>>>>>> <entity name="article" pk="CmsArticleId" >>>>>>>>>> query="Select a.CmsArticleId, a.CreatorId , >>>>>>>>>> LastUpdatedBy, >>>>>>>>>> LastUpdateDate, Title, Synopsis, Author, Source, IsPublished, >>>>>>>>>> ArticleTypeId, >>>>>>>>>> a.StrapHead, ShortHeading, >>>>>>>>>> HomePageBlurb, >>>>>>>>>> ByLine, >>>>>>>>>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank, >>>>>>>>>> c.CategoryId, AncestralName, >>>>>>>>>> CategoryName, >>>>>>>>>> CategoryDisplayName, ParentCategoryId, c.SiteId >>>>>>>>>> from Category c (nolock) >>>>>>>>>> inner join CmsArticleCollection ac >>>>>>>>>> (nolock) >>>>>>>>>> on >>>>>>>>>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId >>>>>>>>>> inner join CmsArticleArticleCollection aac >>>>>>>>>> (nolock) >>>>>>>>>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>>>>>> inner join CmsArticle a (nolock) on >>>>>>>>>> aac.CmsArticleId >>>>>>>>>> = a.CmsArticleId >>>>>>>>>> where (a.LiveEdit is null or a.LiveEdit = 0) >>>>>>>>>> and >>>>>>>>>> aac.SourceCmsArticleArticleCollectionId >>>>>>>>>> is >>>>>>>>>> null" >>>>>>>>>> deltaQuery="Select a.CmsArticleId, a.CreatorId , >>>>>>>>>> LastUpdatedBy, >>>>>>>>>> LastUpdateDate, Title, Synopsis, Author, Source, IsPublished, >>>>>>>>>> ArticleTypeId, >>>>>>>>>> a.StrapHead, ShortHeading, >>>>>>>>>> HomePageBlurb, >>>>>>>>>> ByLine, >>>>>>>>>> ArticleStatusId, LiveEdit, a.OriginalCategoryId, aac.Rank, >>>>>>>>>> c.CategoryId, AncestralName, >>>>>>>>>> CategoryName, >>>>>>>>>> CategoryDisplayName, ParentCategoryId, c.SiteId >>>>>>>>>> from Category c (nolock) >>>>>>>>>> inner join CmsArticleCollection ac >>>>>>>>>> (nolock) >>>>>>>>>> on >>>>>>>>>> c.DefaultCmsArticleCollectionId = ac.CmsArticleCollectionId >>>>>>>>>> inner join CmsArticleArticleCollection aac >>>>>>>>>> (nolock) >>>>>>>>>> on ac.CmsArticleCollectionId = aac.CmsArticleCollectionId >>>>>>>>>> inner join CmsArticle a (nolock) on >>>>>>>>>> aac.CmsArticleId >>>>>>>>>> = a.CmsArticleId >>>>>>>>>> where (a.LiveEdit is null or a.LiveEdit = 0) >>>>>>>>>> and >>>>>>>>>> aac.SourceCmsArticleArticleCollectionId >>>>>>>>>> is >>>>>>>>>> null >>>>>>>>>> and >>>>>>>>>> (LastUpdateDate >>>>>>>>>> > >>>>>>>>>> '${dataimporter.last_index_time}' >>>>>>>>>> OR a.CreationDate > '${dataimporter.last_index_time}')" > >>>>>>>>>> >>>>>>>>>> Have tried casting the dataimporter.last_index_time and the other >>>>>>>>>> date >>>>>>>>>> fields. To no avail. My Full Import works perfectly but I cannot >>>>>>>>>> get >>>>>>>>>> the >>>>>>>>>> command=delta-import to pick up the updated records. The >>>>>>>>>> LastUpdateDate >>>>>>>>>> is >>>>>>>>>> being updated. When I run this in the debug interface with >>>>>>>>>> delta-import >>>>>>>>>> it >>>>>>>>>> just never calls the delta import. >>>>>>>>>> Please, if anyone knows what I am doing wrong??? >>>>>>>>>> Many thanks >>>>>>>>>> Kirsty >>>>>>>>>> -- >>>>>>>>>> View this message in context: >>>>>>>>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25471596.html >>>>>>>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> ----------------------------------------------------- >>>>>>>>> Noble Paul | Principal Engineer| AOL | http://aol.com >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> View this message in context: >>>>>>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25471927.html >>>>>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> ----------------------------------------------------- >>>>>>> Noble Paul | Principal Engineer| AOL | http://aol.com >>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> View this message in context: >>>>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25472102.html >>>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> ----------------------------------------------------- >>>>> Noble Paul | Principal Engineer| AOL | http://aol.com >>>>> >>>>> >>>> >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/DeltaImport-problem-tp25471596p25487855.html >>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>> >>>> >>> >>> >>> >>> -- >>> ----------------------------------------------------- >>> Noble Paul | Principal Engineer| AOL | http://aol.com >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/DeltaImport-problem-tp25471596p25488209.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com > > -- View this message in context: http://www.nabble.com/DeltaImport-problem-tp25471596p25488365.html Sent from the Solr - User mailing list archive at Nabble.com.
