Virtuoso can't load long URIs.
Opened this issue · 0 comments
timrdf commented
*** Error 23000: [Virtuoso Driver][Virtuoso Server]SR133: Can not set NULL to not nullable column 'DB.DBA.RDF_QUAD.S'
at line 2 of Top-Level:
DB.DBA.TTLP_MT(file_to_string_output('/home/lodcloud/prizms/lodcloud/data/source/us/lod-tag/version/2013-06-22/publish/us-lod-tag-2013-06-22.ttl.gz.manual.nt.narrow.nt'),'','http://datafaqstest.tw.rpi.edu/source/us/dataset/lod-tag/version/2013-06-22', 255, 2, 2)
SQL>
http://boards.openlinksw.com/phpBB3/viewtopic.php?f=12&t=1625 indicates it's b/c some URIs are too long. Inspecting my file, the width of my triples (length($0)) are:
...
2744
2836
2868
2871
3022
3039
3116
3134
3137
3227
3353
3371
3472
3589
4392
5201
Trimming to triples only 1500 characters wide works. Triples that are 2000 characters breaks it.
The lengths of my URIs (length($1); print length($2); print length($3)) are:
1887
1893
1895
1927
1961
1963
1989
2219
2243
2245
2451
2453
2617
Triples with URIs 1000, 1500, 1800, load (though, a space in a URI will invalidate a count...), but URIs of length 2000 characters breaks .
The URIs that break it are those named by Naming sparql service description's sd:NamedGraph