Hi Piret, I would suggest run a database integrity check to ensure there is no detected corruption in the database with the command:
backup '/dev/null';
and possibly consider performing backup-dump and restore or even crash-dump and
restore to correct possible corruption/inconsistency in the database as
detailed at:
http://docs.openlinksw.com/virtuoso/backup_recovery/
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 17 Aug 2016, at 09:39, Piret Lattikas <[email protected]> wrote:
>
> Hi all.
>
> We setup a separate location for virtuoso backup files on a different
> volume. First I did a full backup by stopping all processes writing to
> virtuoso and executed commands in ISQL terminal:
> SQL> checkpoint_interval(-1);
> SQL> backup_context_clear();
> SQL> checkpoint;
> SQL>
> backup_online('virt-inc_dump_17082106#',1000000,0,vector('/mnt/backups/virtuoso'));
> SQL> checkpoint_interval(60);
>
> So I disabled checkpoints while doing backups and enabled after backups
> finished. This worked fine.
>
> Then I setup a cron job to execute sql file with same commands at
> midnight every day. Not using virtuoso built in solution as needed to
> specify different location for backup files, by default they are created
> to the virtuoso work directory.
>
> The midnight backup failed right before end with page checksum error. At
> midnight the processes writing to virtuoso were running, when the backup
> started. And virtuoso service stopped after that error. The virtuoso.log
> about the error:
>
> 21:00:38 Starting online backup from page 1 to 16455680, current log is:
> /var/lib/virtuoso-opensource-7/db/virtuoso.trx
> 21:00:39 Backing up page 10000
> 21:00:39 Backing up page 20000
> ...
> 21:04:04 Backing up page 16450000
> 21:04:05 page set checksum ck=2ace7ae3 pck=2aca7ae3 xor = 40000
> 21:04:05 /usr/bin/virtuoso-t() [0xb07467]
> 21:04:05 /usr/bin/virtuoso-t() [0xb0750f]
> 21:04:05 /usr/bin/virtuoso-t() [0x4a2bd1]
> 21:04:05 /usr/bin/virtuoso-t() [0x4a87ef]
> 21:04:05 /usr/bin/virtuoso-t() [0x4a8cd8]
> 21:04:05 /usr/bin/virtuoso-t() [0x4bc9bb]
> 21:04:05 /usr/bin/virtuoso-t() [0x593e12]
> 21:04:05 /usr/bin/virtuoso-t() [0x4fd830]
> 21:04:05 /usr/bin/virtuoso-t() [0x7456c7]
> 21:04:05 /usr/bin/virtuoso-t() [0x746185]
> 21:04:05 /usr/bin/virtuoso-t() [0x746b15]
> 21:04:05 /usr/bin/virtuoso-t() [0x746c06]
> 21:04:05 /usr/bin/virtuoso-t() [0x747cc7]
> 21:04:05 /usr/bin/virtuoso-t() [0x747e0e]
> 21:04:05 /usr/bin/virtuoso-t() [0x747f86]
> 21:04:05 /usr/bin/virtuoso-t() [0x6515b8]
> 21:04:05 /usr/bin/virtuoso-t() [0x65a055]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c18b]
> 21:04:05 /usr/bin/virtuoso-t() [0x6aaecb]
> 21:04:05 /usr/bin/virtuoso-t() [0x652864]
> 21:04:05 /usr/bin/virtuoso-t() [0x65a01e]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c18b]
> 21:04:05 /usr/bin/virtuoso-t() [0x6aaecb]
> 21:04:05 /usr/bin/virtuoso-t() [0x652864]
> 21:04:05 /usr/bin/virtuoso-t() [0x653d36]
> 21:04:05 /usr/bin/virtuoso-t() [0x65f822]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c29f]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c33d]
> 21:04:05 /usr/bin/virtuoso-t() [0x6edcb8]
> 21:04:05 /usr/bin/virtuoso-t() [0x590c1e]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c1a4]
> 21:04:05 /usr/bin/virtuoso-t() [0x6a6264]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c1a4]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c455]
> 21:04:05 /usr/bin/virtuoso-t() [0x6ed7b4]
> 21:04:05 /usr/bin/virtuoso-t() [0x59319c]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c1a4]
> 21:04:05 /usr/bin/virtuoso-t() [0x6550f1]
> 21:04:05 /usr/bin/virtuoso-t() [0x655321]
> 21:04:05 /usr/bin/virtuoso-t() [0x65a085]
> 21:04:05 /usr/bin/virtuoso-t() [0x69c18b]
> 21:04:05 /usr/bin/virtuoso-t() [0x6a9007]
> 21:04:05 /usr/bin/virtuoso-t() [0x6b2f3e]
> 21:04:05 /usr/bin/virtuoso-t() [0x6b3375]
> 21:04:05 /usr/bin/virtuoso-t() [0xb097dc]
> 21:04:05 /usr/bin/virtuoso-t() [0xb15a4c]
> 21:04:05 /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182) [0x7f5472cf6182]
> 21:04:05 /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f547230047d]
> 21:04:05 GPF: disk.c:298 page set checksum error
>
> Did a full backup today again with processes writing to virtuoso stopped
> and it passed successfully.
>
> What can cause this? Is some other session/connection causing checkpoint
> or changing the page while backup is running? Am I missing some command
> that virtuoso built in incremental backup is executing to disable
> changes to pages meant for backup?
>
>
> Sincerely.
>
> Piret
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
