[WG: Sakai QA] QA1-NL.sakaiproject.org up with broken tools

Berg, A.M. A.M.Berg at uva.nl
Mon Dec 14 01:21:50 PST 2009


QA1-NL is up with a clean database and extra web services for provisioning.

Blog, chat, a number of OSP tools are broken and there is a schema update failure which should be an error, but only comes out as a warn. I will Jira today after checking with Anthony if this is code related, pom, or just caused by the schema update failure. The schema update is an obvious mistake and I will Jira as a blocker ASAP.

Other QA-ADMIN's it is what it is, please bring up servers so that some serious testing can take place. I am  curious to see if this is a autodll related to Mysql and does not appear with Oracle.

The relevant log file can be found at: http://qa1-nl.sakaiproject.org/logs/catalina.out

Schema failure (MYSLQ not being taken into account)

Unsuccessful schema statement: create table SAKAI_PERSON_T (ID bigint not null auto_increment, PERSON_TYPE varchar(3) not null, VERSION integer not null, UUID varchar(36) not null unique, LAST_MODIFIED_BY varchar(36) not null, LAST_MODIFIED_DATE datetime not null, CREATED_BY varchar(36) not null, CREATED_DATE datetime not null, AGENT_UUID varchar(99) not null, TYPE_UUID varchar(36) not null, COMMON_NAME varchar(255), DESCRIPTION varchar(255), SEE_ALSO varchar(255), STREET varchar(255), SURNAME varchar(255), TELEPHONE_NUMBER varchar(255), FAX_NUMBER varchar(255), LOCALITY_NAME varchar(255), OU varchar(255), PHYSICAL_DELIVERY_OFFICE_NAME varchar(255), POSTAL_ADDRESS varchar(255), POSTAL_CODE varchar(255), POST_OFFICE_BOX varchar(255), STATE_PROVINCE_NAME varchar(255), STREET_ADDRESS varchar(255), TITLE varchar(255), BUSINESS_CATEGORY varchar(255), CAR_LICENSE varchar(255), DEPARTMENT_NUMBER varchar(255), DISPLAY_NAME varchar(255), EMPLOYEE_NUMBER varchar(255), EMPLOYEE_TYPE varchar(255), GIVEN_NAME varchar(255), HOME_PHONE varchar(255), HOME_POSTAL_ADDRESS varchar(255), INITIALS varchar(255), JPEG_PHOTO blob, LABELED_URI varchar(255), MAIL varchar(255), MANAGER varchar(255), MOBILE varchar(255), ORGANIZATION varchar(255), PAGER varchar(255), PREFERRED_LANGUAGE varchar(255), ROOM_NUMBER varchar(255), SECRETARY varchar(255), UID_C varchar(255), USER_CERTIFICATE tinyblob, USER_PKCS12 tinyblob, USER_SMIME_CERTIFICATE tinyblob, X500_UNIQUE_ID varchar(255), AFFILIATION varchar(255), ENTITLEMENT varchar(255), NICKNAME varchar(255), ORG_DN varchar(255), ORG_UNIT_DN varchar(255), PRIMARY_AFFILIATION varchar(255), PRIMARY_ORG_UNIT_DN varchar(255), PRINCIPAL_NAME varchar(255), CAMPUS varchar(255), HIDE_PRIVATE_INFO bit, HIDE_PUBLIC_INFO bit, NOTES varchar(4000), PICTURE_URL varchar(255), SYSTEM_PICTURE_PREFERRED bit, ferpaEnabled bit, dateOfBirth date, locked bit, FAVOURITE_BOOKS varchar(4000), FAVOURITE_TV_SHOWS varchar(4000), FAVOURITE_MOVIES varchar(4000), FAVOURITE_QUOTES varchar(4000), EDUCATION_COURSE varchar(4000), EDUCATION_SUBJECTS varchar(4000), NORMALIZEDMOBILE varchar(255), primary key (ID), unique (AGENT_UUID, TYPE_UUID)) ENGINE=InnoDB
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
	

Tool failures look like:

2009-12-14 09:53:05,772 ERROR main org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/samigo-app] - Exception sending context initialized event to listener instance of class com.sun.faces.config.ConfigureListener
javax.faces.FacesException: java.lang.ClassNotFoundException: [Ljava.lang.String;
	at com.sun.faces.config.ConfigureListener.contextInitialized(ConfigureListener.java:334)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3795)


I will be contacting relevant project leads as soon as timezones permit.


Alan

Alan Berg
Interim QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam

http://home.uva.nl/a.m.berg




-----Original Message-----
From: Berg, A.M.
Sent: Mon 12/14/2009 9:05
To: Berg, A.M.; Anthony Whyte; Sakai QA
Subject: QA1-NL.sakaiproject.org going down for M2 milestone
 
See you soon, 

QA1-NL will be running with the experimental profile plus some extra web services for provisioning.

Alan

Alan Berg
Interim QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam

http://home.uva.nl/a.m.berg




-----Original Message-----
From: Berg, A.M.
Sent: Sat 12/12/2009 17:38
To: Anthony Whyte; Sakai QA
Cc: Sakai Developers
Subject: RE: [Building Sakai] sakai-2.7.0-M2 milestone tag now available
 
Hi all,

As an addendum, can the QA server admins please generate access logs that are viewable via their Tomcat directories. This can be achieved via the instructions at: 

http://confluence.sakaiproject.org/display/QA/Recipe+Apache+Logs - Apache
http://confluence.sakaiproject.org/display/QA/Tomcat+valve - Tomcat

QA can then start looking at browser version coverage, response times and errors generated.

David Howitz has kindly agreed to run some local continuous stress testing on qa1-za. Seth Theriault is doing the same for his servers. Motivation, functional testers look at how systems perform at above zero load. Further, this is good for pin pointing (if done over weeks) synchronization and resource issues in the code base. If any other QA admin's are interested can they please contact me.

Chris Kretler and Nuno are working on performance tests on qa1-nl for sitestats via grinder.  I would like to say, cheers and thank you very much.

Finally, once again can the QA server admins please update http://confluence.sakaiproject.org/display/QA/QA+Servers+-+Sakai+2.7



Alan

Alan Berg
Interim QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam

http://home.uva.nl/a.m.berg




-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org on behalf of Anthony Whyte
Sent: Sat 12/12/2009 17:17
To: Sakai QA
Cc: Sakai Developers
Subject: [Building Sakai] sakai-2.7.0-M2 milestone tag now available
 
I've generated the sakai-2.7.0-M2 milestone tag.  QA server admins  
should deploy it to QA servers supporting 2.7 testing environments at  
their earliest convenience.

https://source.sakaiproject.org/svn/sakai/tags/sakai-2.7.0-M2/


MODULES DEPLOYED

The M2 tag will deploy (mvn clean install sakai:deploy) to Tomcat the  
following modules:

http://confluence.sakaiproject.org/display/REL/Sakai+2.7.0+release

Please note that with the advent of "indie" releases a number of Sakai  
projects are versioned and released separately from the bulk of Sakai  
projects that are currently versioned as 2.7-SNAPSHOT (the default  
2.7.x maintenance branch version).  One example would be  
entitybroker-1.3.7.  All of this is documented in Release Management  
space in Confluence (with more documentation on the way).


TOMCAT 5.5.28

QA server admins, if they have not done so already, should update  
their QA instances to run Tomcat 5.5.28 by installing sakai-2.7.0-M2.   
Doing so requires that the following setting be added to either  
JAVA_OPTS or $CATALINA_HOME/bin/setenv.sh (unix) or setenv.bat  
(windows).

-Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false

This setting disables strict quote escaping which causes run-time  
errors in certain Sakai tools that use the JavaServer Faces (JSF) UI  
rendering framework.


Cheers,

Anthony









-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-qa/attachments/20091214/6295882f/attachment.html 


More information about the sakai-qa mailing list