Bugs item #3512872, was opened at 2012-03-29 09:26 Message generated for change (Settings changed) made by zazz-coder You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3512872&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: None Status: Open Resolution: None >Priority: 8 Private: No Submitted By: Michael Woytowitz (zazz-coder) Assigned to: Nobody/Anonymous (nobody) >Summary: Readonly query is not querying current state Initial Comment: I initially discovered this issue when using the Java API (jar). But the same issue exists when run in the command line client (se_term) Given a document in the database. If execute and update on that doc (in \upd mode) and view the doc the current version is retrieved. but if switch to readonly mode (\ro) and query the same document the result is the version of the doc as it existed at DB startup. When in readonly mode the query should still retrieve the current version of the document. I expect that \ro mode to only 'not lock for update' the document (or doc in a collection) and thus allow other connections to update the document while a read is performed. I encountered this issue because I am attempting to reduce multi-user dead locking - I am using the Java API and Sedna jar. I desire to issue queries (of the current state of the DB) in read only mode and then switch to update mode when performing updates while using the same active connection. in the case of se_term, It seems the readonly is looking at the data as it existed when the DB if first started (not the current state). The Java API is exhibiting this same behavior. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3512872&group_id=129076 ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Sedna-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
