[Spacewalk-list] rhn-channel command bombs on servers when adding child channels
Fabiano Martins
fabiano.martins at trt4.jus.br
Fri Aug 22 13:31:13 UTC 2014
I already report it on Bugzilla :
https://bugzilla.redhat.com/show_bug.cgi?id=1126877
But there is still no fix for this bug... :(
2014-08-18 19:20 GMT-03:00 Mark Manley <mwmanley at gmail.com>:
> 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...
> ^
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140822/350e0c9c/attachment.htm>
More information about the Spacewalk-list
mailing list