[Spacewalk-list] Issues viewing Solaris patches in Spacewalk
Kenny Van Alstyne
kvanals at gmail.com
Mon Sep 17 22:36:53 UTC 2012
I'm just curious if anyone else is having the below issue --
When browsing to Systems -> Select a Solaris x86 box -> Software ->
Patches, an ISE is reported. The Tomcat and PostgreSQL logs are
below.
2012-09-17 09:07:45,345 [TP-Processor5] ERROR
com.redhat.rhn.common.db.datasource.CachedStatement - Error while
processing cached statement sql: SELECT PN.id as ID,
PN.id || '|' || PE.id AS ID_COMBO,
PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,
PN.name AS name,
PE.version,
PE.release,
PE.epoch,
PN.id AS NAME_ID,
PE.id AS EVR_ID,
nvl( (select spt.name from rhnSolarisPatchType spt,
rhnSolarisPatch RSP,
rhnPackage p
where RSP.package_id = p.id
and P.name_id = SP.name_id
and P.evr_id = SP.evr_id
and P.package_arch_id = SP.package_arch_id
and RSP.patch_type = spt.id),
'unknown') as PATCH_TYPE
FROM rhnPackageName PN,
rhnPackageEVR PE,
rhnServerPackage SP
WHERE SP.server_id = ?
AND SP.name_id = PN.id
AND SP.evr_id = PE.id
AND EXISTS ( SELECT 1
FROM rhnPackageArch PA,
rhnArchType AT
WHERE PA.id = SP.package_arch_id
AND AT.id = PA.arch_type_id
AND AT.label = 'solaris-patch' )
ORDER BY UPPER(PN.name), UPPER(evr_t_as_vre_simple(PE.evr))
com.redhat.rhn.common.db.WrappedSQLException: ERROR: more than one row
returned by a subquery used as an expression
at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54)
at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281)
at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:109)
at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
at com.redhat.rhn.manager.solarispackage.SolarisManager.solarisPackageHelper(SolarisManager.java:43)
at com.redhat.rhn.manager.solarispackage.SolarisManager.systemPatchList(SolarisManager.java:83)
at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.getDataResult(PatchListSetupAction.java:81)
at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.execute(PatchListSetupAction.java:58)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
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 com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
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.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
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:679)
Caused by: org.postgresql.util.PSQLException: ERROR: more than one row
returned by a subquery used as an expression
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
... 52 more
2012-09-17 09:07:45,348 [TP-Processor5] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception
thrown: class com.redhat.rhn.common.db.WrappedSQLException
2012-09-17 09:07:45,348 [TP-Processor5] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back
javax.servlet.ServletException: ERROR: more than one row returned by a
subquery used as an expression
at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
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 com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
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.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
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:679)
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR: more
than one row returned by a subquery used as an expression
at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54)
at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281)
at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:109)
at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
at com.redhat.rhn.manager.solarispackage.SolarisManager.solarisPackageHelper(SolarisManager.java:43)
at com.redhat.rhn.manager.solarispackage.SolarisManager.systemPatchList(SolarisManager.java:83)
at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.getDataResult(PatchListSetupAction.java:81)
at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.execute(PatchListSetupAction.java:58)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
... 40 more
Caused by: org.postgresql.util.PSQLException: ERROR: more than one row
returned by a subquery used as an expression
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
... 52 more
2012-09-17 09:07:45,350 [TP-Processor5] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action]
- Servlet.service() for servlet action threw exception
org.postgresql.util.PSQLException: ERROR: more than one row returned
by a subquery used as an expression
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281)
at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:109)
at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:57)
at com.redhat.rhn.manager.solarispackage.SolarisManager.solarisPackageHelper(SolarisManager.java:43)
at com.redhat.rhn.manager.solarispackage.SolarisManager.systemPatchList(SolarisManager.java:83)
at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.getDataResult(PatchListSetupAction.java:81)
at com.redhat.rhn.frontend.action.rhnpackage.patches.PatchListSetupAction.execute(PatchListSetupAction.java:58)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:99)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
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 com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
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.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
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:679)
2012-09-17 09:07:45,355 [RHN Message Dispatcher] WARN
com.redhat.rhn.common.messaging.SmtpMail - MessagingException while
trying to send email: javax.mail.SendFailedException: Send failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
2012-09-17 09:07:45,356 [RHN Message Dispatcher] ERROR
com.redhat.rhn.common.messaging.ActionExecutor -
com.redhat.rhn.common.messaging.JavaMailException: MessagingException
while trying to send email: javax.mail.SendFailedException: Send
failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
com.redhat.rhn.common.messaging.JavaMailException: MessagingException
while trying to send email: javax.mail.SendFailedException: Send
failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:145)
at com.redhat.rhn.frontend.events.BaseMailAction.execute(BaseMailAction.java:43)
at com.redhat.rhn.common.messaging.ActionExecutor.run(ActionExecutor.java:69)
at com.redhat.rhn.common.messaging.MessageDispatcher.run(MessageDispatcher.java:58)
at java.lang.Thread.run(Thread.java:679)
Caused by: javax.mail.SendFailedException: Send failed;
nested exception is:
javax.mail.MessagingException: Connection refused;
nested exception is:
java.net.ConnectException: Connection refused
at javax.mail.Transport.doSend(Transport.java:231)
at javax.mail.Transport.send(Transport.java:75)
at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:139)
... 4 more
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-1] ERROR: more
than one row returned by a subquery used as an expression
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-2] STATEMENT:
SELECT PN.id as ID,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-3]
PN.id || '|' || PE.id AS ID_COMBO,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-4]
PN.name || '-' || evr_t_as_vre_simple(PE.evr) AS NVRE,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-5]
PN.name AS name,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-6] PE.version,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-7] PE.release,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-8] PE.epoch,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-9]
PN.id AS NAME_ID,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-10]
PE.id AS EVR_ID,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-11]
nvl( (select spt.name from rhnSolarisPatchType spt,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-12]
rhnSolarisPatch RSP,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-13]
rhnPackage p
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-14]
where RSP.package_id = p.id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-15]
and P.name_id = SP.name_id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-16]
and P.evr_id = SP.evr_id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-17]
and P.package_arch_id = SP.package_arch_id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-18]
and RSP.patch_type = spt.id),
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-19]
'unknown') as PATCH_TYPE
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-20] FROM
rhnPackageName PN,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-21]
rhnPackageEVR PE,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-22]
rhnServerPackage SP
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-23] WHERE
SP.server_id = $1
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-24] AND
SP.name_id = PN.id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-25] AND
SP.evr_id = PE.id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-26] AND
EXISTS ( SELECT 1
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-27]
FROM rhnPackageArch PA,
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-28]
rhnArchType AT
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-29]
WHERE PA.id = SP.package_arch_id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-30]
AND AT.id = PA.arch_type_id
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-31]
AND AT.label = 'solaris-patch' )
Sep 17 09:43:59 spacewalkserver postgres[27756]: [4-32] ORDER
BY UPPER(PN.name), UPPER(evr_t_as_vre_simple(PE.evr))
Sep 17 09:43:59 spacewalkserver postgres[27756]: [7-1] ERROR: current
transaction is aborted, commands ignored until end of transaction
block
Thanks,
Kenny
More information about the Spacewalk-list
mailing list