[Mulgara-dev] TransactionalAnswer not closed

David Moll DMoll at viewpointusa.com
Thu Feb 1 21:20:37 UTC 2007


Gentlemen,

 

I am bringing more questions and problems to you!

 

I've been getting the following error several times while doing testing
to try and find more date/time errors.

 

I set up queries to get information about the first 100 "tests" in
Mulgara (using limit 100 on the query), checking the information, and
then deleting those triples.  I can't grab all the information because
the resulting XML is too large to be passed back via SOAP and it times
out.  Intermittently the Mulgara console will toss out:

 

          ;

2007-02-01 16:10:24,700 WARN  TransactionalAnswer - TransactionalAnswer
not clos

ed

2007-02-01 16:10:24,700 WARN  TransactionalAnswer - TransactionalAnswer
not clos

ed

2007-02-01 16:10:24,716 WARN  TransactionalAnswer - TransactionalAnswer
not clos

ed

2007-02-01 16:10:24,716 WARN  TransactionalAnswer - TransactionalAnswer
not clos

ed

2007-02-01 16:10:24,716 WARN  TransactionalAnswer - TransactionalAnswer
not clos

ed

2007-02-01 16:10:24,716 WARN  TransactionalAnswer - TransactionalAnswer
not clos

ed

 

but this is not repeatable or predictable.  Any thoughts as to what is
happening?

 

The query I am running to retrieve 100 tests to verify is:

 

        select $test subquery(

            select $p $o

              from <rmi://192.168.10.205/server1#datetest> where $test
$p $o

            )

          from <rmi://192.168.10.205/server1#datetest> 

          where $test <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> 

            <http://www.viewpointusa.com/vss/fm/elements/1.0/localFile> 

            limit 100;

 

And to delete the triples:

 

      delete (select $test $p $o 

        from <rmi://192.168.10.205/server1#datetest>

        where $test $p $o and

          $test <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> 

            <http://www.viewpointusa.com/vss/fm/elements/1.0/localFile> 

         limit 600) from <rmi://192.168.10.205/server1#datetest>;

 

Limit 600 on the select for the delete because each test is the subject
of 6 triples, and doing a delete with a subquery caused issues.


~Dave

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mulgara.org/pipermail/mulgara-dev/attachments/20070201/a53ff2b5/attachment.htm>


More information about the Mulgara-dev mailing list