Hi Pantelis, SPARUL operations are performed as part of a transaction, which is stored in memory until the operation is completed and committed to the database, and for such a large graph would consume a significant amount system memory, possibly all available memory and not being able to complete. Thus how much memory is available on the system and how much is allocated for Virtuoso data buffers ie NumberOfBuffers INI file param and how much memory is left ? You can run the “status();” command from isql to see the Buffers setting and other Virtuoso server status metrics.
You can also try prepending the query with the "DEFINE sql:log-enable 3” pragma
which sets transaction log mode to autocommit during the insert significantly
reducing the memory requirement which may then allow the operation to complete,
as is required when deleting large graphs as documented at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs
I also note you are running a 3214 build which is from June 2015 and would
recommend updating to the latest 3217 build from April 2016 …
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 2 Jul 2016, at 15:06, Pantelis Natsiavas <natsia...@gmail.com> wrote:
>
> Hi everybody.
>
> I am trying to execute the following query
>
> INSERT INTO GRAPH <targetGraph> {
> ?a <someProperty> ?b
> }
> WHERE {
> GRAPH <sourceGraph> {
> ?a <someOtherProperty> ?c .
> BIND(REPLACE(STR(?a),"something:", "", "i") AS ?b) }
> }
>
> The sourceGraph contains about 94 million triplets. When I execute the above
> SPARQL, I get no error, however, I get no response either. I check after some
> minutes and the <targetGraph> has not yet been created. The system acts as if
> I had never executed the statement.
>
> I have tried executing the above through /sparql and through the /conductor
> web interfaces.
>
> Is there a way to see what is really going on? Am I doing something wrong?
>
> I have also already tried to debug through the isql-v localhost:8890 dba
> <password> -D but I get a totally uncomprehensible error:
>
> isql-v() [0x44986a]
> isql-v() [0x4498c8]
> isql-v() [0x44b00e]
> isql-v() [0x42fc65]
> isql-v() [0x4108b0]
> isql-v() [0x4043ee]
> /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7fc06a645ec5]
> isql-v() [0x40441e]
> GPF: Dkernel.c:3080 can't free if in served sessions
> Segmentation fault (core dumped)
>
> Please note that I am using Version: 07.20.3214, Build: Oct 14 2015 on ubuntu
> server.
>
> Kind regards,
> Pantelis Natsiavas
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
