Bugs item #2810319, was opened at 2009-06-22 14:54
Message generated for change (Comment added) made by nobody
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2810319&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 (current)
Status: Open
Resolution: Accepted
Priority: 5
Private: No
Submitted By: mwaschkowski (mwaschkowski)
Assigned to: Ivan Shcheklein (shcheklein)
Summary: FATAL Data Inconsistency
Initial Comment:
Keep getting
FATAL 22/06/2009 09:56:04 (TRN test pid=7664 sid=49 trid=49)
[micro.cpp:thirdElementAndTextInsertProcedure:90]: Data Inconsistency
errors.
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2009-06-24 15:04
Message:
My own API, using the standard DAO pattern.
The code is simply saving the same document, twice. The first time that
the document saves, a UUID is assigned, and the document is loaded into the
system via:
statement.loadDocument(xml, persistable.getUuid(), collectionName);
The second time the document is saved, it has a UUID assigned and the
update replace statement is used instead.
----------------------------------------------------------------------
Comment By: Ivan Shcheklein (shcheklein)
Date: 2009-06-24 14:57
Message:
I don't understand, actually. What API do you use? XML:DB API?
If code is so simple, what the thing like:
UPDATE replace $doc in document("589d65ff-081b-47ac-8748-4ccd6678d1cb",
"docs")/root with <com.circumail.server.sedna.DocumentImpl>
<uuid>589d65ff-081b-47ac-8748-4ccd6678d1cb</uuid>
<xml><foo><bar>1245354990296</bar></foo></xml>
</com.circumail.server.sedna.DocumentImpl>
does mean?
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2009-06-24 14:46
Message:
There was no data in the system to being with, the code is dead simple:
Persistable doc = new Document("<foo><bar>" +
System.currentTimeMillis()
+ "</bar></foo>");
documentDao.save(doc, docCollectionName);
documentDao.save(doc, docCollectionName);
SessionPerThreadSedna.getConnection().commit();
Unfortunately I haven't been able to make a reproduceable test case for
any of the faults yet, although I did try.
----------------------------------------------------------------------
Comment By: Ivan Shcheklein (shcheklein)
Date: 2009-06-22 15:31
Message:
For the first time this fault was caused by the following sequence of
queries:
CREATE COLLECTION 'docs'
LOAD STDIN "589d65ff-081b-47ac-8748-4ccd6678d1cb" "docs"
UPDATE replace $doc in document("589d65ff-081b-47ac-8748-4ccd6678d1cb",
"docs")/root with <com.circumail.server.sedna.DocumentImpl>
<uuid>589d65ff-081b-47ac-8748-4ccd6678d1cb</uuid>
<xml><foo><bar>1245354990296</bar></foo></xml>
</com.circumail.server.sedna.DocumentImpl>
document('589d65ff-081b-47ac-8748-4ccd6678d1cb', 'docs')
Can you give me a data (in private, if you can't share) on which this
sequence of queries was executed?
Can you determine a stable way to reproduce this fault on the clean data
base?
----------------------------------------------------------------------
Comment By: mwaschkowski (mwaschkowski)
Date: 2009-06-22 15:00
Message:
Windows XP Home, SP3
----------------------------------------------------------------------
Comment By: mwaschkowski (mwaschkowski)
Date: 2009-06-22 14:57
Message:
Sedna version: sedna-3.1.175
was running a simple xquery: collection("Contacts")/node()
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=2810319&group_id=129076
------------------------------------------------------------------------------
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
