[Building Sakai] Problem with SAKAI_SITE_TOOL_PROPERTY query

[Ciellie]

Hi 
 
Could you perhaps tell me what this DB query does?

Thanx
 
select TOOL_ID, NAME, VALUE from SAKAI_SITE_TOOL_PROPERTY where ( SITE_ID = ? )

!gateway
 
Shortly after that query was run I get the following error message:
 
com.mysql.jdbc.CommunicationsException: Communications link failure due to

underlying exception:
 
** BEGIN NESTED EXCEPTION **
 
com.mysql.jdbc.CommunicationsException

MESSAGE: Communications link failure due to underlying exception:
 
** BEGIN NESTED EXCEPTION **
 
java.io.EOFException

MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0

bytes before connection was unexpectedly lost.
 
STACKTRACE:
 
java.io.EOFException: Can not read response from server. Expected to read 4

bytes, read 0 bytes before connection was unexpectedly lost.
        
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997)
        
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411)
       
 at com
.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916)
        
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
       
 at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
      
  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
       
 at co
m.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
       
 at

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
       
 at

org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectio

nFactory.java:38)
        at

org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionF

actory.java:294)
        
at

org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.ja

va:1148)
        
at

org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:9

6)
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

        at

org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:2

60)
        
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)

        at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)

        at
org.sakaiproject.site.impl.DbSiteService$DbStorage.readSiteToolProperties(DbSite

Service.java:1757)

        at
org.sakaiproject.site.impl.DbSiteService$DbStorage.readAllSiteProperties(DbSiteS

ervice.java:1677)

        
at org.sakaiproject.site.impl.BaseSite.loadAll(BaseSite.java:923)
        
at

org.sakaiproject.site.impl.BaseSiteService.getDefinedSite(BaseSiteService.java:5

92)
        
at

org.sakaiproject.site.impl.BaseSiteService.getSite(BaseSiteService.java:672)


        
at

org.sakaiproject.site.impl.BaseSiteService.getSiteVisit(BaseSiteService.java:750

)
        
at

org.sakaiproject.site.cover.SiteService.getSiteVisit(SiteService.java:134)


        
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSiteVisit(PortalSite

HelperImpl.java:927)
        
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getGatewaySiteId(Portal

SiteHelperImpl.java:153)
        
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:145)


        
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:117)


        
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal

.java:862)
        
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)


        
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        
at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt

erChain.java:269)
        
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)

        
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
        
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)


        
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
        
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)

        at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

        
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectio

nFactory.java:38)
        
at

org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionF

actory.java:294)

        
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.ja

va:1148)
        
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:9

6)
        
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)


        
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:2

60)
        
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)


        at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)


        at

org.sakaiproject.site.impl.DbSiteService$DbStorage.readSiteToolProperties(DbSite

Service.java:1757)
        at
org.sakaiproject.site.impl.DbSiteService$DbStorage.readAllSiteProperties(DbSiteS

ervice.java:1677)

        at org.sakaiproject.site.impl.BaseSite.loadAll(BaseSite.java:923)

        at
org.sakaiproject.site.impl.BaseSiteService.getDefinedSite(BaseSiteService.java:5

92)
        at
org.sakaiproject.site.impl.BaseSiteService.getSite(BaseSiteService.java:672)


        at
org.sakaiproject.site.impl.BaseSiteService.getSiteVisit(BaseSiteService.java:750

)
        at
org.sakaiproject.site.cover.SiteService.getSiteVisit(SiteService.java:134)


        at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSiteVisit(PortalSite

HelperImpl.java:927)
        at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getGatewaySiteId(Portal

SiteHelperImpl.java:153)
        at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:145)


        at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:117)


        at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal

.java:862)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt

erChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.

java:188)
        at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
        at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt

erChain.java:215)

        at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.

java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2

10)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1

74)
        at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)


        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)


        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108

)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)


        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)

        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConne

ction(Http11BaseProtocol.java:665)
        at


org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:52

8)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorker

Thread.java:81)
        at

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:68

5)
        at java.lang.Thread.run(Thread.java:662)
 

** END NESTED EXCEPTION **