---
Ken Weiss
ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>
UC Office of the President 510-587-6311 (office)
California Digital Library 916-905-6933 (mobile)
UC Curation Center
415 20th Street, 4th Flo
n
>
> ------------
> Ken Weiss ken.we...@ucop.edu
> <mailto:ken.we...@ucop.edu>
> UC Office of the President 510-587-6311
-
Ken Weiss
ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>
UC Office of the President 510-587-6311 (office)
California Digital Library 916-905-6933 (mobile)
UC Curation Center
415 20th Street
rtuoso-users] Migrate database from Virtuoso v6 to v7
Hi Ken,
Try connecting to a running instance of the v6 with the “isql” command line
tool and run a “checkpoint;” followed immediately by “shutdown” and the trx
file should then be 0 bytes:
Hughs-MBP:database hwilliams$ ../bin/isql
Con
; 415 20th Street, 4th Floor
> Oakland, CA 94612
>
>
> From: Hugh Williams <mailto:hwilli...@openlinksw.com>>
> Date: Friday, May 8, 2015 6:36 PM
> To: Ken Weiss mailto:ken.we...@ucop.edu>>
> Cc: "virtuoso-users@lists.sourceforge.net
> <mailto:virtuoso-users@lists.s
From: Hugh Williams mailto:hwilli...@openlinksw.com>>
Date: Friday, May 8, 2015 6:36 PM
To: Ken Weiss mailto:ken.we...@ucop.edu>>
Cc:
"virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net>"
mailto:virtuoso-users@lists.sourceforge.net>
Hi Ken,
You need to run the “checkpoint;” command from isql to commit all pending
transactions in the “virtuoso.trx” to the database file “virtuoos.db” , so the
trx file is 0 bytes, otherwise you get that transaction log version mismatch
error, see:
http://virtuoso.openlinksw.com/data
I should have added that the 4-step process I described using +backup-dump and
+restore-crash-dump works perfectly to move the database from one version 6
instance to another. It only fails when I try to move from version 6 to version
7.
--Ken
---
I am trying to migrate a database from Virtuoso version 6 to version 7, without
success. Here is the procedure I tried:
1) Shut down the version 6 database
2) Make an offline dump of the version 6 database as follows:
./virtuoso-iodbc-t -c ../var/lib/virtuoso/ontowiki/virtuoso.ini +backup-dump -
