[Spacewalk-list] creating a snapshot tag fails
Evan Frey
efrey2 at optonline.net
Tue Oct 16 15:45:15 UTC 2012
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
More information about the Spacewalk-list
mailing list