You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Sujatha Arun <su...@gmail.com> on 2014/10/01 09:19:25 UTC

Solr 4.7 .0 Issues with Update and Delete

I am having the  following issue on delete and update in solr 4.7.0


*Delete Issue*

I am using the following Curl command to delete a document from index

curl http://localhost:8080/solr/bf/update?commit=true -H "Content-Type:
text/xml" --data-binary '<delete><id>"1.0"</id></delete>'

<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader"><int name="status">0</int><int
name="QTime">7</int></lst>
</response>

This is what I see in logs

 INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
webapp=/solr path=/update params={commit=true} {delete=["1.0"
(-1480743948591824896)],commit=} 0 8

But When  I query I am still seeing the document

INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1 status=0
QTime=111


=============================================================

*Update Issue*

When I update a document for the first time it works fine ,but when I
update the same document again ,i  see this message in the logs and
document is not updated

 INFO  org.apache.solr.update.UpdateHandler  – No uncommitted changes.
Skipping IW.commit.

Regards

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Sujatha Arun <su...@gmail.com>.
Thanks Erick, No problem. Will check .

On Thu, Oct 2, 2014 at 12:54 AM, Erick Erickson <er...@gmail.com>
wrote:

> I'm clueless about the MongoDB connector. I suspect
> that's where the issue is unless you can reproduce
> this with a solr-only case.
>
> As you can tell, I don't recall seeing this problem come by
> the boards.
>
> Best,
> Erick
>
> On Wed, Oct 1, 2014 at 11:53 AM, Sujatha Arun <su...@gmail.com> wrote:
> > Erick,
> >
> >  Actually I am synching data between solr and  Mongodb using
> > mongo-connector.The details below. I have submitterd an issue in
> > Mongo-conenctor forum,just trying at the solr forum too  just in  case
> > anybody has encountered the same :) or why does the log state No
> > uncommitted changes. Skipping IW.commit
> >
> >
> > *Solr 4.7.0 Mongo connector 1.3.dev0 *
> >
> >
> > When I update a document for the first time with query
> >
> >
> > db.products.update({BookId:1179416.0},{$set:{Status:"no sell"}}
> >
> >
> > Entry in solr Mongo connector
> > INFO - Finished 'http://search.bf.com:8080/solr/bf/update/?commit=true'
> > (post) with body 'u'<commit ' in 0.004 seconds.
> >
> >
> > Entry in solr logs
> > org.apache.solr.update.UpdateHandler – end_commit_flush 47824126
> > [http-bio-8080-exec-1] INFO
> > org.apache.solr.update.processor.LogUpdateProcessor – [bf] webapp=/solr
> > path=/update/ params={commit=true} {add=[1179416.0
> > (1480746950999408640)],commit=} 0 36
> >
> > When I update same document again
> > db.products.update({BookId:1179416.0},{$set:{Status:"sell"}}
> >
> > Mongo Db Logs
> > NFO - Finished 'http://search.bf.com:8080/solr/bf/update/?commit=true'
> > (post) with body 'u'<commit ' in 0.004 seconds
> > Solr Logs
> > org.apache.solr.update.UpdateHandler – No uncommitted changes. Skipping
> > IW.commit. 47904520 [http-bio-8080-exec-8] INFO
> > org.apache.solr.search.SolrIndexSearcher – Opening Searcher@7f771c0[bf]
> > main 47904520 [http-bio-8080-exec-8] INFO
> > org.apache.solr.update.UpdateHandler – end_commit_flush 47904521
> > [searcherExecutor-6-thread-1] INFO org.apache.solr.core.SolrCore – [bf]
> > Registered new searcher Searcher@7f771c0[bf]
> > main{StandardDirectoryReader(segments_2zz:8617:nrt
> > _s1(4.7):C450500/3:delGen=3 _wj(4.7):C63500 _1kf(4.7):C396334/1:delGen=1
> > _26o(4.7):C360500 _2pl(4.7):C248000 _2in(4.7):C59000 _2ub(4.7):C77000
> > _2zv(4.7):C63500 _36a(4.7):C77000 _32x(4.7):C27500 _34v(4.7):C27500
> > _38s(4.7):C27500 _3ag(4.7):C41000 _3ba(4.7):C6860 _3b0(4.7):C5000
> > _3bb(4.7):C1 _3bc(4.7):C1 _3bg(4.7):C1 _3bh(4.7):C1 _3bi(4.7):C1)}
> 47904521
> > [http-bio-8080-exec-8] INFO
> > org.apache.solr.update.processor.LogUpdateProcessor – [bf] webapp=/solr
> > path=/update/ params={commit=true} {commit=,commit=} 0 3
> > Each time Mongoconnector sends a commit, but the second time ,nothing
> > happens.this seems to work only once.
> >
> > On Wed, Oct 1, 2014 at 9:47 PM, Erick Erickson <er...@gmail.com>
> > wrote:
> >
> >> At this point details matter a lot.
> >>
> >> What exactly are you doing when you update?
> >>
> >> What happens if you issue an explicit update command? i.e.
> >> http://blahlbah/solr/collection/update?commit=true?
> >>
> >> Are you sure you aren't seeing, say, browser caching?
> >>
> >> Best,
> >> Erick
> >>
> >> On Wed, Oct 1, 2014 at 9:04 AM, Sujatha Arun <su...@gmail.com>
> wrote:
> >> > Thanks, BookId is the unique key, the issue is resolved with respect
> to
> >> > delete .Its the update that causing the issue
> >> >
> >> > On Wed, Oct 1, 2014 at 8:51 PM, Erick Erickson <
> erickerickson@gmail.com>
> >> > wrote:
> >> >
> >> >> I'd add only one thing to Angel's comments:
> >> >> you're deleting by "id", but querying by "BookId". This
> >> >> _should_ work (on a quick glance at the code) iff
> >> >> your <uniqueKey> is "BookId"...
> >> >>
> >> >> I took a quick glance at the code and "id" should delete by
> >> >> <uniqueKey>, so is your "BookId" the <uniqueKey> in
> >> >> your schema?
> >> >>
> >> >>
> >> >>
> >> >> On Wed, Oct 1, 2014 at 12:37 AM, Angel Tchorbadjiiski
> >> >> <an...@antibodies-online.com> wrote:
> >> >> > Hello Sujatha,
> >> >> >
> >> >> > have you tried to leave the quotes out? :-)
> >> >> >
> >> >> > Alternatively try using '<delete><query>id:1.0</query></delete>' to
> >> see
> >> >> if
> >> >> > the same error arises.
> >> >> >
> >> >> > A bit more information on the Update issue (exact query sent and
> all
> >> the
> >> >> log
> >> >> > corresponding entries) would be needed to help you with your
> problem.
> >> >> >
> >> >> > Cheers
> >> >> > Angel
> >> >> >
> >> >> >
> >> >> > On 01.10.2014 09:19, Sujatha Arun wrote:
> >> >> >>
> >> >> >> I am having the  following issue on delete and update in solr
> 4.7.0
> >> >> >>
> >> >> >>
> >> >> >> *Delete Issue*
> >> >> >>
> >> >> >> I am using the following Curl command to delete a document from
> index
> >> >> >>
> >> >> >> curl http://localhost:8080/solr/bf/update?commit=true -H
> >> "Content-Type:
> >> >> >> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
> >> >> >>
> >> >> >> <?xml version="1.0" encoding="UTF-8"?>
> >> >> >> <response>
> >> >> >> <lst name="responseHeader"><int name="status">0</int><int
> >> >> >> name="QTime">7</int></lst>
> >> >> >> </response>
> >> >> >>
> >> >> >> This is what I see in logs
> >> >> >>
> >> >> >>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  –
> [bf]
> >> >> >> webapp=/solr path=/update params={commit=true} {delete=["1.0"
> >> >> >> (-1480743948591824896)],commit=} 0 8
> >> >> >>
> >> >> >> But When  I query I am still seeing the document
> >> >> >>
> >> >> >> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr
> path=/select
> >> >> >> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1
> >> >> status=0
> >> >> >> QTime=111
> >> >> >>
> >> >> >>
> >> >> >> =============================================================
> >> >> >>
> >> >> >> *Update Issue*
> >> >> >>
> >> >> >> When I update a document for the first time it works fine ,but
> when I
> >> >> >> update the same document again ,i  see this message in the logs
> and
> >> >> >> document is not updated
> >> >> >>
> >> >> >>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted
> >> changes.
> >> >> >> Skipping IW.commit.
> >> >> >>
> >> >> >> Regards
> >> >> >>
> >> >> >
> >> >>
> >>
>

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Erick Erickson <er...@gmail.com>.
I'm clueless about the MongoDB connector. I suspect
that's where the issue is unless you can reproduce
this with a solr-only case.

As you can tell, I don't recall seeing this problem come by
the boards.

Best,
Erick

On Wed, Oct 1, 2014 at 11:53 AM, Sujatha Arun <su...@gmail.com> wrote:
> Erick,
>
>  Actually I am synching data between solr and  Mongodb using
> mongo-connector.The details below. I have submitterd an issue in
> Mongo-conenctor forum,just trying at the solr forum too  just in  case
> anybody has encountered the same :) or why does the log state No
> uncommitted changes. Skipping IW.commit
>
>
> *Solr 4.7.0 Mongo connector 1.3.dev0 *
>
>
> When I update a document for the first time with query
>
>
> db.products.update({BookId:1179416.0},{$set:{Status:"no sell"}}
>
>
> Entry in solr Mongo connector
> INFO - Finished 'http://search.bf.com:8080/solr/bf/update/?commit=true'
> (post) with body 'u'<commit ' in 0.004 seconds.
>
>
> Entry in solr logs
> org.apache.solr.update.UpdateHandler – end_commit_flush 47824126
> [http-bio-8080-exec-1] INFO
> org.apache.solr.update.processor.LogUpdateProcessor – [bf] webapp=/solr
> path=/update/ params={commit=true} {add=[1179416.0
> (1480746950999408640)],commit=} 0 36
>
> When I update same document again
> db.products.update({BookId:1179416.0},{$set:{Status:"sell"}}
>
> Mongo Db Logs
> NFO - Finished 'http://search.bf.com:8080/solr/bf/update/?commit=true'
> (post) with body 'u'<commit ' in 0.004 seconds
> Solr Logs
> org.apache.solr.update.UpdateHandler – No uncommitted changes. Skipping
> IW.commit. 47904520 [http-bio-8080-exec-8] INFO
> org.apache.solr.search.SolrIndexSearcher – Opening Searcher@7f771c0[bf]
> main 47904520 [http-bio-8080-exec-8] INFO
> org.apache.solr.update.UpdateHandler – end_commit_flush 47904521
> [searcherExecutor-6-thread-1] INFO org.apache.solr.core.SolrCore – [bf]
> Registered new searcher Searcher@7f771c0[bf]
> main{StandardDirectoryReader(segments_2zz:8617:nrt
> _s1(4.7):C450500/3:delGen=3 _wj(4.7):C63500 _1kf(4.7):C396334/1:delGen=1
> _26o(4.7):C360500 _2pl(4.7):C248000 _2in(4.7):C59000 _2ub(4.7):C77000
> _2zv(4.7):C63500 _36a(4.7):C77000 _32x(4.7):C27500 _34v(4.7):C27500
> _38s(4.7):C27500 _3ag(4.7):C41000 _3ba(4.7):C6860 _3b0(4.7):C5000
> _3bb(4.7):C1 _3bc(4.7):C1 _3bg(4.7):C1 _3bh(4.7):C1 _3bi(4.7):C1)} 47904521
> [http-bio-8080-exec-8] INFO
> org.apache.solr.update.processor.LogUpdateProcessor – [bf] webapp=/solr
> path=/update/ params={commit=true} {commit=,commit=} 0 3
> Each time Mongoconnector sends a commit, but the second time ,nothing
> happens.this seems to work only once.
>
> On Wed, Oct 1, 2014 at 9:47 PM, Erick Erickson <er...@gmail.com>
> wrote:
>
>> At this point details matter a lot.
>>
>> What exactly are you doing when you update?
>>
>> What happens if you issue an explicit update command? i.e.
>> http://blahlbah/solr/collection/update?commit=true?
>>
>> Are you sure you aren't seeing, say, browser caching?
>>
>> Best,
>> Erick
>>
>> On Wed, Oct 1, 2014 at 9:04 AM, Sujatha Arun <su...@gmail.com> wrote:
>> > Thanks, BookId is the unique key, the issue is resolved with respect to
>> > delete .Its the update that causing the issue
>> >
>> > On Wed, Oct 1, 2014 at 8:51 PM, Erick Erickson <er...@gmail.com>
>> > wrote:
>> >
>> >> I'd add only one thing to Angel's comments:
>> >> you're deleting by "id", but querying by "BookId". This
>> >> _should_ work (on a quick glance at the code) iff
>> >> your <uniqueKey> is "BookId"...
>> >>
>> >> I took a quick glance at the code and "id" should delete by
>> >> <uniqueKey>, so is your "BookId" the <uniqueKey> in
>> >> your schema?
>> >>
>> >>
>> >>
>> >> On Wed, Oct 1, 2014 at 12:37 AM, Angel Tchorbadjiiski
>> >> <an...@antibodies-online.com> wrote:
>> >> > Hello Sujatha,
>> >> >
>> >> > have you tried to leave the quotes out? :-)
>> >> >
>> >> > Alternatively try using '<delete><query>id:1.0</query></delete>' to
>> see
>> >> if
>> >> > the same error arises.
>> >> >
>> >> > A bit more information on the Update issue (exact query sent and all
>> the
>> >> log
>> >> > corresponding entries) would be needed to help you with your problem.
>> >> >
>> >> > Cheers
>> >> > Angel
>> >> >
>> >> >
>> >> > On 01.10.2014 09:19, Sujatha Arun wrote:
>> >> >>
>> >> >> I am having the  following issue on delete and update in solr 4.7.0
>> >> >>
>> >> >>
>> >> >> *Delete Issue*
>> >> >>
>> >> >> I am using the following Curl command to delete a document from index
>> >> >>
>> >> >> curl http://localhost:8080/solr/bf/update?commit=true -H
>> "Content-Type:
>> >> >> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
>> >> >>
>> >> >> <?xml version="1.0" encoding="UTF-8"?>
>> >> >> <response>
>> >> >> <lst name="responseHeader"><int name="status">0</int><int
>> >> >> name="QTime">7</int></lst>
>> >> >> </response>
>> >> >>
>> >> >> This is what I see in logs
>> >> >>
>> >> >>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
>> >> >> webapp=/solr path=/update params={commit=true} {delete=["1.0"
>> >> >> (-1480743948591824896)],commit=} 0 8
>> >> >>
>> >> >> But When  I query I am still seeing the document
>> >> >>
>> >> >> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
>> >> >> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1
>> >> status=0
>> >> >> QTime=111
>> >> >>
>> >> >>
>> >> >> =============================================================
>> >> >>
>> >> >> *Update Issue*
>> >> >>
>> >> >> When I update a document for the first time it works fine ,but when I
>> >> >> update the same document again ,i  see this message in the logs and
>> >> >> document is not updated
>> >> >>
>> >> >>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted
>> changes.
>> >> >> Skipping IW.commit.
>> >> >>
>> >> >> Regards
>> >> >>
>> >> >
>> >>
>>

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Sujatha Arun <su...@gmail.com>.
Erick,

 Actually I am synching data between solr and  Mongodb using
mongo-connector.The details below. I have submitterd an issue in
Mongo-conenctor forum,just trying at the solr forum too  just in  case
anybody has encountered the same :) or why does the log state No
uncommitted changes. Skipping IW.commit


*Solr 4.7.0 Mongo connector 1.3.dev0 *


When I update a document for the first time with query


db.products.update({BookId:1179416.0},{$set:{Status:"no sell"}}


Entry in solr Mongo connector
INFO - Finished 'http://search.bf.com:8080/solr/bf/update/?commit=true'
(post) with body 'u'<commit ' in 0.004 seconds.


Entry in solr logs
org.apache.solr.update.UpdateHandler – end_commit_flush 47824126
[http-bio-8080-exec-1] INFO
org.apache.solr.update.processor.LogUpdateProcessor – [bf] webapp=/solr
path=/update/ params={commit=true} {add=[1179416.0
(1480746950999408640)],commit=} 0 36

When I update same document again
db.products.update({BookId:1179416.0},{$set:{Status:"sell"}}

Mongo Db Logs
NFO - Finished 'http://search.bf.com:8080/solr/bf/update/?commit=true'
(post) with body 'u'<commit ' in 0.004 seconds
Solr Logs
org.apache.solr.update.UpdateHandler – No uncommitted changes. Skipping
IW.commit. 47904520 [http-bio-8080-exec-8] INFO
org.apache.solr.search.SolrIndexSearcher – Opening Searcher@7f771c0[bf]
main 47904520 [http-bio-8080-exec-8] INFO
org.apache.solr.update.UpdateHandler – end_commit_flush 47904521
[searcherExecutor-6-thread-1] INFO org.apache.solr.core.SolrCore – [bf]
Registered new searcher Searcher@7f771c0[bf]
main{StandardDirectoryReader(segments_2zz:8617:nrt
_s1(4.7):C450500/3:delGen=3 _wj(4.7):C63500 _1kf(4.7):C396334/1:delGen=1
_26o(4.7):C360500 _2pl(4.7):C248000 _2in(4.7):C59000 _2ub(4.7):C77000
_2zv(4.7):C63500 _36a(4.7):C77000 _32x(4.7):C27500 _34v(4.7):C27500
_38s(4.7):C27500 _3ag(4.7):C41000 _3ba(4.7):C6860 _3b0(4.7):C5000
_3bb(4.7):C1 _3bc(4.7):C1 _3bg(4.7):C1 _3bh(4.7):C1 _3bi(4.7):C1)} 47904521
[http-bio-8080-exec-8] INFO
org.apache.solr.update.processor.LogUpdateProcessor – [bf] webapp=/solr
path=/update/ params={commit=true} {commit=,commit=} 0 3
Each time Mongoconnector sends a commit, but the second time ,nothing
happens.this seems to work only once.

On Wed, Oct 1, 2014 at 9:47 PM, Erick Erickson <er...@gmail.com>
wrote:

> At this point details matter a lot.
>
> What exactly are you doing when you update?
>
> What happens if you issue an explicit update command? i.e.
> http://blahlbah/solr/collection/update?commit=true?
>
> Are you sure you aren't seeing, say, browser caching?
>
> Best,
> Erick
>
> On Wed, Oct 1, 2014 at 9:04 AM, Sujatha Arun <su...@gmail.com> wrote:
> > Thanks, BookId is the unique key, the issue is resolved with respect to
> > delete .Its the update that causing the issue
> >
> > On Wed, Oct 1, 2014 at 8:51 PM, Erick Erickson <er...@gmail.com>
> > wrote:
> >
> >> I'd add only one thing to Angel's comments:
> >> you're deleting by "id", but querying by "BookId". This
> >> _should_ work (on a quick glance at the code) iff
> >> your <uniqueKey> is "BookId"...
> >>
> >> I took a quick glance at the code and "id" should delete by
> >> <uniqueKey>, so is your "BookId" the <uniqueKey> in
> >> your schema?
> >>
> >>
> >>
> >> On Wed, Oct 1, 2014 at 12:37 AM, Angel Tchorbadjiiski
> >> <an...@antibodies-online.com> wrote:
> >> > Hello Sujatha,
> >> >
> >> > have you tried to leave the quotes out? :-)
> >> >
> >> > Alternatively try using '<delete><query>id:1.0</query></delete>' to
> see
> >> if
> >> > the same error arises.
> >> >
> >> > A bit more information on the Update issue (exact query sent and all
> the
> >> log
> >> > corresponding entries) would be needed to help you with your problem.
> >> >
> >> > Cheers
> >> > Angel
> >> >
> >> >
> >> > On 01.10.2014 09:19, Sujatha Arun wrote:
> >> >>
> >> >> I am having the  following issue on delete and update in solr 4.7.0
> >> >>
> >> >>
> >> >> *Delete Issue*
> >> >>
> >> >> I am using the following Curl command to delete a document from index
> >> >>
> >> >> curl http://localhost:8080/solr/bf/update?commit=true -H
> "Content-Type:
> >> >> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
> >> >>
> >> >> <?xml version="1.0" encoding="UTF-8"?>
> >> >> <response>
> >> >> <lst name="responseHeader"><int name="status">0</int><int
> >> >> name="QTime">7</int></lst>
> >> >> </response>
> >> >>
> >> >> This is what I see in logs
> >> >>
> >> >>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
> >> >> webapp=/solr path=/update params={commit=true} {delete=["1.0"
> >> >> (-1480743948591824896)],commit=} 0 8
> >> >>
> >> >> But When  I query I am still seeing the document
> >> >>
> >> >> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
> >> >> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1
> >> status=0
> >> >> QTime=111
> >> >>
> >> >>
> >> >> =============================================================
> >> >>
> >> >> *Update Issue*
> >> >>
> >> >> When I update a document for the first time it works fine ,but when I
> >> >> update the same document again ,i  see this message in the logs and
> >> >> document is not updated
> >> >>
> >> >>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted
> changes.
> >> >> Skipping IW.commit.
> >> >>
> >> >> Regards
> >> >>
> >> >
> >>
>

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Erick Erickson <er...@gmail.com>.
At this point details matter a lot.

What exactly are you doing when you update?

What happens if you issue an explicit update command? i.e.
http://blahlbah/solr/collection/update?commit=true?

Are you sure you aren't seeing, say, browser caching?

Best,
Erick

On Wed, Oct 1, 2014 at 9:04 AM, Sujatha Arun <su...@gmail.com> wrote:
> Thanks, BookId is the unique key, the issue is resolved with respect to
> delete .Its the update that causing the issue
>
> On Wed, Oct 1, 2014 at 8:51 PM, Erick Erickson <er...@gmail.com>
> wrote:
>
>> I'd add only one thing to Angel's comments:
>> you're deleting by "id", but querying by "BookId". This
>> _should_ work (on a quick glance at the code) iff
>> your <uniqueKey> is "BookId"...
>>
>> I took a quick glance at the code and "id" should delete by
>> <uniqueKey>, so is your "BookId" the <uniqueKey> in
>> your schema?
>>
>>
>>
>> On Wed, Oct 1, 2014 at 12:37 AM, Angel Tchorbadjiiski
>> <an...@antibodies-online.com> wrote:
>> > Hello Sujatha,
>> >
>> > have you tried to leave the quotes out? :-)
>> >
>> > Alternatively try using '<delete><query>id:1.0</query></delete>' to see
>> if
>> > the same error arises.
>> >
>> > A bit more information on the Update issue (exact query sent and all the
>> log
>> > corresponding entries) would be needed to help you with your problem.
>> >
>> > Cheers
>> > Angel
>> >
>> >
>> > On 01.10.2014 09:19, Sujatha Arun wrote:
>> >>
>> >> I am having the  following issue on delete and update in solr 4.7.0
>> >>
>> >>
>> >> *Delete Issue*
>> >>
>> >> I am using the following Curl command to delete a document from index
>> >>
>> >> curl http://localhost:8080/solr/bf/update?commit=true -H "Content-Type:
>> >> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
>> >>
>> >> <?xml version="1.0" encoding="UTF-8"?>
>> >> <response>
>> >> <lst name="responseHeader"><int name="status">0</int><int
>> >> name="QTime">7</int></lst>
>> >> </response>
>> >>
>> >> This is what I see in logs
>> >>
>> >>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
>> >> webapp=/solr path=/update params={commit=true} {delete=["1.0"
>> >> (-1480743948591824896)],commit=} 0 8
>> >>
>> >> But When  I query I am still seeing the document
>> >>
>> >> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
>> >> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1
>> status=0
>> >> QTime=111
>> >>
>> >>
>> >> =============================================================
>> >>
>> >> *Update Issue*
>> >>
>> >> When I update a document for the first time it works fine ,but when I
>> >> update the same document again ,i  see this message in the logs and
>> >> document is not updated
>> >>
>> >>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted changes.
>> >> Skipping IW.commit.
>> >>
>> >> Regards
>> >>
>> >
>>

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Sujatha Arun <su...@gmail.com>.
Thanks, BookId is the unique key, the issue is resolved with respect to
delete .Its the update that causing the issue

On Wed, Oct 1, 2014 at 8:51 PM, Erick Erickson <er...@gmail.com>
wrote:

> I'd add only one thing to Angel's comments:
> you're deleting by "id", but querying by "BookId". This
> _should_ work (on a quick glance at the code) iff
> your <uniqueKey> is "BookId"...
>
> I took a quick glance at the code and "id" should delete by
> <uniqueKey>, so is your "BookId" the <uniqueKey> in
> your schema?
>
>
>
> On Wed, Oct 1, 2014 at 12:37 AM, Angel Tchorbadjiiski
> <an...@antibodies-online.com> wrote:
> > Hello Sujatha,
> >
> > have you tried to leave the quotes out? :-)
> >
> > Alternatively try using '<delete><query>id:1.0</query></delete>' to see
> if
> > the same error arises.
> >
> > A bit more information on the Update issue (exact query sent and all the
> log
> > corresponding entries) would be needed to help you with your problem.
> >
> > Cheers
> > Angel
> >
> >
> > On 01.10.2014 09:19, Sujatha Arun wrote:
> >>
> >> I am having the  following issue on delete and update in solr 4.7.0
> >>
> >>
> >> *Delete Issue*
> >>
> >> I am using the following Curl command to delete a document from index
> >>
> >> curl http://localhost:8080/solr/bf/update?commit=true -H "Content-Type:
> >> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
> >>
> >> <?xml version="1.0" encoding="UTF-8"?>
> >> <response>
> >> <lst name="responseHeader"><int name="status">0</int><int
> >> name="QTime">7</int></lst>
> >> </response>
> >>
> >> This is what I see in logs
> >>
> >>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
> >> webapp=/solr path=/update params={commit=true} {delete=["1.0"
> >> (-1480743948591824896)],commit=} 0 8
> >>
> >> But When  I query I am still seeing the document
> >>
> >> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
> >> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1
> status=0
> >> QTime=111
> >>
> >>
> >> =============================================================
> >>
> >> *Update Issue*
> >>
> >> When I update a document for the first time it works fine ,but when I
> >> update the same document again ,i  see this message in the logs and
> >> document is not updated
> >>
> >>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted changes.
> >> Skipping IW.commit.
> >>
> >> Regards
> >>
> >
>

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Erick Erickson <er...@gmail.com>.
I'd add only one thing to Angel's comments:
you're deleting by "id", but querying by "BookId". This
_should_ work (on a quick glance at the code) iff
your <uniqueKey> is "BookId"...

I took a quick glance at the code and "id" should delete by
<uniqueKey>, so is your "BookId" the <uniqueKey> in
your schema?



On Wed, Oct 1, 2014 at 12:37 AM, Angel Tchorbadjiiski
<an...@antibodies-online.com> wrote:
> Hello Sujatha,
>
> have you tried to leave the quotes out? :-)
>
> Alternatively try using '<delete><query>id:1.0</query></delete>' to see if
> the same error arises.
>
> A bit more information on the Update issue (exact query sent and all the log
> corresponding entries) would be needed to help you with your problem.
>
> Cheers
> Angel
>
>
> On 01.10.2014 09:19, Sujatha Arun wrote:
>>
>> I am having the  following issue on delete and update in solr 4.7.0
>>
>>
>> *Delete Issue*
>>
>> I am using the following Curl command to delete a document from index
>>
>> curl http://localhost:8080/solr/bf/update?commit=true -H "Content-Type:
>> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <response>
>> <lst name="responseHeader"><int name="status">0</int><int
>> name="QTime">7</int></lst>
>> </response>
>>
>> This is what I see in logs
>>
>>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
>> webapp=/solr path=/update params={commit=true} {delete=["1.0"
>> (-1480743948591824896)],commit=} 0 8
>>
>> But When  I query I am still seeing the document
>>
>> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
>> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1 status=0
>> QTime=111
>>
>>
>> =============================================================
>>
>> *Update Issue*
>>
>> When I update a document for the first time it works fine ,but when I
>> update the same document again ,i  see this message in the logs and
>> document is not updated
>>
>>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted changes.
>> Skipping IW.commit.
>>
>> Regards
>>
>

Re: Solr 4.7 .0 Issues with Update and Delete

Posted by Angel Tchorbadjiiski <an...@antibodies-online.com>.
Hello Sujatha,

have you tried to leave the quotes out? :-)

Alternatively try using '<delete><query>id:1.0</query></delete>' to see 
if the same error arises.

A bit more information on the Update issue (exact query sent and all the 
log corresponding entries) would be needed to help you with your problem.

Cheers
Angel

On 01.10.2014 09:19, Sujatha Arun wrote:
> I am having the  following issue on delete and update in solr 4.7.0
>
>
> *Delete Issue*
>
> I am using the following Curl command to delete a document from index
>
> curl http://localhost:8080/solr/bf/update?commit=true -H "Content-Type:
> text/xml" --data-binary '<delete><id>"1.0"</id></delete>'
>
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int
> name="QTime">7</int></lst>
> </response>
>
> This is what I see in logs
>
>   INFO  org.apache.solr.update.processor.LogUpdateProcessor  – [bf]
> webapp=/solr path=/update params={commit=true} {delete=["1.0"
> (-1480743948591824896)],commit=} 0 8
>
> But When  I query I am still seeing the document
>
> INFO  org.apache.solr.core.SolrCore  – [bf] webapp=/solr path=/select
> params={indent=true&q=BookId:1.0&_=1412147431359&wt=json} hits=1 status=0
> QTime=111
>
>
> =============================================================
>
> *Update Issue*
>
> When I update a document for the first time it works fine ,but when I
> update the same document again ,i  see this message in the logs and
> document is not updated
>
>   INFO  org.apache.solr.update.UpdateHandler  – No uncommitted changes.
> Skipping IW.commit.
>
> Regards
>