Hello Ben, Thanks for your input, I found out my issue though and I rewrote the iTQL query. It was indeed a problem with memory and I needed a solution that worked faster than I had there.
On Wed, Aug 17, 2011 at 4:22 PM, Benjamin Armintor <armin...@gmail.com> wrote: > Tomasz- > A while back, I had a similar issue with very large sets of triples. > If your heap is big enough, you could try setting the > mulgara.xa.memoryType environment variable to "javaHeap". The default > setting uses direct buffers, which aren't managed by Java's GC. > > As an aside, why are you using a subquery there? I think all objects > in Fedora will have a state. > > - Ben > > On Wed, Aug 17, 2011 at 7:26 AM, Tomasz Cielecki <tom...@ostebaronen.dk> > wrote: >> I guess I was doing something wrong, or well the tripples generated >> was quite a large number and hence I got that error and so much >> waiting time. Note to self, constrain a bit more when handling large >> data sets :) >> >> On Wed, Aug 17, 2011 at 10:01 AM, Tomasz Cielecki <tom...@ostebaronen.dk> >> wrote: >>> Hello again, >>> >>> I tried the query again by removing the subquery part and then it >>> seems to work. Trying a similar query such as: >>> >>> select $kbatitle >>> subquery ( select $owner from <#ri> where $obja <fedora-model:state> $owner >>> ) >>> from <#ri> >>> where $obja <http://kemibrug.dk/k2/rdf#orgid> '183' >>> and $obja <http://kemibrug.dk/k2/relations#belongsToKBA> $kba >>> and $kba <dc:title> $kbatitle >>> >>> Throws fedora into limbo and just gives me a new tab in my browser >>> which claims it is loading. Looking at the ressource monitor for my >>> computer it brings Fedora to use 100% CPU and it ends when it throws a >>> JVM Heap size error. Is risearch broken in 3.5 or is it me doing >>> something wrong? >>> >>> On Thu, Aug 11, 2011 at 3:37 PM, Tomasz Cielecki <tom...@ostebaronen.dk> >>> wrote: >>>> Hello fedora users, >>>> >>>> I have some trouble executing iTQL through risearch. I have created >>>> the following query: >>>> >>>> select $obja $objaval $kbatitle >>>> subquery( >>>> select $obja $objaval >>>> from <#ri> >>>> where $obja <http://kemibrug.dk/k2/rdf#orgid> '183' >>>> and $obja <http://kemibrug.dk/k2/rdf#value> $objaval >>>> and $obja <http://kemibrug.dk/k2/relations#belongsToKBA> $kba >>>> ) >>>> from <#ri> >>>> where $kba <dc:title> $kbatitle; >>>> >>>> This gives me an error which says: Failed to constrain all variables: >>>> $obja not constrained in WHERE or GIVEN clauses. From my point of view >>>> $obja seems to be constrained in the subquery. >>>> Can someone maybe point out what is wrong here? >>>> >>>> -- >>>> Med Venlig Hilsen / With Best Regards >>>> Tomasz Cielecki >>>> http://ostebaronen.dk >>>> >>> >>> >>> >>> -- >>> Med Venlig Hilsen / With Best Regards >>> Tomasz Cielecki >>> http://ostebaronen.dk >>> >> >> >> >> -- >> Med Venlig Hilsen / With Best Regards >> Tomasz Cielecki >> http://ostebaronen.dk >> >> ------------------------------------------------------------------------------ >> Get a FREE DOWNLOAD! and learn more about uberSVN rich system, >> user administration capabilities and model configuration. Take >> the hassle out of deploying and managing Subversion and the >> tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 >> _______________________________________________ >> Fedora-commons-users mailing list >> Fedora-commons-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users >> > > ------------------------------------------------------------------------------ > Get a FREE DOWNLOAD! and learn more about uberSVN rich system, > user administration capabilities and model configuration. Take > the hassle out of deploying and managing Subversion and the > tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 > _______________________________________________ > Fedora-commons-users mailing list > Fedora-commons-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users > -- Med Venlig Hilsen / With Best Regards Tomasz Cielecki http://ostebaronen.dk ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Fedora-commons-users mailing list Fedora-commons-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
