On 12/12/17 9:52 AM, Thomas Michaux wrote: > 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."
Okay, but you are making a backup of data in a database where the
aforementioned index is corrupt, as the system message indicates.
>
>
> 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.
Yes, but you are using +restore-crash-dump against a backup of a
corrupted database. You should have used +crash-dump as per:
./virtuoso -?
Usage:
virtuoso [-fcnCbDARwMKrBd] [+foreground] [+configfile arg]
[+no-checkpoint]
[+checkpoint-only] [+backup-dump] [+crash-dump]
[+crash-dump-data-ini arg] [+restore-crash-dump] [+wait]
[+mode arg] [+dumpkeys arg] [+restore-backup arg]
[+backup-dirs arg] [+debug] [+pwdold arg] [+pwddba arg]
[+pwddav arg]
+foreground run in the foreground
+configfile use alternate configuration file
+no-checkpoint do not checkpoint on startup
+checkpoint-only exit as soon as checkpoint on startup is complete
+backup-dump dump database into the transaction log, then exit
* +crash-dump dump inconsistent database into the
transaction log, then exit*
+crash-dump-data-ini specify the DB ini to use for reading the data
to dump
*+restore-crash-dump restore from a crash-dump*
+wait wait for background initialization to complete
+mode specify mode options for server startup (onbalr)
+dumpkeys specify key id(s) to dump on crash dump
(default : all)
+restore-backup restore from online backup
+backup-dirs default backup directories
+debug Show additional debugging info
+pwdold Old DBA password
+pwddba New DBA password
+pwddav New DAV password
Kingsley
>
> 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
>
--
Regards,
Kingsley Idehen
Founder & CEO
OpenLink Software (Home Page: http://www.openlinksw.com)
Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen
Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen
Web Identities (WebID):
Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i
:
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ 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
