Attachment 851471 Details for Bug 1054663 – relevant part of catalina.out

relevant part of catalina.out

file_1054663.txt (text/plain), 13.06 KB, created by Jan Hutař on 2014-01-17 08:41:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jan Hutař

Created: 2014-01-17 08:41:04 UTC

Size: 13.06 KB

patch

obsolete

>2014-01-17 03:34:09,325 [TP-Processor1] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT DISTINCT E.id, E.advisory_name AS advisory,
>                E.update_date AS UPDATE_DATE,
>                E.synopsis as ADVISORY_SYNOPSIS,
>                E.advisory_type as ADVISORY_TYPE
>   FROM rhnErrata E inner join
>        rhnChannelErrata CE on CE.errata_id = E.id inner join
>        rhnSet S on S.element = CE.channel_id inner join
>        rhnErrataPackage EP on EP.errata_id = E.id inner join
>        rhnPackage P on p.id = EP.package_id inner join
>        rhnPackage P2 on P.name_id = P2.name_id inner join
>        rhnChannelPackage CP on P2.id = CP.package_id
>  WHERE
>    CP.channel_id = ?
>    and S.user_id = ?
>    and S.label = 'channels_for_errata'
>    and E.id not in (select errata_id from rhnChannelErrata where channel_id = ?)
>    and E.id not in (select original_id from rhnChannelErrata CE, rhnErrataCloned EC where CE.errata_id = EC.id and CE.channel_id = ?);
>com.redhat.rhn.common.db.WrappedSQLException: ORA-00911: invalid character
>
>	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:467)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:443)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:345)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:351)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:287)
>	at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:110)
>	at com.redhat.rhn.manager.channel.ChannelManager.findErrataFromRhnSetForTarget(ChannelManager.java:2339)
>	at com.redhat.rhn.frontend.action.channel.manage.AddRedHatErrataAction.getData(AddRedHatErrataAction.java:324)
>	at com.redhat.rhn.frontend.action.channel.manage.AddRedHatErrataAction.execute(AddRedHatErrataAction.java:215)
>	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
>	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
>	at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:102)
>	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
>	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>	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:127)
>	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:100)
>	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:57)
>	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:298)
>	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:761)
>Caused by: 
>java.sql.SQLException: ORA-00911: invalid character
>
>	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
>	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
>	at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
>	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
>	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)
>	... 50 more
>2014-01-17 03:34:09,326 [TP-Processor1] WARN  org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class com.redhat.rhn.common.db.WrappedSQLException
>2014-01-17 03:34:09,326 [TP-Processor1] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
>javax.servlet.ServletException: com.redhat.rhn.common.db.WrappedSQLException: ORA-00911: invalid character
>
>	at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
>	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
>	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
>	at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:102)
>	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
>	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>	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:127)
>	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:100)
>	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:57)
>	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:298)
>	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:761)
>Caused by: 
>com.redhat.rhn.common.db.WrappedSQLException: ORA-00911: invalid character
>
>	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:467)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:443)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:345)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:351)
>	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:287)
>	at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:110)
>	at com.redhat.rhn.manager.channel.ChannelManager.findErrataFromRhnSetForTarget(ChannelManager.java:2339)
>	at com.redhat.rhn.frontend.action.channel.manage.AddRedHatErrataAction.getData(AddRedHatErrataAction.java:324)
>	at com.redhat.rhn.frontend.action.channel.manage.AddRedHatErrataAction.execute(AddRedHatErrataAction.java:215)
>	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
>	... 40 more
>Caused by: 
>java.sql.SQLException: ORA-00911: invalid character
>
>	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
>	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
>	at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
>	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
>	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
>	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
>	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
>	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
>	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)
>	... 50 more

Actions: View

Attachments on bug 1054663: 851471