Hi,
unfortunately my load problem doesn't seem to be fixed yet. I can load
datasets of up to approx. 500 MB (~ 5.000.000 triples), but when trying
to load a file with 25.000.000 triples (~ 2.7 GB), I get the following
error message:
13:39:06 Can't write to file
/data/SP2B/sp2b/bench/sparqlengines/virtuoso//sesnZpG6K
File size limit exceeded
I already checked, and there are no user limits for the file size. The
used file system is ext3, which should support files of at least up to
16 GB, so this cannot be the problem either.
The weirdest thing is that the files:
virtuoso.trx
virtuoso.db
do not change their initial size after the start of the load, which
normally happened for the other file sizes.
I am using the following load command, which works fine for the
"smaller" files:
ttlp_mt
(file_to_string_output('/data/SP2B/sp2b/bench/data/rdf/dblp25000000.n3'),
'', 'http://my_graph', 0);
Am I missing something obvious here?
Best regards,
Thomas
Ivan Mikhailov schrieb:
Thomas,
Yes, DB.DBA.TTLP_MT() is more suitable. Among other things it does not
try to fit everything into single transaction.
Best Regards,
Ivan Mikhailov,
OpenLink Software.
On Fri, 2008-02-22 at 15:03 +0100, Thomas Hornung wrote:
Hi,
I have a problem when I try to load a "large" (~109MB, approx. 1.000.000
triples) RDF data set into Virtuoso. Ideally I'd like to load files of
up to several GBs into Virtuoso.
I always get the same error message:
Connected to OpenLink Virtuoso
Driver: 05.00.3026 OpenLink Virtuoso ODBC Driver
*** Error 40005: [Virtuoso Driver][Virtuoso Server]SR325: Transaction
aborted because it's log after image size went above the limit
at line 2 of Command-Line-Load virtuoso_cmds/load_1000000.virtuoso:
ttlp (file_to_string_output(...)
*** Error 40005: [Virtuoso Driver][Virtuoso Server]SR325: Transaction
aborted because it's log after image size went above the limit
at line 2 of Command-Line-Load virtuoso_cmds/load_1000000.virtuoso:
ttlp (file_to_string_output(...)
OK
Where can I increment the image/log size? Or am I using the wrong
command, i.e. is ttlp the wrong command for bulk loading?
Thanks,
Thomas
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
