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
