[Spacewalk-list] Error after upgrade to 1.3

Kobus Bensch kobus.bensch at lovefilm.com
Mon Feb 7 15:58:59 UTC 2011


Ok, renamed the tnsnames.ora and re-ran   spacewalk-setup --upgrade

Stopped and started oracle and spacewalk and getting the folloign in the 
catalina logs:

07-Feb-2011 15:56:19 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 2857a293 -- 
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to 
acquire a needed new resource, we failed to succeed more than the 
maximum number of allowed acquisition attempts (30).
2011-02-07 15:56:19,562 [TP-Processor3] WARN  
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2011-02-07 15:56:19,562 [TP-Processor3] ERROR 
org.hibernate.util.JDBCExceptionReporter - Connections could not be 
acquired from the underlying database!
2011-02-07 15:56:19,562 [TP-Processor3] ERROR 
com.redhat.rhn.frontend.servlets.SessionFilter - Error during 
transaction. Rolling back
com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't open 
session
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:303)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)
        at 
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)
        at 
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)
        at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.initializeContext(LocalizedEnvironmentFilter.java:78)
        at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:66)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open 
connection
        at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
        at 
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at 
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at 
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)
        ... 37 more
Caused by: java.sql.SQLException: Connections could not be acquired from 
the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)
        at 
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
        at 
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
        at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
        ... 42 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A 
ResourcePool could not acquire a resource from its primary factory or 
source.
        at 
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
        at 
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
        ... 45 more
2011-02-07 15:56:19,563 [TP-Processor3] ERROR 
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] 
- Servlet.service() for servlet action threw exception
com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't open 
session
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:303)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)
        at 
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)
        at 
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)
        at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.initializeContext(LocalizedEnvironmentFilter.java:78)
        at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:66)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open 
connection
        at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
        at 
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at 
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at 
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)
        ... 37 more
Caused by: java.sql.SQLException: Connections could not be acquired from 
the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)
        at 
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
        at 
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
        at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
        ... 42 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A 
ResourcePool could not acquire a resource from its primary factory or 
source.
        at 
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
        at 
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
        ... 45 more
07-Feb-2011 15:56:48 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 2e6b611e -- 
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to 
acquire a needed new resource, we failed to succeed more than the 
maximum number of allowed acquisition attempts (30).
2011-02-07 15:56:48,398 [TP-Processor3] WARN  
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
2011-02-07 15:56:48,398 [TP-Processor3] ERROR 
org.hibernate.util.JDBCExceptionReporter - Connections could not be 
acquired from the underlying database!
2011-02-07 15:56:48,399 [TP-Processor3] ERROR 
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp] 
- Servlet.service() for servlet 
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp threw exception
com.mchange.v2.resourcepool.CannotAcquireResourceException: A 
ResourcePool could not acquire a resource from its primary factory or 
source.
        at 
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
        at 
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
        at 
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
        at 
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
        at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
        at 
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at 
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at 
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)
        at 
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)
        at 
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)
        at com.redhat.rhn.manager.acl.AclManager.hasAcl(AclManager.java:49)
        at 
com.redhat.rhn.frontend.taglibs.RequireTag.doStartTag(RequireTag.java:101)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspx_meth_rhn_005frequire_005f0(Unknown 
Source)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at 
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:605)
        at 
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:255)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown 
Source)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
        at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at 
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
2011-02-07 15:56:48,399 [TP-Processor3] ERROR 
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp] 
- Servlet.service() for servlet 
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp threw exception
com.mchange.v2.resourcepool.CannotAcquireResourceException: A 
ResourcePool could not acquire a resource from its primary factory or 
source.
        at 
com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
        at 
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
        at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
        at 
com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
        at 
org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
        at 
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
        at 
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at 
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at 
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getInternalSession(ConnectionManager.java:300)
        at 
com.redhat.rhn.common.hibernate.ConnectionManager.getSession(ConnectionManager.java:287)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.getSession(HibernateFactory.java:318)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:277)
        at 
com.redhat.rhn.common.hibernate.HibernateFactory.saveObject(HibernateFactory.java:291)
        at 
com.redhat.rhn.domain.session.WebSessionFactory.save(WebSessionFactory.java:71)
        at 
com.redhat.rhn.manager.session.SessionManager.makeSession(SessionManager.java:87)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.createPxtSession(PxtSessionDelegateImpl.java:164)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.loadPxtSession(PxtSessionDelegateImpl.java:110)
        at 
com.redhat.rhn.frontend.servlets.PxtSessionDelegateImpl.getPxtSession(PxtSessionDelegateImpl.java:46)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getWebSession(RequestContext.java:532)
        at 
com.redhat.rhn.frontend.struts.RequestContext.getLoggedInUser(RequestContext.java:172)
        at com.redhat.rhn.manager.acl.AclManager.hasAcl(AclManager.java:49)
        at 
com.redhat.rhn.frontend.taglibs.RequireTag.doStartTag(RequireTag.java:101)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspx_meth_rhn_005frequire_005f0(Unknown 
Source)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at 
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:605)
        at 
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:255)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown 
Source)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
        at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at 
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
javax.servlet.ServletException: javax.servlet.jsp.JspException: Error 
writing to JSP file:
        at 
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:842)
        at 
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fhead_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at 
org.apache.jsp.WEB_002dINF.decorators.layout_005fc_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:594)
        at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:505)
        at 
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
        at 
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:605)
        at 
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:255)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown 
Source)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
        at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at 
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
2011-02-07 15:56:48,402 [TP-Processor3] ERROR 
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp] 
- Servlet.service() for servlet 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp threw exception
javax.servlet.jsp.JspException: javax.servlet.ServletException: 
javax.servlet.jsp.JspException: Error writing to JSP file:
        at 
com.opensymphony.module.sitemesh.taglib.page.ApplyDecoratorTag.doEndTag(ApplyDecoratorTag.java:270)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspx_meth_page_005fapplyDecorator_005f0(Unknown 
Source)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
        at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at 
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
07-Feb-2011 15:56:48 org.apache.catalina.core.StandardHostValve custom
SEVERE: Exception Processing ErrorPage[errorCode=500, 
location=/WEB-INF/pages/common/errors/500.jsp]
javax.servlet.ServletException: javax.servlet.ServletException: 
javax.servlet.jsp.JspException: Error writing to JSP file:
        at 
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
        at 
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
        at 
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(Unknown 
Source)
        at 
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
        at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
        at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
        at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at 
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:229)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
        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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
        at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
        at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:636)
07-Feb-2011 15:56:49 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1c465648 -- 
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to 
acquire a needed new resource, we failed to succeed more than the 
maximum number of allowed acquisition attempts (30).
07-Feb-2011 15:56:57 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING: 
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 4dca9f78 -- 
Acquisition Attempt Failed!!! Clearing pending acquires. While trying to 
acquire a needed new resource, we failed to succeed more than the 
maximum number of allowed acquisition attempts (30).


Jan Pazdziora wrote:
> On Mon, Feb 07, 2011 at 02:55:09PM +0000, Kobus Bensch wrote:
>   
>> I tried again after removeing the tnsnames.ora and restart both
>> oracle and spacewalk.
>>
>> I started oracle xe and it seems to be ok.
>> /etc/init.d/oracle-xe status
>>     
>
> [...]
>
>   
>> /etc/init.d/oracle-xe status
>>     
>
> [...]
>
>   
>> I then started spacwalk and got the following
>>
>> /usr/sbin/spacewalk-service start
>>     
>
> Did you run spacewalk-setup --upgrade after doing that change? Because
> otherwise you have bad connect information in /etc/rhn/rhn.conf for
> sure. You cannot just remove tnsnames.ora and expect things to
> continue working.
>
>   

-- 
*Kobus Bensch*
Linux Administrator
kobus.bensch at lovefilm.com

No.9 | 6 Portal Way | London | W3 6RU |
T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111
<http://www.lovefilm.com>

-----------------------------------------------------------------------------------------------------------------------------------------
LOVEFiLM UK Limited is a company registered in England and Wales. 
Registered Number: 06528297. 
Registered Office: No.9, 6 Portal Way, London W3 6RU, United Kingdom.

This e-mail is confidential to the ordinary user of the e-mail address to which it was addressed. If you have received it in error, 
please delete it from your system and notify the sender immediately.

This email message has been delivered safely and archived online by Mimecast.
For more information please visit http://www.mimecast.co.uk 
-----------------------------------------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110207/e2adf38a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lfi.gif
Type: image/gif
Size: 1641 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110207/e2adf38a/attachment.gif>


More information about the Spacewalk-list mailing list