Virtuoso 22026 Error SR319 #118

Open
jakubklimek opened this Issue Dec 16, 2013 · 6 comments

Comments

Projects
None yet
5 participants

In develop/6 da1abf3

Virtuoso 22026 Error SR319: Max row length is exceeded when trying to store a string of 132 chars into a temp col

SPARQL query:
define sql:big-data-const 0 define sql:signal-void-variables 1 
PREFIX s: <http://schema.org/>
select count distinct (?address)
WHERE 
{
?address a s:PostalAddress ;
    ?p ?o . 
}

And also even a simpler query

Virtuoso 22026 Error SR319: Max row length is exceeded when trying to store a string of 132 chars into a temp col
SPARQL query:
define sql:big-data-const 0 
#output-format:text/html
define sql:signal-void-variables 1 PREFIX s: <http://schema.org/>
select count distinct (?address)
WHERE 
{
?address a s:PostalAddress . 
}
Collaborator

HughWilliams commented Dec 16, 2013

We have a few occurrences of this error reported that are still resolved. If you can provide a test case for recreating this error against your datasets that we can recreate locally this may aid in finding a general solution to this error condition ?

Actually, I have isolated the problem to a single graph and dumped it. When I cleared the graph, the query started working. When I reloaded the graph, the error started to occur again. You can download the graph dump.

Collaborator

HughWilliams commented Dec 20, 2013

I have been able to recreate with the dataset you provided against both v6 & v7:

SQL> sparql PREFIX s: http://schema.org/ select count distinct (?address) WHERE { ?address a s:PostalAddress ; ?p ?o . };

*** Error 22026: VD [Virtuoso Server]SR319: Max row length is exceeded when trying to store a string of 157 chars into a temp col
at line 11 of Top-Level:
sparql PREFIX s: http://schema.org/ select count distinct (?address) WHERE { ?address a s:PostalAddress ; ?p ?o . }
SQL>

and have reported to development to fix ...

tombech commented Feb 7, 2014

I see a similar problem here, has this been fixed?

Collaborator

HughWilliams commented Feb 9, 2014

A solution is not available yet I'm afraid ...

@openlink openlink assigned imitko and iv-an-ru and unassigned imitko Feb 12, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment