Hide Forgot
Description of problem: When trying to push scout configs, it loads forever, throws exception Error message: RHN::Exception: DBD::Pg::st execute failed: ERROR: function rhn_install_satellite(numeric, numeric) does not exist LINE 1: SELECT rhn_install_satellite( $1 , $2 ) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT rhn_install_satellite( $1 , $2 ) CONTEXT: PL/pgSQL function "rhn_install_org_satellites" line 22 at PERFORM RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 467 RHN::DB::handle_error RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 431 RHN::DB::db::call_function RHN::DB::SatCluster /usr/share/perl5/vendor_perl/RHN/DB/SatCluster.pm 329 RHN::DB::db::call_procedure Sniglets::ListView::ScoutList /usr/share/perl5/vendor_perl/Sniglets/ListView/ScoutList.pm 129 RHN::DB::SatCluster::push_config Sniglets::ListView::List /usr/share/perl5/vendor_perl/Sniglets/ListView/List.pm 374 Sniglets::ListView::ScoutList::push_config_cb Sniglets::Lists /usr/share/perl5/vendor_perl/Sniglets/Lists.pm 135 Sniglets::ListView::List::callback PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 489 Sniglets::Lists::listview_cb PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval) main -e 0 PXT::ApacheHandler::handler main -e 0 (eval) Version-Release number of selected component (if applicable): Spacewalk 1.6 / Postgresql backend How reproducible: Go to Monitoring->Scout Config Push -> select and click push Actual results: see above Expected results: it should push the configs Additional info: /usr/share/spacewalk/setup/upgrade/rhn-enable-monitoring.pl results in RHN::Exception: DBD::Pg::st execute failed: ERROR: column "sysdate" does not exist ZEILE 4: last_update_date = sysdate ^ RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 564 RHN::DB::handle_error RHN::DB::SatInstall /usr/share/perl5/vendor_perl/RHN/DB/SatInstall.pm 67 RHN::DB::st::execute_h main /usr/share/spacewalk/setup/upgrade/rhn-enable-monitoring.pl 115 RHN::DB::SatInstall::update_monitoring_config however monitoring services are running. So i dont know if this is really related
Possibly related: https://www.redhat.com/archives/spacewalk-list/2012-January/msg00091.html
(In reply to comment #0) > Description of problem: > When trying to push scout configs, it loads forever, throws exception > > Error message: > RHN::Exception: DBD::Pg::st execute failed: ERROR: function > rhn_install_satellite(numeric, numeric) does not exist > LINE 1: SELECT rhn_install_satellite( $1 , $2 ) > ^ > HINT: No function matches the given name and argument types. You might need to > add explicit type casts. > QUERY: SELECT rhn_install_satellite( $1 , $2 ) > CONTEXT: PL/pgSQL function "rhn_install_org_satellites" line 22 at PERFORM When you connect to your PostgreSQL with psql, what does \df rhn_install_satellite show?
\df rhn_install_satellite gives --------+-----------------------+------------------+----------------------------------------------------+-------- public | rhn_install_satellite | void | command_instance_id smallint, satellite_id numeric | normal So I assume parameter 1 is given in wrong format
Thanks. Was this a fresh 1.6 installation or upgrade from older version? What OS version and architecture is this?
I upgraded a 1.5 install to 1.6 (followed instructions here https://fedorahosted.org/spacewalk/wiki/HowToUpgrade) [root@spacewalk ~]# uname -a Linux HOSTNAME_HERE 2.6.32-131.17.1.el6.x86_64 #1 SMP Thu Oct 6 19:24:09 BST 2011 x86_64 x86_64 x86_64 GNU/Linux [root@spacewalk ~]# cat /etc/issue CentOS release 6.2 (Final) Kernel \r on an \m basically all I did for updating was: yum clean all;yum upgrade rpmconf -a /usr/bin/spacewalk-schema-upgrade (succeeded) spacewalk-setup --disconnected --upgrade (succeeded) rm -f /var/lib/jabberd/db/* service rhn-search cleanindex /usr/sbin/spacewalk-service start
Fixed in Spacewalk master, 5f8531c716d771de4cbf90db450f7582fab4a26d.
thanks(In reply to comment #6) > Fixed in Spacewalk master, 5f8531c716d771de4cbf90db450f7582fab4a26d. thanks for the quick fix! Could you give me a short howto-fix a 1.6 installation ?
Two more commits in Spacewalk master, c000aeee3f6a60b2db669b87626c309c5e85933d and 9d16068e1c3251b2247d01c6a2c28becf8762dfb.
(In reply to comment #7) > thanks(In reply to comment #6) > > Fixed in Spacewalk master, 5f8531c716d771de4cbf90db450f7582fab4a26d. > > thanks for the quick fix! > > Could you give me a short howto-fix a 1.6 installation ? In your psql, execute http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/008-rhn_install_satellite.sql.postgresql;h=89593c17d3d146a39ef0b4f7deba80915558ed8c;hb=5f8531c716d771de4cbf90db450f7582fab4a26d http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/009-rhn_prepare_install.sql.postgresql;h=4d8075df825527be8eba68320dd6050d51d2f6bb;hb=5f8531c716d771de4cbf90db450f7582fab4a26d and then commit; To fix the rhn-enable-monitoring.pl issue, apply patch http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=9d16068e1c3251b2247d01c6a2c28becf8762dfb
applied patches/sql... "push scout config" doesnt throw an exception anymore but it still loads the page forever. However if I restart the spacewalk service, it says "push initiated" and the probe configs are then indeed updated.
Spacewalk 1.7 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes17