[ refdb-Bugs-2795347 ] Too many extended notes are deleted

Bugs item #2795347, was opened at 2009-05-22 14:04
Message generated for change (Comment added) made by mhoenicka
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=2795347&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: refdbd
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Torsten Bronger (bronger)
Assigned to: Markus Hoenicka (mhoenicka)
Summary: Too many extended notes are deleted

Initial Comment:
refdbd received the following command from me:

addlink -d biblio -E utf-8 -r -u drefdbuser1 -w 055106045081047114063119089044 ":NCK:=django-refdb-relevance-3 :CK:=Bld2006"

The log further says:

SELECT note_id FROM t_note WHERE note_key='django-refdb-relevance-3'
SELECT refdb_id FROM t_refdb WHERE refdb_citekey='Bld2006'
SELECT xnote_id FROM t_xnote WHERE xnote_type='REFERENCE' AND xref_id=1
DELETE FROM t_xnote WHERE xnote_id=78
DELETE FROM t_xnote WHERE xnote_id=79
UPDATE t_meta SET meta_modify_date='2009-05-22 11:55:59' WHERE meta_type='risx'
command processing done, finish dialog now

I interpret this output so that *two* links to extended notes were deleted.  However, the command clearly says that only one should be deleted.  In particular, refdbd deleted the links to both "django-refdb-relevance-3" and (erroneously) "django-refdb-relevance-2".

----------------------------------------------------------------------

>Comment By: Markus Hoenicka (mhoenicka)
Date: 2009-05-22 23:03

Message:
The current code indeed removes all t_xnote entries related to a particular
item instead of just the requested link. I'm working on a fix.

----------------------------------------------------------------------

Comment By: Torsten Bronger (bronger)
Date: 2009-05-22 14:23

Message:
I tried the official client and experienced the same problem:

refdbc: getnote :ID:=1
999:0 retrieved:0 failed
refdbc: addlink :NCK:=django-refdb-relevance-3 :CK:=Bld2006
421:django-refdb-relevance-3 -> REFERENCE:Bld2006
999:1 added:0 skipped:0 failed
refdbc: addlink :NCK:=django-refdb-relevance-2 :CK:=Bld2006
421:django-refdb-relevance-2 -> REFERENCE:Bld2006
999:1 added:0 skipped:0 failed
refdbc: getnote :ID:=1
Note ID:213 (Fri May 22 2009)
Key: django-refdb-relevance-2


Note ID:214 (Fri May 22 2009)
Key: django-refdb-relevance-3


999:2 retrieved:0 failed
refdbc: deletelink :NCK:=django-refdb-relevance-2 :CK:=Bld2006
419:django-refdb-relevance-2 -> REFERENCE:Bld2006
999:1 removed:0 skipped:0 failed
refdbc: getnote :ID:=1
999:0 retrieved:0 failed
refdbc: 


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=2795347&group_id=26091

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com