Personnel:
- Prabhu E Pilli, DBA Implement/verification
- Jon Gorrono, QA verification
Communication
- server: irc.freenode.net
- channel: #ucdsakai
During Maintenance Window
Pre Implementation tasks
- (Prabhu) Run the following queries to compare with the results after the fix implementation.
select select mothraid,kerberos_name,deleted from cm_devsakaiext.mothra_person where mothraid in ('00133387', '00344830', '00600118', '00655505', '00589927', '00618662',
'00597123', '00396833');
Expected Expected Results:
MOTHRAID KERBEROS_NAME DELETED
===============================================
- 00133387 dhfeldma/DELETED
...
- N
- 00344830
...
- abarnes/DELETED N
- 00396833 zee/DELETED
...
- Y
- 00589927 jjhicks
...
- N
- 00597123
...
- zee
...
- N
- 00600118
...
- jazhicks N
- 00618662 dhfeldma N
- 00655505 abarnes N
During the Implementation rollout (all times are PST)
- (45:00 45 am, Prabhu) Backup current mothra package body and MOTHRA_PERSON table from SAKAIEXT schema on banner production.
- (46:45 am, Mark) Notify UCD about successful run of 6:00 am to 4:15 table switch
- (7:30 am to 7:45 am, Prabhu) Download https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakaiext_ban_prod/sakai_external_plsql.sql and run mothra feed package body. Make sure no errors returned.
- (47:20 45 am – 48:35 00 am, Prabhu) Execute the Mothra feed Package
Data Verification Testing
- (48:40 00 – 48:50am15am, Prabhu)
- Run the following queries to compare with the results after the fix implementation.
select mothraid,kerberos_name,deleted from cm_devsakaiext.mothra_person where mothraid in ('00133387', '00344830', '00600118', '00655505', '00589927', '00618662',
'00597123', '00396833'); Expected
Expected Results:
MOTHRAID MOTHRAID KERBEROS_NAME DELETED
===============================================00133387
- 00133387
...
- dhfeldma/DELETED Y
...
- 00344830 abarnes/DELETED Y
...
- 00396833 zee/DELETED Y
...
- 00589927 jjhicks
...
...
- N
- 00597123 zee
...
- N
- 00600118 jazhicks
...
- Y
- 00618662 dhfeldma
...
- N
- 00655505 abarnes N
Vote on to go
- (48:50 15 – 58:0030, Jon Gorrono) .
Rollback
- (58:00 45 am – 59:10 30 am Prabhu ) Restore the MOTHRA_PERSON table and mothra feed package body from the backup. Execute the mothra feed package.