STILL UNDER CONSTRUCTION [Note, the fallback release is April 17, 2010]
Start time: 3:45am
End time: 8:00am
Personnel: • Kirk
- Kirk Alexander
...
- Sandra Stewart
- Pete Peterson
- David Woods
- UC Davis programming team
...
- rSmart programming team
Communication • server
- server: irc.freenode.net
...
- channel: #ucdsakai
During Maintenance Window
Pre Implementation tasks
(March 16, rSmart team) check out SAK-3163.patch for Gradebook 2 from our subversion patches director.
...
Prepare Prod local.properties file for tag 2.6.2.13 wrt RSN-3986-8307456
During the Implementation rollout • Add
- Add database markers.
...
- (3:45am, rSmart) Place SmartSite-prod into maintenance mode and stop ALL TomCats. #1
...
- (3:45am to 5:00am, already scheduled run) Allow already scheduled back up of internal database to run.
...
- (5:00am, rSmart) rSmart will
...
- (5:00am to 5:02, rSmart) run the script for RSN-3986-8306969 to change the MOTD tool. See bottom of doc for sql. This SQL also exists on the production db server in /home/oracle/apr13.motd.sql AND run April 13th GB2 SQL in same location (see sql at end of doc)
...
- (4:00am to 5:30, rSmart) for RSN-3986-8306769, change the number of qmail connection to 200 and recompile qmail.
...
- (5:00a to 5:30am, rSmart) Deploy tag 2.6.2.13 on SmartSite-Prod. Code will be compiled beforehand and just deployed at this point. Total time is 15 minutes, but it can be started any time after 3:45am after tomcat is stopped.
...
- (N/A, rSmart) Retrieve attachment from RSN: 3986-8306816 ticket and apply to SmartSite prod. This code is already in the 2.6.2.12 tag
...
- (5:31am to , rSmart) RSN-3986-8307016, repair tools that need OSIV per lazy loading issues: Lazy loading exception in WebContent tool
o ( , rSmart) RSN-3986-8307456, Check out properties to Prod local.properties file.
o ( ,rSmart) RSN-3986-8307376, gradebook.editAssignments permission needs to be removed from TA Role. This is database sql.
o (5:30am to 5:35am, rSmart) Bring up one node, still in maintenance mode, for QA verification.
Content and Function Verification Testing
• (5:35am to 5:55***am, UCDavis) QA will verify that the system has been successfully upgraded by doing the following:
o Verify that we can search on a student name in Gradebook (on the spreadsheet side)
o Verify that TA’s do not have permission to change category and item set up in Gradebook.
o Verify that a new site with gradebook will open immediately and not require refreshing for it to open.
o Verify that duplicate sections is fixed
• (5:55am--6:00am, rSmart and UCDavis) Team will decide go or roll back.
...