roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave <snoopd...@gmail.com>
Subject Re: Could not toggle autocommit errors in roller.log
Date Wed, 09 May 2007 18:32:47 GMT
You might want to experiment with using other versions of the MySQL
JDBC driver. Also, make sure the Hibernate configuration file
WEB-INF/classes/hibernate.cfg.xml is using he MySQL5Dialect.

- Dave



On 5/7/07, Brian Cross <brian@tigernet.com> wrote:
> I posted this a few weeks ago but didn't get any responses so I'm trying
> one more time.  Thanks!
>
> Hello, my roller 3.0 install is working great, except I am getting
> around 400 meg of errors per day in roller.log.  I think there are just
> 2 different errors reported over and over.  The only symptom I see on
> the actual site is sometimes I get a blank page (doesn't matter what
> page I am loading), and reloading the browser brings up the page
> correctly.  I would really appreciate any tips on how to fix these
> errors, thanks so much!
>
> My config:
>
> Roller 3.0
> Tomcat 5.5
> MySQL 5 - Roller tables are all of the MyISAM type
> Java 1.5
> Newest Debian Linux (2.6 kernel)
>
>
> Here are the errors in the log:
>
> ERROR 2007-04-16 13:31:47,944 JDBCTransaction:toggleAutoCommit - Could
> not toggle autocommit
> com.mysql.jdbc.CommunicationsException: Communications link failure due
> to underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Broken pipe
>
> STACKTRACE:
>
> java.net.SocketException: Broken pipe
>        at java.net.SocketOutputStream.socketWrite0(Native Method)
>        at
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:105)
>        at java.net.SocketOutputStream.write(SocketOutputStream.java:149)
>        at
> java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:88)
>        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:146)
>        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2637)
>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
>        at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
>        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5273)
>        at
> org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
>
>        at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293)
>
>        at
> org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
>
>        at
> org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:186)
>
>        at
> org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
>
>        at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.release(HibernatePersistenceStrategy.java:128)
>
>        at
> org.apache.roller.business.hibernate.HibernateRollerImpl.release(HibernateRollerImpl.java:110)
>
>        at
> org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:63)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
>
>        at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
>
>        at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:138)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:135)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
>        at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:121)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:104)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>
>        at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>
>        at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>
>        at
> org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
>
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>
>        at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>
>        at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
>
>        at java.lang.Thread.run(Thread.java:803)
>
> ** END NESTED EXCEPTION **
>
> Last packet sent to the server was 1 ms ago.
>        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2652)
>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
>        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
>        at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
>        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5273)
>        at
> org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268)
>
>        at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293)
>
>        at
> org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
>
>        at
> org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:186)
>
>        at
> org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
>
>        at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.release(HibernatePersistenceStrategy.java:128)
>
>        at
> org.apache.roller.business.hibernate.HibernateRollerImpl.release(HibernateRollerImpl.java:110)
>
>        at
> org.apache.roller.ui.core.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:63)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
>
>        at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
>
>        at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:138)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:135)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191)
>
>        at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
>
>        at
> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
>        at
> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.roller.ui.core.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:121)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.roller.ui.core.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:104)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>
>        at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>
>        at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>
>        at
> org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
>
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>
>        at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>
>        at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
>
>        at java.lang.Thread.run(Thread.java:803)
>
>
> ****************************
> 2nd Error:
>
> ERROR 2007-04-16 13:31:49,760 ApplicationDispatcher:invoke -
> Servlet.service() for servlet jsp threw exception
> java.lang.IllegalStateException: getOutputStream() has already been
> called for this response
>        at
> org.apache.catalina.connector.Response.getWriter(Response.java:599)
>        at
> org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:195)
>
>        at
> org.apache.jasper.runtime.JspWriterImpl.initOut(JspWriterImpl.java:124)
>        at
> org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:117)
>        at
> org.apache.jasper.runtime.JspWriterImpl.flush(JspWriterImpl.java:172)
>        at
> org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:887)
>
>        at
> org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:460)
>        at
> org.apache.jsp.WEB_002dINF.jsps._404_jsp._jspx_meth_tiles_insert_0(_404_jsp.java:222)
>
>        at
> org.apache.jsp.WEB_002dINF.jsps._404_jsp._jspService(_404_jsp.java:116)
>        at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>        at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
>
>        at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
>        at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
>
>        at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:465)
>
>        at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
>
>        at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
>        at
> org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:363)
>
>        at
> org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:284)
>
>        at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
>
>        at
> org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55AgentValve.java:20)
>
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
>
>        at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>
>        at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
>
>        at java.lang.Thread.run(Thread.java:803)
>
>
>

Mime
View raw message