Differences

This shows you the differences between two versions of the page.

--- xythos:upgrade_times_log [2011/07/28 15:29]
hmeij
+++ xythos:upgrade_times_log [2011/08/01 15:46] (current)
hmeij [Qs]
@@ Line 1: / Line 1: @@
-UPGRADE TIMES BY MATT/HENK
+====== Qs ======
+Upgrade path:  Each time we took a copy of production, changed database name and user/password properties (xml properties file and inside database). Also staged content area (except in FIRST).  We have 5 questions:
+  * #1 Can we get rid of the prompting when upgrading? (username/passwd, tables for datastores ... just accept defaults provided)
+ Summary of THIRD attempt:
+stage version 7.1.37.13\\
+./fixServerPrincipleIDs -a [test|fix] ... server remains up !! test=7 mins, fix=20 hours \\
+hotfix 7.1.37_sp2 (skipped)\\
+upgrade to 7.2.88 (1:50)\\
+hotfix 7.2.88.sp2 (skipped)\\
+upgrade 7.2.91 (1:10)\\
+  * #2 When executing fixServerPrincipleIDs script dev server can remain up (we tested). Is this true/advisable for production upgrade?
+  * #3 If yes above, should we while production is up, consider running in batches (directory trees) or all at once?
+  * #4 If answer is no, server must be down: when we apply the 7.2.88 upgrade (without fixServerPrincipleIDs script manually, this upgrade seems to automatically invoke it) script **and** upgrade take 19 hours (second attempt) versus script by itself only takes 20 hours (third attempt).  Why?
+  * #5 Can we skip the hotfix upgrades after running the script and go directly to 7.2.88, then to 7.2.91?
+====== UPGRADE TIMES BY MATT/HENK ======
+**FIRST:** \\
 **copy of prod db on filer1, no content\\
-exactly what hong did, achieved about similar times, roughly 5 hours**
+exactly what hong did, achieved about similar times, roughly 6 hours + pre/post work**\\
-...upgrade...
+...upgrade to 7.2.88...\\
 Jul 26, 2011 6:18:27 PM -- Xythos Database Schema Installer Version 7.2.88.1020 - (cumulative time) \\
 Jul 26, 2011 7:16:24 PM -- Successfully upgraded the Xythos Global Schema - 1:00 \\
@@ Line 13: / Line 40: @@
 Jul 26, 2011 11:25:25 PM --     7_2_internal_id_fix - 5:15 \\
 Jul 26, 2011 11:25:27 PM -- Exited successfully - 5:15 \\
-...apply path...\\
+...hotfix 7.2.88.sp2...\\
 Jul 27, 2011 2:31:53 PM -- Xythos Database Schema Installer Version 7.2.88.1020 - (cumulative time)\\
 Jul 27, 2011 2:45:41 PM -- Successfully upgraded the Xythos Global Schema - 0:15 \\
@@ Line 20: / Line 47: @@
 Jul 27, 2011 3:20:47 PM -- Exited successfully - 0:50 \\
-**copy of prod db on filer1, with content\\
+**SECOND:**\\
-...upgrade...\\
+**copy of prod db on filer4, with content, roughly 20 hours + pre/post work**\\
+...upgrade to 7.2.88...\\
 Jul 27, 2011 6:35:55 PM -- Xythos Database Schema Installer Version 7.2.88.1020 - (cumulative time)\\
 Jul 27, 2011 7:15:16 PM -- Successfully upgraded the Xythos Global Schema - 0:40 \\
@@ Line 27: / Line 55: @@
 Jul 27, 2011 8:49:45 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 1:45 \\
 Jul 27, 2011 9:12:07 PM -- Workflow data upgrade completed - 2:15 \\
-Jul 28, 2011 10:24:18 AM --     7_2_internal_id_fix - 15:00 \\
+Jul 28, 2011 10:24:18 AM --     7_2_internal_id_fix - 15:00 <------------ the hang over \\
 Jul 28, 2011 2:25:43 PM --     7_2_internal_id_fix - 19:00 \\
 Jul 28, 2011 2:25:43 PM --     7_2_internal_id_fix - 19:00 \\
 Jul 28, 2011 2:25:43 PM -- Exited successfully - 19:00 \\
+...hotfix 7.2.88.sp2...\\
+Jul 28, 2011 3:12:29 PM -- Xythos Database Schema Installer Version 7.2.91.1042 - (cumulative time)
+Jul 28, 2011 3:12:59 PM -- Successfully upgraded the Xythos Global Schema - 0:01 \\
+Jul 28, 2011 3:17:31 PM -- Successfully upgraded the Xythos Document Store: 'Data Document Store - 0:05 \\
+Jul 28, 2011 3:32:00 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 0:20 \\
+Jul 28, 2011 3:50:01 PM -- Exited successfully - 0:20\\
+**THIRD:**\\
+**copy of prod db on filer4, with content **\\
+...hotfix 7.1.37_24 (contains the fixInternalPrincipalIDs script ) on current version...\\
+download and unpack\\
+fix java path or stage old java\\
+./fixServerPrincipleIDs -a [test|fix] ... server remains up !! test=7 mins, fix=20 hours \\
+...3:45 pm -> 11:45 am basically, 20 hours, NOTE this is longer than upgrade (includes fix) in step 2\\
+...but then the server must be down, using the utility it appears it can remain up (verify with xythos)\\
+...internal fix utility results: broken in home 210, broken in data 1,296 \\
+...upgrade to 7.1.37_sp2  (needed ???  time ???) \\
+...upgrade to 7.2.88...\\
+Jul 29, 2011 4:02:52 PM -- Xythos Database Schema Installer Version 7.2.88.1020 - (cumulative time)\\
+Jul 29, 2011 4:35:55 PM -- Successfully upgraded the Xythos Global Schema - 0:35 \\
+Jul 29, 2011 5:00:20 PM -- Successfully upgraded the Xythos Document Store: 'Data Document Store - 1:00 \\
+Jul 29, 2011 5:28:44 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 1:30 \\
+Jul 29, 2011 5:46:42 PM -- Workflow data upgrade completed - 1:45 \\
+Jul 29, 2011 5:48:24 PM --     7_2_internal_id_fix - 1:50 \\
+Jul 29, 2011 5:51:07 PM --     7_2_internal_id_fix - 1:50 \\
+Jul 29, 2011 5:51:07 PM --     7_2_internal_id_fix - 1:50 \\
+Jul 29, 2011 5:51:08 PM -- Exited successfully - 1:50 \\
+...hotfix 7.2.88.sp2... (took 20 mins before, skip???)\\
+...upgrade 7.2.91 (with pauses)\\
+Jul 29, 2011 6:04:26 PM -- Xythos Database Schema Installer Version 7.2.91.1042 - (cumulative time) \\
+Jul 29, 2011 6:05:11 PM -- Successfully upgraded the Xythos Global Schema - 1:00 \\
+Jul 29, 2011 6:11:51 PM -- Successfully upgraded the Xythos Document Store: 'Data Document Store - 8:00 \\
+Jul 29, 2011 6:51:44 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 45:00 \\
+Jul 29, 2011 7:14:16 PM -- Exited successfully - 1:10 \\
+...matt states: upgraded 7.2.88 and then to 7.2.91 (with pauses \\
+...in between), starting at 12:00PM and finishing at 3:00PM -- check!)\\
+====== UPGRADE TIMES BY HONG (copy of prod db on filer1 no content) ======
-UPGRADE TIMES BY HONG (copy of prod db on filer1 no content)
 > Anyway, on test database yesterday, db objects update took:

DokuWiki

User Tools

Site Tools

Differences

Page Tools