Hi Mark, This issue was addressed in SW-nightly via bug report 1122438 - Syntax Error in SQL-Statement "subscribe_sql" in "rhnChannel.py" https://bugzilla.redhat.com/show_bug.cgi?id=1122438
Dimi ----- Original Message ----- > From: "Mark Manley" <[email protected]> > To: [email protected] > Sent: Tuesday, August 19, 2014 12:20:37 AM > Subject: [Spacewalk-list] rhn-channel command bombs on servers when adding > child channels > > 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list -- Dimitar Yordanov System Management Quality Engineer Red Hat Satellite | Spacewalk _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
