|
From: Ken W. <ken...@uc...> - 2015-05-08 18:37:17
|
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 -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.ini +restore-crash-dump -f I get the following error: 11:03:05 OpenLink Virtuoso Universal Server 11:03:05 Version 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'. The version of this server is '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' 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-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.RES_SIZE. -- #line 4636 "[executable]/dav.sql" create trigger SYS_DAV_RE 11:07:21 Error compiling stored procedure: 42S22: SQ062: No column O.RES_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.HTML_RETRIEVE_TABLES" overruled by the RDBMS 11:07:21 built-in procedure "PUMP.DBA.HTML_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.RESTORE_TABLES_AND_PARS_RETRIEVE" overruled by the RDBMS 11:07:21 built-in procedure "DB.DBA.RESTORE_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'. The version of this server is '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' 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...@uc...<mailto:ken...@uc...> UC Office of the President 510-587-6311 (office) California Digital Library 916-905-6933 (mobile) UC Curation Center 415 20th Street, 4th Floor Oakland, CA 94612 |