Iframe | ||
---|---|---|
|
...
|
...
|
...
Iframe |
---|
Implementation Plan August 14, 2010 (rev0.4)
Personnel:
â—� Anand Mehta – Application Support Analyst (480-236-4203 cell)
â—� Mark Pankow – DBA (602-369-8714 cell)
â—� Lauren Brodsky – rSmart Project Manager (602-430-5218 cell)
â—� Sandra Stewart – UCD SmartSite Project Manager (530-219-3151 cell)
â—� Joyce Johnstone – UCD SmartSite Project Manager (916-204-9639 cell)
â—� Thomas Amsler – UCD SmartSite Programmer (916-803-2226 cell)
â—� Mike Wenk – UCD SmartSite Programmer (916-764-2312 cell)
â—� David Woods – UCD SmartSite Level 3 Support (530-400-2691 cell, 530-752-4901 office)
â—� Vernon O’Connor – rSmart QA Analyst Support (707-761-0541 cell)
â—� Fernando Socorro – UCD SmartSite Trainer (415-637-4026 cell 530-754-5194 office)
â—� Kirk Alexander – UCDavis Program Manager (530-753-4430 home, 530-902-7352 cell)
Communication:
This level of communication represents communications with the team involved in the rollout, during the roll out, e.g, programmers communicating with the project manager and QA people, etc. We chat using IRC.
â—� server: irc.freenode.net
â—� channel: #ucdsakai
Login for verification while prod is still in maintenance mode:
â—� https://smartsite.ucdavis.edu:8081/xsl-portal
â—� Enter via guest login.
â—� Use your Kerberos login and ID.
Pre Implementation tasks:
On Friday, August 13, 2010:
â—� Sandra and Fernando will set database markers.
â—� Anand Mehta will:
â—‹ Copy the existing Tomcat to tomcat-264 on all seven app servers
â—‹ Delete all CLE files from tomcat-264
â—‹ Build and deploy the 2.6.4 code to tomcat-264
â—‹ Make a copy of all properties file in the sakai directory and update the copies to 2.6.4 level
â—� Anand Mehta to set the Sakai properties:
Code Block |
---|
UCD Deployment Notes
-----------------------
1. Commands to remove old CLE files from Tomcat (executed from /home/ucdavis/cle/tomcat)
rm -rf shared/lib/*
rm -rf components
rm common/lib/sakai*
rm server/lib/sakai*
mv webapps/balancer /tmp; mv webapps/ROOT /tmp
rm -rf webapps/*
mv /tmp/ROOT webapps; mv /tmp/balancer webapps
rm -rf work/*
2. Verify the following setting in sakai.properties:
portalPath=/xsl-portal (This is used by GB2 security, and should be already set in sakai.properties)
3. Modify/Add the following settings in local.properties
a. version.service=2.6.4.0
b. version.sakai=2.6.2
c. Gradebook2 properties:
gb2.help.url=[http://smartsite.ucdavis.edu/ucd-gateway/Gradebook2Documents.html]
gb2.enabled.grade.types=points,percentages,letters
gb2.gradable.role.names=Student,Participant,Open Campus,access
gb2.enable.scaled.extra.credit=INSTRUCTOR
gb2.limit.scaled.extra.credit=CATEGORIES,WEIGHTED CATEGORIES
gb2.import.delete.missing.grades=true
gb2.security.enabled=true
d. Add to prevent lazy initialization errors:
osiv.enable=true
osiv.sessionFactoryBeanName=edu.ucdavis.sakai.external.GlobalSessionFactory
e. Add sakai.kaltura,sakai-itunesu-admin,sakai.iTunesU to the stealth tool setting
f. Verify that all the Gradebook2 final grade submission properties are still in place
4. Ensure that auto.ddl is true in the first Tomcat's instance.properties
5. Make the following changes to SystemGlobals.properties
a. set cache.engine.implementation=org.etudes.jforum.cache.MemoryServiceCacheEngine
b. set html.tags.welcome=a, abbr, acronym, address, b, big, blockquote, br, center, cite, code, dd, del, dir, div, dl, dt, em, font, hr, h1, h2, h3, h4, h5, h6, I, ins,kbd, li, marquee, menu, nobr, noembed, ol, p, pre, q, rt, ruby, rbc, rb, rtc, rp,s, samp, small, span, strike, strong, sub, sup, tt, u, ul, var, xmp, img, embed,object, table, tr, td, th, tbody, caption, thead, tfoot, colgroup, col\
|
Saturday, August 14, 2010 during maintenance window: 5:00 am to 10:30am
- (5:00 am to 5:10 am) Anand Mehta will place smartsite in maintenance mode and stop all Tomcats.
- (5:11 am to 5:25 am) Anand Mehta will rename tomcat to tomcat-263 and tomcat-264 to tomcat on all app servers
- (5:26 am to 5:40 am) Anand Mehta will backup the 2.6.3 properties files and put the 2.6.4 properties files in the sakai directory
- (5:40am to 6:10 am) Mark Pankow will backup the existing DB.
- No cron jobs will be disabled or altered. ** Mark will link to actual text document.
- I will let the normally scheduled hot backup run at 4AM. It will not include a datapump (export) which is part of my "normal" daily backup.
- At 5:40 I will manually export the SAKAI schema. It should not alter the timeline, but I will be running a test at some point this weekend to verify.
- After the export, I will manually switch the logfile in production and make note of that.
- I will then defer log transfer to the standby.
- (6:10 am to 6:20) Mark Pankow will execute the upgrade scripts 2.6.2 to 2.6.3 and 2.6.3 to 2.6.4 CLE upgrade scripts as follows:
ADD: Talk to Anand: No commits; add commits or have DBA issue commits.
Code Block |
---|
/* change Preferences to split out email into different fields that can be controlled individually.*/
/* add the new columns, default to false as we update them further down. */
alter table PROFILE_PREFERENCES_T add (EMAIL_REQUEST number(1,0) default 0, EMAIL_CONFIRM number(1,0) default 0);
/* update the new columns based on the old data */
/* if all emails, then both true */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=1, EMAIL_CONFIRM=1 where EMAIL=0;
/* if just requests, set requests to true, confirms to false */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=1, EMAIL_CONFIRM=0 where EMAIL=1;
/* if just confirms, set confirms to true, requests to false */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=0, EMAIL_CONFIRM=1 where EMAIL=2;
/* if all off, set both false */
update PROFILE_PREFERENCES_T set EMAIL_REQUEST=0, EMAIL_CONFIRM=0 where EMAIL=3;
/* now drop the old column */
alter table PROFILE_PREFERENCES_T drop COLUMN EMAIL;
/* change name of profile field to be profile_image since it only controls that now (PRFL-24) */
alter table PROFILE_PRIVACY_T rename column PROFILE to PROFILE_IMAGE;
/* update values in profile_image and search, we no longer have 2 as an option (ie only me) */
update PROFILE_PRIVACY_T set PROFILE_IMAGE=1 where PROFILE_IMAGE>1;
update PROFILE_PRIVACY_T set SEARCH=1 where SEARCH>1;
/* add my_status column */
alter table PROFILE_PRIVACY_T add MY_STATUS number(1,0) default 0;
/* add the new academic column, default to 0, (PRFL-38) */
alter table PROFILE_PRIVACY_T add ACADEMIC_INFO number(1,0) default 0;
/* increase size of UUID columns (PRFL-44) */
alter table PROFILE_FRIENDS_T modify USER_UUID varchar2(99);
alter table PROFILE_FRIENDS_T modify FRIEND_UUID varchar2(99);
alter table PROFILE_IMAGES_EXTERNAL_T modify USER_UUID varchar2(99);
alter table PROFILE_IMAGES_T modify USER_UUID varchar2(99);
alter table PROFILE_PREFERENCES_T modify USER_UUID varchar2(99);
alter table PROFILE_PRIVACY_T modify USER_UUID varchar2(99);
alter table PROFILE_STATUS_T modify USER_UUID varchar2(99);
/* resize column (PRFL-44) but also change its type (PRFL-45) */
alter table SAKAI_PERSON_META_T modify USER_UUID varchar2(99);
/* add indexes (PRFL-76) */
create index PROFILE_FRIENDS_USER_UUID_I on PROFILE_FRIENDS_T (USER_UUID);
create index PROFILE_FRIENDS_FRIEND_UUID_I on PROFILE_FRIENDS_T (FRIEND_UUID);
create index PROFILE_IMAGES_USER_UUID_I on PROFILE_IMAGES_T (USER_UUID);
create index PROFILE_IMAGES_IS_CURRENT_I on PROFILE_IMAGES_T (IS_CURRENT);
create index SAKAI_PERSON_META_USER_UUID_I on SAKAI_PERSON_META_T (USER_UUID);
create index SAKAI_PERSON_META_PROPERTY_I on SAKAI_PERSON_META_T (PROPERTY);
/* CLE-4417 jforum reset icon missing */
update rsn_tool_final_config set prop_value = true where prop_key = “reset.button� and tool_id = (select id from rsn_tool where tool_id = “sakai.jforum.tool�) ;
/* CLE-4329 logical delete of sakai site data */
alter table SAKAI_SITE add IS_DELETED CHAR(1) DEFAULT ‘N’;
/* CLE-4321 trim space after term name */
update SAKAI_SITE_PROPERTY set VALUE = trim(VALUE) where name=�term�;
|
6. (6:20 am to 6:40 am) Mark Pankow to run rsnfixes.sql [Mark will move to script files] ADD: Talk to Anand: No commits; add commits or have DBA issue commit.
Code Block |
---|
--Cannot Change Config options on some tools (8306969)
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, 'false', 'show-subject' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '3', 'items' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '/announcement/channel/!site/motd', 'channel' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, 'true', 'show-newlines' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '50000', 'length' FROM rsn_tool WHERE tool_id = 'sakai.motd';
INSERT INTO RSN_TOOL_MUTABLE_CONFIG ( TOOL_ID, PROP_VALUE, PROP_KEY) SELECT id, '1000', 'days' FROM rsn_tool WHERE tool_id = 'sakai.motd';
-- Cannot assign TA in Section Info (8306675)
insert into sakai_realm_rl_fn (realm_key, role_key, function_key) (select realm_key, 9, 74 from sakai_realm where realm_id like '/site/%/group/%' and realm_key not in (select realm_key from sakai_realm_rl_fn where function_key = (select function_key from sakai_realm_function where function_name = 'section.role.ta') and role_key = (select role_key from sakai_realm_role where role_name = 'Teaching Assistant')));
DELETE from sakai_realm_rl_fn where role_key = (select role_key from sakai_realm_role where ROLE_NAME = 'Lead TA') and realm_key in (select realm_key from sakai_realm where REALM_ID LIKE '/site/%/group/%') and function_key = (select function_key from sakai_realm_function where function_name = 'section.role.ta');
--Site Editor tool does not show for Participants in Project site (8306970)
--THIS TICKET IS STILL OPEN SO THIS MAY CHANGE
update rsn_tool_mutable_config set prop_value='site.visit' where tool_id in(select id from sakai.rsn_tool where tool_id='sakai.siteinfo'and prop_key='functions.require');
--Stack trace when selecting the Content over Text layout during Freeform Portfolio creation (8306957)
update OSP_PRESENTATION_LAYOUT SET xhtml_file_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/simpleRichText.xml'), preview_image_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/Simplehtml.jpg') WHERE id = 'simpleRichText';
update OSP_PRESENTATION_LAYOUT SET xhtml_file_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/twoColumn.xml'), preview_image_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/2column.jpg') WHERE id = 'twoColumn';
update OSP_PRESENTATION_LAYOUT SET xhtml_file_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/contentOverText.xml'), preview_image_id = (select RESOURCE_UUID from CONTENT_RESOURCE where RESOURCE_ID = '/group/PortfolioAdmin/system/contentOverText.jpg') WHERE id = 'contentOverText';
UCD Thinks this should be removed. 8/6/2010
--Tests and Quizzes: Students receiving credit for unanswered questions (8308099)
create table SAM_ITEMGRADING_TT (ITEMGRADINGID number(19,0) not null, ASSESSMENTGRADINGID number(19,0) not null, PUBLISHEDITEMID number(19,0) not null, PUBLISHEDITEMTEXTID number(19,0) not null, AGENTID varchar2(255 char) not null, SUBMITTEDDATE timestamp, PUBLISHEDANSWERID number(19,0), RATIONALE varchar2(4000 char), ANSWERTEXT varchar2(4000 char), AUTOSCORE float, OVERRIDESCORE float, COMMENTS varchar2(4000 char), GRADEDBY varchar2(255 char), GRADEDDATE timestamp, REVIEW number(1,0), ATTEMPTSREMAINING number(10,0), LASTDURATION varchar2(36 char), primary key (ITEMGRADINGID));
create table SAM_ITEMGRADING_TTT (ITEMGRADINGID number(19,0) not null, ASSESSMENTGRADINGID number(19,0) not null, PUBLISHEDITEMID number(19,0) not null, PUBLISHEDITEMTEXTID number(19,0) not null, AGENTID varchar2(255 char) not null, SUBMITTEDDATE timestamp, PUBLISHEDANSWERID number(19,0), RATIONALE varchar2(4000 char), ANSWERTEXT varchar2(4000 char), AUTOSCORE float, OVERRIDESCORE float, COMMENTS varchar2(4000 char), GRADEDBY varchar2(255 char), GRADEDDATE timestamp, REVIEW number(1,0), ATTEMPTSREMAINING number(10,0), LASTDURATION varchar2(36 char), primary key (ITEMGRADINGID));
insert into sakai.sam_itemgrading_tt (select * from sakai.sam_itemgrading_t where submitteddate is null);
insert into sakai.sam_itemgrading_ttt (select * from sakai.sam_itemgrading_t where itemgradingid in (select a.itemgradingid from sakai.sam_itemgrading_tt a join sakai.sam_itemgrading_t b on a.assessmentgradingid = b.assessmentgradingid and a.publisheditemid = b.publisheditemid and b.submitteddate is not null and a.autoscore = b.autoscore and a.overridescore=b.overridescore);
delete from from sam_itemgrading_t where itemgradingid in (select itemgradingid from sam_itemgrading_ttt);
DROP TABLE sam_itemgrading_tt;
DROP TABLE sam_itemgrading_ttt;
--Site Editor on new Course sites is being named Site Setup (8306811)
update sakai_site_page set title = 'Site Editor' where page_id in (select page_id from sakai_site_page ssp join sakai_site ss on ss.site_id = ssp.site_id and ss.type = 'course' and ssp.title = 'Site Setup');
UCD Thinks this should be removed because we don’t have QA results that say it fixed anything.. 8/6/2010
--Duplicate student entries in Dropbox (8307538)
DELETE FROM CONTENT_DROPBOX_CHANGES WHERE DROPBOX_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/d5cf9904-0895-4409-b201-d967d9ebd030/';
DELETE FROM CONTENT_DROPBOX_CHANGES WHERE DROPBOX_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/ed575560-6ef5-40fc-846b-558350daac45/';
DELETE FROM CONTENT_COLLECTION WHERE COLLECTION_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/d5cf9904-0895-4409-b201-d967d9ebd030/';
DELETE FROM CONTENT_COLLECTION WHERE COLLECTION_ID = '/group-user/631ba4ad-8eeb-4b7a-8f73-a7bbcf297451/ed575560-6ef5-40fc-846b-558350daac45/';
-- Bad data in sakai.GB_CATEGORY_T table causing grade submission failure (8308193)
insert into ucdrw.savegb2weights
(ID, VERSION, GRADEBOOK_ID, NAME, WEIGHT, DROP_LOWEST,
REMOVED, IS_EXTRA_CREDIT, IS_EQUAL_WEIGHT_ASSNS,
IS_UNWEIGHTED, CATEGORY_ORDER, ENFORCE_POINT_WEIGHTING)
(SELECT * FROM SAKAI.GB_CATEGORY_T Where ROUND(WEIGHT,14) \!= WEIGHT)
UPDATE GB_CATEGORY_T SET WEIGHT=ROUND(WEIGHT,14) WHERE ROUND(WEIGHT,14) \!= WEIGHT;
|
7. (6:40am to 6:50 am) Mark Pankow to run SQL conversion for GB2. Talk to Thomas: Commit to script (Thomas)
Conversion script is below but source can be taken from:https://source.sakaiproject.org/contrib/gradebook2/tags/1.3.0-rc1/sakai/2-6-x/sql/oracle/conversion_1.2.0_to_1.3.0.sql.
At the time of deployment this link will be active for the source script:https://source.sakaiproject.org/contrib/gradebook2/tags/1.3.0/sakai/2-6-x/sql/oracle/conversion_1.2.0_to_1.3.0.sql
Code Block |
---|
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_ID'
where PROPERTY_NAME='ID';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_NM'
where PROPERTY_NAME='NAME';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_WGHT'
where PROPERTY_NAME='WEIGHT';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_EQL_WGHT'
where PROPERTY_NAME='EQUAL_WEIGHT';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_X_CRDT'
where PROPERTY_NAME='EXTRA_CREDIT';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_INCLD'
where PROPERTY_NAME='INCLUDED';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_RMVD'
where PROPERTY_NAME='REMOVED';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_GB_NAME'
where PROPERTY_NAME='GRADEBOOK';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='I_DRP_LWST'
where PROPERTY_NAME='DROP_LOWEST';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_CTGRY_NAME'
where PROPERTY_NAME='CATEGORY_NAME';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='L_CTGRY_ID'
where PROPERTY_NAME='CATEGORY_ID';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='W_DUE'
where PROPERTY_NAME='DUE_DATE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_PNTS'
where PROPERTY_NAME='POINTS';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PNTS'
where PROPERTY_NAME='POINTS_STRING';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_RLSD'
where PROPERTY_NAME='RELEASED';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_NLLS_ZEROS'
where PROPERTY_NAME='NULLSASZEROS';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_SOURCE'
where PROPERTY_NAME='SOURCE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_ITM_TYPE'
where PROPERTY_NAME='ITEM_TYPE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_PCT_GRD'
where PROPERTY_NAME='PERCENT_COURSE_GRADE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PCT_GRD'
where PROPERTY_NAME='PERCENT_COURSE_GRADE_STRING';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='D_PCT_CTGRY'
where PROPERTY_NAME='PERCENT_CATEGORY';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PCT_CTGRY'
where PROPERTY_NAME='PERCENT_CATEGORY_STRING';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_IS_PCT'
where PROPERTY_NAME='IS_PERCENTAGE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='O_LRNR_KEY'
where PROPERTY_NAME='STUDENT_MODEL_KEY';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='L_ITM_ID'
where PROPERTY_NAME='ASSIGNMENT_ID';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_NM'
where PROPERTY_NAME='NAME';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_DATA_TYPE'
where PROPERTY_NAME='DATA_TYPE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='C_CTGRY_TYPE'
where PROPERTY_NAME='CATEGORYTYPE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='G_GRD_TYPE'
where PROPERTY_NAME='GRADETYPE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_REL_GRDS'
where PROPERTY_NAME='RELEASEGRADES';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_REL_ITMS'
where PROPERTY_NAME='RELEASEITEMS';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='I_SRT_ORDR'
where PROPERTY_NAME='ITEM_ORDER';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='L_GRD_SCL_ID'
where PROPERTY_NAME='GRADESCALEID';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_RECALC_PTS'
where PROPERTY_NAME='DO_RECALCULATE_POINTS';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_WT_BY_PTS'
where PROPERTY_NAME='ENFORCE_POINT_WEIGHTING';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_MEAN'
where PROPERTY_NAME='SHOWMEAN';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_MEDIAN'
where PROPERTY_NAME='SHOWMEDIAN';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_SHW_MODE'
where PROPERTY_NAME='SHOWMODE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_RANK'
where PROPERTY_NAME='SHOWRANK';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_SHW_ITM_STATS'
where PROPERTY_NAME='SHOWITEMSTATS';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='A_CHILDREN'
where PROPERTY_NAME='CHILDREN';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_ACTIVE'
where PROPERTY_NAME='IS_ACTIVE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_EDITABLE'
where PROPERTY_NAME='IS_EDITABLE';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_CHKD'
where PROPERTY_NAME='IS_CHECKED';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='S_PARENT'
where PROPERTY_NAME='PARENT_NAME';
update GB_ACTION_RECORD_PROPERTY_T
set PROPERTY_NAME='B_ALW_SCL_X_CRDT'
where PROPERTY_NAME='ALLOW_SCALED_EXTRA_CREDIT';
|
8. (6:50 am to 6:55 am) Anand Mehta will check each prod node to make sure that the file /etc/krb5.conf does not exist. Rename existing to /etc/krb5.config.orig.
9. (6:55to 7:00 am) Add the commands to actually deploy the code.
Code Block |
---|
mvn \-Dmaven.test.skip=true \-Dmaven.tomcat.home=/home/ucdavis/cle/tomcat/ \-Dsakai-login-tool.cas \-Ducd.cas.mothra.filter \-Dsakai2.6 clean install sakai:deploy
|
10. Content and Function Verification Testing:
1. (7:00 am to 7:05 am) Anand will bring up one server still in maintenance mode for verification testing.
2. (7:05 am to 7:35am) Sandra, Joyce, Dave Woods, Fernando, Steve(?) and Vernon will verify that the system has been successfully upgraded by doing the following:
â—� Verify that webdav works, from course site xxx, from his Mac (10.4 and 10.6) Windows 7 and xp. (Fernando will do this).
â—� Verify that course management work by accessing Site Editor, Rosters, and Mailtool on sites to be determined. Screen shots are stored on RSN ticket, 8307884 for course sites BIS 002C A01-A15,B01-B15 SQ 2010, and BIS 002A A21-A26 SS2 2010 (Sandra will do this).
â—� Verify that adding and dropping a roster for a multi-section site changes the title in the tab (if we get permission from an instructor). Or duplicate a site, unpublish it, then add and drop the rosters and check the site. Then delete the site after the verification (Kirk will do this).
� Verify that, for RSN ticket 8306811 “Site Editor on new Course sites is being named Site Setup� no longer occurs. Create a new course site. Verify that it doesn’t have site info. Should say site editor. (Joyce will do this).
â—� Verify that exporting gradebook using IE8 works without an error. User course site xxx. This will be for letter grades and points (David will do this).
â—� Verify that we can import gradebooks without error, using course site AHI 001e SS1 2010. This will be for letter grades and points (Sandra will do this).
� Verify that we’re using the correct grade scale for letter grade gradebooks. This will use course site xxxxx. Modify the grade scale to be odd. Verify that grades are not looking at grade scale and have not changed. David will do this.
â—� Basic performance test (e.g. Site Editor performance), response time, first time in, should be no greater than 5 seconds. Use course site BIS 002C A01-A15,B01-B15 SQ 2010 with Susan Keen (slkeen), participants > 635. Vernon will do this.
â—� Check to make sure the gradebook sorts on its labels in the spreadsheet view the way we expect, A+ as highest, F as lowest. Will use course sites BIS 002C A01-A15,B01-B15 SQ 2010 & BIS 002C A01-A15,B01-B15 WQ 2010. Vernon will do this. Take a screen shot of this unacceptable sort prior to rollout, attach to GRBK-585.
â—� Check Section Info, verify that we can add TAs. Will use course sites BIS 002C A01-A15,B01-B15 SQ 2010 & BIS 002C A01-A15,B01-B15 WQ 2010. Vernon will do this.
â—� UCD and rSmart programming team will make sure final grades has the correct url
3. (7:35 am to 7:50 am) Anand Mehta will restart Tomcat on remaining servers.
4. (7:50 am to 7:55 am) Team will decide go or roll back.
5. In the case of “GO,� move to “Vote on our readiness to bring the system back up�
6. In the case of “ROLLBACK,� move to “Rollback Section�
Vote on our readiness to bring the system back up:
1. (7:55 am to 8:00 am) Team to vote on readiness to bring the system back up assuming we’re going forward. See rollback section for retreating.
Release the system to public:
1. (8:00 am to 8:15 am) Anand Mehta Release servers to the public.
2. (8:15 am to 8:30 am) UCD - PM will send email notification to our SmartSite community to say the system is back up.
3. (8:30 am to 8:45 am) UCD - Project or Program Manager will change the MOTD.
4. ADD (9:45) : Wait one hour; reconnect primary database to hot standby
a. Details to be added by Mark
Post release actions:
1. GRBK-646: Check production DB if we have duplicate (same realm_id) entries in the GB_USER_DEREF_RM_UPDATE_T
a.
Code Block |
---|
select realm_id, count(*) as NUM_DUPS from GB_USER_DEREF_RM_UPDATE_T group by REALM_ID having count(*) > 1;
|
Rollback:
â—� Anand Mehta rolls back the upgrade by doing the following:
- (8:00 am to 8:15 am) Anand Mehta stops any running Tomcats.
- (8:15 am to 8:25 am) Anand Mehta renames tomcat to tomcat-264 and tomcat-263 to tomcat on all app servers.
- (8:25 am to 8:40 am) Anand Mehta backs up the existing properties files and puts the 2.6.2 properties files in the sakai directory.
- (8:40 am to 9:40 am) Mark Pankow
- I would import the SAKAI schema from the export taken manually. That should not take more than the 40 minutes alloted.
- Additionally, measures above would allow for a restore and recovery to the point right before the upgrade using the 4AM hot backup.
- Lastly, the standby base is there and ready to be converted to the primary in the event of catastrophic failure.
- ADD: log transfer; reconnect primary database to hot standby
- ADD: Any syntax, commands, sql scripts for these steps above
- (9:40 am to 9:50am)Anand Mehta starts one Tomcat.
...
|