Bugs item #3206819, was opened at 2011-03-11 22:48
Message generated for change (Comment added) made by shcheklein
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3206819&group_id=129076

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: Query Execution
Group: Sedna (development)
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Ivan Shcheklein (shcheklein)
Summary: database query/update failed (SEDNA Message: ERROR SE3007

Initial Comment:
<sedna version="3.4" build="66"/>
Linux ubuntu 2.6.35-22-generic #35-Ubuntu SMP Sat Oct 16 20:45:36 UTC 2010 
x86_64 GNU/Linux

Next steps to reproduce the bug:

 - Create collection "test".
 - Load document 1.xml

Query1:

let $e := (<a>
                                <b id="1" o="1"/>
                                <b id="2" o="2"/>
                                <b id="1" o="3"/>
                                <b id="3" o="4"/>
                                <b id="1" o="5"/>
                        </a>
)

for $c in $e/b
    return
       $c[not(@id = preceding::b/@id)]

Result:
<b id="1" o="1"/>
<b id="2" o="2"/>
<b id="3" o="4"/>


Query2:
let $e := document("1.xml","test")/a
for $c in $e/b
    return
       $c[not(@id = preceding::b/@id)]

Result:
<b id="1" o="1"/>
<b id="2" o="2"/>
<b id="3" o="4"/>


Next:
  - Load document 2.xml

Query1 - same result.
Query2 - next error:

SDBAdmin say:
2011/03/11 21:17:31 initiating XQuery
2011/03/11 21:17:32 database query/update failed (SEDNA Message: ERROR SE3007
Failed to recieve a message.)

event.log
LOG   11/03/2011 21:17:31 (TRN e pid=29047 sid=49 trid=49) 
[tr_functions.cpp:on_user_statement_begin:103]: User query:
---   let $e := document("1.xml","test")/a
---   for $c in $e/b
---       return
---          $c[not(@id = preceding::b/@id)]
FATAL 11/03/2011 21:17:31 (SM e pid=29039) 
[bm_core.cpp:calculate_offset_and_file_handler:169]: Offset is out of range

See attachments.

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

>Comment By: Ivan Shcheklein (shcheklein)
Date: 2011-03-14 14:39

Message:
Fixed. Please try the latest development build from here:
http://modis.ispras.ru/FTPContent/sedna/development/ .

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

Comment By: Ivan Shcheklein (shcheklein)
Date: 2011-03-12 02:47

Message:
Reproduced on 3.4.66 and development snapshot  (both linux and windows
versions are affected). The fix will be available in the next week's
development version and included in the next Sedna release.

To workaround this problem in 3.4.66 version try to apply the patch below
and rebuild Sedna.

========================================================
--- a/kernel/tr/executor/xqops/PPAxisFP.cpp
+++ b/kernel/tr/executor/xqops/PPAxisFP.cpp
@@ -228,7 +228,7 @@ void PPAxisFP::next_qname_and_text(tuple &t,const
char* uri,const char* name,t_i
             }
             else
             {
-                base=getPreviousDONode(cur);
+                cur = getPreviousDONode(base);
                 while (true)
                 {
                     if (cur==XNULL ||
(cfun(getSchemaNode(cur),uri,name,type) &&
nid_cmp_effective(cur,base)!=-2))
========================================================

Thank you for submitting the bug report!

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3206819&group_id=129076

------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Reply via email to