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
