[Spacewalk-list] SQL error in SSM after update to 2.9

Hailer, Christian christian.hailer at interhyp.de
Fri Feb 1 06:28:14 UTC 2019 

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Hello all,

I recently updated Spacewalk from version 2.8 to 2.9. Since then I'm unable to manage multiple servers at once.
As soon as I select some servers on the "Systems" tab and click the "Manage" button, I get an internal server error. Looking at the Tomcat catalina.out log, I can see the following SQL error:


2019-02-01 07:14:02,504 [TP-Processor11] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT COUNT(*) as count
      FROM rhnSet
      WHERE
        rhnSet.user_id = ? AND
        rhnSet.label = ? AND (
          SELECT COUNT(*)
            FROM rhnServerFeaturesView
            WHERE rhnSet.element = rhnServerFeaturesView.server_id
              AND rhnServerFeaturesView.label = ?
        ) = 0;
com.redhat.rhn.common.db.WrappedSQLException: ORA-00933: SQL command not properly ended

        at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)
        at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:414)
        at com.redhat.rhn.common.db.datasource.CachedStatement.internalExecute(CachedStatement.java:293)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:232)
        at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:90)
        at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
        at com.redhat.rhn.manager.system.SystemManager.countSystemsInSetWithoutFeature(SystemManager.java:1333)
        at com.redhat.rhn.common.security.acl.Access.aclAllSystemsInSetHaveFeature(Access.java:208)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:470)
        at com.redhat.rhn.frontend.nav.AclGuard.canRender(AclGuard.java:69)
        at com.redhat.rhn.frontend.nav.RenderGuardComposite.canRender(RenderGuardComposite.java:49)
        at com.redhat.rhn.frontend.nav.Renderable.canRender(Renderable.java:126)
        at com.redhat.rhn.frontend.nav.DialognavRenderer.navNodeInactive(DialognavRenderer.java:102)
        at com.redhat.rhn.frontend.nav.RenderEngine.renderLevel(RenderEngine.java:96)
        at com.redhat.rhn.frontend.nav.RenderEngine.render(RenderEngine.java:58)
        at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.render(RenderUtils.java:148)
        at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:132)
        at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:73)
        at com.redhat.rhn.frontend.taglibs.NavMenuTag.doStartTag(NavMenuTag.java:53)
        at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspx_meth_rhn_005fdialogmenu_005f0(Unknown Source)
        at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspService(Unknown Source)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
        at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083)
        at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232)
        at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1926)
        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:451)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:104)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
        at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:101)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:299)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:673)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:1320)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)
        ... 74 more
2019-02-01 07:14:02,513 [TP-Processor11] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: javax.servlet.jsp.JspException: Error writing to JSP file:
        at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
        at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
        at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspService(Unknown Source)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
        at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083)
        at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232)
        at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1926)
        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:451)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:104)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
        at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:101)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:58)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:299)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:748)
Caused by: com.redhat.rhn.common.MethodInvocationException: IllegalInvocationException calling aclAllSystemsInSetHaveFeature ("all_systems_in_set_have_feature(ftr_kickstart)"): null
        at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:492)
        at com.redhat.rhn.frontend.nav.AclGuard.canRender(AclGuard.java:69)
        at com.redhat.rhn.frontend.nav.RenderGuardComposite.canRender(RenderGuardComposite.java:49)
        at com.redhat.rhn.frontend.nav.Renderable.canRender(Renderable.java:126)
        at com.redhat.rhn.frontend.nav.DialognavRenderer.navNodeInactive(DialognavRenderer.java:102)
        at com.redhat.rhn.frontend.nav.RenderEngine.renderLevel(RenderEngine.java:96)
        at com.redhat.rhn.frontend.nav.RenderEngine.render(RenderEngine.java:58)
        at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.render(RenderUtils.java:148)
        at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:132)
        at com.redhat.rhn.frontend.taglibs.helpers.RenderUtils.renderNavigationMenu(RenderUtils.java:73)
        at com.redhat.rhn.frontend.taglibs.NavMenuTag.doStartTag(NavMenuTag.java:53)
        at org.apache.jsp.WEB_002dINF.pages.ssm.ssmindex_jsp._jspx_meth_rhn_005fdialogmenu_005f0(Unknown Source)
        ... 51 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.redhat.rhn.common.security.acl.Acl.evalAcl(Acl.java:470)
        ... 62 more
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-00933: SQL command not properly ended

        at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)
        at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:414)
        at com.redhat.rhn.common.db.datasource.CachedStatement.internalExecute(CachedStatement.java:293)
        at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:232)
        at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:90)
        at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
        at com.redhat.rhn.manager.system.SystemManager.countSystemsInSetWithoutFeature(SystemManager.java:1333)
        at com.redhat.rhn.common.security.acl.Access.aclAllSystemsInSetHaveFeature(Access.java:208)
        ... 67 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:673)
        at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:1320)
        at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)
        ... 74 more


What could be the problem here? Any help would be appreciated!

Specs:

CentOS 6.10
Kernel 2.6.32-754.10.1.el6.x86_64
Oracle DB

Regards,
Christian Hailer

-----BEGIN PGP SIGNATURE-----
Version: PGP Universal 3.4.2 (Build 353)
Charset: us-ascii

wsFVAwUBXFPm/yMT++4TjnpaAQi/pQ//cJHoQTiZwTc/3kYDAXvIMS21Fc47W6HS
CDBzcmRWZCtnZSS8kTXKpEE+/sblYhpWXlMi1tfJ9RWRbvSFz7GOgFfXRC5Ckdtd
Rk+ZH5RQaZqhpzRuUOWY0kBj0hA5xm24ja7LdVu83LVJmlIcXEpMrY/HSlwiCVEL
r4gQqYg0r1lmW87mROck22JFk6nQyc8+I8U8dWQqiQjovd+Cn1ihSQNpPqmG20CK
R+/9QSTPdbl7SdIKw/2IHTZHYJM8xrQF7ST98PaH2VMSEUUlbF1DSc0Xy5+Bxh2e
r3zG7tctoquNtUrnrq6vZq0op1v2mIztSfYMH3jNKguc7kvlWiQc+CjFh2QI3WLF
Ih0C2ltFYHariIb3TR9T10zdzJGJvFM+m84he7FgMv2aEBmGKwDp1m2UI4CAxZIi
M04lGhF9GSRhPPoDWq5VxxFwRPpXtqpjeaTJhX/I9hOUsnY/CFr+JbD66ycO9qm4
hQzuom/ns34pxjNFV8GfUNxscrsMLFx+auxBqSNKjDXKUMTHkIbIBgfugTbMRKA4
3xmRUIIgz/Z7cB2IFkfohb/qRmQL0OzyUMnt2hCbhuKUmT361bdGPjtsBaJE8Aco
Meql9osU/VXxqBHJCpyIYBr/0q+Ba7G0CiffHVt/Hz7RaxZSHr7yDRZL+C8qGURW
RFhtTOFGH6Y=
=CEcB
-----END PGP SIGNATURE-----

More information about the Spacewalk-list mailing list