Tried that, too. Same result, 87 byte .trx file.
Sent from my Virgin Mobile phone.
------ Original message------
From: Hugh Williams
Date: Wed, May 13, 2015 5:51 PM
To: Ken Weiss;
Cc:
virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net>;
Subject:Re: [Virtuoso-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 1111
Connected to OpenLink Virtuoso
Driver: 06.01.3127<tel:06.01.3127> OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> checkpoint;
Done. -- 64 msec.
SQL> shutdown;
Hughs-MBP:database hwilliams$ ls -ltr virtuoso.tr<http://virtuoso.tr>x
-rw-r--r--@ 1 root wheel 0 14 May 01:34 virtuoso.tr<http://virtuoso.tr>x
Hughs-MBP:database hwilliams$
It seems the +checkpoint-only server option does not truncate the log to 0
bytes:
Hughs-MBP:database hwilliams$ sudo ../bin/virtuoso-t +checkpoint-only
Hughs-MBP:database hwilliams$ ls -ltr virtuoso.tr<http://virtuoso.tr>x
-rw-r--r--@ 1 root wheel 155 14 May 01:33
virtuoso.tr<http://virtuoso.tr>x
Hughs-MBP:database hwilliams$
Will have to get the option checked …
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 14 May 2015, at 00:04, Ken Weiss
<ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>> wrote:
Hugh,
Thanks for the suggestion, and for the link to the documentation. I tried
following that procedure, but I end up with a .trx file of 87 bytes, not zero.
First I made sure virtuoso was not running:
udfr@uc3-udfr-prd:~/apps/virtuoso-opensource-version$ ps -ef | grep virtuoso
udfr 25078 24905 0 15<tel:25078%2024905%20 0%2015>:55 pts/0 00:00:00
grep virtuoso
Then I started the server with the +checkpoint-only flag set. I also ran it in
foreground so I could see the log, but got the exact same result when I tried
running in background.
udfr@uc3-udfr-prd:~/apps/virtuoso-opensource-version$ ./bin/virtuoso-iodbc-t -c
./var/lib/virtuoso/ontowiki/virtuoso.in<http://virtuoso.in>i +checkpoint-only -f
Wed May 13 2015
15:56:12 { Loading plugin 1: Type `plain', file `wikiv' in
`/apps/udfr/apps/virtuoso-opensource-version/lib/virtuoso/hosting'
15:56:12 WikiV version 0.6 from OpenLink Software
15:56:12 Support functions for WikiV collaboration tool
15:56:12 SUCCESS plugin 1: loaded from
/apps/udfr/apps/virtuoso-opensource-version/lib/virtuoso/hosting/wikiv.so<http://wikiv.so>
}
15:56:12 { Loading plugin 2: Type `plain', file `mediawiki' in
`/apps/udfr/apps/virtuoso-opensource-version/lib/virtuoso/hosting'
15:56:12 MediaWiki version 0.1 from OpenLink Software
15:56:12 Support functions for MediaWiki collaboration tool
15:56:12 SUCCESS plugin 2: loaded from
/apps/udfr/apps/virtuoso-opensource-version/lib/virtuoso/hosting/mediawiki.so<http://mediawiki.so>
}
15:56:12 { Loading plugin 3: Type `plain', file `creolewiki' in
`/apps/udfr/apps/virtuoso-opensource-version/lib/virtuoso/hosting'
15:56:12 CreoleWiki version 0.1 from OpenLink Software
15:56:12 Support functions for CreoleWiki collaboration tool
15:56:12 SUCCESS plugin 3: loaded from
/apps/udfr/apps/virtuoso-opensource-version/lib/virtuoso/hosting/creolewiki.so<http://creolewiki.so>
}
15:56:12 OpenLink Virtuoso Universal Server
15:56:12 Version 06.01.3127<tel:06.01.3127>-pthreads for Linux as of Jan 24 2012
15:56:12 uses parts of OpenSSL, PCRE, Html Tidy
15:56:12 Database version 3126
15:56:12 SQL Optimizer enabled (max 1000 layouts)
15:56:13 Compiler unit is timed at 0.000443 msec
15:56:13 Roll forward started
15:56:13 2 transactions, 87 bytes replayed (100 %)
15:56:13 Roll forward complete
15:56:14 Checkpoint started
15:56:14 Checkpoint finished, new log is
/apps/udfr/apps/virtuoso-opensource-version/var/lib/virtuoso/db/virtuoso20150513155614.tr<http://virtuoso20150513155614.tr>x
15:56:14 Server exiting
So far, so good. But when I look at that new log file
(virtuoso20150513155614.tr<http://virtuoso20150513155614.tr>x), it's 87 bytes,
not zero:
udfr@uc3-udfr-prd:~/apps/virtuoso-opensource-version$ ls -l
var/lib/virtuoso/db/virtuoso20150513155614.tr<http://virtuoso20150513155614.tr>x
-rw-r--r-- 1 udfr udfr 87 May 13 15:56
var/lib/virtuoso/db/virtuoso20150513155614.tr<http://virtuoso20150513155614.tr>x
The guide you pointed me to said, "If larger .trx files persist, contact
Technical Support<http://support.openlinksw.com/support/online-support.vsp>.",
so I guess that's what I'll do.
--Ken
------------------------------------------------------------
Ken Weiss
ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>
UC Office of the President 510-587-6311<tel:510-587-6311> (office)
California Digital Library 916-905-6933<tel:916-905-6933> (mobile)
UC Curation Center
415 20th Street, 4th Floor
Oakland, CA 94612
From: Hugh Williams <hwilli...@openlinksw.com<mailto:hwilli...@openlinksw.com>>
Date: Friday, May 8, 2015 6:36 PM
To: Ken Weiss <ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>>
Cc:
"virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net>"
<virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net>>
Subject: Re: [Virtuoso-users] Migrate database from Virtuoso v6 to v7
Hi Ken,
You need to run the “checkpoint;” command from isql to commit all pending
transactions in the “virtuoso.tr<http://“virtuoso.tr>x” 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/dataspace/doc/dav/wiki/Main/UpgradingToVOS610#Upgrading%20from%20Release%206.x%20to%20Release%207.x
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 8 May 2015, at 19:26, Ken Weiss
<ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>> wrote:
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
------------------------------------------------------------
Ken Weiss
ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>
UC Office of the President 510-587-6311<tel:510-587-6311> (office)
California Digital Library 916-905-6933<tel:916-905-6933> (mobile)
UC Curation Center
415 20th Street, 4th Floor
Oakland, CA 94612
From: Ken Weiss <ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>>
Date: Friday, May 8, 2015 11:19 AM
To:
"virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net>"
<virtuoso-users@lists.sourceforge.net<mailto:virtuoso-users@lists.sourceforge.net>>
Subject: Migrate database from Virtuoso v6 to v7
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.in<http://virtuoso.in>i +backup-dump -f
3) Copy the .trx files from the db directory for version 6 to the db directory
for version 7
4) Attempt to restore the offline dump as follows:
./virtuoso-iodbc-t -c
../var/lib/virtuoso/ontowiki/virtuoso.in<http://virtuoso.in>i
+restore-crash-dump -f
I get the following error:
11:03:05 OpenLink Virtuoso Universal Server
11:03:05 Version 07.20.3212<tel:07.20.3212>-pthreads for Linux as of May 8 2015
11:03:05 uses parts of OpenSSL, PCRE, Html Tidy
11:03:05 Database version 3126
11:03:05 SQL Optimizer enabled (max 1000 layouts)
11:03:05 Roll forward started
11:03:05 The transaction log file has been produced by server version
'06.01.3127<tel:06.01.3127>'. The version of this server is
'07.20.3212<tel:07.20.3212>'. If the transaction log is empty or you do not
want to replay it then delete it and start the server again. Otherwise replay
the log using the server of version '06.01.3127<tel:06.01.3127>' and make
checkpoint and shutdown to ensure that the log is empty, then delete it and
start using new version.
I also tried simply copying the virtuoso.db file from the version 6
installation to a freshly built version 7, and got the exact same error when I
start the version 7 instance, plus a bunch of errors that I assume are due to
missing tables and schema elements:
11:07:19 OpenLink Virtuoso Universal Server
11:07:19 Version 07.20.3212<tel:07.20.3212>-pthreads for Linux as of May 8 2015
11:07:19 uses parts of OpenSSL, PCRE, Html Tidy
11:07:19 Database version 3126
11:07:19 SQL Optimizer enabled (max 1000 layouts)
11:07:20 Compiler unit is timed at 0.000202 msec
11:07:21 built-in procedure "repl_undot_name" overruled by the RDBMS
11:07:21 Error compiling stored procedure: 42S22: SQ062: No column
N.RE<http://N.RE>S_SIZE. -- #line 4636 "[executable]/dav.sql"
create trigger SYS_DAV_RE
11:07:21 Error compiling stored procedure: 42S22: SQ062: No column
O.RE<http://O.RE>S_SIZE. -- #line 4728 "[executable]/dav.sql"
create trigger SYS_DAV_RE
11:07:21 Error compiling stored procedure: 42S22: SQ063: No column RES_SIZE. --
#line 5185 "[executable]/dav.sql"
create trigger SYS_DAV_RE
11:07:21 built-in procedure "adm_lt_make_dsn_part" overruled by the RDBMS
11:07:21 built-in procedure "adm_next_checkbox" overruled by the RDBMS
11:07:21 built-in procedure "adm_lt_dsn_options" overruled by the RDBMS
11:07:21 built-in procedure "vector_print" overruled by the RDBMS
11:07:21 built-in procedure "adm_get_file_dsn" overruled by the RDBMS
11:07:21 built-in procedure "adm_get_init_name" overruled by the RDBMS
11:07:21 built-in procedure "adm_make_option_list" overruled by the RDBMS
11:07:21 built-in procedure "adm_is_hosted" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_get_uid" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_user_can_read_col_p" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_user_can_read_res_p" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_uid_to_user" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_uid_to_group" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_fmt_perm" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_list_error" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_map_icon" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_fmt_col" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_fmt_res" overruled by the RDBMS
11:07:21 built-in procedure "adm_path_normalize" overruled by the RDBMS
11:07:21 built-in procedure "adm_file_like" overruled by the RDBMS
11:07:21 built-in procedure "adm_os_br_gen_col_c_listing" overruled by the RDBMS
11:07:21 built-in procedure "adm_dav_br_gen_col_c_listing" overruled by the
RDBMS
11:07:21 built-in procedure "PUMP.DBA.__GET_KEYWORD" overruled by the RDBMS
11:07:21 built-in procedure "PUMP.DBA.URLIFY_STRING" overruled by the RDBMS
11:07:21 built-in procedure "PUMP.DBA.__GET_TEMPORARY" overruled by the RDBMS
11:07:21 built-in procedure "PUMP.DBA.DBPUMP_START_COMPONENT" overruled by the
RDBMS
11:07:21 built-in procedure "PUMP.DBA.DBPUMP_RUN_COMPONENT" overruled by the
RDBMS
11:07:21 built-in procedure "PUMP.DBA.HT<http://PUMP.DBA.HT>ML_RETRIEVE_TABLES"
overruled by the RDBMS
11:07:21 built-in procedure
"PUMP.DBA.HT<http://PUMP.DBA.HT>ML_RETRIEVE_QUALIFIERS_VIA_PLSQL" overruled by
the RDBMS
11:07:21 built-in procedure "PUMP.DBA.DUMP_TABLES_AND_PARS_RETRIEVE" overruled
by the RDBMS
11:07:21 built-in procedure
"PUMP.DBA.RE<http://PUMP.DBA.RE>STORE_TABLES_AND_PARS_RETRIEVE" overruled by
the RDBMS
11:07:21 built-in procedure "DB.DBA.RE<http://DB.DBA.RE>STORE_DBPUMP'S_FOLDER"
overruled by the RDBMS
11:07:21 Roll forward started
11:07:21 The transaction log file has been produced by server version
'06.01.3127<tel:06.01.3127>'. The version of this server is
'07.20.3212<tel:07.20.3212>'. If the transaction log is empty or you do not
want to replay it then delete it and start the server again. Otherwise replay
the log using the server of version '06.01.3127<tel:06.01.3127>' and make
checkpoint and shutdown to ensure that the log is empty, then delete it and
start using new version.
11:07:21 Server exiting
Can anyone give me a procedure to migrate a version 6 database to version 7?
--Ken
------------------------------------------------------------
Ken Weiss
ken.we...@ucop.edu<mailto:ken.we...@ucop.edu>
UC Office of the President 510-587-6311<tel:510-587-6311> (office)
California Digital Library 916-905-6933<tel:916-905-6933> (mobile)
UC Curation Center
415 20th Street, 4th Floor
Oakland, CA 94612
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net<mailto:Virtuoso-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
