[Spacewalk-list] Subscription Management with Postgres in SW 1.6

Wed Jan 18 04:45:39 UTC 2012

On Tue, Jan 17, 2012 at 8:36 PM, Ian Forde <ianforde at gmail.com> wrote:
> On Mon, Jan 16, 2012 at 11:19 AM, Jan Pazdziora <jpazdziora at redhat.com> wrote:
>> On Thu, Jan 12, 2012 at 04:04:14PM -0800, Ian Forde wrote:
>>> Has anyone successfully used "Overview/Subscription Management/System
>>> Entitlements" successfully in 1.6?  I'm trying to remove all of the
>>> monitoring entitlements from my boxes, so I enabled Monitoring,
>>> restarted Spacewalk, went to the aforementioned page, selected the
>>> boxes, clicked on "Remove Entitlement", and got an Internal Server
>>> Error page.  In the emailed traceback, I saw the following:
>>>
>>> Exception:
>>> javax.servlet.ServletException: ERROR: function
>>> rhn_install_org_satellites(bigint, bigint, bigint) does not exist
>>>       at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
>>>
>>> of course, there was much more output, but I think this one is the crux of it...
>>
>> Please let us see some 20 more lines of that traceback.

Sorry about that - mis-clicked in gmail... one more thing before I
paste it.  Since I had to re-enable monitoring in the Spacewalk
Configuration/General page, I find that I have to clear the "HTTP
proxy username" and "HTTP proxy password" fields before clicking
Update.  (It's the same problem as the one that used to exist in
kickstart on the "System Details" page, when, say you wanted to change
the SELinux setting, it assumed that you wanted to change the password
as well.)

Okay - now that I've re-enabled monitoring in Spacewalk, when I give
the Monitoring provision to 2 hosts (both VMs) through the
Subscription Management page, this is what I get from the "Show Tomcat
Logs" page at the bottom...

2012-01-17 20:42:22,783 [TP-Processor2] WARN
org.apache.struts.util.PropertyMessageResources -   Resource
org/apache/struts/action/ActionResources_en_US.properties Not Found.
2012-01-17 20:42:22,789 [TP-Processor2] WARN
org.apache.struts.util.PropertyMessageResources -   Resource
org/apache/struts/action/ActionResources_en.properties Not Found.
2012-01-17 20:42:22,790 [TP-Processor2] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception
thrown: class com.redhat.rhn.common.db.WrappedSQLException
2012-01-17 20:42:22,794 [TP-Processor2] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back
javax.servlet.ServletException:
com.redhat.rhn.common.db.WrappedSQLException: ERROR: function
rhn_install_org_satellites(bigint, bigint, bigint) does not exist
  Hint: No function matches the given name and argument types. You
might need to add explicit type casts.
  Position: 15
	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:99)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	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:91)
	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:108)
	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:55)
	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:679)
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR:
function rhn_install_org_satellites(bigint, bigint, bigint) does not
exist
  Hint: No function matches the given name and argument types. You
might need to add explicit type casts.
  Position: 15
	at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)
	at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)
	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
	at com.redhat.rhn.manager.monitoring.ScoutConfigPushCommand.store(ScoutConfigPushCommand.java:60)
	at com.redhat.rhn.frontend.action.systems.entitlements.SystemEntitlementsSubmitAction.operateAddOnEntitlements(SystemEntitlementsSubmitAction.java:412)
	at com.redhat.rhn.frontend.action.systems.entitlements.SystemEntitlementsSubmitAction.processAdd(SystemEntitlementsSubmitAction.java:281)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:616)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
	at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:146)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	... 40 more
Caused by: org.postgresql.util.PSQLException: ERROR: function
rhn_install_org_satellites(bigint, bigint, bigint) does not exist
  Hint: No function matches the given name and argument types. You
might need to add explicit type casts.
  Position: 15
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
	at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2417)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
	... 53 more
2012-01-17 20:42:22,963 [RHN Message Dispatcher] ERROR
com.redhat.rhn.common.messaging.ActionExecutor -
java.lang.NullPointerException
java.lang.NullPointerException
	at com.redhat.rhn.frontend.events.TraceBackEvent.toText(TraceBackEvent.java:75)
	at com.redhat.rhn.frontend.events.BaseMailAction.execute(BaseMailAction.java:42)
	at com.redhat.rhn.common.messaging.ActionExecutor.run(ActionExecutor.java:72)
	at com.redhat.rhn.common.messaging.MessageDispatcher.run(MessageDispatcher.java:58)
	at java.lang.Thread.run(Thread.java:679)