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 <[email protected]>:
> 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 <[email protected]> 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 <[email protected]>:
> > 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 <[email protected]>:
> >
> > 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 <[email protected]>
> 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 <[email protected]>:
> > 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 <[email protected]>
> 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
> > [email protected]
> > 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
> > [email protected]
> > 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
