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 14:01] hmeij |
xythos:upgrade_times_log [2011/07/28 17:53] hmeij |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | UPGRADE TIMES BY MATT/HENK (copy of prod db on filer1, no content) | + | ====== Qs ====== |
- | exactly what hong did, achieved about similar times, roughly 4 hours | + | * can we get rid of the prompting? username/ |
+ | * what causes the internal id fix to take so long when content is present vs no content? | ||
+ | | ||
- | Start - 2:45\\ | + | ====== UPGRADE TIMES BY MATT/HENK ====== |
- | 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)\\ | + | |
+ | 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, roughly XX hours + pre/post work**\\ | ||
+ | ...hotfix 7.1.37_24 on current version...\\ | ||
+ | ...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: | > Anyway, on test database yesterday, db objects update took: |