Not logged in : Login
(Sponging disallowed)

About: Step 3     Goto   Sponge   NotDistinct   Permalink

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

Database reports Broken index RDF_QUAD_XXXX on startup If on startup the Virtuoso database fails to start reporting Broken index RDF_QUAD_XXXX: 11:14:55 built-in procedure "WS.WS.SYS_DAV_RES_RES_CONTENT_HOOK" overruled by the RDBMS 11:14:55 built-in procedure "WS.WS.SYS_DAV_RES_RES_CONTENT_INDEX_HOOK" overruled by the RDBMS 11:14:59 Roll forward started 11:15:03 353 transactions, 3698455 bytes replayed (100 %) 11:15:03 Roll forward complete 11:15:05 Broken index RDF_QUAD_POGS 11:15:05 GPF: colsearch.c:1757 less ces in seg than indicated in leaf col ref GPF: colsearch.c:1757 less ces in seg than indicated in leaf col ref This can be recovered by as follows: Ensure a full backup or copy of the database is made Remove or rename the virtuoso.trx transaction log file Start the database again which should not start successfully and run the command to drop the broken RDF index: _INTERNAL_DROP_INDEX ('DB.DBA.RDF_QUAD', 'RDF_QUAD_POGS'); Perform a database crash dump of the database with the +crash-dump command: virtuoso-iodbc-t +configfile virtuoso.ini +crash-dump On completion the database can be restored with the +restore-crash-dump command: virtuoso-iodbc-t +configfile virtuoso.ini +restore-crash-dump The missing index can then be recreated as detailed in the RDF Performance Tuning guide, thus is the case of the RDF_QUAD_POGS index the command would be: DROP INDEX RDF_QUAD_POGS ; CREATE COLUMN INDEX RDF_QUAD_POGS ON DB.DBA.RDF_QUAD (P, O, G, S) PARTITION (O varchar (-1, 0hexffff));

AttributesValues
type
described by
name
  • Step 3
description
  • Database reports Broken index RDF_QUAD_XXXX on startup If on startup the Virtuoso database fails to start reporting Broken index RDF_QUAD_XXXX: <blockquote> 11:14:55 built-in procedure "WS.WS.SYS_DAV_RES_RES_CONTENT_HOOK" overruled by the RDBMS 11:14:55 built-in procedure "WS.WS.SYS_DAV_RES_RES_CONTENT_INDEX_HOOK" overruled by the RDBMS 11:14:59 Roll forward started 11:15:03 353 transactions, 3698455 bytes replayed (100 %) 11:15:03 Roll forward complete 11:15:05 Broken index RDF_QUAD_POGS 11:15:05 GPF: colsearch.c:1757 less ces in seg than indicated in leaf col ref GPF: colsearch.c:1757 less ces in seg than indicated in leaf col ref </blockquote> This can be recovered by as follows: Ensure a full backup or copy of the database is made Remove or rename the virtuoso.trx transaction log file Start the database again which should not start successfully and run the command to drop the broken RDF index: <code>_INTERNAL_DROP_INDEX ('DB.DBA.RDF_QUAD', 'RDF_QUAD_POGS');</code> Perform a database crash dump of the database with the +crash-dump command: <code>virtuoso-iodbc-t +configfile virtuoso.ini +crash-dump </code> On completion the database can be restored with the +restore-crash-dump command: <code>virtuoso-iodbc-t +configfile virtuoso.ini +restore-crash-dump </code> The missing index can then be recreated as detailed in the RDF Performance Tuning guide, thus is the case of the RDF_QUAD_POGS index the command would be: <pre> DROP INDEX RDF_QUAD_POGS ; CREATE COLUMN INDEX RDF_QUAD_POGS ON DB.DBA.RDF_QUAD (P, O, G, S) PARTITION (O varchar (-1, 0hexffff)); </pre>
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