xythos:upgrade_times_log
Warning: Undefined array key 22 in /usr/share/dokuwiki/inc/html.php on line 1453
Warning: Undefined array key -1 in /usr/share/dokuwiki/inc/html.php on line 1458
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
xythos:upgrade_times_log [2011/07/28 09:55] hmeij created |
xythos:upgrade_times_log [2011/08/01 11:46] hmeij [Qs] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | WINDOWS | + | ====== Qs ====== |
| + | |||
| + | Upgrade path: Each time we took a copy of production, changed database name and user/ | ||
| + | |||
| + | * #1 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)\\ | ||
| + | |||
| + | * #2 When executing fixServerPrincipleIDs script dev server can remain up (we tested). Is this true/ | ||
| + | * #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). | ||
| + | * #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 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 -- | ||
| + | Jul 26, 2011 11:25:24 PM -- | ||
| + | Jul 26, 2011 11:25:25 PM -- | ||
| + | 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 -- | ||
| + | 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 \\ | ||
| + | ...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) ====== | ||
| > Anyway, on test database yesterday, db objects update took: | > Anyway, on test database yesterday, db objects update took: | ||
| Line 7: | Line 108: | ||
| > Home schema: ~30mins | > Home schema: ~30mins | ||
| > Internal fix: ~2hours | > Internal fix: ~2hours | ||
| + | >7.2.88 to 7.2.91 requires a database object update that took ~30mins on xydev | ||
| - | 7.2.88 to 7.2.91 requires a database object update that took ~30mins on xydev | + | > Last Friday on production: |
| - | + | ||
| - | > Last Friday on production: | + | |
| > -------------------------- | > -------------------------- | ||
| > Global schema: ~30mins | > Global schema: ~30mins | ||
| > Data schema: ~50mins | > Data schema: ~50mins | ||
| > Home schema: ~45mins | > Home schema: ~45mins | ||
| - | > Internal fix started at 3:06pm, aborted ~7:30pm... 4 HRS aborted, on retry 7-8 HRS ...abortedJust | + | > Internal fix started at 3:06pm, aborted ~7:30pm... 4 hours, |
| + | |||
| + | |||
| + | Just looking through the old install.log(s) | ||
| Install.log start of July 9th from prod. | 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 ' | + | Start of Document Store ' |
| - | Completion of Document STore ' | + | Completion of Document STore ' |
| - | Analysis of database done: 11:00 (~25 minutes) | + | Analysis of database done: 11:00 (~25 minutes)\\ |
| - | Start of Document Store ' | + | Start of Document Store ' |
| - | Completion of Document Store ' | + | Completion of Document Store ' |
| - | 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 ' | ||
| - | Completion of Document STore ' | ||
| - | Anaylsis done - 4:10 (~ 13 minutes) | ||
| - | STart of Document STore ' | ||
| - | 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) | ||
| - | 7_2_internal_id_fix (#1) - 6:17 PM (1 hour, 27 minutes) | ||
| - | 7_2_internal_id_fix (#2) - 7:25 PM (1 hour, 8 minutes) | ||
| - | 7_2_internal_id_fix (#3) - 7:25 PM (1 hour, 0 minutes) | ||
xythos/upgrade_times_log.txt · Last modified: 2011/08/01 11:46 by hmeij
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
