[ monetdb-Bugs-2009556 ] XQ: "Zombie" document in collection

[SourceForge.net]

Bugs item #2009556, was opened at 2008-07-03 11:41
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2009556&group_id=56967

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: PF/runtime
Group: Pathfinder "stable"
Status: Open
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Luc Touraille (touraillel)
Assigned to: Stefan Manegold (stmane)
Summary: XQ: "Zombie" document in collection

Initial Comment:
[Jun 2008 release]

A deleted document from a collection where there is more than 1 document is still visible using the collection("mycoll") function.

On Feb 2008 release, the pf:collection function worked correctly, but not the fn:collection function, that produced the same bug.

Stefan reproduced this bug, giving the following trace :

========
$ cat /tmp/MyDoc1.xml
--------
<a/>
========
$ cat /tmp/MyDoc2.xml
--------
<b/>
========
========
$ mclient -lx -s'pf:add-doc("/tmp/MyDoc1.xml","MyDoc1","MyCol")'
--------
========
$ mclient -lx -s'pf:collections()'
--------
<collection updatable="false" size="99 KiB" numDocs="1">MyCol</collection>
========
$ mclient -lx -s'pf:collection("MyCol")'
--------
<a/>
========
$ mclient -lx -g -s'fn:collection("MyCol")'
--------
<?xml version="1.0" encoding="utf-8"?>
<a/>

========
$ mclient -lx -s'pf:documents()'
--------
<document updatable="false" url="/tmp/MyDoc1.xml" collection="MyCol">MyDoc1</document>
========
$ mclient -lx -s'pf:documents("MyCol")'
--------
<document updatable="false" url="/tmp/MyDoc1.xml" collection="MyCol">MyDoc1</document>
========
========
$ mclient -lx -s'pf:del-doc("MyDoc1")'
--------
========
$ mclient -lx -s'pf:collections()'
--------

========
$ mclient -lx -s'pf:collection("MyCol")'
--------

========
$ mclient -lx -g -s'fn:collection("MyCol")'
--------

========
$ mclient -lx -s'pf:documents()'
--------

========
$ mclient -lx -s'pf:documents("MyCol")'
--------

========
========
$ mclient -lx -s'pf:add-doc("/tmp/MyDoc1.xml","MyDoc1","MyCol")'
--------
========
$ mclient -lx -s'pf:add-doc("/tmp/MyDoc2.xml","MyDoc2","MyCol")'
--------
========
$ mclient -lx -s'pf:collections()'
--------
<collection updatable="false" size="99 KiB" numDocs="2">MyCol</collection>
========
$ mclient -lx -s'pf:collection("MyCol")'
--------
<a/><b/>
========
$ mclient -lx -g -s'fn:collection("MyCol")'
--------
<?xml version="1.0" encoding="utf-8"?>
<a/>
,
<?xml version="1.0" encoding="utf-8"?>
<b/>

========
$ mclient -lx -s'pf:documents()'
--------
<document updatable="false" url="/tmp/MyDoc1.xml" collection="MyCol">MyDoc1</document>,
<document updatable="false" url="/tmp/MyDoc2.xml" collection="MyCol">MyDoc2</document>
========
$ mclient -lx -s'pf:documents("MyCol")'
--------
<document updatable="false" url="/tmp/MyDoc2.xml" collection="MyCol">MyDoc2</document>,
<document updatable="false" url="/tmp/MyDoc1.xml" collection="MyCol">MyDoc1</document>
========
========
$ mclient -lx -s'pf:del-doc("MyDoc2")'
--------
========
$ mclient -lx -s'pf:collections()'
--------
<collection updatable="false" size="99 KiB" numDocs="1">MyCol</collection>
========
$ mclient -lx -s'pf:collection("MyCol")'
--------
<a/><b/>
========
$ mclient -lx -g -s'fn:collection("MyCol")'
--------
<?xml version="1.0" encoding="utf-8"?>
<a/>
,
<?xml version="1.0" encoding="utf-8"?>
<b/>

========
$ mclient -lx -s'pf:documents()'
--------
<document updatable="false" url="/tmp/MyDoc1.xml" collection="MyCol">MyDoc1</document>
========
$ mclient -lx -s'pf:documents("MyCol")'
--------
<document updatable="false" url="/tmp/MyDoc1.xml" collection="MyCol">MyDoc1</document>
========
========
$ mclient -lx -s'pf:del-doc("MyDoc1")'
--------
========
$ mclient -lx -s'pf:collections()'
--------

========
$ mclient -lx -s'pf:collection("MyCol")'
--------

========
$ mclient -lx -g -s'fn:collection("MyCol")'
--------

========
$ mclient -lx -s'pf:documents()'
--------

========
$ mclient -lx -s'pf:documents("MyCol")'
--------

========

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

>Comment By: Stefan Manegold (stmane)
Date: 2008-11-18 11:48

Message:
The URLs are indeed to be ignored --- not trivial with Mtest.py right now,
though, I'll check and think about it.

The changes sizes in KB look very suspicious to me --- I would strongly
object to ignoring or approving them unless we know for sure why they
differ, or better, which size they represent --- I honestly don't know
either, yet ...

Moreover, the current output shows an extra

<aap>
Hello World
</aap>

compared to the stable/approved output --- also that needs to be checked
before considering this bug fixed ...


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

Comment By: Lefteris Sidirourgos (lsidir)
Date: 2008-11-18 11:31

Message:
Hi,

the test Zombie_document.SF-2009556 seems to be failing not because the
bug is still there, but because of some dynamic(?) information in the
documents, such as size in kb and URL. I am not aware if and how can we
make testweb to ignore these differences. Assigning to Stefan:) I
considering this bug fixed though. We just have to manage the tests a
little, the same holds for the rest, of the related to this bug, reports.

lefteris

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

Comment By: Stefan Manegold (stmane)
Date: 2008-07-03 22:34

Message:
Logged In: YES
user_id=572415
Originator: NO

Might be related to
[ 1976341 ] XQ: leftovers after deleting document
http://sourceforge.net/tracker/index.php?func=detail&aid=1976341&group_id=56967&atid=482468


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

Comment By: Stefan Manegold (stmane)
Date: 2008-07-03 22:33

Message:
Logged In: YES
user_id=572415
Originator: NO

The problem seems to be "even worse":

*  add 2 documents to a single collection "MyCol"
*  delete one of them, again
=> + pf:colections(), pf:documents(), & pf:documents("MyCol") correctly
show only one remaining document
   - pf:collection("MyCol") & fn:collection("MyCol") wrongly show both
documents

*  stop Mserver
*  restart Mserver
=> - all above functions wrongly show *both* documents, again!

This happens both with the (now) default Algebra back-end and with the
(old) "milprint_summer" back-end.


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

Comment By: Stefan Manegold (stmane)
Date: 2008-07-03 14:48

Message:
Logged In: YES
user_id=572415
Originator: NO

Added test in
pathfinder/tests/BugTracker/Tests/Zombie_document.SF-2009556.*


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

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2009556&group_id=56967

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
Monetdb-bugs@...
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs