This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
xythos:upgrade_times_log [2011/07/28 15:29] hmeij |
xythos:upgrade_times_log [2011/08/01 15:20] hmeij |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | UPGRADE TIMES BY MATT/ | + | ====== Qs ====== |
- | **copy of prod db on filer1, no content\\ | + | Upgrade path: Each time we took a copy of production, changed database name and user/ |
- | exactly what hong did, achieved about similar times, roughly | + | |
- | ...upgrade... | + | * Can we get rid of the prompting when upgrading? (username/ |
+ | |||
+ | | ||
+ | |||
+ | stage version 7.1.37.13\\ | ||
+ | ./ | ||
+ | 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)\\ | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ====== UPGRADE TIMES BY MATT/HENK ====== | ||
+ | |||
+ | |||
+ | FIRST: | ||
+ | exactly what hong did, achieved about similar times, roughly | ||
+ | ...upgrade | ||
Jul 26, 2011 6:18:27 PM -- Xythos Database Schema Installer Version 7.2.88.1020 - (cumulative time) \\ | 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:16:24 PM -- Successfully upgraded the Xythos Global Schema - 1:00 \\ | ||
Line 13: | Line 33: | ||
Jul 26, 2011 11:25:25 PM -- | Jul 26, 2011 11:25:25 PM -- | ||
Jul 26, 2011 11:25:27 PM -- Exited successfully - 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: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:45:41 PM -- Successfully upgraded the Xythos Global Schema - 0:15 \\ | ||
Line 20: | Line 40: | ||
Jul 27, 2011 3:20:47 PM -- Exited successfully - 0:50 \\ | Jul 27, 2011 3:20:47 PM -- Exited successfully - 0:50 \\ | ||
- | **copy of prod db on filer1, with content\\ | + | SECOND: |
- | ...upgrade...\\ | + | ...upgrade |
Jul 27, 2011 6:35:55 PM -- Xythos Database Schema Installer Version 7.2.88.1020 - (cumulative time)\\ | 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:15:16 PM -- Successfully upgraded the Xythos Global Schema - 0:40 \\ | ||
Line 27: | Line 47: | ||
Jul 27, 2011 8:49:45 PM -- Successfully upgraded the Xythos Document Store: 'Home Document Store - 1:45 \\ | 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 27, 2011 9:12:07 PM -- Workflow data upgrade completed - 2:15 \\ | ||
- | Jul 28, 2011 10:24:18 AM -- | + | Jul 28, 2011 10:24:18 AM -- |
Jul 28, 2011 2:25:43 PM -- | Jul 28, 2011 2:25:43 PM -- | ||
Jul 28, 2011 2:25:43 PM -- | Jul 28, 2011 2:25:43 PM -- | ||
Jul 28, 2011 2:25:43 PM -- Exited successfully - 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\\ | ||
+ | ./ | ||
+ | ...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 | ||
+ | ...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 -- | ||
+ | Jul 29, 2011 5:51:07 PM -- | ||
+ | Jul 29, 2011 5:51:07 PM -- | ||
+ | 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: | > Anyway, on test database yesterday, db objects update took: |