Every time we try to create a snapshot tag it fails with the following error:

RHN::Exception: DBD::Pg::st execute failed: ERROR: function quote_literal(numeric, unknown) does not exist LINE 1: ...es (' || $1 || ', ' || $2 || ', ' || coalesce(quote_lite... HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT pg_dblink_exec( 'insert into rhnTag(id, org_id, name_id) values (' || $1 || ', ' || $2 || ', ' || coalesce(quote_literal(lookup_tag_name( $3 ), 'NULL')) || ')') CONTEXT: PL/pgSQL function "lookup_tag" line 13 at PERFORM SQL statement "insert into rhnSnapshotTag (snapshot_id, server_id, tag_id) select $1 , server_id, lookup_tag( $2 , $3 ) from rhnSnapshot where id = $1 "
PL/pgSQL function "tag_snapshot" line 2 at SQL statement
RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 121 RHN::Exception::DB::throw RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 355 RHN::DB::handle_error RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 319 RHN::DB::db::call_function RHN::DB::SystemSnapshot /usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 233 RHN::DB::db::call_procedure RHN::DB::Server /usr/share/perl5/vendor_perl/RHN/DB/Server.pm 454 RHN::DB::SystemSnapshot::add_tag_to_snapshot Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 247 RHN::DB::Server::add_system_tag Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 246 (eval) PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 482 Sniglets::Snapshot::add_system_tag_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)

this occurs both from the gui and the api. We are running version 1.7 on x86_64 with the postgresql backend. Any ideas on how to address this?

Regards

Evan

_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to