[Building Sakai] Error accessing SST_JOB_RUN table SiteStats

Tue Jan 10 08:30:16 PST 2012

Miguel version SiteStats is 2.2.
Thanks,
Sue Collarte

De: Miguel Carro Pellicer [mailto:farreri.sakai at gmail.com]
Enviado el: Martes, 10 de Enero de 2012 13:24
Para: SUSANA COLLARTE A.
CC: sakai-dev at collab.sakaiproject.org; Feliz Gouveia
Asunto: Re: [Building Sakai] Error accessing SST_JOB_RUN table SiteStats

Maybe you have Sitestats data in a secondary database and the quartz job still access Sakai's database instead of secondary DB, i will check it in the source.

Also i'll include the author to get more info.

Miguel

El 10/01/2012 16:43, SUSANA COLLARTE A. escribió:
Hello, I have problem with "INFO QuartzScheduler_Worker-1 org.sakaiproject.sitestats.impl.StatsAggregateJobImpl - Starting job: DEFAULT.Estadisticas
2012-01-09 14:44:08,892  WARN QuartzScheduler_Worker-1 org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08S01
2012-01-09 14:44:08,893 ERROR QuartzScheduler_Worker-1 org.hibernate.util.JDBCExceptionReporter - The last packet successfully received from the server was 248.908.331 milliseconds ago.  The last packet sent successfully to the server was 248.908.331 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
2012-01-09 14:44:08,893 ERROR QuartzScheduler_Worker-1 org.sakaiproject.sitestats.impl.StatsAggregateJobImpl - Error accessing SST_JOB_RUN table. Does this table exists? Aborting job.."

In the BD motor variable wait_timeout=28800
In sakai.properties of variables are:
initialSize at javax.sql.BaseDataSource=20<mailto:initialSize at javax.sql.BaseDataSource=20>
maxActive at javax.sql.BaseDataSource=1000000<mailto:maxActive at javax.sql.BaseDataSource=1000000>
timeBetweenEvictionRunsMillis at javax.sql.BaseDataSource=-1<mailto:timeBetweenEvictionRunsMillis at javax.sql.BaseDataSource=-1>
removeAbandoned at javax.sql.BaseDataSource=true<mailto:removeAbandoned at javax.sql.BaseDataSource=true>
removeAbandonedTimeout at javax.sql.BaseDataSource=300<mailto:removeAbandonedTimeout at javax.sql.BaseDataSource=300>
logAbandoned at javax.sql.BaseDataSource=false<mailto:logAbandoned at javax.sql.BaseDataSource=false>
And Connector/J is jdbc:mysql://bdcmsuc.puc.cl:3311/wlms_stats3?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
Version sakai: 2.6.3
Tomcat 5.5.27
Apache 2.2.17
Jdk1.5.0.18
MYSQL 5.1.47

What can I do? I need your help about it. Thanks.

Saludos,

Susana Collarte A.
Jefa Area de Desarrollos e Investigacion TIC en Educación
Subdireccion de Servicios Academicos, Direccion Informatica
Pontificia Universidad Católica de Chile
*: 562 354 7139

_______________________________________________

sakai-dev mailing list

sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>

http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"

--

[cid:image001.jpg at 01C9F98A.71C74E60]<http://www.samoo.es/>
 <http://www.samoo.es/>
Miguel Carro Pellicer
Technical Manager - Director técnico
miguel.carro at samoo.es<mailto:miguel.carro at samoo.es>
+34 - 673 80 32 69
www.samoo.es<http://www.samoo.es>

Este  correo  y  sus archivos asociados son privados y confidenciales y va dirigido  exclusivamente  a su destinatario. Si recibe este correo sin ser el  destinatario del mismo, le rogamos proceda a su eliminación y lo ponga en  conocimiento del emisor. La difusión por cualquier medio del contenido de  este  correo podría ser sancionada conforme a lo previsto en las leyes españolas, Ley Orgánica 15/1999 de Protección de Datos de Carácter Personal.  No  se autoriza la utilización con fines comerciales o para su incorporación a ficheros automatizados de las direcciones del emisor o del destinatario."

This mail and its attached files are confidential and are only and exclusively intended to their addressee. In case you may receive this mail not being its addressee, we beg you to let us know the error by reply and to proceed to destroy it. The circulation by any mean of this mail could be penalised in accordance with the Spanish legislation. Is not allowed the use of both, the transmitter and the addressee's, address with a commercial aim, or in order to be incorporated to automated data process or to any kind of files.

P Antes de imprimir este correo electrónico piense bien si es necesario hacerlo. El medioambiente es cosa de todos.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120110/a0b2b653/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3022 bytes
Desc: image001.jpg
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120110/a0b2b653/attachment.jpg 