Hi Christophe.
I observe the same behaviour performing these steps against the latest
develop/7 git archive, thus we shall have to look into this. I presume this
method works with earlier v6 ot other builds that have been tried ?
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 25 May 2014, at 10:35, Christophe Desclaux <christo...@reador.net> wrote:
> Hello,
> so i'm creating a french version of dbpedia using the extraction-framework
> from dbpedia, and I have a problem with inserted datas which are saved in
> graph "http://fr.dbpedia.org"; but with sparql request i can't get the datas:
>
> I created new virtuoso (Version 7.1.0.3207-pthreads as of Apr 4 2014)
> database with the following virtuoso.ini
> <https://gist.github.com/descl/98bfa481bd3a9d068f1d>.
> I installed new version of DBpedia vad for this test.
>
> My extraction files are in /home/extraction-framework/datas/frwiki/20140521
> root@ns384501:/home/extraction-framework/datas/frwiki/20140521# ls
> frwiki-20140521-article-categories.nt.gz
> frwiki-20140521-infobox-properties.nt.gz
> frwiki-20140521-redirects.nt.gz
> frwiki-20140521-article-templates.nt.gz
> frwiki-20140521-infobox-property-definitions.nt.gz
> frwiki-20140521-revision-ids.nt.gz
> frwiki-20140521-category-labels.nt.gz frwiki-20140521-infobox-test.nt.gz
> frwiki-20140521-revision-uris.nt.gz
> frwiki-20140521-disambiguations.nt.gz
> frwiki-20140521-instance-types.nt.gz
> frwiki-20140521-skos-categories.nt.gz
> frwiki-20140521-download-complete
> frwiki-20140521-interlanguage-links.nt.gz
> frwiki-20140521-specific-mappingbased-properties.nt.gz
> frwiki-20140521-external-links.nt.gz frwiki-20140521-labels.nt.gz
> frwiki-20140521-template-redirects.obj
> frwiki-20140521-extraction-complete
> frwiki-20140521-mappingbased-properties.nt.gz
> frwiki-20140521-topical-concepts.nt.gz
> frwiki-20140521-french-population.nt.gz frwiki-20140521-page-ids.nt.gz
> frwiki-20140521-wikipedia-links.nt.gz
> frwiki-20140521-geo-coordinates.nt.gz frwiki-20140521-page-links.nt.gz
> global.graph
> frwiki-20140521-homepages.nt.gz frwiki-20140521-pages-articles.xml
> index.html
> frwiki-20140521-images.nt.gz frwiki-20140521-pnd.nt.gz
>
> There is the global.graph file with "http://fr.dbpedia.org"; inside.
> In order to have datas inserted in the triplestore i used the following
> commands:
>
> set password dba *****;
> DB.DBA.RDF_GRAPH_GROUP_CREATE ('http://fr.dbpedia.org',1);
> DB.DBA.RDF_GRAPH_GROUP_INS
> ('http://fr.dbpedia.org','http://fr.dbpedia.org/live');
> DB.DBA.RDF_GRAPH_GROUP_INS
> ('http://fr.dbpedia.org','http://static.fr.dbpedia.org');
> DB.DBA.RDF_GRAPH_GROUP_INS
> ('http://fr.dbpedia.org','http://fr.dbpedia.org/resource/classes#');
> log_enable(3,1);
> registry_set ('dbp_decode_iri', 'on');
> registry_set ('dbp_domain', 'http://fr.dbpedia.org');
> registry_set ('dbp_graph', 'http://fr.dbpedia.org');
> registry_set ('dbp_lang', 'fr');
> registry_set ('dbp_DynamicLocal', 'off');
> registry_set ('dbp_category', 'Catégorie');
> registry_set ('dbp_imprint', 'http://dbpedia.fr/doc/Imprint');
> registry_set ('dbp_website', 'http://wimmics.inria.fr/projects/dbpedia/');
> registry_set ('dbp_lhost', ':80');
> registry_set ('dbp_vhost', 'dbpedia.org');
> vad_install('/usr/local/share/virtuoso/vad/dbpedia_dav.vad', 0);
> vad_install('/usr/local/share/virtuoso/vad/rdf_mappers_dav.vad', 0);
> ld_dir('/home/extraction-framework/datas/frwiki/20140521/','*.nt.gz',
> 'http://static.fr.dbpedia.org');
> rdf_loader_run();
>
> Now my datas are on http://live.fr.dbpedia.org/sparql
>
> If i make the following request (thanks Julien Plu for help)
> select * from <http://fr.dbpedia.org> where
> {<http://fr.dbpedia.org/resource/France> ?a ?b} LIMIT 100
> => no results
>
> But with:
> select * where {graph <http://fr.dbpedia.org>
> {<http://fr.dbpedia.org/resource/France> ?a ?b}} LIMIT 100
> => I have the triples ! :'(
>
> IfI can't put my datas in the well graph i can't have results in
> http://live.fr.dbpedia.org/data/France.ntriples
>
>
> Julien Cojan helped gave me a isql request in order to know graph for triples:
> select top 5 id_to_iri(G) as G_iri, id_to_iri(S) as S_iri, id_to_iri(P) as
> P_iri, id_to_iri(O) as O_iri from DB.DBA.RDF_QUAD where
> S=iri_to_id('http://fr.dbpedia.org/resource/Paris') and
> P=iri_to_id('http://www.w3.org/1999/02/22-rdf-syntax-ns#type');
>
> G_iri
> S_iri
> P_iri
> O_iri
> LONG VARCHAR
> LONG VARCHAR
> LONG VARCHAR
> LONG VARCHAR
> _______________________________________________________________________________
>
> http://fr.dbpedia.org
> http://fr.dbpedia.org/resource/Paris
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> http://www.w3.org/2002/07/owl#Thing
> http://fr.dbpedia.org
> http://fr.dbpedia.org/resource/Paris
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> http://www.w3.org/2004/02/skos/core#Concept
> http://fr.dbpedia.org
> http://fr.dbpedia.org/resource/Paris
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> http://schema.org/Place
> http://fr.dbpedia.org
> http://fr.dbpedia.org/resource/Paris
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> http://dbpedia.org/ontology/Place
> http://fr.dbpedia.org
> http://fr.dbpedia.org/resource/Paris
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> http://dbpedia.org/ontology/PopulatedPlace
>
> 5 Rows. -- 1 msec.
>
> It's saying that my datas are in the good graph...
>
>
> I have no solution yet for solving the problem. To you have ideas of
> solutions?
>
>
> Here is the virtuoso log:
> root@ns384501:/home/virtuoso/db# virtuoso-t +foreground
>
> Thu May 22 2014
> 17:24:37 OpenLink Virtuoso Universal Server
> 17:24:37 Version 07.10.3207-pthreads for Linux as of Apr 4 2014
> 17:24:37 uses parts of OpenSSL, PCRE, Html Tidy
> 17:24:40 Database version 3126
> 17:24:40 SQL Optimizer enabled (max 1000 layouts)
> 17:24:41 Compiler unit is timed at 0.000148 msec
> 17:24:42 built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST" overruled by the
> RDBMS
> 17:24:42 built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH" overruled by the RDBMS
> 17:24:42 built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI" overruled by the
> RDBMS
> 17:24:42 built-in procedure "repl_undot_name" overruled by the RDBMS
> 17:24:43 Roll forward started
> 17:24:43 Roll forward complete
> 17:24:43 Checkpoint started
> 17:24:43 Checkpoint finished, log reused
> 17:24:43 HTTP/WebDAV server online at 80
> 17:24:43 Server online at 1111 (pid 4647)
>
>
> Thanks! Chris
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.
> Get unparalleled scalability from the best Selenium testing platform available
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
