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