• 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?

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
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…
…internal fid fix utility…
…upgrade to 7.2.88…
…hotfix 7.2.88.sp2…

Anyway, on test database yesterday, db objects update took:

Global schema: ~30mins
Data schema: ~30mins
Home schema: ~30mins
Internal fix: ~2hours
7.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)
————————–
Global schema: ~30mins
Data schema: ~50mins
Home schema: ~45mins
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
Global Schema done: 10:00 (~26 minutes)
Analysis done: 10:04 (~4 minutes)
Start of Document Store 'Data' - 10:16
Completion of Document STore 'data'e: 10:35 (~ 19 minutes)
Analysis of database done: 11:00 (~25 minutes)
Start of Document Store 'Home' - 11:06
Completion of Document Store 'Home' - 11:22 (~15 minutes)
Database Analysis Done: 11:47 (~ 25 minutes)
Workflow Upgrades: 11:47
Workflow completed: 11:53 (~6 minutes)
*ABORTED BEFORE ANYTHING WRITTEN OUT TO INSTALL.LOG*