[Spacewalk-list] rhn-channel command bombs on servers when adding child channels

Mark Manley mwmanley at gmail.com
Mon Aug 18 22:20:37 UTC 2014


Howdy,

I'm running Spacewalk client/server 2.2 on CentOS 6.4 and seeing these SQL
errors when trying to run the rhn-channel command on clients to add child
channels via a proxy.  I'm redacting most of the traceback emails since it
emails quite a bit of information, including passwords.  Is this a known
bug?  I have no problems adding child channels via the Spacewalk server's
web interface or via the spacecmd command, and I used to do this quite a
bit with the 1.x versions of Spacewalk.

I see this running:

rhn-channel -a -c <CHILD CHANNEL LABEL> -u <USER> -p <PASSWORD>

Removing child channels works great.

Thanks!

-MM

######

Extra information about this error:
SQL Error generated: ('ERROR:  syntax error at or near
"rhnServerChannel"\nLINE 4:        join rhnServerChannel sc on
c.parent_channel = sc.cha...\n                    ^\n', <connection
object at 0x7fb57452bad0; dsn: 'port=5432
host=spacewalk\-db01\.prd\.nj1\.tapad\.com
password=xxxxxxxxxxxxxxxxxxxxxxxx dbname=spaceschema user=spaceuser',
closed: 0>, '\nselect 1\n  from rhnChannel c,\n       join
rhnServerChannel sc on c.parent_channel = sc.channel_id\n  where
sc.server_id = %(sid)s\n    and c.label = %(channel)s\n')

Exception Handler Information
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py",
line 122, in call_function
    response = func(*params)
  File "/usr/share/rhn/server/handlers/xmlrpc/up2date.py", line 171,
in subscribeChannels
    username, passwd)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnChannel.py",
line 1756, in subscribe_channel
    h.execute(sid=server_id, channel=str(channel))
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 147, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 294, in _execute_wrapper
    raise sql_base.SQLStatementPrepareError(self.dbh, e.pgerror, self.sql)
SQLStatementPrepareError: ('ERROR:  syntax error at or near
"rhnServerChannel"\nLINE 4:        join rhnServerChannel sc on
c.parent_channel = sc.cha...\n                    ^\n', <connection
object at 0x7fb57452bad0; dsn: 'port=5432
host=spacewalk\-db01\.prd\.nj1\.tapad\.com
password=xxxxxxxxxxxxxxxxxxxxxxxx dbname=spaceschema user=spaceuser',
closed: 0>, '\nselect 1\n  from rhnChannel c,\n       join
rhnServerChannel sc on c.parent_channel = sc.channel_id\n  where
sc.server_id = %(sid)s\n    and c.label = %(channel)s\n')

Local variables by frame
Frame _execute_wrapper in
/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py
at line 294
	            function = <type 'instancemethod'> <bound method
Cursor._execute of <spacewalk.server.rhnSQL.driver_postgresql.Cursor
instance at 0x7fb574d6be60>>
	                   e = <class 'psycopg2.ProgrammingError'> syntax
error at or near "rhnServerChannel"
LINE 4:        join rhnServerChannel sc on c.parent_channel = sc.cha...
                    ^
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140818/1958fdbf/attachment.htm>


More information about the Spacewalk-list mailing list