Reloading the database with the correct graph name (http://dbpedia.org and
not http://dbpedia.org/) solved the problem.
Thank you !
2014-04-22 0:43 GMT+02:00 Romain Beaumont <romain.r...@gmail.com>:
> Yes I've been trying to do
> - log_enable(3) and increasing TransactionAfterImageLimit : I still get
> the error "Transaction aborted because it's log after image size went
> above the limit"
> - log_enable(2) : it uses too much memory and end up using the swap : I
> didn't let it run to its end but I suspect it would take a long time
> because it's using the swap
>
> So I've decided to simply reload the database from scratch, it will
> probably be faster that way.
>
> Thank you for your help !
>
>
> 2014-04-22 0:17 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com>:
>
> Hi Romain,
>>
>> It seems you have been following the following tip on renaming a graph in
>> Virtuoso:
>>
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksGuideRenameGraph
>>
>> You can also increase the "TransactionAfterImageLimit" INI file param to
>> get around the "Transaction aborted because it's log after image size went
>> above the limit" error if you have sufficient free memory available as
>> detailed at:
>>
>> http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#dbadm
>>
>> but then it probably would be quicker to reload the datasets into an
>> empty database from scratch ...
>>
>> 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 21 Apr 2014, at 22:30, Romain Beaumont <romain.r...@gmail.com> wrote:
>>
>> > ok so, doing log_enable(2); before UPDATE DB.DBA.RDF_QUAD TABLE OPTION
>> (index RDF_QUAD_GS) SET g = iri_to_id ('http://dbpedia.org') WHERE
>> g = iri_to_id ('http://dbpedia.org/', 0);
>> > in isql-vt seems to go beyong that "Transaction aborted because it's
>> log after image size went above the limit" error
>> > but now it just start using all the RAM again...
>> > I guess deleting the db and starting from scratch will work, but if
>> anyone know how to rename a big graph in virtuoso that would be helpful ?
>> >
>> >
>> > 2014-04-21 22:41 GMT+02:00 Romain Beaumont <romain.r...@gmail.com>:
>> > I tried to, but as the dbpedia db is pretty big (a 44Go db virtuoso
>> file), it doesn't work with the conductor interface (it just fill up the
>> 16Go ram of my server), and the isql-vt interface doesn't work much better
>> for this (I get "Transaction aborted because it's log after image size went
>> above the limit")
>> >
>> > But that might still be the problem (I've seen "http://dbpedia.org";
>> and http://dbpedia.org/"; for the ld_dir_all('<a path>', '*.*', '
>> http://dbpedia.org/'); on the web...), I'll try again.
>> >
>> >
>> > 2014-04-21 21:45 GMT+02:00 Dimitris Kontokostas <jimk...@gmail.com>:
>> >
>> > Can you try to remove the "/" from the graph?
>> > I think Virtuoso has a graph rename function (also from the conductor
>> interface)
>> >
>> > Dimitris
>> >
>> >
>> > On Mon, Apr 21, 2014 at 10:39 PM, Romain Beaumont <
>> romain.r...@gmail.com> wrote:
>> > I got the triples from http://downloads.dbpedia.org/3.9/en/ then
>> loaded the script
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtBulkRDFLoaderScript
>> > and run ld_dir_all('<a path>', '*.*', 'http://dbpedia.org/');
>> > then run rdf_loader_run();
>> > SELECT * FROM DB.DBA.LOAD_LIST; show that ll_graph is
>> http://dbpedia.org/ for the dumps
>> >
>> > How can I check if the triples are actually loaded under the "
>> http://dbpedia.org"; graph?
>> >
>> >
>> > 2014-04-21 21:28 GMT+02:00 Dimitris Kontokostas <jimk...@gmail.com>:
>> > Hello,
>> >
>> > Did you load the triples in the "http://dbpedia.org"; graph?
>> >
>> > Best,
>> > Dimitris
>> >
>> >
>> > On Mon, Apr 21, 2014 at 10:19 PM, Romain Beaumont <
>> romain.r...@gmail.com> wrote:
>> > Hello,
>> > I'm trying to make a mirror of dbpedia with virtuoso, I've successfuly
>> imported dbpedia data.
>> > I can use the sparql interface without problem and conductor works fine
>> too.
>> > After that i've been trying to install the dbpedia vad, I can now
>> access the /page/Entity pages, but there's only the owl:sameAs property
>> displayed.
>> > Where might it come from and how can I fix this ?
>> > Thank you,
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Start Your Social Network Today - Download eXo Platform
>> > Build your Enterprise Intranet with eXo Platform Software
>> > Java Based Open Source Intranet - Social, Extensible, Cloud Ready
>> > Get Started Now And Turn Your Intranet Into A Collaboration Platform
>> > http://p.sf.net/sfu/ExoPlatform
>> > _______________________________________________
>> > Dbpedia-discussion mailing list
>> > Dbpedia-discussion@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>> >
>> >
>> >
>> >
>> > --
>> > Kontokostas Dimitris
>> >
>> >
>> >
>> >
>> > --
>> > Kontokostas Dimitris
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Start Your Social Network Today - Download eXo Platform
>> > Build your Enterprise Intranet with eXo Platform Software
>> > Java Based Open Source Intranet - Social, Extensible, Cloud Ready
>> > Get Started Now And Turn Your Intranet Into A Collaboration Platform
>> >
>> http://p.sf.net/sfu/ExoPlatform_______________________________________________
>> > Dbpedia-discussion mailing list
>> > Dbpedia-discussion@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>
>>
>
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
