I've been able to reproduce the dump, and i got these in the logs :

17:45:36 Dumping the schema done
17:57:21 Broken index RDF_QUAD_POGS
18:00:25 Broken index RDF_QUAD
18:00:25 Broken index DB_DBA_RDF_IRI_UNQC_RI_ID
18:00:25 Broken index RDF_IRI
18:00:25 Database dump complete

could you explain the Broken index ?

does it mean indexes where invalid "before" the dump ?

should i fix them before doing the dump ? after the recovery ?

Thx


Le 12/12/2017 à 15:52, Thomas Michaux a écrit :
Hello,

we made a dump (+backup-dump) after we found messages in virtuoso.log like these :

" There are pages in the backup set that are actually free. Should do backup_context_clear () and thus get a full backup. This can indicate corruption around page 73 81024."


the dump was ok, no errors, after we saved the .db and delete it we recover by reading the .trx from previous step (+restore-crash-dump) and it was also successfull.

Now the problem is we have graphs but only with IRI_ID showed, no names ? is there an internal data structure to update to have the graph names back or is it definitely corrupted ?

Thanks

PS:

15:21:41 OpenLink Virtuoso Universal Server
15:21:41 Version 07.20.3217-pthreads for Linux as of Feb 10 2017
15:21:41 uses parts of OpenSSL, PCRE, Html Tidy
15:21:47 Database version 3126


graph list :

SQL> sparql select distinct ?g where {GRAPH ?g{?s a ?t}};
g
LONG VARCHAR
_______________________________________________________________________________

http://www.openlinksw.com/schemas/virtrdf#
iri_id_179939769_with_no_name_entry
b3sifp
http://www.w3.org/2002/07/owl#
iri_id_101440794_with_no_name_entry
iri_id_138171152_with_no_name_entry
iri_id_109064725_with_no_name_entry
iri_id_120447918_with_no_name_entry
iri_id_122475737_with_no_name_entry
iri_id_126542051_with_no_name_entry
iri_id_134423479_with_no_name_entry
iri_id_126235267_with_no_name_entry
iri_id_130855391_with_no_name_entry
iri_id_182388251_with_no_name_entry
iri_id_115082563_with_no_name_entry
iri_id_107233893_with_no_name_entry
iri_id_176955935_with_no_name_entry
iri_id_138170213_with_no_name_entry
http://localhost:8890/sparql
iri_id_120447899_with_no_name_entry
iri_id_126235266_with_no_name_entry
iri_id_111093750_with_no_name_entry
iri_id_111317575_with_no_name_entry
iri_id_115156110_with_no_name_entry
iri_id_169252958_with_no_name_entry
iri_id_184144716_with_no_name_entry
iri_id_176961926_with_no_name_entry
iri_id_104573215_with_no_name_entry
iri_id_126542040_with_no_name_entry
iri_id_173680485_with_no_name_entry
iri_id_169407489_with_no_name_entry
virtrdf-label
iri_id_102730058_with_no_name_entry
iri_id_113150701_with_no_name_entry
iri_id_126920998_with_no_name_entry

35 Rows. -- 3384 msec.


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to