Description of problem: I create new organizations. I add other organization to the list of trusted organizations for this new organization. When I used method listTrusts from API org.trusts, that method crashed. Version-Release number of selected component (if applicable): spacewalk nightly postgresql How reproducible: always on postgresql Steps to Reproduce: 1. I create organization. In webUI I clicked on admin -> Organizations -> create new organization 2. I add other organization to list of trusted for this organization. In webUI I clicked on admin -> Organizations -> <name organization> -> trusts -> choose some org -> modify trust 3. I used method org.trusts.listTrusts(sessionKey,orgId) Actual results: Traceback (most recent call last): File "/mnt/tests/CoreOS/RHN-Satellite/Helper/manage-org.py", line 123, in ? for t in client.org.trusts.listTrusts(key, int(ORG)): File "/usr/lib64/python2.4/xmlrpclib.py", line 1096, in __call__ return self.__send(self.__name, args) File "/usr/lib64/python2.4/xmlrpclib.py", line 1383, in __request verbose=self.__verbose File "/usr/lib64/python2.4/xmlrpclib.py", line 1147, in request return self._parse_response(h.getfile(), sock) File "/usr/lib64/python2.4/xmlrpclib.py", line 1286, in _parse_response return u.close() File "/usr/lib64/python2.4/xmlrpclib.py", line 744, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: <Fault -1: 'redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: syntax error at or near "trusted"'> Additional info: WARNING: redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: syntax error at or near "trusted" 2011-11-30 08:18:39,852 [TP-Processor1] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT org.id, org.name, (SELECT count(*) FROM rhnTrustedOrgs tr WHERE tr.org_trust_id = org.id AND tr.org_id = ?) trusted FROM web_customer org WHERE org.id != ? com.redhat.rhn.common.db.WrappedSQLException: ERROR: syntax error at or near "trusted" at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45) ... cut ... Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "trusted" 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) ... 50 more Nov 30, 2011 8:22:44 AM redstone.xmlrpc.XmlRpcDispatcher writeError WARNING: redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: syntax error at or near "trusted"
spacewalk.git 17cf0aa87ebc5d2b783846e70dcc36e224f565ba
Spacewalk 1.6 has been released.