[Building Sakai] Problem with SAKAI_SITE_TOOL_PROPERTY query

Mark J. Norton markjnorton at earthlink.net
Mon Jan 30 04:53:31 PST 2012 

It looks like a database connector problem.  Have a look at how your 
database access is set up in sakai.properties.  Also, you might have a 
mismatch between your version of MySQL and the connector JAR you are using.

- Mark

On 1/30/2012 2:18 AM, Ciellie wrote:
> 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 **
>
> _______________________________________________
> sakai-dev mailing list
> 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 with a subject of "unsubscribe"
>
>

More information about the sakai-dev mailing list