Not logged in : Login
(Sponging disallowed)

About: Step 5     Goto   Sponge   Distinct   Permalink

An Entity of Type : schema:HowToStep, within Data Space : linkeddata.uriburner.com:28898 associated with source document(s)

If the counts of the queries are not all "0" this indicated the indexes with none "0" counts are corrupt and needs to be repaired, which can be done with the following queries/commands: create table rq_recov (g iri_id_8, s iri_id_8, p iri_id_8, o any, primary key (g,s,p,o)); log_enable (3,1); insert soft rq_recov (g,s,p,o) select g,s,p,o from RDF_QUAD a table option (index RDF_QUAD) where not exists (select 1 from RDF_QUAD b table option (loop, index RDF_QUAD_POGS, no exists join) where a.G = b.G and a.P = b.P and a.O = b.O and a.S = b.S); insert soft rq_recov (g,s,p,o) select g,s,p,o from RDF_QUAD a table option (index RDF_QUAD_POGS) where not exists (select 1 from RDF_QUAD b table option (loop, index primary key, no exists join) where a.G = b.G and a.P = b.P and a.O = b.O and a.S = b.S); insert soft rdf_quad index rdf_quad (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_pogs (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_sp (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_op (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_gs (g,s,p,o) select g,s,p,o from rq_recov; log_enable (1,1); drop table rq_recov; checkpoint; Then run the select count ... queries again for Virtuoso 7 or 8 , as above, to check indexes, the counts ALL of which should all be zero indicating they are repaired.

AttributesValues
type
described by
name
  • Step 5
description
  • If the counts of the queries are not all "0" this indicated the indexes with none "0" counts are corrupt and needs to be repaired, which can be done with the following queries/commands: <pre> create table rq_recov (g iri_id_8, s iri_id_8, p iri_id_8, o any, primary key (g,s,p,o)); log_enable (3,1); insert soft rq_recov (g,s,p,o) select g,s,p,o from RDF_QUAD a table option (index RDF_QUAD) where not exists (select 1 from RDF_QUAD b table option (loop, index RDF_QUAD_POGS, no exists join) where a.G = b.G and a.P = b.P and a.O = b.O and a.S = b.S); insert soft rq_recov (g,s,p,o) select g,s,p,o from RDF_QUAD a table option (index RDF_QUAD_POGS) where not exists (select 1 from RDF_QUAD b table option (loop, index primary key, no exists join) where a.G = b.G and a.P = b.P and a.O = b.O and a.S = b.S); insert soft rdf_quad index rdf_quad (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_pogs (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_sp (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_op (g,s,p,o) select g,s,p,o from rq_recov; insert soft rdf_quad index rdf_quad_gs (g,s,p,o) select g,s,p,o from rq_recov; log_enable (1,1); drop table rq_recov; checkpoint; </pre> Then run the select count ... queries again for Virtuoso 7 or 8 , as above, to check indexes, the counts ALL of which should all be zero indicating they are repaired.
schema:nextItem
position
is topic of
is schema:nextItem of
is schema:step of
Faceted Search & Find service v1.17_git149 as of Dec 03 2024


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3331 as of Aug 25 2024, on Linux (x86_64-ubuntu_noble-linux-glibc2.38-64), Single-Server Edition (378 GB total memory, 40 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2025 OpenLink Software