Re: [Virtuoso-users] Bug with upgrade Virtuoso 6.1.6 to 7.0.0

[Julien P. <jul...@re...>]

Hi Hugh,

Ok, I will let you know about this new query monday, because I don't have
access to this Virtuoso instance for now.

Best.

Julien.


2013/10/25 Hugh Williams <hwi...@op...>

> Hi Julien,
>
> I don't see how that query can fails with a  No table error as the
> RDF_QUAD table holds all your RDF triples ?  Can you try fully qualifying
> it with:
>
>         select distinct count(distinct g) from DB.DBA.RDF_QUAD;
>
> Which should also be visible in the in the database schema ...
>
> 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 24 Oct 2013, at 08:42, Julien Plu <jul...@re...>
> wrote:
>
> > Hi Hugh,
> >
> > I use the stable version, more precisely the "tar.gz" from here :
> http://sourceforge.net/projects/virtuoso/files/virtuoso/7.0.0/
> >
> > And for the query I have this error :
> >
> > *** Error S0002: [Virtuoso Driver][Virtuoso Server]SQ200: No table
> rdf_quad
> > at line 3 of Top-Level:
> > select distinct count(distinct g) from rdf_quad
> >
> > Best.
> >
> > Julien.
> >
> >
> >
> > 2013/10/24 Hugh Williams <hwi...@op...>
> > Hi Julien,
> >
> > Can you please confirm if you are using the stable or develop 7 branch
> in git ?
> >
> > Also, what does the following query directly against the RDF_QUAD table
> report as the number of graphs:
> >
> >       select distinct count(distinct g) from rdf_quad;
> >
> > 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 23 Oct 2013, at 18:10, Julien Plu <
> jul...@re...> wrote:
> >
> >> Hi,
> >>
> >> I try to upgrade my old Virtuoso version (6.1.6) to the new one (7.0.0)
> but in keeping the same virtuoso.db file.
> >>
> >> So I saved the "virtuoso.db" file, deleted completely the 6.1.6
> virtuoso version, installed the 7.0.0 version, put the "virtuoso.db" file
> in the "db" folder then start the new Virtuoso.
> >>
> >> Until there everything goes well, I have all my users, all my data,
> etc... But I have one problem which is in the conductor, in the "graphs"
> tab only these graphs are displayed :
> >>
> >> http://www.openlinksw.com/schemas/virtrdf#
> >> http://localhost:8890/sparql
> >> http://www.w3.org/2002/07/owl#
> >>
> >> Even with the "DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS();" procedure or even
> with the SPARQL query :
> >>
> >> SELECT DISTINCT ?namedgraph WHERE { GRAPH ?namedgraph { ?s ?p ?o } }
> >>
> >> Whereas if I query a graph which not appear in this list but which was
> displayed with the previous Virtuoso version with this query :
> >>
> >> SELECT DISTINCT count(*) FROM <http://one/of/my/graph> WHERE {?s ?p ?o}
> >>
> >> I have all my data and that works for all the graphs which not appear
> in the "graphs" tab.
> >>
> >> This come a bug from Virtuoso or there is something to do to see appear
> all the graph contained in the the "virtuoso.db" file ?
> >>
> >> Thanks in advance.
> >>
> >> Julien
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> October Webinars: Code for Performance
> >> Free Intel webinars can help you accelerate application performance.
> >> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the
> most from
> >> the latest Intel processors and coprocessors. See abstracts and
> register >
> >>
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk_______________________________________________
> >> Virtuoso-users mailing list
> >> Vir...@li...
> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> >
> >
> >
> ------------------------------------------------------------------------------
> > October Webinars: Code for Performance
> > Free Intel webinars can help you accelerate application performance.
> > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> > the latest Intel processors and coprocessors. See abstracts and register
> >
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk_______________________________________________
> > Virtuoso-users mailing list
> > Vir...@li...
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>