Error thrown trying to create a blog...

Andy Akins Mon, 22 May 2006 12:16:53 -0700

I've got Roller set up, I believe correctly. Its running on Tomcat 5.5,
under JVM 1.5r6 under Red Hat ES3. Its talking to a mysql 5.0.17 database,
which has a roller user with all privileges, and the tables have been
created.


However, when I try to create a blog, the following shows up in the logs:

ERROR 2006-05-22 14:09:44,016 StandardWrapperValve:invoke -
Servlet.service() for servlet action threw exception
org.hibernate.exception.GenericJDBCException: could not execute query
        at 
org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(Error
CodeConverter.java:92)
        at 
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:8
0)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java
:43)
        at org.hibernate.loader.Loader.doList(Loader.java:1596)
        at org.hibernate.loader.Loader.list(Loader.java:1577)
        at 
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
        at 
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:433)
        at 
org.roller.business.hibernate.HibernateUserManagerImpl.getWebsiteByHandle(Hi
bernateUserManagerImpl.java:167)
        at 
org.roller.business.UserManagerImpl.getWebsiteByHandle(UserManagerImpl.java:
103)
        at 
org.roller.presentation.website.actions.CreateWebsiteAction.validate(CreateW
ebsiteAction.java:201)
        at 
org.roller.presentation.website.actions.CreateWebsiteAction.save(CreateWebsi
teAction.java:114)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at 
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:
276)
        at 
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
        at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
        at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
        at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at 
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:79
)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.j
ava:77)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persistenc
eSessionFilter.java:43)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:292)
        at 
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:116)
        at 
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:79)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:143)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:138)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:50)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProc
essingFilter.java:168)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:174)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:246)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:220)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
        at 
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120
)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnfor
cementFilter.java:104)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilt
er.java:94)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
        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.Http11AprProcessor.process(Http11AprProcessor.java:
833)
        at 
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:639)
        at 
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
        at 
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement
.java:1347)
        at 
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStateme
nt.java:958)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
        at 
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
        at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
        at org.hibernate.loader.Loader.doQuery(Loader.java:391)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.ja
va:218)
        at org.hibernate.loader.Loader.doList(Loader.java:1593)
        at org.hibernate.loader.Loader.list(Loader.java:1577)
        at 
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
        at 
org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:433)
        at 
org.roller.business.hibernate.HibernateUserManagerImpl.getWebsiteByHandle(Hi
bernateUserManagerImpl.java:167)
        at 
org.roller.business.UserManagerImpl.getWebsiteByHandle(UserManagerImpl.java:
103)
        at 
org.roller.presentation.website.actions.CreateWebsiteAction.validate(CreateW
ebsiteAction.java:201)
        at 
org.roller.presentation.website.actions.CreateWebsiteAction.save(CreateWebsi
teAction.java:114)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at 
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:
276)
        at 
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
        at 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
        at 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
        at 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at 
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:79
)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.j
ava:77)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persistenc
eSessionFilter.java:43)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:292)
        at 
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:116)
        at 
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:79)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:143)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:138)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:50)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProc
essingFilter.java:168)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:174)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:246)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:220)
        at 
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
        at 
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
        at 
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120
)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnfor
cementFilter.java:104)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilt
er.java:94)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
        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.Http11AprProcessor.process(Http11AprProcessor.java:
833)
        at 
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:639)
        at 
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **


        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2500)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
        at 
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement
.java:1347)
        at 
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStateme
nt.java:958)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
        at 
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
        at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
        at org.hibernate.loader.Loader.doQuery(Loader.java:391)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.ja
va:218)
        at org.hibernate.loader.Loader.doList(Loader.java:1593)
        ... 70 more

Any ideas? I'm fairly sure that the MySQL is functioning properly - other
apps use it as well, and have no problems.

Here's my context file, sans passwords:

<Context path="/blogs" docBase="/opt/roller/blogs" debug="0">
  <Resource name="jdbc/rollerdb" auth="Container"
type="javax.sql.DataSource"
    driverClassName="com.mysql.jdbc.Driver"
    
url="jdbc:mysql://mdb.tnanytime.org:3306/roller?autoReconnect=true&amp;useUn
icode=true&amp;characterEncoding=utf-8&amp;mysqlEncoding=utf8"
    username="roller"
    password="blahblah"
    maxActive="20"
    maxIdle="3"
    removeAbandoned="true"
    maxWait="3000" />
  <Resource name="mail/Session" auth="Container" type="javax.mail.Session"
     mail.smtp.host="dns.tnanytime.org" />
</Context>

Thanks!

-- 
Andy Akins
Director of Development
TennesseeAnytime - A partnership with Tennessee.gov
Phone:    615.313.0305
Fax:      615.313.0301
Email:    [EMAIL PROTECTED]
 
Visit www.Tennessee.gov the official Web site for the State of Tennessee
 
**********************************
CONFIDENTIALITY NOTICE:
This E-mail and any attachments are confidential. If you are not the
intended recipient, you do not have permission to disclose, copy,
distribute, or open any attachments. If you have received this E-mail in
error, please notify us immediately by returning it to the sender and
delete this copy from your system.

Thank you. TennesseeAnytime
**********************************

Error thrown trying to create a blog...

Reply via email to