[Spacewalk-list] problem syncing profiles...
Ron Parker
rparker at customerdirect.com
Wed Apr 11 16:21:56 UTC 2012
I'm running into an issue trying to use the profile sync feature on
spacewalk-postqesql 1.7.3. The GUI allows me to compare and then select
the packages to sync, but generates a 500 error when attempting to effect
the changes. The systems are registered correctly in spacewalk, have valid
DNS entries, and I can push packages and scripts successfully to them. I'm
not familiar with postgresql and wondering if profile syncing is simply
broken for postgresql installs. I didn't see anything about this in the
list. Can anyone offer any insight?
Here is the traceback:
-------------------------------------------
The following exception occurred while executing this request:
GET /rhn/systems/details/packages/profiles/MissingPackageSubmit.do
[...]
Exception:
javax.servlet.ServletException:
com.redhat.rhn.common.db.WrappedSQLException: ERROR: syntax error at or
near ","
Where: Error occurred on dblink connection named "unnamed": could not
execute command.
SQL statement "SELECT dblink_exec('at_conn', $1 , true)"
PL/pgSQL function "pg_dblink_exec" line 4 at PERFORM
SQL statement "SELECT pg_dblink_exec( 'insert into rhnTransactionPackage
(id, operation, name_id, evr_id, package_arch_id)' || ' values (' || $1
|| ', ' || $2 || ', ' || $3 || ', ' || $4 || ', ' || ', ' || $5 ||
')')"
PL/pgSQL function "lookup_transaction_package" line 36 at PERFORM
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.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: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: syntax
error at or near ","
Where: Error occurred on dblink connection named "unnamed": could not
execute command.
SQL statement "SELECT dblink_exec('at_conn', $1 , true)"
PL/pgSQL function "pg_dblink_exec" line 4 at PERFORM
SQL statement "SELECT pg_dblink_exec( 'insert into rhnTransactionPackage
(id, operation, name_id, evr_id, package_arch_id)' || ' values (' || $1
|| ', ' || $2 || ', ' || $3 || ', ' || $4 || ', ' || ', ' || $5 ||
')')"
PL/pgSQL function "lookup_transaction_package" line 36 at PERFORM
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.executeUpdate(CachedStatement.java:270)
at
com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
at
com.redhat.rhn.manager.action.ActionManager.schedulePackageRunTransaction(ActionManager.java:1063)
at
com.redhat.rhn.manager.profile.ProfileManager.syncToSystem(ProfileManager.java:696)
at
com.redhat.rhn.frontend.action.rhnpackage.profile.MissingPackageAction.syncToVictim(MissingPackageAction.java:88)
at
com.redhat.rhn.frontend.action.rhnpackage.profile.MissingPackageAction.removePackagesFromSync(MissingPackageAction.java:152)
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: syntax error at or
near ","
Where: Error occurred on dblink connection named "unnamed": could not
execute command.
SQL statement "SELECT dblink_exec('at_conn', $1 , true)"
PL/pgSQL function "pg_dblink_exec" line 4 at PERFORM
SQL statement "SELECT pg_dblink_exec( 'insert into rhnTransactionPackage
(id, operation, name_id, evr_id, package_arch_id)' || ' values (' || $1
|| ', ' || $2 || ', ' || $3 || ', ' || $4 || ', ' || ', ' || $5 ||
')')"
PL/pgSQL function "lookup_transaction_package" line 36 at PERFORM
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.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:362)
at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
... 56 more
--
Ronald Parker
System Administrator
Customer Direct L.L.C.
P: 636-736-4017
F: 800-326-4249
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120411/8898db3f/attachment.htm>
More information about the Spacewalk-list
mailing list