check the logs and see if you have any messages like Exception while adding ... or Error creating document :
2009/9/17 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com>: > the status command is command=status > > 2009/9/17 Noble Paul നോബിള് नोब्ळ् <noble.p...@corp.aol.com>: >> 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 >> > > > > -- > ----------------------------------------------------- > Noble Paul | Principal Engineer| AOL | http://aol.com > -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com
