<div dir="ltr"><div>I already report it on Bugzilla : <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1126877">https://bugzilla.redhat.com/show_bug.cgi?id=1126877</a><br><br></div>But there is still no fix for this bug... :(<br>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-08-18 19:20 GMT-03:00 Mark Manley <span dir="ltr"><<a href="mailto:mwmanley@gmail.com" target="_blank">mwmanley@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Howdy,<div><br></div><div>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.</div>
<div><br></div><div>I see this running:</div><div><br></div><div>rhn-channel -a -c <CHILD CHANNEL LABEL> -u <USER> -p <PASSWORD></div><div><br></div><div>Removing child channels works great.</div><div><br>
</div><div>Thanks!</div><div><br></div><div>-MM<br><br></div><div>######</div><div><br></div><div><pre>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...
^</pre><pre><br></pre></div></div>
<br>_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br></blockquote></div><br></div>