[Spacewalk-list] Error while subscribing system to additional child channels

P.A.M. van Dam (Pascal) pascal at jarmine01.kleefdraakjes.nest
Wed Dec 16 22:24:19 UTC 2015


Good evening,

I am currently running spacewalk from the nightly builds. Since last update I've got this strange error when I try to add extra child channels to a system.

The httpd errorlog shows

[Wed Dec 16 20:51:47.999810 2015] [core:notice] [pid 4996] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Wed Dec 16 20:57:49.996379 2015] [:error] [pid 5004] Spacewalk 5004 2015/12/16 20:57:49 +02:00: ('SQLSchemaError', SQLSchemaError(99999, 'ERROR:  function rhn_channel.subscribe_server(integer, integer, integer) is not unique', 'LINE 1: SELECT rhn_channel.subscribe_server(1000010086, 266, 0)\\n               ^\\nHINT:  Could not choose a best candidate function. You might need to add explicit type casts.\\n', ProgrammingError('function rhn_channel.subscribe_server(integer, integer, integer) is not unique\\nLINE 1: SELECT rhn_channel.subscribe_server(1000010086, 266, 0)\\n               ^\\nHINT:  Could not choose a best candidate function. You might need to add explicit type casts.\\n',)))
[Wed Dec 16 20:57:49.996751 2015] [:error] [pid 5004] Spacewalk 5004 2015/12/16 20:57:49 +02:00: ('Unhandled exception',
[Wed Dec 16 20:57:49.996772 2015] [:error] [pid 5004] Internal code error. Information available:
[Wed Dec 16 20:57:49.996781 2015] [:error] [pid 5004]   (99999, 'ERROR:  function rhn_channel.subscribe_server(integer, integer, integer) is not unique', 'LINE 1: SELECT rhn_channel.subscribe_server(1000010086, 266, 0)\\n               ^\\nHINT:  Could not choose a best candidate function. You might need to add explicit type casts.\\n', ProgrammingError('function rhn_channel.subscribe_server(integer, integer, integer) is not unique\\nLINE 1: SELECT rhn_channel.subscribe_server(1000010086, 266, 0)\\n               ^\\nHINT:  Could not choose a best candidate function. You might need to add explicit type casts.\\n',))
[Wed Dec 16 20:57:49.996790 2015] [:error] [pid 5004] )
[Wed Dec 16 20:57:49.999864 2015] [:error] [pid 5004] Exception reported from ipacln04
[Wed Dec 16 20:57:49.999883 2015] [:error] [pid 5004] Time: Wed Dec 16 20:57:49 2015
[Wed Dec 16 20:57:49.999888 2015] [:error] [pid 5004] Exception type <class 'spacewalk.common.rhnException.rhnException'>
[Wed Dec 16 20:57:49.999893 2015] [:error] [pid 5004] Exception while handling function up2date.subscribeChannels
[Wed Dec 16 20:57:49.999905 2015] [:error] [pid 5004] Request object information:

E.g. an SQL error.

Is there a fix or a workaround for this?

Thanks in advance!

Kind regards,

	Pascal van Dam





More information about the Spacewalk-list mailing list