Hello Nathan, We have a guess how to make a workaround and will experiment with it before (long waiting and coming soon) next release.
Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Wed, 2010-06-16 at 21:09 +0100, Nathan wrote: > Just a quick follow up, any progress / new snapshot to test or similar? > > Best, > > Nathan > > Nathan wrote: > > Hi Ivan, > > > > That's stopped the exception, however the output is a little messed up > > now: here's a direct link: http://bit.ly/ccBdXy you can see the XML > > fragment in the 'encoded' val is.. screwed. > > > > This only happens with larger blocks of XML, not sure on the exact > > figure but think it's circa 4000 bytes and above. > > > > Also the error code alternates depending on length, getting: > > "22026 Error SR478: Value of ANY type column too long" for some chunks > > of XML, and other times the original "22026 Error SR319: Max row length > > is exceeded when trying to store a string of 4951 chars into a temp col" > > > > Best, > > > > Nathan > > > > > > Ivan Mikhailov wrote: > >> Hello Mathan, > >> > >> I've found and tested a workaround for similar case on other dataset: > >> > >> sparql > >> [prefix declarations skipped] > >> select * from <http://lib.uchicago.edu/campub> > >> where > >> { ?item local:parent ?parent ; local:text ?text . > >> FILTER regex (?text, ' rabbit ', 'i') > >> } order by ?parent ; > >> > >> caused same error. > >> > >> sparql > >> [prefix declarations skipped] > >> select * from <http://lib.uchicago.edu/campub> > >> where > >> { > >> { select * where > >> { ?item local:parent ?parent ; local:text ?text . > >> FILTER regex (?text, ' rabbit ', 'i') > >> } order by ?parent > >> } > >> } ; > >> > >> runs fine. The reason is that RDF literals are kept in the table of > >> quads as compact references to a separate table but "expanded" to their > >> full size before being returned from SPARQL request to the client. If > >> some values are long texts then they does not fit into a temporary table > >> of ORDER BY and thus the error happens. With a nested SELECT, sorting is > >> before expansion. > >> > >> So for the query in your question the workaround may be similar: > >> > >> select * where { > >> {{ select * where { > >> ?item foaf:maker <http://webr3.org/nathan#me> ; > >> dcterms:created ?created ; > >> dcterms:title ?title ; > >> rdfs:seeAlso ?link . > >> OPTIONAL { ?item dcterms:abstract ?abstract } > >> OPTIONAL { ?item content:encoded ?encoded } > >> } order by desc(?created) }} > >> > >> Best Regards, > >> > >> Ivan Mikhailov > >> OpenLink Software > >> http://virtuoso.openlinksw.com > >> > >> On Fri, 2010-05-28 at 23:36 +0100, Nathan wrote: > >>> Hi, > >>> > >>> Just came upon an error I don't seem to be able to get around.. > >>> > >>> "22026 Error SR319: Max row length is exceeded when trying to store a > >>> string of 4951 chars into a temp col" > >>> > >>> when running a rather simple sparql query over a graph which contains a > >>> mere 702 triples (quadstore contains 38,326,545 over all graphs though): > >>> > >>> select * where { > >>> ?item foaf:maker <http://webr3.org/nathan#me> ; > >>> dcterms:created ?created ; > >>> dcterms:title ?title ; > >>> rdfs:seeAlso ?link . > >>> OPTIONAL { ?item dcterms:abstract ?abstract } > >>> OPTIONAL { ?item content:encoded ?encoded } > >>> } order by desc(?created) > >>> > >>> > >>> Virtuoso version: > >>> Version 6.1.1.3127-pthreads as of Apr 8 2010 > >>> > >>> Any fixes or workarounds? > >> > >> > >> > > > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > > Virtuoso-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > > > > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
