lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Noble Paul നോബിള്‍ नोब्ळ् <noble.p...@corp.aol.com>
Subject Re: DeltaImport problem
Date Thu, 17 Sep 2009 09:50:04 GMT
can you try the same command a commit=true ?

On Thu, Sep 17, 2009 at 3:15 PM, KirstyS <kirstypr@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 <kirstypr@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 <kirstypr@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 <kirstypr@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 <kirstypr@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

Mime
View raw message