Differences

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

--- xythos:upgrade_times_log [2011/07/28 13:55]
hmeij created
+++ xythos:upgrade_times_log [2011/07/28 19:35]
hmeij [UPGRADE TIMES BY MATT/HENK]
@@ Line 1: / Line 1: @@
-WINDOWS
+====== Qs ======
+  * can we get rid of the prompting? username/passwd, tables for datastores?
+  * what causes the internal id fix to take so long when content is present vs no content?
+  *
+====== UPGRADE TIMES BY MATT/HENK ======
+FIRST: **copy of prod db on filer1, no content\\
+exactly what hong did, achieved about similar times, roughly 6 hours + pre/post work**\\
+...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 \\
+Jul 26, 2011 7:57:46 PM -- Successfully upgraded the Xythos Document Store: 'Data Document Store - 1:40 \\
+Jul 26, 2011 8:35:19 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 2:15 \\
+Jul 26, 2011 8:50:50 PM -- Workflow data upgrade completed - 2:30 \\
+Jul 26, 2011 10:17:28 PM --     7_2_internal_id_fix - 4:00 \\
+Jul 26, 2011 11:25:24 PM --     7_2_internal_id_fix - 5:15 \\
+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 \\
+...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 \\
+Jul 27, 2011 2:51:48 PM -- Successfully upgraded the Xythos Document Store: 'Data Document Store - 0:20 \\
+Jul 27, 2011 3:07:28 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 0:35 \\
+Jul 27, 2011 3:20:47 PM -- Exited successfully - 0:50 \\
+SECOND: **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 \\
+Jul 27, 2011 7:45:57 PM -- Successfully upgraded the Xythos Document Store: 'Data Document Store - 0:50 \\
+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 <------------ 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, roughly XX hours + pre/post work**\\
+...hotfix 7.1.37_24 on current version...\\
+download and unpack
+fix java path or stage old java
+./fixServerPrincipleIDs -a [test|fix] ... server remains up, test=7mins, fix=
+...internal fid fix utility...\\
+...upgrade to 7.2.88...\\
+...hotfix 7.2.88.sp2...\\
+====== UPGRADE TIMES BY HONG (copy of prod db on filer1 no content) ======
 > Anyway, on test database yesterday, db objects update took:
@@ Line 7: / Line 66: @@
 > Home schema: ~30mins
 > Internal fix: ~2hours
+>7.2.88 to 7.2.91 requires a database object update that took ~30mins on xydev
-.2.88 to 7.2.91 requires a database object update that took ~30mins on xydev
+> Last Friday on production: (upgrade of prod db on filer4)
-> Last Friday on production:
 > --------------------------
 > Global schema: ~30mins
 > Data schema: ~50mins
 > Home schema: ~45mins
-> Internal fix started at 3:06pm, aborted ~7:30pm... 4 HRS aborted, on retry 7-8 HRS ...abortedJust looking through the old install.log(s)
+> Internal fix started at 3:06pm, aborted ~7:30pm... 4 hours, aborted, on retry 7-8 hours ...aborted
+Just looking through the old install.log(s)
 Install.log start of July 9th from prod.
-Start - 9:34 PM
+Start - 9:34 PM\\
-Global Schema done:  10:00 (~26 minutes)
+Global Schema done:  10:00 (~26 minutes)\\
-Analysis done: 10:04 (~4 minutes)
+Analysis done: 10:04 (~4 minutes)\\
-Start of Document Store 'Data' - 10:16
+Start of Document Store 'Data' - 10:16\\
-Completion of Document STore 'data'e: 10:35 (~ 19 minutes)
+Completion of Document STore 'data'e: 10:35 (~ 19 minutes)\\
-Analysis of database done: 11:00 (~25 minutes)
+Analysis of database done: 11:00 (~25 minutes)\\
-Start of Document Store 'Home' - 11:06
+Start of Document Store 'Home' - 11:06\\
-Completion of Document Store 'Home' - 11:22 (~15 minutes)
+Completion of Document Store 'Home' - 11:22 (~15 minutes)\\
-Database Analysis Done: 11:47 (~ 25 minutes)
+Database Analysis Done: 11:47 (~ 25 minutes)\\
-Workflow Upgrades: 11:47
+Workflow Upgrades: 11:47\\
-Workflow completed: 11:53 (~6 minutes)
+Workflow completed: 11:53 (~6 minutes)\\
-*ABORTED BEFORE ANYTHING WRITTEN OUT TO INSTALL.LOG*
+*ABORTED BEFORE ANYTHING WRITTEN OUT TO INSTALL.LOG*\\
-Today (and we're still stuck in a limbo after workflow):
-Start - 2:45
-Global Schema Done: 3:16 (~31 minutes)
-Analysis of database done: 3:18 (~2 minutes)
-Start of Document Store 'Data' - 3:38 (because we hadn't pushed enter)
-Completion of Document STore 'Data' - 3:57 (~19 minutes)
-Anaylsis done - 4:10  (~ 13 minutes)
-STart of Document STore 'Home' - 4:21 (delay because we hadn't pushed
-enter)
-Completion of Document Store: 4:35 (~ 14 minutes)
-Database Anlysis: 4:44 ( ~ 9 minutes)
-STart of workflow: 4:44
-Workflow completed: 4:50 (~ 6 minutes)
-_2_internal_id_fix (#1) - 6:17 PM (1 hour, 27 minutes)
-_2_internal_id_fix (#2) - 7:25 PM (1 hour, 8 minutes)
-_2_internal_id_fix (#3) - 7:25 PM (1 hour, 0 minutes)

DokuWiki

User Tools

Site Tools

Differences

Page Tools